SAP Note 1425488 - DB6: Performance problems with volatile tables

Component : CCMS/Database Monitors for DB2 Universal Database - DB2 Universal Database for Unix / NT

Solution : https://service.sap.com/sap/support/notes/1425488 (SAP Service marketplace login required)

Key words :
sap system table fluctuates considerably, automatic sap runstats procedure, poor access plans, access planapqdapqiarfcrstatearfcsdataarfcsstatecoixcoix_data40db6cstracedb6_dlmon_histvals_dllockdb6_dlmon_histvals_stmthistdb6_dlmon_histvals_stmtvalsdbtablogdynploadrepoloadtrfcqdatatrfcqintrfcqinstrfcqouttrfcqstatevbdatavbhdrvblogvbmodqrfc_i_qinqrfc_n_qoutqrfc_o_qoutqreftidsmofcdbhdsmofcmpdatsmofcmphdsmofcmpobjsmoejobidsmohjobqsmohmsgqsmohsiteq reason, volatile table <tabname>', volatile table <tabname>, newly-included tables, 'obsolete exception entry, real-time statistics, sap systems

Related Notes :

1502194DB6: Automatic Statistics Collection (Automatic RUNSTATS)