Is Database Analyzer designed to collect LOB objects statistics?
search cancel

Is Database Analyzer designed to collect LOB objects statistics?

book

Article ID: 16965

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction



Is Database Analyzer designed to collect LOB objects statistics and if so how is this enabled?

Environment

Release:
Component: INS

Resolution

With regards to LOB support, we only collect data set and volume level (RAVL_STATS_XXX table) stats natively for LOB tablespaces. For auxillary indexes, we collect full statistics (RAVL/RAIX). We do call RUNSTATS for LOB tablespaces to update catalog statistics but we do not collect or externalize LOB tablespace stats to the PDA statistical tables (RATS/RATB...)

Additional Information

Further details for our current LOB Support can be found in the CA Database Analyzer Reference documentation:

Volume Statistics