DB2 error in onlne reorg


(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
Comment on this article using form below. Requires email login only for authentication. HTML forbidden, Markdown only.