Invocation for DB2ALRT solution
This solution is invoked by Rules for these major DB2 messages:
DSN3201I ABNORMAL EOT IN PROGRESS FOR USER= CON-ID= COR-ID=
DSNB200I UPDATE VVDS FAILED
DSNB204I OPEN OF DATA SET FAILED. DSNAME = dsn
DSNB207I DYNAMIC ALLOCATION OF DATA SET FAILED. REASON = rrr DSNAME = dsn
DSNB217I csect-name - ONLINE RECOVERY FOR AN INCONSISTENT PAGE
WAS UNSUCCESSFUL FOR DBNAME = dbn, SPACENAME = spn,
PAGE NUMBER = X'pno'
DSNB224I csect-name - BUFFER MANAGER I/O ERROR DURING function DBNAME=dbn, ...
DSNB225I BUFFER MANAGER I/O ERROR
DSNB226I BUFFER MANAGER DETECTED INVALID PAGE
DSNB227I DFHSM RECALL FAILED
DSNB551I BSDS READ ERROR
DSNB552I BSDS WRITE ERROR
DSNB553I BSDS INSERT ERROR
DSNB601I BUFFER POOL nn FULL
DSNB602I UNABLE TO CREATE BUFFERPOOL
DSNB603I INSUFFICIENT STORAGE FOR BUFFERPOOL EXPAND/CREATE
DSNB605I INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL
DSNB606I INSUFFICIENT STORAGE FOR HIPERPOOL
DSNB607I UNABLE TO CREATE HIPERPOOL - NO EXPANDED
DSNB608I UNABLE TO CREATE HIPERPOOL
DSNB609I VIRTUAL BUFFERPOOL IS ZERO - DEFAULT USED
DSNB610I UNABLE TO CREATE HIPERPOOL - NO ADMF
DSNB611I HIPERPOOL DELETED - ADMF INACTIVE
DSNC001I CICS UR INDOUBT RESOLUTION IS INCOMPLETE FOR name
DSNC030E ERROR WRITING TO TRANSIENT DS
DSNC034I INDOUBT RESOLUTION FOR ur-id IS INCORRECT
DSNC035I INDOUBT RESOLUTION INCOMPLETE
DSNC036I INDOUBT RESOLUTION FOR ur-id IS INCONSISTENT
DSNC901I UNRECOVERABLE I/O ERROR IN DSNCCOM1
DSNI001I RESTART HAS BEEN DEFERRED
DSNI007I UNABLE TO DIRECT READ A LOG RECORD
DSNI010I BROKEN PAGE ACCESSED TYPE type NAME name MODNAME
csect-name CONN-ID id CORR-ID id
DSNI012I PAGE LOGICALLY BROKEN TYPE type NAME name MODNAME
modname ERQUAL erqual
DSNJ004I ACTIVE LOG COPY n INACTIVE, LOG IN SINGLE MODE, ENDRBA=...
DSNJ008E nn OF mm ACTIVE LOGS ARE FULL ssname NEEDS ARCHIVE
SCRATCH. REPLY YY WHEN DEVICE READY OR N TO CANCEL
DSNJ013I TERMINAL ERROR ccc IN BUFFER rrr BEFORE ACTIVE LOG WRITE
DSNJ014I TERMINAL ERROR ccc IN BUFFER rrr AFTER ACTIVE LOG WRITE
DSNJ073I LOG ARCHIVE UNIT ALLOCATION FAILURE DETECTED,
RETURN CODE = nnnn. ALLOCATION OR OFF-LOAD OF ARCHIVE
LOG DATA SET MAY FAIL
DSNJ100I csect-name ERROR OPENING BSDSn DSNAME=..., ERROR STATUS=...
DSNJ102I LOG RBA CONTENT OF LOG DATA SET DSNAME=... STARTRBA=..
ENDRBA=.. DOES NOT AGREE WITH BSDS INFORMATION
DSNJ103I LOG ALLOCATION ERROR DSNAME=dsname, ERROR STATUS=eeeeiiii
DSNJ104I csect-name RECEIVED ERROR STATUS nnn FROM macro-name FOR DSNAME dsname
DSNJ105I csect-name LOG WRITE ERROR DSNAME=..., LOGRBA=...,ERROR STATUS=ccccffss
DSNJ106I LOG READ ERROR DSNAME=..., LOGRBA=...,ERROR STATUS=ccccffss
DSNJ107I READ ERROR ON BSDS DSNAME=... ERROR STATUS=...
DSNJ108I WRITE ERROR ON BSDS DSNAME=... ERROR STATUS=...
DSNJ109I OUT OF SPACE IN BSDS DSNAME=...
DSNJ110E LAST COPYn ACTIVE LOG DATA SET IS nnn PERCENT FULL
DSNJ111E OUT OF SPACE IN ACTIVE LOG DATA SETS
DSNJ115I OFFLOAD FAILED FOR ARCHIVE
DSNJ117I INITIALIZATION ERROR READING BSDS DSNAME=..., ERROR STATUS=...
DSNJ120I DUAL BSDS DATA SETS HAVE UNEQUAL TIME STAMPS, BSDS1
SYSTEM=..., UTILITY=..., BSDS2 SYSTEM=..., UTILITY=...
DSNJ124I OFFLOAD OF ACTIVE LOG SUSPENDED FROM RBA xxxx TO RBA
yyyy DUE TO I/O ERROR
DSNJ126I BSDS ERROR FORCED SINGLE MODE
DSNJ150E LOG CAPTURE EXIT ABEND
DSNL007I DDF IS ABNORMALLY TERMINATING
DSNL033I DDF TERMINATION BECAUSE OF ABEND
DSNL400E INDOUBT THREAD HEURISTIC DAMAGE
DSNL401E INDOUBT THREAD REMOTE ABORT - HEURISTIC DAMAGE
DSNL402I INDOUBT THREAD REMOTE COMMIT - HEURISTIC DAMAGE
DSNL403I INDOUBT THREAD REMOTE ABORT - HEURISTIC DAMAGE
DSNL404E PROTOCOL ERROR
DSNL405I THREAD PLACED INDOUBT
DSNL406I THREAD MAY BE INDOUBT - COMM FAILURE
DSNL408I INDOUBT THREAD HEURISTIC DAMAGE - COORDINATOR
DSNL409I INDOUBT THREAD HEURISTIC DAMAGE - COORDINATOR
DSNL411E COLD START BY COORDINATOR - MANUAL RESOLUTION
DSNL412I PROTOCOL ERROR DURING SYNCHPOINT
DSNL413I PROTOCOL ERROR DURING SYNCHPOINT
DSNL414E PROTOCOL ERROR DURING INDOUBT
DSNL420I COLD START BY PARTICIPANT - POSSIBLE DAMAGE
DSNL421I SNA XLN PROTOCOL VIOLATION
DSNL500I CONVERSATION FAILED TO LOCATION locname ...
DSNL501I CNOS PROCESSING FAILED
DSNL502I SYSTEM CONVERSATION FAILED TO LOCATION=locname ...
DSNM002I IMS/VS xxxx DISCONNECTED FROM SUBSYSTEM yyyy RC=rc
DSNM004I RESOLVE INDOUBT ENTRY(S) ARE OUTSTANDING FOR SUBSYS xxxx
DSNM005I RESOLVE INDOUBT SYNCHRONIZATION PROBLEM WITH SUBSYS xxxx
DSNP001I DSNPmmmm - dsn IS WITHIN n KBYTES OF AVAILABLE SPACE
RC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP007I DSNPmmmm - EXTEND FAILED FOR dsn
RC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP011I DSNPmmmm - MEDIA MANAGER SERVICES ERROR FOR dsn. MMRC=C
DSMRC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP012I DSNPmmmm - ERROR IN VSAM CATALOG LOCATE FUNCTION FOR dsn
CTLGRC=r CTLGRSN=r CONNECTION-ID=id CORRELATION-ID=id
DSNP015I IRLM MANUAL UNLOCK FAILED
DSNP028I HSM RECALL FAILED
DSNT377I PLAN plan-id1 WITH CORRELATION ID id1 CONNECTION ID id2
IS IN CONFLICT WITH AN INDOUBT THREAD
DSNT500I csect-name RESOURCE UNAVAILABLE REASON r TYPE t NAME n
DSNT501I csect-name RESOURCE UNAVAILABLE CORRELATION-ID id1
CONNECTION-ID id2 REASON r TYPE t NAME n
DSNV086E DB2 ABNORMAL TERMINATION REASON=xxxxxxxx
DXR013E ABEND UNDER IRLM TCB/SRB
DXR016E BUCK PROCESS TIME EXCEEDS 30 SECONDS
DXR019E STORAGE POOL DESTROYED
DXR021E ABEND VTAM ERROR
DXR022E SUBTASK FAILURE
DXR023E INTERNAL OR MVS ERROR
DXR024E VTAM REQUEST UNSUCCESSFUL
DXR027A SESSION LOST
DXR031E ABEND UNDER PTB SRB
DXR050I OUT OF STORAGE DETECTED DURING DEADLOCK
DSNX905I csect-name PROCEDURE OR FUNCTION name TERMINATED ABNORMALLY ASID= asid WLM_ENV= wlmenv
DSNX906I csect-name PROCEDURE OR FUNCTION name TERMINATED ABNORMALLY. THE PROCEDURE HAS BEEN STOPPED. ASID= asid WLM_ENV= wlmenv
DSNX908I csect-name PROCEDURE OR FUNCTION name WITH LOAD MODULE module EXCEEDED CPU RESOURCE LIMIT SSN= ssn PROC= jclprocASID= asid WLM_ENV= wlmenv
DSNX921I csect-name SOME SQL CALL STATEMENTS CANNOT BE PROCESSED, BECAUSE REQUIRED RESOURCES ARE NOT AVAILABLE REASON=reason TYPE=type NAME=name
DSNX922I csect-name BEGINNING DISCONNECTION OF STORED PROCEDURE ADDRESS SPACES
DSNX923I csect-name ALL STORED PROCEDURE ADDRESS SPACES ARE NOW DISCONNECTED.
DSNX944I csect-name THE STORED PROCEDURE FUNCTION IS NOT AVAILABLE
DSNX950I csect-name PROCEDURE procname HAS NOT BEEN ACCESSED
DSNX953E csect-name STORED PROCEDURE JOBNAME OR STARTED TASK NAME DOES NOT MATCH ZPARM
DSNX954I csect-name ATTEMPT TO START DB2-Established STORED PROCEDURE ADDRESS SPACE PROC= jclproc FAILED
DSNX960E csect-name SOME SQL CALL STATEMENTS CANNOT BE PROCESSED, BECAUSE THE Language Environment ROUTINE CEEPIPI CANNOT BE LOADED SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX962I csect-name THE Language Environment CEEPIPI SERVICE RETURNED AN UNEXPECTED RETURN CODE rc FOR FUNCTION func SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX964I csect-name THE DB2-Established STORED PROCEDURES ADDRESS SPACE FOR SUBSYSTEM subs IS STARTED
DSNX965I csect-name THE DB2-Established STORED PROCEDURES ADDRESS SPACE FOR SUBSYSTEM subs IS STOPPING
DSNX966I csect-name STORED PROCEDURE OR FUNCTION sp FAILED. Language Environment ENCLAVE RC = erc, FEEDBACK INFORMATION = fi SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX967I csect-name ATTEMPT TO PERFORM WLM FUNCTION func FAILED WITH WLM RC= rc RSN= rsn SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX968I csect-name STORED PROCEDURE ADDRESS SPACE IS UNABLE TO CONNECT TO WLM BECAUSE WLM_ENV = wlmenv IS STOPPED OR QUIESCED
DSNX983I csect-neme DB2 STORED PROCEDURE SUPPORT CODE AND SUBSYSTEM CODE ARE NOT AT THE SAME LEVEL SSN= ssn PROC = jclproc
DSNB200I UPDATE VVDS FAILED
DSNB204I OPEN OF DATA SET FAILED. DSNAME = dsn
DSNB207I DYNAMIC ALLOCATION OF DATA SET FAILED. REASON = rrr DSNAME = dsn
DSNB217I csect-name - ONLINE RECOVERY FOR AN INCONSISTENT PAGE
WAS UNSUCCESSFUL FOR DBNAME = dbn, SPACENAME = spn,
PAGE NUMBER = X'pno'
DSNB224I csect-name - BUFFER MANAGER I/O ERROR DURING function DBNAME=dbn, ...
DSNB225I BUFFER MANAGER I/O ERROR
DSNB226I BUFFER MANAGER DETECTED INVALID PAGE
DSNB227I DFHSM RECALL FAILED
DSNB551I BSDS READ ERROR
DSNB552I BSDS WRITE ERROR
DSNB553I BSDS INSERT ERROR
DSNB601I BUFFER POOL nn FULL
DSNB602I UNABLE TO CREATE BUFFERPOOL
DSNB603I INSUFFICIENT STORAGE FOR BUFFERPOOL EXPAND/CREATE
DSNB605I INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL
DSNB606I INSUFFICIENT STORAGE FOR HIPERPOOL
DSNB607I UNABLE TO CREATE HIPERPOOL - NO EXPANDED
DSNB608I UNABLE TO CREATE HIPERPOOL
DSNB609I VIRTUAL BUFFERPOOL IS ZERO - DEFAULT USED
DSNB610I UNABLE TO CREATE HIPERPOOL - NO ADMF
DSNB611I HIPERPOOL DELETED - ADMF INACTIVE
DSNC001I CICS UR INDOUBT RESOLUTION IS INCOMPLETE FOR name
DSNC030E ERROR WRITING TO TRANSIENT DS
DSNC034I INDOUBT RESOLUTION FOR ur-id IS INCORRECT
DSNC035I INDOUBT RESOLUTION INCOMPLETE
DSNC036I INDOUBT RESOLUTION FOR ur-id IS INCONSISTENT
DSNC901I UNRECOVERABLE I/O ERROR IN DSNCCOM1
DSNI001I RESTART HAS BEEN DEFERRED
DSNI007I UNABLE TO DIRECT READ A LOG RECORD
DSNI010I BROKEN PAGE ACCESSED TYPE type NAME name MODNAME
csect-name CONN-ID id CORR-ID id
DSNI012I PAGE LOGICALLY BROKEN TYPE type NAME name MODNAME
modname ERQUAL erqual
DSNJ004I ACTIVE LOG COPY n INACTIVE, LOG IN SINGLE MODE, ENDRBA=...
DSNJ008E nn OF mm ACTIVE LOGS ARE FULL ssname NEEDS ARCHIVE
SCRATCH. REPLY YY WHEN DEVICE READY OR N TO CANCEL
DSNJ013I TERMINAL ERROR ccc IN BUFFER rrr BEFORE ACTIVE LOG WRITE
DSNJ014I TERMINAL ERROR ccc IN BUFFER rrr AFTER ACTIVE LOG WRITE
DSNJ073I LOG ARCHIVE UNIT ALLOCATION FAILURE DETECTED,
RETURN CODE = nnnn. ALLOCATION OR OFF-LOAD OF ARCHIVE
LOG DATA SET MAY FAIL
DSNJ100I csect-name ERROR OPENING BSDSn DSNAME=..., ERROR STATUS=...
DSNJ102I LOG RBA CONTENT OF LOG DATA SET DSNAME=... STARTRBA=..
ENDRBA=.. DOES NOT AGREE WITH BSDS INFORMATION
DSNJ103I LOG ALLOCATION ERROR DSNAME=dsname, ERROR STATUS=eeeeiiii
DSNJ104I csect-name RECEIVED ERROR STATUS nnn FROM macro-name FOR DSNAME dsname
DSNJ105I csect-name LOG WRITE ERROR DSNAME=..., LOGRBA=...,ERROR STATUS=ccccffss
DSNJ106I LOG READ ERROR DSNAME=..., LOGRBA=...,ERROR STATUS=ccccffss
DSNJ107I READ ERROR ON BSDS DSNAME=... ERROR STATUS=...
DSNJ108I WRITE ERROR ON BSDS DSNAME=... ERROR STATUS=...
DSNJ109I OUT OF SPACE IN BSDS DSNAME=...
DSNJ110E LAST COPYn ACTIVE LOG DATA SET IS nnn PERCENT FULL
DSNJ111E OUT OF SPACE IN ACTIVE LOG DATA SETS
DSNJ115I OFFLOAD FAILED FOR ARCHIVE
DSNJ117I INITIALIZATION ERROR READING BSDS DSNAME=..., ERROR STATUS=...
DSNJ120I DUAL BSDS DATA SETS HAVE UNEQUAL TIME STAMPS, BSDS1
SYSTEM=..., UTILITY=..., BSDS2 SYSTEM=..., UTILITY=...
DSNJ124I OFFLOAD OF ACTIVE LOG SUSPENDED FROM RBA xxxx TO RBA
yyyy DUE TO I/O ERROR
DSNJ126I BSDS ERROR FORCED SINGLE MODE
DSNJ150E LOG CAPTURE EXIT ABEND
DSNL007I DDF IS ABNORMALLY TERMINATING
DSNL033I DDF TERMINATION BECAUSE OF ABEND
DSNL400E INDOUBT THREAD HEURISTIC DAMAGE
DSNL401E INDOUBT THREAD REMOTE ABORT - HEURISTIC DAMAGE
DSNL402I INDOUBT THREAD REMOTE COMMIT - HEURISTIC DAMAGE
DSNL403I INDOUBT THREAD REMOTE ABORT - HEURISTIC DAMAGE
DSNL404E PROTOCOL ERROR
DSNL405I THREAD PLACED INDOUBT
DSNL406I THREAD MAY BE INDOUBT - COMM FAILURE
DSNL408I INDOUBT THREAD HEURISTIC DAMAGE - COORDINATOR
DSNL409I INDOUBT THREAD HEURISTIC DAMAGE - COORDINATOR
DSNL411E COLD START BY COORDINATOR - MANUAL RESOLUTION
DSNL412I PROTOCOL ERROR DURING SYNCHPOINT
DSNL413I PROTOCOL ERROR DURING SYNCHPOINT
DSNL414E PROTOCOL ERROR DURING INDOUBT
DSNL420I COLD START BY PARTICIPANT - POSSIBLE DAMAGE
DSNL421I SNA XLN PROTOCOL VIOLATION
DSNL500I CONVERSATION FAILED TO LOCATION locname ...
DSNL501I CNOS PROCESSING FAILED
DSNL502I SYSTEM CONVERSATION FAILED TO LOCATION=locname ...
DSNM002I IMS/VS xxxx DISCONNECTED FROM SUBSYSTEM yyyy RC=rc
DSNM004I RESOLVE INDOUBT ENTRY(S) ARE OUTSTANDING FOR SUBSYS xxxx
DSNM005I RESOLVE INDOUBT SYNCHRONIZATION PROBLEM WITH SUBSYS xxxx
DSNP001I DSNPmmmm - dsn IS WITHIN n KBYTES OF AVAILABLE SPACE
RC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP007I DSNPmmmm - EXTEND FAILED FOR dsn
RC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP011I DSNPmmmm - MEDIA MANAGER SERVICES ERROR FOR dsn. MMRC=C
DSMRC=r CONNECTION-ID=id CORRELATION-ID=id
DSNP012I DSNPmmmm - ERROR IN VSAM CATALOG LOCATE FUNCTION FOR dsn
CTLGRC=r CTLGRSN=r CONNECTION-ID=id CORRELATION-ID=id
DSNP015I IRLM MANUAL UNLOCK FAILED
DSNP028I HSM RECALL FAILED
DSNT377I PLAN plan-id1 WITH CORRELATION ID id1 CONNECTION ID id2
IS IN CONFLICT WITH AN INDOUBT THREAD
DSNT500I csect-name RESOURCE UNAVAILABLE REASON r TYPE t NAME n
DSNT501I csect-name RESOURCE UNAVAILABLE CORRELATION-ID id1
CONNECTION-ID id2 REASON r TYPE t NAME n
DSNV086E DB2 ABNORMAL TERMINATION REASON=xxxxxxxx
DXR013E ABEND UNDER IRLM TCB/SRB
DXR016E BUCK PROCESS TIME EXCEEDS 30 SECONDS
DXR019E STORAGE POOL DESTROYED
DXR021E ABEND VTAM ERROR
DXR022E SUBTASK FAILURE
DXR023E INTERNAL OR MVS ERROR
DXR024E VTAM REQUEST UNSUCCESSFUL
DXR027A SESSION LOST
DXR031E ABEND UNDER PTB SRB
DXR050I OUT OF STORAGE DETECTED DURING DEADLOCK
DSNX905I csect-name PROCEDURE OR FUNCTION name TERMINATED ABNORMALLY ASID= asid WLM_ENV= wlmenv
DSNX906I csect-name PROCEDURE OR FUNCTION name TERMINATED ABNORMALLY. THE PROCEDURE HAS BEEN STOPPED. ASID= asid WLM_ENV= wlmenv
DSNX908I csect-name PROCEDURE OR FUNCTION name WITH LOAD MODULE module EXCEEDED CPU RESOURCE LIMIT SSN= ssn PROC= jclprocASID= asid WLM_ENV= wlmenv
DSNX921I csect-name SOME SQL CALL STATEMENTS CANNOT BE PROCESSED, BECAUSE REQUIRED RESOURCES ARE NOT AVAILABLE REASON=reason TYPE=type NAME=name
DSNX922I csect-name BEGINNING DISCONNECTION OF STORED PROCEDURE ADDRESS SPACES
DSNX923I csect-name ALL STORED PROCEDURE ADDRESS SPACES ARE NOW DISCONNECTED.
DSNX944I csect-name THE STORED PROCEDURE FUNCTION IS NOT AVAILABLE
DSNX950I csect-name PROCEDURE procname HAS NOT BEEN ACCESSED
DSNX953E csect-name STORED PROCEDURE JOBNAME OR STARTED TASK NAME DOES NOT MATCH ZPARM
DSNX954I csect-name ATTEMPT TO START DB2-Established STORED PROCEDURE ADDRESS SPACE PROC= jclproc FAILED
DSNX960E csect-name SOME SQL CALL STATEMENTS CANNOT BE PROCESSED, BECAUSE THE Language Environment ROUTINE CEEPIPI CANNOT BE LOADED SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX962I csect-name THE Language Environment CEEPIPI SERVICE RETURNED AN UNEXPECTED RETURN CODE rc FOR FUNCTION func SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX964I csect-name THE DB2-Established STORED PROCEDURES ADDRESS SPACE FOR SUBSYSTEM subs IS STARTED
DSNX965I csect-name THE DB2-Established STORED PROCEDURES ADDRESS SPACE FOR SUBSYSTEM subs IS STOPPING
DSNX966I csect-name STORED PROCEDURE OR FUNCTION sp FAILED. Language Environment ENCLAVE RC = erc, FEEDBACK INFORMATION = fi SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX967I csect-name ATTEMPT TO PERFORM WLM FUNCTION func FAILED WITH WLM RC= rc RSN= rsn SSN= ssn PROC= jclproc ASID= asid WLM_ENV= wlmenv
DSNX968I csect-name STORED PROCEDURE ADDRESS SPACE IS UNABLE TO CONNECT TO WLM BECAUSE WLM_ENV = wlmenv IS STOPPED OR QUIESCED
DSNX983I csect-neme DB2 STORED PROCEDURE SUPPORT CODE AND SUBSYSTEM CODE ARE NOT AT THE SAME LEVEL SSN= ssn PROC = jclproc
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*