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".