Basis Errors and Solutions

DB2-z/OS: Service SQL

August 1, 2009 at 11:47 am

[DB2] [DSNPLI8] [grid service] [OS/390] [PLI8] [service] [sql server service] [webservice] [z/OS]

1. DB2-z/OS:CCMS: DB13: DB2 Utilities SHRLEVEL SyntaxSymptom The DB13 job templates to call DB2 Utilities contain a wrong syntax for SHRLEVEL. The value of SHRLEVEL is accidentally enclosed in brackets. This prevents the fix from IBM APAR PK87122...
2. DB2-z/OS:CCMS: DB2 Utility job changesSymptom REORG jobs in transaction DB13 alter the primary and secondary space allocation, if the number of extents is greater than four. In addition, REORG and COPY jobs in DB13 are not...
3. DB2-z/OS:CCMS: DSNACCOR RUNSTATS recommendationsSymptom When computing RUNSTATS recommendations, the stored procedure DSNACCOR does not take into account, if last RUNSTATS time is older than last REORG time. Other terms DB2, CCMS, DB13, z/OS, OS/390, RUNSTATS,...
4. DB2/390: Automated PTF CheckSymptom Latest News As of7-Jul-2009a new version of RSDB2FIX is available as an attachment (SAPK34POSN.CAR) to this note.Attention:This transport should only be applied for Releases = 6.10 apply the highest Basis Support...
5. DB2-z/OS:CCMS: DSNDB01 excluded when calling DSNACCMOSymptom DB13 jobs exclude DB2 directory table spaces (DSNDB01) from RUNSTATS, REORG and COPY when stored procedure DNSACCMO is used to call the DB2 utilities. Other terms DB2, CCMS, DB13, z/OS, OS/390,...
6. DB2-z/OS:CCMS: Mapping Table for REORG not found (DSNU056I)Symptom The execution of Online REORG fails with the following error message: DSNU056I -D6K0 117 09:26:04.97 DSNUGMAP – TABLE ‘SAPBRE.QT000101′ NOT FOUND This means, that the mapping table, which is necessary for...
7. Deploy of web service failsSymptom Webservices common deployment exception. The reason is: There is duplicate element for web service. Other terms web service deploy Reason and Prerequisites When more than one application with web service are...
8. DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x)Symptom This note describes DB2 for z/OS-specific corrections and advance developments for the CCMS for R/3 Releases 6.10, 6.20, 6.40 and 7.00. Other terms DB2, z/OS, ABAP, transport, correction, fix, advance development,...

Symptom

You want to create the service SQL to extract the current SQL query scenario.
Other terms

DB2, OS/390, z/OS, PLI8, DSNPLI8
Reason and Prerequisites

To reproduce problems in the area of the DB2 optimizer, you must extract and copy the database objects that are involved and the related database statistics. You can use the service SQL to do this. You can create the service SQL using the DB2 Optimization Service Center (OSC).
This note provides the additional option of creating the service SQL in an SAP system.
Solution

Use the source code attached to this note to implement the ABAP report ZSAP_SERVICE_SQL.
Then use the EXPLAIN function (for example, in transaction ST05 – SQL trace) to write the access plan of an SQL statement to the plan table PLAN_TABLE. Start the report ZSAP_SERVICE_SQL and enter the query number (QUERYNO) of the access plan. In addition, determine whether the system displays information about the definition of the database objects, the database statistics, the contents of the plan table, and the buffer pool that you use. Choose “Execute”. The system displays the service SQL as a list. You can then save it in a local file.

Permalink