Symptom
- When using the new monitor (job DB4STATS running in subsystem QUSRWRK, profile parameter as4/dbmon/central_collector=1), you will always see 0 for the number of rows returned in queries, both in the overview screens and in Visual Explain.
- When using the old monitor (still the default for all shipped releases), transactions ST04 and DBACockpit have no data about SQL performance.
- The plan cache dump aborts with the below error in the joblog:
SQL0407 Null values not allowed in column or variable QQARSS
Also, the following errors can be found in the RSDB4DBH log (SM37 -> RSDB4DBH - > Job log)
Job started
Step 001 started (program RSDB4DBH, variant &0000000085627, user ID DDIC)
Checking existence of DBMon outfiles in R3QTEMP ..
Checking completed successfully.
Could not find previous dump timestamp.
Job canceled after system exception ERROR_MESSAGE
Read more...
Environment
- AS400
- IBM i
Keywords
AS/400, OS/400, system i, i5/OS, IBM i , KBA , BC-OP-AS4 , IBM AS/400 , BC-DB-DB4 , DB2 for AS/400 , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.