Use of DSNACCOX in DB2V8

Document ID : KB000030720
Last Modified Date : 14/02/2018
Show Technical Document Details

 QUESTION:

I see DSNACCOX is being used  for selecting index candidates for Reorgs but DSNACCOX is only available from DB2V9 and DB2V10. DSNACCOX reads from RTS table(SYSIBM.SYSTABLESPACESTATS) to make recommendations. SYSTABLESPACESTATS is only populated when ENFM job is run. How and why DSNACCOX is being used when we're in DB2V8?

Answer:

DSNACCOX is DB2V9 based and can't be used with DB2V8. If used in DB2V8 an SQL error will occur. The equivalent of DSNACCOX for DB2V8 is DSNACCOR. DSNACCOR reads from RTS table to make REORG recommendation.