This DB2 error message SQL2219N reason code 9 appeared in the db2 db2diag file.
The DB2 documentation details for reason code 9 are “START is not allowed as a prior paused table reorganization has not been stopped”.
I discovered there was a scheduled maintenance of the databases – 1) REORG - managing reorg of tables (and indexes). 2) RUNSTATS
It conflicted with the AUTO_REORG on the databases. Turning off AUTO_REORG stopped the error occurring.
2012-03-18-22.49.37.393468+000 E2273446E603 LEVEL: Error PID : 25077 TID : 189054052704 PROC : db2sysc INSTANCE: db2tdw NODE : 000 DB :MYDB APPHDL : 0-17413 APPID: *LOCAL.db2tdw.120319003038 AUTHID : DB2JV EDUID : 82 EDUNAME: db2agent (MYDB) FUNCTION: DB2 UDB, data management, sqldOLRValidate, probe:100 MESSAGE : ADM5590E The specified INPLACE table reorganization action on table "DB2JV .DATA_DETAILS" is not allowed on this node because of SQLCODE -2219 reason code "9".