|
||||||
|
While working on a deadlocking problem, I came across the cur_commit optoin that is now available in version 9.7. This option is part of the ongoing efforts to make DB2 more Oracle compliant. After reading about the cur_commit database option, it seemed to be a fair solution to the problem. We installed/upgraded our databases to [...] The db2pd command is a relatively new command (released with version 8.2) that will tell you a huge amount of information about your db2 system. I first made myself familiar with it when looking for a way to get the status of HADR without going through a snapshot output. db2pd -db sample -hadr - will tell you all you need [...] Some time ago, I had the requirement to sample data from a table to do validation work. Basically, we wanted to validate syncronized data with a base table, but could not afford to compare every row. We had to come up with a way to ‘sample’ the data. Each table we had to sample had [...] One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts. I use this technique when I need to do the same thing to many objects. I often use it when I want something quick and dirty or create a base script [...] I’ve always been a little frustrated with db2 when running scripts and command lines with fact that when a command would run like insert, update or delete, you never knew how many rows you affected. Some GUI products will tell you, but with command line it would just come back as being successful (or not) and it [...] There are a lot of things you can do with db2 batch scripts that can make your life easy. In this set of posts I will talk about just a few things that might make your life easier. [...] |
Site hosted by:
|
|||||
|
Copyright © 2012 DBMSguy.com - All Rights Reserved |
||||||
