A fix is available
APAR status
Closed as program error.
Error description
Abstract - INCORROUT APPLICATION TRACE Event Detail screen ZATD3 Description - From main menu - s A APPLICATION TRACE .... Trace and view application activity s D SELECT DATASET ..... Specify a trace dataset to view on screen ZATRD specify dataset name, press enter, validate and press enter again enter E in command line to for E-VIEW DATASET result ZATVD - zoom thread result ZATVC - zoom thread result ZATVS - enter E in command line for E-EVENT DETAIL result ZATD3 - page down see lines of periods rather than data PMR shows APPLICATION TRACE: Enter a selection letter on the top line. A- PROGRAM B-SQL INDEX C-SQL DETAIL D-LOCK DETAIL *-EVENT DETAIL ================================================================ =============== > APPLICATION TRACE EVENT DETAIL ATD3 + Planname=DSNESPCS Connid=TSO Corrid=T8659KM Authid=T8659KM + : Control=NEXT (FIRST/LAST/NEXT/PREV/+nnnn/-nnnn/Snnnn/TOP/BOTTOM/UP/DOWN) + Current=000001 Total Number of SQL Calls=000030 + + Event Time TN Event Type Event Resource Information + ------------ -- --------------------- --------------------------------------- + 11:48:10.333 START PREPARE PGM=DSNESM68 STMT=00134 and more lines until + 11:48:10.608 END OF INDEX SCAN DB=DSNRLST PS=00004 + 11:48:10.620 END PREPARE ROWS=0000012 PAGES=0000061 + ........... ..................... ....................................... + ............ ..................... ....................................... + ............ ..................... ....................................... I ran an ATF of my userid performing a SPUFI against D71D. I record to the following dataset LISOM.ATF.P55111.V4. After performing the application trace From main menu - s A APPLICATION TRACE .... Trace and view application activity s D SELECT DATASET ..... Specify a trace dataset to view on screen ZATRD specify dataset name, press enter, validate and press enter again enter E in command line to for E-VIEW DATASET result ZATVD - zoom thread result ZATVC - zoom thread result ZATVS - enter E in command line for E-EVENT DETAIL result ZATD3 - page down a couple of times and + 12:01:27.927 LOCK RELEASE (GROUP) DURATION=MANUAL + 12:01:27.935 END PREPARE ROWS=0000013 PAGES=0000042 + ........... ..................... ....................................... + ............ ..................... ....................................... + ............ ..................... ....................................... Additionally this screen has controls for stepping thru the data : Control=NEXT (FIRST/LAST/NEXT/PREV/+nnnn/-nnnn/Snnnn/TOP/BOTTOM/UP/DOWN) + Current=000001 Total Number of SQL Calls=001712 If I start stepping thru the data, press enter for next, some subsequent screens do not show the line of dots and some do; eg : Control=NEXT (FIRST/LAST/NEXT/PREV/+nnnn/-nnnn/Snnnn/TOP/BOTTOM/UP/DOWN) + Current=000002 Total Number of SQL Calls=001712 + + Event Time TN Event Type Event Resource Information + ------------ -- --------------------- --------------------------------------- + 12:01:27.935 START OPEN CURSOR PGM=DSNESM68 STMT=00190 + 12:01:27.937 END OPEN CURSOR ROWS=0000000 PAGES=0000000 ================================================================ =============== : Control=NEXT (FIRST/LAST/NEXT/PREV/+nnnn/-nnnn/Snnnn/TOP/BOTTOM/UP/DOWN) + Current=000003 Total Number of SQL Calls=001712 + + Event Time TN Event Type Event Resource Information + ------------ -- --------------------- --------------------------------------- + 12:01:27.937 START FETCH PGM=DSNESM68 STMT=00183 + 12:01:27.963 START SEQUENTIAL SCAN DB=........ PS=00009 + 12:01:27.999 LOCK ACQUIRE DB=........ PS=00009 DPAG S D=MNL + 12:01:28.058 END FETCH ROWS=0000003 PAGES=0000001 + ........... ..................... ....................................... ================================================================ ================== I also think there is an error on ZATD1, the results of selecting C-SQL Detail. This was a single SPUFI that I ran. It looks like the screen is prepared to show a second miniplan when none exists + Dynamic SQL Call Text : + ----------------------- + SELECT * FROM SYSIBM.SYSTABLES + + Miniplan Generated by DB2 : + --------------------------- + + Plan # 1 (Estimated Cost: 2776 ) + + Table: SYSTABLES Access Type: SEQUENTIAL SCAN + Prefetch Activity: SEQUENTIAL + + + Plan # 2 (Estimated Cost: 2776 ) <====== why is this line here ======================================================
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310 * * users of component: * * - Classic Interface * **************************************************************** * PROBLEM DESCRIPTION: Panel ATD3 shows rows of dots rather * * than data * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
ARSB program is updated to fix this problem ---------------- SYSMOD TITLE: Panel ATD3 shows rows of dots KEYWORDS: INCORROUT ROWS OF DOTS ATF ATD3
Temporary fix
Comments
APAR Information
APAR number
PK25904
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-06-06
Closed date
2006-06-08
Last modified date
2006-07-06
APAR is sysrouted FROM one or more of the following:
OA16278
APAR is sysrouted TO one or more of the following:
UK15169
Modules/Macros
KO2ARSBS KO2ARSB2
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R310 PSY UK15169
UP06/06/12 P F606
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 July 2006