error codes in mainframes

-
File error codes:
00: Successful operation.
02: Duplicate key, non-unique key, alt index.
10: End of file.
20: Invalid key VSAM KSDS/RRDS.
21: Key errors (rewrite & write).
22: Duplicate primary key found.
23: Record not found.
24: Disk filled or key outside of boundary of file.
37: Wrong mode.
39: File attributes do not match COBOL description.
91: password or authorization failed.
92: logic error.
93: Resources are not available.
95: Invalid file information.
96: No DD statement for the file.
97: Open successful.
98: File is locked.
99: Record locked.
--------------------------------------------------------------------------------------------
DB2 Return code.
Note: 0: means successful execution.
-ve: Negative means unsuccessful with an error.
+ve: Positive means successful execution with a warning.
00: Successful operation.
-104: illegal symbol using.
-117: no of values in the insert does not match the no of columns.
-180: wrong data passing to column.
-204: Object not defined to DB2.
-205: Column name not in table.
-206: Column does not exist in any table of the SELECT.
-305: Null indicator needed.
-501: Cursor not opens on FETCH.
-502: Opening cursor that is already open.
-503: Updating column needs to be specified.
-504: Cursor name not declared.
-601: You tried to create an object that already exists.
-803: Duplicate key on insert or update.
-805: DBRM or package not found in plan.
-811: More than one row retrieved in SELECT INTO.
-818: Plan and program: timestamp mismatch.
+100: Row not found or ends of cursor.
--------------------------------------------------------------------------------------------------
ABEND CODES
What i s ABEND?
It happens during the execution of a program in a step.
There are two types of ABEND are there
SYSTEM ABEND
System not able to execute a statement which is coded in a program.
USER ABEND
An unexpected condition occurs in data passed.
S0C1: Misspelled DD name.
Missing DD name.
S0C2: wrong record length/
S0C4: Index overflow, boundary violation.
To identify we use process ssrange.
S0C7: Passing numerical data to non-numerical data fields.
S222: Resource not allocated to the job and job gets cancelled.
S322: Due to time ABEND (overall the job).
To overcome this error we use time=maximum.
S522: TSO time out error (particle step).
S806: Load module not found.
SB37: End of volume.
SD37: No secondary space allocation to the dataset.
S0C13: Invalid PDS member.
S0CB: Divided by zero & not using size error.
SB14: Giving mode to PDS member.
U1026: COBOL sort failed.
---------------------------------------------------------------------------------------
CICS ERROR CODES

ASRA Program Check Exception
AEI0 Program ID Error
AEI9 Map Fail condition
AEIO Duplicate Key
AEIN Duplicate Record
AEID End of file reached
AEIP Invalid request condition
AEY7 Not authorised to use the resource
APCT Program not found
AFCA Dataset not found

Comments

Post a Comment

Popular posts from this blog

COBOL + DB2 complication process.

-
Image
There are various step involved before we run/execute a COBOL + DB2 program.   Below step are the various steps.   Precompile.   Compile.   Link edit.   Bind.   Package & plan. Step 1: Precompile               COBOL compiler did not understand about SQL statement so, it undergoes to precompile. In precompile.     Expands all include copybooks which are written in program.     Extracts all SQL statements into DBRM and SQL statement are convert into call statements.    Generates time-stamp for modified source codes and DBRM .there are checked at run time.   Check syndicated error of SQL statements and validates the fields based on the table declaration from dclgen copybook.    Notes: precompilation process can be executed even if DB2 is down. DSNHPC    ----------- It is the program used for precompilation. Step 2:  Compile            It is same as normal COBOL compilation.it takes modified source as input and compilers.  IGYRCTL --
Read more

ABEND list for JCL

-
what is ABEND?   An ABEND (abnormal end) is an exception condition which results in the abnormal termination of a program or software. It is a common terminology used in the mainframe world where a JCL terminates with an error code.  S0CB -    Attempting to divide by 0 and not using ON SIZE ERROR S002 -    Very large record length/ wrong record length Sx22 -   Job has been cancelled. The value of x will vary depending on the way the job was  cancelled. . S222 -    Means job was cancelled by a user or operator without a dump.                If a TSO session times out you will probably get an S522 ABEND code. S222 -    The job was cancelled (by subsystem or operator) because it violated               Some restriction. S522 -    JOB or TSO session exceeded maximum job wait time OR               Operator did not mount the require tape within allowed time limit    S806 -    Load module not found SB37
Read more

difference between jes2 and jes3

-
JES2 JES3       1.        Decentralization.       2.        Every processor the incoming job individually.       3.        It is prestep allocation.       4.        Dataset allowed before step is executed.       5.        It is a local process.       6.        Control statement (//*). 1. Centralization. 2. It control process and assign job to sub processor. 3. It is prejob allocation. 4. Dataset allowed before job is schedule. 5. It is global process. 6. Control statement (/*).
Read more