SAP Knowledge Base Article - Preview

2328283 - Issues with ST04 / DBACockpit after PTF update

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.