A fix is available
APAR status
Closed as program error.
Error description
ENV : DB2 for z/os 11.1 The customer wants to use a Java program to invoke the Stored Procedure ADMIN_COMMAND_DB2 to basically show the Indoubt threads on a Java distributed Enviroment. During operation, when DB2_CMD '-DISPLAY THREAD(*) TYPE(INDOUBT) LIMIT(*)' are passed on the first input variable and PARSE_TYPE 'THD' passed on the third input Variable of this SP, he cannot get the information of indoubt threads when they indeed exist.
Local fix
Workaround: We can get the indoubt threads when specify the third variable as "" in Java
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS * * users of the DB2-supplied stored procedure * * SYSPROC.ADMIN_COMMAND_DB2 * **************************************************************** * PROBLEM DESCRIPTION: ADMIN_COMMAND_DB2 does not return the * * parsed information about indoubt or * * postponed threads that exist in a * * DB2 11 for z/OS subsystem. * **************************************************************** * RECOMMENDATION: APPLY PTF * **************************************************************** DB2 11 for z/OS increased the length of URID from CHAR(12) to CHAR(20). URID is an RBA of the DB2 recovery log which points to the beginning of recovery logging for an indoubt or postponed thread. This new URID length resulted in a change in the output format of the -DISPLAY THREAD command for indoubt and postponed threads. Specifically, this header line: COORDINATOR STATUS RESET URID AUTHID <- 15 -> <- 9 -> spaces spaces that follows the message "DSNV406I - INDOUBT THREADS -" or the message "DSNV431I - POSTPONED ABORT THREADS -" is reformatted to: COORDINATOR STATUS RESET URID AUTHID <- 10 -> <- 17 -> spaces spaces Since ADMIN_COMMAND_DB2 does not recognize this new header format as it scans the -DISPLAY THREAD command output, it does not extract any data following this header and therefore does not return anything in the result table SYSIBM.DB2_THREAD_STATUS.
Problem conclusion
In response, this APAR implements the following changes: (1) DB2 11: (a) Modifies the stored procedure ADMIN_COMMAND_DB2 to handle the new V11 output format of the -DISPLAY THREAD command for indoubt and postponed threads. (b) Modifies the result table SYSIBM.DB2_THREAD_STATUS, which is returned by ADMIN_COMMAND_DB2 and is populated with the parsed data from the -DISPLAY THREAD command output. The length of the URID column in this table is increased from CHAR(12) to CHAR(20). (2) DB2 10: In a mixed release data sharing group with DB2 10 and DB2 11 members, a user can connect to a DB2 10 member and call ADMIN_COMMAND_DB2 to issue a -DISPLAY THREAD command against a DB2 11 member. In this case, ADMIN_COMMAND_DB2 must be able to process the V11 format of the command output. The following changes are made in DB2 10 to support a mixed release data sharing group with DB2 10 and DB2 11 members: (a) Modifies the stored procedure ADMIN_COMMAND_DB2 to handle the V11 output format of the -DISPLAY THREAD command. (b) Modifies the result table SYSIBM.DB2_THREAD_STATUS and makes it identical to SYSIBM.DB2_THREAD_STATUS in DB2 11. That is, the following columns in this table are modified as follows: FROM TO ---- -- URID CHAR(12) CHAR(20) WORKSTATION CHAR(18) VARCHAR(255) USERID CHAR(16) VARCHAR(128) APPLICATION CHAR(32) VARCHAR(255) ACCOUNTING CHAR(247) VARCHAR(255)
Temporary fix
Comments
APAR Information
APAR number
PI66296
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-07-24
Closed date
2016-11-22
Last modified date
2017-07-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI42893 UI42894 PI84488
Modules/Macros
DSN@DMCD DSN@DMCW DSN@RIN DSNADMCA DSNADMCB DSNADMCD DSNADMCW DSNTESR DSNTRIN HDBAA10J
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
13 July 2017