DB2 error in onlne reorg
Thu, Mar 24, 2016 · 1 minute readdatabasedb2
(an old note, resurrected).
Saw the following error in DB2 9.7.2 LUW during a manual online reorg.
db2 => REORG TABLE SAPR3.VBAP INPLACE ALLOW WRITE ACCESS START
SQL2216N SQL error "-668" occurred while reorganizing a database table or its indexes.
Apparently this is a known issue, the Fix for which is an offline reorg (INPLACE not allowed for reorg pending state).
db2 => CALL SYSPROC.ADMIN_CMD('REORG TABLE SAPR3.VBAP')
That prompting a very short investigation of how to monitor a DB2 reorg.
This site has several suggestions - i liked db2pd
$ db2pd -d ER3 -reorgs | grep VBAP
0x00002ABC297B7028 26 13138 n/a n/a n/a VBAP Offline 0 26
0x00002ABC297B7028 VBAP 08/08/2015 18:55:22 n/a 08/08/2015 18:55:23 3 Build 369003 607210 Started 0