Personal tools
You are here: Home DB2 How To's How to update partitioned database cfg on DB2 v9.7
Navigation
Log in


Forgot your password?
 
Document Actions

How to update partitioned database cfg on DB2 v9.7

Starting with DB2 9.7 db2 update db cfg runs on ALL partitions, regardless the current node you are connected, except when DBPARTITIONNUM keyword is used.

The following example shows how to update LOGARCHMETH1 to use a different path on each partition:

before:

db2pd -dbcfg -db sample -alldbp|grep "LOGARCHMETH1 (memory)"
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20000/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20000/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20000/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20000/

after:

db2_all "\"echo ##;db2 update db cfg for sample DBPARTITIONNUM ## using LOGARCHMETH1 DISK:/db2/db2inst1/sample
/archlog/db2000##"

db2pd -dbcfg -db sample -alldbp|grep "LOGARCHMETH1 (memory)"
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20000/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20001/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20002/
LOGARCHMETH1 (memory)          DISK:/db2/db2inst1/sample/archlog/db20003/

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls