A fix is available
APAR status
Closed as program error.
Error description
DB2 QUERY MONITOR #EXCP SUBTASK ABEND with SYSTEM COMPLETION CODE SAC7-00080001 may occur when the #EXCP task is trying to schedule a cleanup before #SSMN is finished installing DB2, causing the #EXCP task to recover, resulting in a dump. Additional symptoms can include an S878 abend that may eventually result from a storage leak in the #EXCP subtask after repeated abends in inflight subroutine.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM DB2 Query Monitor * **************************************************************** * PROBLEM DESCRIPTION: While testing compatibility between 2.2 * * and 2.3: * * * * Stopped 2.2 was monitoring (n7a, n71a, * * n8a, n8a1,n9a) * * Started 2.3 (N8A, N9A) * * Started 2.2 (N7A, N71A) * * * * Did an activate for N81A in 2.3 * * (CQMDEV1) * * 13:22:56.32 S0223549 00000090 * * CQM3006I MONITORING AGENT * * ACTIVATED FOR N81A * * 13:22:56.32 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * OBTAIN * * MASTER ENQ * * 13:22:56.32 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * OBTAIN CQMDB2 ENQ * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * OBTAIN SQLHOOK ADDRESS * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * ACQUIRING SRB PLISTS * * 13:22:56.33 S0223549 00000090 * * VERIFYING RESMGR STATUS * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * OBTAIN ADHDB2 ENQ * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: SETUP * * CLEANUP SRB * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CONNECT PC FOR DB2 * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * INITIALIZE SMDB2 AREA * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: SETUP * * LOOP DETECTION * * 13:22:56.33 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * SCHEDULE MASTER SRB * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: SETUP * * COLLECTOR ABEND TABLE * * 13:22:59.20 S0223549 00000090 IEA794I * * SVC DUMP HAS CAPTURED: * * 251 * * 251 00000090 DUMPID=003 * * REQUESTED BY JOB (CQMDEV1 ) * * * * 251 00000090 DUMP TITLE=DB2 * * QUERY MONITOR #EXCP SUBTASK * * ABEND 251 00000090 * * * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATED DB2 SHARED AREAS * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATE WORK POOL * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATE THREAD SPACE * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATE LOCATOR SPACE * * 13:22:59.21 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: CREATE * * 13:22:59.22 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATE LOG RECORD POOL * * 13:22:59.22 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * ACQUIRE SYSTEM OWNERSHIP * * 13:22:59.22 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: * * CREATE PROFILE POOL * * 13:22:59.22 S0223549 00000090 * * CQM9993I INSTALL_DEBUG: LOAD * * CQM PROFILES * * 13:22:59.38 00000281 IEF196I * * IGD17070I DATA SET * * SVCDUMP.D080502.T182256.RS52.S00003 * * 13:22:59.38 00000281 IEF196I * * ALLOCATED SUCCESSFULLY * * WITH 1 STRIPE(S). * * 13:22:59.38 00000281 IEF196I * * IGD17160I DATA SET * * SVCDUMP.D080502.T182256.RS52.S00003 * * 13:22:59.38 00000281 IEF196I * * IS ELIGIBLE FOR COMPRESSION * * 13:22:59.38 00000281 IEF196I * * IGD101I SMS ALLOCATED TO * * DDNAME (SYS00008) * * 13:22:59.38 00000281 IEF196I * * DSN * * (SVCDUMP.D080502.T182256.RS52.S00003) * * 13:22:59.38 00000281 IEF196I * * STORCLAS (DUMP) * * MGMTCLAS (DUMP) DATACLAS (EFCOMP) * * 13:22:59.39 00000281 IEF196I * * VOL SER NOS=DMP202 * * * * CQM3254I DIAGNOSTIC DATA FOR * * STARTED TASK(CQM,DEV1): * * CQM3206I DIAGNOSTIC DATA FOR * * ABEND AT PSW 040C10008143F2DA * * CQM3221I JOB/ASID:SYSTEM / * * AUTH:SYSTEM PROGRAM:UNKNOWN +00000 * * CQM3266I HOME ASID: 0083 * * PRIMARY ASID: 0083 SECONDARY ASID: * * 0083 * * CQM3207I SYSTEM COMPLETION * * CODE SAC7-0001 * * CQM3208I OCCURRENCES 1 * * DATE 05/02/2008 TIME 13:22:56 * * CQM3209I HIGH 0-3 00000234 * * 00000000 00000000 00000000 * * * * CQM3209I GPR 0-3 07D7E33C * * 04AC7000 02B09A18 02B099C8 * * * * CQM3210I HIGH 4-7 00000000 * * 00000000 00000000 00000000 * * * * CQM3210I GPR 4-7 00000BE0 * * 0F051A1C 00000000 00000008 * * * * CQM3211I HIGH 8-11 00000000 * * 00000000 00000000 00000000 * * * * CQM3211I GPR 8-11 0144100A * * 8143F00C 0144000B 00000BE0 * * * * CQM3212I HIGH 12-15 00000000 * * 00000000 00000000 00000000 * * * * CQM3212I GPR 12-15 01442009 * * 02B098F8 8143F2B8 00080001 * * * * CQM3213I AR 0-3 00000000 00000000 * * 00000000 00000000 * * * * CQM3214I AR 4-7 00000000 00000000 * * 00000000 00000000 * * * * CQM3215I AR 8-11 00000000 00000000 * * 00000000 00000000 * * CQM3216I AR 12-15 00000000 00000000 * * 00000000 00000000 * * * * The abend is an ac7-00080001 which * * states: 00080001 * * Explanation: The space token specified * * via the TARGETSTOKEN keyword on * * IEAMSCHD is not valid. * * This occurred because the #EXCP task * * was trying to schedule a cleanup * * before #SSMN was finished installing * * the DB2. The #EXCP task * * recovered and took a dump. This is a * * simple timing error and would * * have gone unnoticed had it not taken * * the dump. * * Additional symptoms can include an * * S878 abend that may eventually * * result from a storage leak in the * * #EXCP subtask after repeated * * abends in inflight subroutine. * **************************************************************** * RECOMMENDATION: * **************************************************************** Code changes have been made to address these issues
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PK73957
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
230
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-10-16
Closed date
2008-11-13
Last modified date
2008-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQMMINST
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R230 PSY UK41562
UP08/11/19 P F811
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":"230"}]
Document Information
Modified date:
17 March 2021