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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.