클릭해서 보세용
*--------------------------------------------------------------------- *
* CODE ABEND MESSAGE DESCRIPTION *
*--------------------------------------------------------------------- *
FABH0350E *HSSR FALLS BACK TO DL/I FOR NAMED DBD (ALL DBDS)
BECAUSE OF FOLLOWING PROBLEM IN DBD=...
FABH0343E HSSR INITIALIZATION HAS INTERCEPTED A PGM CHCK
HSSR UNLOAD시에 HSSR의 VERSION이 틀려서 발생
HSSR LIB을IMSVS.DBT.SFABLMD0.V510으로OVERRIDE
*----------------------------------------------------------------------*
IEC070I 034-202,LNCNGMH0,PS020 JS010,SYS00041,0441,CTO241
=> SPACE SHORTAGE
R0004(DB2) NO BACKUP COPIES FOUND : NORMAL
NO INDEXES FOUND FOR TABLESPACE : NOT ERROR (DB2 VER 3.1)
NORMAL JOB : NOT ERROR
NORMAL COMPLETE : NOT ERROR
UNABLE TO CONNECT TO DB2 : NOT ERROR
INDEXSPACE IS EMPTY : NOT ERROR MFILEEDIT
* DSNU726I - DSNUKINP - SCOPE PENDING IS ACTIVE, BUT
THE ENTIRE TABLE SPACE 'LDCYQE01.TYQE02' MUST BE CHECKED
R0004(IMS) ABNORMAL COMPLETED : NOT ERROR : NO SECONDARY INDEX
DATA BASE EMPTY : NOT ERROR
* PSB MOVE중 KEY LENGTH ERROR로 ACB GEN은 실패
DFS0919I PSB --....-- PCB --.....--
KEYLEN SPECIFICATION TOO SMALL
DFS0587I ERROR BUILDING PSB=.... - IT WILL BE
DELETED FROM ACBLIB
R0006( )*
R0008(DB2)* 이전에 ABEND된UTILITY로 인해 TS가 UTUT상태인
TABLE을 BACKUP받으려했음
* DATA SET ALREADY USED FOR PREVIOUS IMAGE : GDG LIMIT ERROR
A REQUIRED DD CARD IS MISSING DDNAME( ) SYS.. : JCL ERROR
DUPLICATE UTILITY FOUND IN SYSUTIL : RUN THE SAME JCL AGAIN
* UNABLE TO CONNECT TO DB2 : OTHER JOB CONTENTION
UNABLE TO CONNECT TO DB2 : NOT ERROR : DB2 SYSTEM DOWN
UNEXPECTED RACXTRT ERROR : TIME OUT BECAUSE OF DEADLOCK
UNABLE TO CONNECT TO DB2 : DB2 REGION ERROR
ABNORMAL COMPLETED : TIME OUT BECAUSE OF DEADLOCK
UTILITY BATCH MEMORY EXECUTION ABEND :
EXECUTION TO ANOTHER SYSTEM :
KEY WORD 'DEVT' IGNORED :
R0008(IMS)* BMC2759 DUPLICATE KSDS KEY ENCOUNTERED IN DDNAME=LDCDSK11
DUMP LOG에 DUP KEY가 있음（오른쪽HEX아닌부분)
* BMC2758 SIX의 KEY SEQUENCE ERROR (DB REORG중 SIU STEP)
DUMP LOG에 OUT OF SEQUENCE있음 (")
* IEC161I 072-053 RECOVERY중 CISIZE가 달라서
* DFS0587I ERROR BUILDING PSB=.....
DFS0929I BLDL FAILED FOR ....
R0012(TAPE) IEC143I 213-30, writing PDS Contention
R0012(cobol) SYSTEM COMPLETION CODE=0CB REASON CODE=0000000B
divide exception error
R0012(DB2) UNABLE TO CONNECT TO DB2 : AUTHORITY ERROR
* USER NOT AUTHORIZED TO ACCES TABLESPACE : DBA ERROR
CANCELED DUE TO DEVICE CONTENTION : CONTENTION
QSAM ERROR : SYSIN ERROR
UNABLE TO ALLOCATE SPACE ON USER VOLUME : VOLUME FULL ERROR
R0012(IMS) QSAM ERROR : SYSIN ERROR
DATA SET IS ALLOCATED TO ANOTHER JOB.. : CONTENTION
* UNABLE TO ALLOCATE SPACE ON USER VOLUME : VOLUME FULL ERROR
CONSTANT '21607180' NOT WITHIN VALUE RAN.. : SYSIN ERROR
PGM ERROR : VOLUME NOT FOUND : SYSIN ERROR
INPUT STREAM END OF FILE FOUND BEFORE EN.. : SYSIN ERROR
QSAM ERROR : INVALID RECORD LENGTH ERROR
QSAM ERROR : SYSIN ERROR
DEFINE ERROR : SYSIN ERROR
QSAM ERROR : JCL ERROR
DSN CONTENTION : TAPE ERROR
UNABLE TO OPEN DATA SET :
REQUEST SPACE WAS NOT ALLCATED : SYSIN ERROR
AMS/CATALOG FUNCTION SUPPRESSED : ACF ERROR
R0012(EDVR)*SMGR116E SYNCHRONIZATION ERROR
PR에서 RETREIVE하지 않고 GEN했을 때
MOVE시 SYNCH OPTION을 주고 다시 넘긴다.
R0012(VSAM) QSAM ERROR : SYSIN ERROR
*REPRO OPEN/CLOSE/EOV ERROR DCB정보빼먹고 하면
OUTPUT FILE OPEN시 ERROR발생
*INDEX REORG중 발생
UNLOAD DATASET RELOAD시 발생
I/O ERROR
IDC3300I ERROR OPENING PLGI.ZDBJW.REPOSSX1.G0001V00
IDC3321I ** OPEN/CLOSE/EOV ABEND EXIT TAKEN
*116 -> DATA없는 IMS DB VERIFY시
*118 ->P/G이 이미 I/O목적으로 OPEN해서 PROCESSING
하다가 ABEND발생하여 JLFCMAST FILE이 제대로
CLOSE하지 못했음
*168 -> 다른 TASK나 USER가 이미 사용하기위해 OPEN
R0016(tape) IEFTMS70 3YY-116 OPCODE=36
IEFTMS70 ***** CA-1 ABEND,IO,36 ***** **
IEA794I SVC DUMP HAS CAPTURED:
=> call tape admin
R0016(IMS) USE CHAIN IS NOT EMPTY : DB POINTOR ERROR
POINTOR CHECKER ERROR : DB POINTOR ERROR
DATA SET NOT FOUND : DB POINTOR ERROR
DATA SET NOT FOUND : SYSIN ERROR : VOLUME FULL
SORT CAPACITY EXCEEDED : JCL ERROR
MODULE PCPICP00 FUNCTION GBC STOP : DBD NOT IN IMSVS.DBDLIB
PCF/FPA ERROR POINTER : DB POINTER ERROR
DBDLIB DD STATEMENT NOT FOUND (DBDLIB CODING)
* IEC070I REACH LIMIT EXTENT
* DBD NOT FOUND
* LRECL ERROR
SIX의 DEFINE SYSIN과 SIX SEG SIZE가 틀려서
일반적으로 SIX의 SEG SIZE = KEY FIELD LENGTH이나
특수한 경우에는 SEG SIZE가 더 클수도 있다．
DBIS 에서 만든 SYSIN은 그걸 반영못함．
* recovery 의 s.i build때의 put error
1. index 갯수를 잘못 건 경우
2. vsam extention 119번이상일 경우
--> s.i vsam del/def후 s.i build step!
R0024(db2)* PQC0098E DUPLICATE DATASET FOUND
PQC0192E INTERNAL RC 04 AT LOCATION 0150
R2954(IMS)* PROD INITIAL LOAD중 DBD가 해당DBDLIB에 없어서
*--------------------------------------------------------------------- *
S120 (CICS) IEC161I 120-53 OPEN ABEND
VSAM FILE의 CISIZE 4K->8K 변경시8K짜리 가용 BUFFER
POOL이 없어서 발생
SA13 (DB2)* SYSIN의 COPYDDN과 JCL의 DD NAME NOT MATCHES
SB37 (IMS)* IEC030I B37-08 EOV에서 SEC EXTEND할때
IEC030I B37-04 MOUNT/DEMOUNT ERROR
IEC030I B37-0C 해당 VOLUME에 MAX USER (127 USER)
S013 (IMS)* IEC141I 013-20 IGG0191A,해당 dataset lrecl,blksize확인
S0C1 (DB2)* PROGRAM ERROR (CODING EROR)
S0C4 (DB2)* SEGMENT TRANSLATION EXCEPTION : JCL ERROR
S001 (IMS) DCB EROPT=ABE OR AN INVALID CODE,SYNAD.. : TAPE DEVICE ERROR
* IEC020I DCB EROPT=ABE OR INVALID CODE, SYNAD..
P/G UNLOAD DATASET을 RELOAD UTILITY로 LOAD하려할때
S04E (DB2)* UNLOAD받은COL LENGTH보다 CREATE COL LENGTH가 작아서
* SYSIBM.SYSCOPY DEAD LOCK
* DSNUTILB의 PLAN에 LOCK CONTENTION발생
JOB WITH DUPLICATE UTLID FOUND IN SYSUT :CONSOLE RERUN ERROR
SYSTEM DETECTS AN ERROR IN INTERNAL DB2 :DB2 SYSTEM ERROR
SYSTEM DETECTS AN ERROR IN INTERNAL DB2 :CONTENTION
SYSTEM DETECTS AN ERROR IN INTERNAL DB2 :CONSOLE RERUN ERROR
SYSTEM DETECTS AN ERROR IN INTERNAL DB2 :INVALID TABLE
* RESOURCE UNAVAILABLE, REASON 00D70014, EXTENT LIMIT OVER
* RESOURCE UNAVAILABLE, reason 00C2010D,type 0220
=> DB2 LEVEL ID error( Repair util or drop/create)
=> REPAIR LEVELID TABLESPACE LCED2xx0.Txxx0
* RESOURCE UNAVAILABLE, reason 00C200C1
=> DB2 VCAT ERROR (Query VCAT in CATALOG)
*IEF450I CDBJDHKX JS10 - ABEND=S04E U0000 REASON=00E40070
=> utility data set missing (check jcl)
=> RECFM=U FOR DDNAME SYSUT1(REORG시)
-> SYSUT1은 FIXED,VARIABLE,BLOCKED라고 정의해야함．
S047 (MVS)* IEF450I S047 UNAUTHORIZED PROGRAM REQUESTED
IMS TEAM에서 SE01, 02 ,03에서의 실행을 막았기 때문
S214 (IMS) WAANBK02 DD STATEMENT MISSING : TAPE I/O ERROR
S222 * 강제로 JOB을 CANCEL시켰을 때
S222 (IMS) CONTENTIONED WITH OLSIP9DL : CONTENTION WITH IMS
CONTENTION WITH ONLINE : CONTENTION WITH IMS
TAPE I/O ERROR(50D) : TAPE ITSELF OR TAPE-DEVICE ERROR
TAPE DEVICE PROBLEMS : TAPE-DEVICE ERROR
CANCELED DUE TO DEVICE PROBLEM : TAPE ERROR
RMG CANCELED THE JOB BY SE-REQUET : CONTENTION
S237 (IMS)* IEC023I 237-08 EOV
S306 (IMS)* DFSRESLIB -> DASRESLIB으로 오기
S322 * TIME OUT CLASS기준
S413 (DB2) TAPE DEVIECE I/O ERROR OCCURED(523) : TAPE ERROR
UTILITY BATCH MEMORY EXECUTION ABEND :
S413 (IMS) I/O ERROR OCCURS (TAPE DEV 522-IPC..) : TAPE ERROR
I/O ERROR (SIMULATED CHANNEL ERROR ) :
* IEC145I 143-08 DEVICE I/O ERROR
S413 (VSM) TAPE DEVIECE I/O ERROR OCCURED(523) : TAPE ERROR
S513 * IEC146I 513-0C THE ERROR OCCURED DURING EXECUTION FOR OPEN .
MACRO INSTRUCTION FOR A DATA SET ON MAGNETIC TAPE.
S522 * TIME OUT MVS INSTALL PARAMETER 기준
S613 (DB2) I/O ERROR(DCK:DATA CHECK) : TAPE I/O ERROR
S637 (MVS)* I/O ERROR
THE ERROR OCCURRED DURING END-OF-VOLUME FOR A
DATA SET ON MAGNETIC TAPE OR AN END-OF-VOLUME DURING
CONCATENATION.
S714 (DB2) I/O ERROR(DCK:DATA CHECK) : TAPE DEVICE ERROR
S714 (IMS) I/O ERROR(DCK:DATA CHECK) : TAPE DEVICE ERROR
S804 (IMS) ERROR DURING GETMAIN SYSCODE 804-10 :
S806 (IMS) DFSRRC00 을 DASRRC00으로 오기
S806 (PGM) PGM을 찾지 못한 경우 발생
SUB PGM 의 경우 JCL에 TLCE.DB2.MODLIB 을 STEPLIB
에 포함하여야함(TEST PGM 수행시)
S822 (IMS) IEF085I REGION UNAVAILABLE, ERROR CODE=20
JCL내 RESION=8192K -> 0K 변경으로 해결
S813 (DB2) DSNAME NOT MATCH TLS RECORD DSNAME :
(IMS)* IEC149I 813-04 TAPE-DEVICE I/O ERROR
S837 (IMS) USED MORE THAN 5 OUTPUT TAPE : VOL( ) SER JCL ERROR
S878 (JCL) DD CARD에 DCB정보를 주지않아 발생
IN THIS CASE , ADD ",DCB=BUFNO=1"
IEA995I SYMPTOM DUMP OUTPUT
SYSTEM COMPLETION CODE=878 REASON CODE=00000010
TIME=16.27.59 SEQ=62448 CPU=0040 ASID=011A
-----------------------------------------------
END OF SYMPTOM DUMP
MVS0010I LCEJ6SYS 02.080 S JS010 ** R0012 **
S913 (IMS)* ACF2 VIOLATION : JCL ERROR
*--------------------------------------------------------------------- *
* ONLINE-PROGRAM MESSAGE(CICS) *
*--------------------------------------------------------------------- *
DFHSR0001 ASECICPP An abend (code 0CB/AKEA)
has occurred at offset X'000049E2' in program LNCPPT5C.
=> COMPILE OUTPUT의 OFFSET을 찾아위치 확인가능．
=> 0CB Decimal-divide exception. The reason code is B.
CF) => 0CC Exponent-overflow exception. The reason code is C.
=> 0CD Exponent-underflow exception. The reason code is D.
=> 0CE Significance exception. The reason code is E.
=> 0CF Floating-point-divide exception. The reason code is F.
*--------------------------------------------------------------------- *
* DB2 REASON CODE *
*--------------------------------------------------------------------- *
00C200EA Buffer manager(BM) is unable to perform the drain function
on an object. The object was held by another function.
00C90101 -DBF5 DSNIRNXT DATA IN USE DURING ABEND
1. ERQUAL 5005 : POTENTIALLY INCONSISTENT DATA
2. ERQUAL 53CB &
DSNT408I SQLCODE = -904 & REASON 00E30100 &
TYPE OF RESOURCE 00000906 ....
: 테이블(T2A10)의 경우 PROD는 ALTER 되고
, DBF5 DROP 후 RECREATE 되어 FLCE VSAM 의 LENGTH
와 DBD 정보가 맞지 않음（？）
==> DUMMY COL 을 추가하던지 마지막 COL을 제외하고
생성한후 ALTER 를 하던지．．．
00C90082 Attempt to allocate a resource that is started for DB2 Util
ity function
00C90083 Attempt to allocate a resource that is started for DB2 Util
ity function , read-only status
00C90084 Temporary file with the page size shown in NAME is not
available.Error during opening th page set or formatting
header and space map page.
00C90085 Limit of 253 extends for a temporary file has been reached
00C90086 Attempt to allocate a resource that is started for DB2 Util
ity, utility access only. DSNT501I
00C90087 Page that is marked as 'broken' has been read.
00C90089 EDM pool shortage
00C9008E lock request failed
00C90205 ERQUAL 5005 : POTENTIALLY INCONSISTENT DATA
CHECK INDEX 후 INDEX RECOVERY
*--------------------------------------------------------------------- *
U0016(VSM) SORTIN IS AN UNINTIALIZED SEQUENTIAL.. : NOT ENOUGH SORTWORK
(VSM) SORT CAPACITY EXCEEDED : SMS'S MISTAKE TO ALLOCATE SORTWORK
(DB2) INSUFFICIENT VIRTUAL STORAGE
U0101(WAA) A USER EXIT HAS RETURNED WITH AN INVALID CODE IN REGISTER
15.THE INVALID CODE IS STILL IN REGISTER 15 WHEN THE DUMP
IS TAKEN
U0253(IMS) DBD NAME 'LPCDPA20' DOES NOT MATCH ANY OF THE DBDS IN THE
PSB, ABEND 253
DLT0의SYSIN에 DBD NAME이 틀렸을 때
U0821(IMS)* DFS564I DMB LDCDPA40 REFERENCES UNKNOWN DMB LDCDSA44
DMB STOPPED IMP2
- LDCDSA44추가시 OLD DBD를 가지고 PSBBUILD된 경우
U0828(IMS)* DUPLICATE INDEX KEY INSERT하려할때
U0850(IMS)* DBD NO MATCHING , TEST에서 PROD DB걸고 작업하는 경우
HIDAM은 문제 없으나 HDAM은 ERROR/ POINTER BREAK
U0852(IMS)* backup 중 pcp에서 error --> maybe pointer broken.
U0868(IMS)* WHEN INSERTING A HIDAM ROOT WITH A TWIN BACKWARD POINTER
IN UPDATE MODE, THE TWIN FORWARD POINTER WAS FOUND TO
BE ZERO
U0888(IMS) TAPE DEVICE EQC ERROR : TAPE DEVICE ERROR
(IMS) SYSTEM ERROR : PROC ERROR
U0929(IMS)* DFS0929I PROD INITIAL LOAD중 DBD NOTFOUND
DBDLIB잘못걸었을때
U1010(WAA) BAD OPEN OF VSAM FILE
U1020(VSM)* IEC161I 039-061 AIX있는 VSAM FILE의DEFINE/BUILD순서
가 잘못되었음．
(WAA) READ FAILED FOR VSAM FILE
U1030(VSM) SHOWCD ERROR
U1040(VSM) MODCB FAILED CHAINING FOR ESDS FILE
U1041(IMS)* DHAI(CICS USER), AI OPEN ERROR
DFS0730I UNABLE TO OPEN DATA SET WITH DDNAME LKYDPPG0 FOR
REASON O,A8, DATABASE LKYDPPG0 PSB PMPBCA7P IMP1
(IMS)* DHGP(BATCH) GU에서ROOTKEY > WORK로 읽어 WORK와
READ된 ROOTKEY값이 다른데도 GNP에서 WORK로
KEY를 주고 읽었음
GP ==> NO PARENTAGE ESTABLISHED
U1050(IMS)* DURING INDEX REORG, KEYS OUT OF SEQUENCE AT LOADING REPRO
INPUT DATASET.
(VSM)* VSAM REORG중 RELOAD시 발생 KEYS OUT OF SEQUENCE
U2000(IMS) WANNVSAM NOT OPEN :
(WAA)* IEC161I 072-053,LKYDV0BA,PS130 JS010,WAANVSAM,,,
VSAM FILE BACKUP중RECORD가 없을 경우
* IEC161I 052-084 VSAM NOT CLOSED, CONTENTION
U2010(WAA) NO BACKUP FILE OPEN
U2020(WAA) SPAN PROCESSING NOT ALLOWED
U2025(DB2) MVS0010I LNCNPTB0 99.108 H JS010 PS040 ** U2025 **
=> PGM ERROR DUE TO -904(UNAVAILABLE RESOURCE)
U2030(WAA) RRDS PROCESSING NOT ALLOWED
U2040(WAA) BAD RETURN FROM SHOWCB
U2050(WAA) BAD RETURN FROM MODCB
U2060(WAA) BAD RETURN FROM REOPEN
U2070(WAA) BAD RETURN FROM POINT
U2080(WAA) BAD RETURN FROM GET
U2090(WAA) CI IN BUFC DISAGREES WITH CI ADD FROM VSAM
Unload dataset LRECL ERROR (LISTCAT & SIZE COMPARE)
U2633(IMS) 'SEGMENT#00' TWIN CHAIN SEQUENCE FIELD NOT.. : DB BROKEN
U2634(IMS)* PACKER삭제한DBD로PACKER적용된 DB를 UNLOAD하고
적용안된 DBD로 LOAD하려할때
BMC2634 ROOT SEGMENT NOT IN SEQUENCE
U2654(IMS)* DBD의 KEYLENGTH와 DEFINE한 DATASET의CATALOG상의
KEY LENGTH가 맞지 않을 때 ( DEFINE SOURCE수정)
U2835(BMC)* LOAD척 ERROR u p BMC2835
REPORT쐴SPACE ALLOCATE맞 ERROR,RERUN
U2893(IMS)* DBAT의 SOURCE LENGTH가 틀려서
U2849(IMS)* BMC2849 VSAM DATASET NOT EMPTY (RELOAD중)
U3000(WAA) BAD GET IN READ ROUTINE
U3057(IMS)* DB2,IMS/DB같이ACCES하는 PRGRAM의 BATCHJCL 실행중
PARM PARAMETER에DSNMTV01을 써야함. P/G NAME썼음
U4013(IMS) DB ERROR : SYSIN ERROR
* FABH0581E OPEN OF DBD=... KSDS --- OPEN FAILED
PIX없는데 UNLOAD하려했음
* UNLOAD에서변경된 DBD로 UNLOAD하려했기 때문
FABH0031E DDNAME=.... DATA REQUEST OUTSIDE OF DATASET LLIMIT
FABH0661E RBA REQUEST BEYOND ORIGINAL DATASET LIMITS
DDNAME=...........
* IEC161I 072-053,LKYDBRJK,PS10 JS10,LKYDPJK0,,,
+FABH0591E: OPEN OF DBD=LKYDPJK0 DDN=... ESDS- OPEN FAILED
=> VIRTUAL MEMORY ERROR 라고 사료됨．RESTART!!!!
U4000(WAA) MAXIMUM WAITS EXCEEDED
U4032(IMS) DFS629I LPC P/G PLITDLI으로 P/G HEAD SETTING
DLITPLI으로 수정후 EDVR ADD/MOVE
U4040(WAA) NO PARAMETER IS SUPPLIED
U4044(WAA) NO DELIMITER IS CODED AND THE FIRST FOUR CHARACTERS OF
THE PARAMETER ARE NOT NUMERIC
U4050(WAA) NO USER ABEND CODE SUPPLIED OR PARAMETER WAS STARTED WITH
A DELIMITER
U4082(WAA) PROGTME2 DATA SET CANNOT BE OPENED
U4083(WAA) PROGTME3 DATA SET CANNOT BE OPENED.
U4088(WAA) USER PROGRAM ABENDED
U4089(WAA) ERROR IN FINDING PROGRAM TO BE EXECUTED
1. COMPLIEL/LINK STEP UNSUCCESSFUL
2. NAME OF PROGRAM CAN NOT BE FOUNDED
U4092(WAA) CONTROL CARD ERRORS
U4094(IMS)* IEC512I TAPE I/O ERROR : TAPE ITSELF OR TAPE-DEVICE ERROR
* BMC8373C CISIZE,LREC MISMATCH (RECOVERY)
* IEC151I A13-10,IFG0195H
VSAM DDNAME & COPY DDNAME MISMATCH SYSIN
* BMC2954 CANNOT FIND DBD "@@@DPXX0"
WRONG DD CARD IN ICP SYSIN
* BMC2954 CANNOT FIND DBD "@@@DPXX0"
WRONG DD CARD IN ICP SYSIN
* BMC8454C LGODPXX0 DUMP DATA SET DOES NOT MATCH DBD
IMAGECOPY시의 DBDNAME과 RESTORE시의
DBDNAME이 불일치-> IMAGECOPY때 DBDNAME을 가
지고있어 DBD내용이 같아도 NAME틀리면
RESTORE불가능
U4095(IMS)* DSR4101 MAXIMUM NUMBER OF EXTENTS REACHED FOR VSAM DATASET
* IEC070I 104-204, EOV ERROR SEC.SPACE CAN'T ALLOCATE
(WAA) DATA ERROR OR IOS CONTROL BLOCK ERRORS
(WAA) USER ABEND CODE IS GREATER THAN 4095
U4096(IMS)* IEC151I A13-10 IMCP DD문순서와 SYSIN순서가 틀려서
*--------------------------------------------------------------------- *
-104 SQLSTATE=42501 ILLEGAL SYMBOL
-122 SQLSTATE=42803 A SELECT STATEMENT WITH NO GROUP BY CLAUSE
CONTAINS A COLUMN NAME AND A COLUMN FUNCTION IN THE SELECT
CLAUSE OR A COLUMN NAME IS CONTAINED IN A SELECT CLAUSE
BUT NOT IN THE GROUP BY CLAUSE
-181 SQLSTATE=22007 THE STRING REPRESENTATION OF A DATETIME
VALUE IS NOT A DATETIME VALUE
-199 SQLSTATE=42601 ILLEGAL USE OF KEYWORD
-204 SQLSTATE=42704 DBNAME.TSNAME IS A UNDEFINED NAME
-206 BIND시발생 TABLE COLUMN NOT MATCHING TO CATALOG COLUMN
-303 SQLSTATE=42806 A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST
VARIABLE MEMBER 011 BECAUSE THE DATA TYPES ARE NOT
COMPARABLE
-404 SQLSTATE=22001 THE UPDATE OR INSERT STATEMENT SPECIFIES A
STRING THAT IS TOO LONG COL-NAME
-407 SQLSTATE=23502 PK에 NULL을 INSERT/UPDATE
-501 SQLSTATE=24501 THE CURSOR IDENTIFIED IN A FETCH OR CLOSE
STATEMENT IS NOT OPEN
-502 SQLSTATE=24502 THE CURSOR IDENTIFIED IN AN OPEN STATEMENT
IS ALREADY OPEN
-514 SQLSTATE=26501 THE CURSOR CUR-NAME IS NOT A PREPARED STATE
-530 SQLSTATE=23503 FK FIELD INSERT/UPDATE시없은 VALUE사용
-531 SQLSTATE=23504 PK UPDATE RESTRICT
-532 SQLSTATE=23504 PK DELETE RESTRICT
-538 FOREIGN KEY와 PRIMARY KEY의 DATA TYPE이 맞지않음
-551 AUTH-ID DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
OPERATION ON OBJECT OBJECT-NAME.(object에대한권한check)
-623 INDEX CREATE시에 CLUSTER OPTION을 다른 INDEX에도사용
-679 TS CREATE시 DROP후 COMMIT없이 곧바로 CREATE시도
-803 SQLSTATE=23505 PK DUPLICATE
-805 * DBRM과 P/G SQL문의 TIMESTAMP불일치
PRECOMPILE부터 다시 해야함
DB2가 해당PLAN중 PKLIST DBRM의 TIMESTAMP가 일치
하는 PACKAGE를 못찾음 SQLSTATE=51002
* CICS RCT 등록안된 경우 DEFAULT 란 PLAN을 DB2로 넘
김 ==> REASON = 03
* PGM RUN 시에PACKAGE임에도 공통PLAN을 걸어주지 않음
-811 SQLSTATE=21000 THE RESULT OF AN EMBEDDED SELECT STATEMENT
IS A TABLE OF MORE THA ONE ROW, OR THE RESULT OF SUBQUERY
OF A BASIC PREDICATE IS MORE THAN ONE VALUE
-818 * DBRM과 P/G SQL문의 TIMESTAMP불일치
PRECOMPILE부터 다시 해야함
DB2가 해당PLAN중 MEMBER DBRM의 TIMESTAMP가 일치
하는 PACKAGE를 못찾음 SQLSTATE=51003
-904 * DB2 VOLUME ERROR
* REASON 00C2010D : DSN1COPY로 VSAM->VSAM일 경우
HEADER PAGE의정보가 변경되어 DATASET OPEN ERROR
＝＝＞ REPAIR로 해결해야 함
* DB2 TABLESPACE DROP없이 VSAM DEFINE새로하고 TABLE만
DROP 한후 CREATE하려했을때 REASONCODE=00C90094
* COPY PENDING걸린 TABLE을UPDATE, DELETE하려했을때
* CHECK PENDING상태의 TABLE을ACCESS하려했을때
SQLSTATE=57011 REASONCODE=00C900A3
* TEMP FILE, VSAM EXTENTION FULL
REASONCODE=00C900A5, RESORCE TYPE =230, RESORCE NAME=4K
* REASONCODE=00C90096, RESORCE TYPE =302, RESORCE NAME=4K
=> 임시로 lock table을 사용하여 numlkus를 줄임．
-911 * DB2 JOB CONTENTION
-923 * DB2 DOWN OR DB2 OPEN ERROR .. 다른 REGION에서 실행
* E0030302 AUTO-BIND실행중 ERROR발생
-924 * DB2 CONNECTION ERROR : ROLLBACK시도중 발생
-922 * AUTHORITY ERROR : ERROR TYPE 4가지 이므로 TYPE과
REASON CODE가 있어야 정확한 원인규명이 가능함
대개의 경우 PLAN문제일 경우가 많다．
* PLAN이UT에만 있고 PROD에 없는상태에서
PROD REGION을 걸고 작업했을 경우
* CICS 에 RCT등록안된 상태에서 INVOKE시켰을 경우
TSE1.XCIUF.AUTODELE
* LCEJPROD 가 LNC-PLAN 에대한 EXCUTION 권한이 없음
* CICS 에 RCT 등록을 잘못한 경우
*--------------------------------------------------------------------- *
IEC161I 120-053 BUFFER를 너무 많이 잡아서 (MAX < ) 해당
DBD 에 대한 OPEN FAILED
*--------------------------------------------------------------------- *
PTQC028 * IF SHRLELVEL IS CHANGE, MODIFYBITS MUST BE NO.
PLATIMUN QUICK COPY중 발생
*--------------------------------------------------------------------- *
PGU4040(WAA) NO PARM SUPPLIED
PGU4043(WAA) THE PARM IS LONGER THAN ALLOWED, MESSAGE MAY BE TRUNCATED
PGU4044(WAA) NO DELIMITER CODED AND FIRST FOUR CHARACTERS OF THE
PARAMTER NOT NUMERIC
PGU4046(WAA) THE ABEND CODE IS LONGER THAN FOUR, AND NO DELIMITER
WAS CODED
PGU4050(WAA) NO ABEND CODE PASSED
PGU4047(WAA) NO USER MESSAGE SUPPLIED
PGU4095(WAA) SUPPLIED ABEND CODE IS GREATER THAN 4095
[출처] ABEND CODE집|작성자 희성지애
