A fix is available
APAR status
Closed as program error.
Error description
INCORRECT DATA ON PANELS WLMA AND THDZ (OF STORED PROCEDURES) The panels WLMA and THDZ (of Stored Procedures) shows no correct data, if the Stored Procedure is a Java Stored Procedure. The columns Threads in WLMA does not contain a value for the WLM address space and THDZ does not contain any value if Java Stored Procedure is currently active. FYI. ________________ ZALLT VTM O2 V540.HZ D81D 03/09/07 17:12:13 2 > Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11 > T.A > THREAD ACTIVITY: Enter a selection letter on the top line. > *-ALL B-TSO C-CICS D-IMS E-BACKGROUND F-DIST ALLIED > G-DIST DBAC H-UTIL I-INACT J-FILTER K-FUNCTIONS L-STORED PROC > M-TRIGGERS N-SYSPLEX O-ENCLAVES P-WORKSTA ================================================================ =============== > ALL THREADS CONNECTED TO DB2 THDA + * + Elapsed Planname CPU Status GetPg Update Commit Jobname + ---------- -------- ----- ------------ ------ ------ ------ -------- + 01-05:35 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 S5O2SJC + 01-00:25 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 S5O2SJC + 22:27:24.4 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 D2DB020 + 15:20:06.0 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 D5M5001 + 04:51:49.9 KO2PLAN 02.9% IN-DB2 0 0 0 S5O2CMT + 04:07:23.2 KO2540HP 03.1% NOT-IN-DB2 0 0 0 D2DB021 + 03:21:17.8 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 S5O2CMT + 03:15:01.3 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 CTD53D00 + 01:14:03.4 KO2540HP 00.0% NOT-IN-DB2 0 0 0 D2DB058 + 00:20:10.0 KO2540IF 00.0% NOT-IN-DB2 0 0 0 D2DB051 + 00:14:16.6 KO2540IF 00.0% NOT-IN-DB2 0 0 0 D2DB051 + 00:10:45.5 DISTSERV 00.0% IN-SQL-CALL 719500 0 0 JAVA.EXE + 00:06:19.8 KO2540HP 01.0% NOT-IN-DB2 0 0 0 D2DB000 + 00:04:24.2 DSNTEP81 00.0% IN-SQL-CALL 937641 11289 0 CMIKSFX + 00:01:08.4 DSNTEP81 00.0% IN-SQL-CALL 0 0 0 CMIKSF2 ________________ ZRRSAT VTM O2 V540.HZ D81D 03/09/07 17:37:02 2 > Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11 > T.K > THREAD ACTIVITY: Enter a selection letter on the top line. > A-ALL B-TSO C-CICS D-IMS E-BACKGROUND F-DIST ALLIED > G-DIST DBAC H-UTIL I-INACT J-FILTER *-FUNCTIONS L-STORED PROC > M-TRIGGERS N-SYSPLEX O-ENCLAVES P-WORKSTA ================================================================ =============== > FUNCTIONS THREAD SUMMARY RRSA + Job Name ASID CPU% Connection Threads + -------- ---- ----- ---------- ------- + MQMHMSTR 009C 00.0 1 0 + D2DB021 0156 00.0 1 0 + D2DB051 017B 00.0 1 0 + D2DB058 0173 00.0 1 0 + D81DJAVA 017D 00.0 1 0 + D2DB000 0142 00.0 1 0 THDY + No Threads for USER-DEFINED FUNCTIONS currently active ________________ ZSTPT VTM O2 V540.HZ D81D 03/09/07 17:37:30 2 > Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11 > T.K > THREAD ACTIVITY: Enter a selection letter on the top line. > A-ALL B-TSO C-CICS D-IMS E-BACKGROUND F-DIST ALLIED > G-DIST DBAC H-UTIL I-INACT J-FILTER K-FUNCTIONS *-STORED PROC > M-TRIGGERS N-SYSPLEX O-ENCLAVES P-WORKSTA ================================================================ =============== > STORED PROCEDURES THREAD SUMMARY WLMA + Job Name ASID CPU% Connection Threads + -------- ---- ----- ---------- ------- + D81DJAVA 017D 00.0 1 0 THDZ + No Threads for STORED PROCEDURES currently active
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Classic Interface * **************************************************************** * PROBLEM DESCRIPTION: INCORRECT DATA FOR COMMANDS WLMA AND * * THDZ * **************************************************************** * RECOMMENDATION: APPLY THIS PTF * **************************************************************** NUMBER OF THREADS WAS NOT OBTAINED CORRECTLY FOR WLM AND RRS CONNECTIONS.
Problem conclusion
CHANGED LOGIC TO OBTAIN CORRECT NUMBER OF THREADS FOR WLM AND RR CONNECTIONS. KEYWORDS : INCORROUT NUMBER THREADS WLMA RRSA COMMAND
Temporary fix
Comments
APAR Information
APAR number
PK46824
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
310
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2007-06-12
Closed date
2007-09-03
Last modified date
2007-10-02
APAR is sysrouted FROM one or more of the following:
OA21037
APAR is sysrouted TO one or more of the following:
UK28727 UK28728
Modules/Macros
KO2CCNSA KO2CCNSS KO2CCNS2
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"310"}]
Document Information
Modified date:
31 March 2021