Example 1: Diagnosing a lockwait If you rundb2pd -dbdatabasename-locks -transactions -applications -dynamic, the results are similar to the following ones: Locks:TranHdlLockname Type Mode Sts Owner Dur HldCnt Att ReleaseFlg300020002000000040000000052 Row ..X G 3 1 0 0x0000 0x40000000200020002000...
Example 1: Diagnosing a lockwait If you rundb2pd -dbdatabasename-locks -transactions -applications -dynamic, the results are similar to the following ones: Locks:TranHdlLockname Type Mode Sts Owner Dur HldCnt Att ReleaseFlg300020002000000040000000052 Row ..X G 3 1 0 0x0000 0x40000000200020002000...
Example 1: Diagnosing a lockwait If you rundb2pd -dbdatabasename-locks -transactions -applications -dynamic, the results are similar to the following ones: Locks:TranHdlLockname Type Mode Sts Owner Dur HldCnt Att ReleaseFlg300020002000000040000000052 Row ..X G 3 1 0 0x0000 0x40000000200020002000...
When adding a new node, you can monitor the progress of the operation on the database partition server, that is adding the node, using thedb2pd -addnodecommand with the optionaloldviewappsanddetailparameters for more detailed information. If you require a list of event monitors that are curre...