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.
SAP Knowledge Base Article - Preview