|
||||||
|
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 [...] 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 [...] This is the last post about HADR, I think I covered most of the basics of HADR finishing off with how it switches primary and standby. What I have gone over is the basics of HADR. There are many other topics within HADR. One important thing to remember is to NEVER do unlogged operations (careful [...] |
Site hosted by:
|
|||||
|
Copyright © 2012 DBMSguy.com - All Rights Reserved |
||||||
