Previous Topic: DB2 ReportNext Topic: Snap Report


CA IDMS/DB Report

The CA IDMS/DB portion of the abend report is produced whenever a program that accesses a CA IDMS/DB database using CA IDMS/DB r12.0 or above abends. The reports are generated based on the SYSIDMS parameters specified. Information about these parameters can be found in the CA IDMS/DB documentation.

The first page of the CA IDMS/DB report follows:

****************** * CA-IDMS REPORT * ****************** CA-IDMS abend trace Tape Genlevel: G0GJ6M Release: 1600 A User=USER02 B Batch Local Job DBNODE= DBNAME=EMPDEMO DICTNODE= DICTNAME= C ***************** * SYSIDMS parms * D ***************** ECHO=ON DMCL=R160DMCL DBNAME=EMPDEMO ABENDTRACE=ON ABENDTRACE_ENTRIES=255 ABENDTRACE_VIBSNAP=ON ABENDTRACE_SUBSCHEMA_DISPLAY=ON ************************************ * DML trace for subschema=EMPSS01 * E ************************************ VERB=59 BIND SUBSCHEMA-->EMPSS01 DBNAME=EMPDEMO PROGRAM=CAO2IDMS Caller=CAO2IDMS DMLSEQ=000001 *** I D M S VERB=48 BIND Record REC-->STRUCTURE ADDR=000403A0 Caller=CAO2IDMS DMLSEQ=000002 *** I D M S VERB=48 BIND Record REC-->SKILL ADDR=000403B0 Caller=CAO2IDMS DMLSEQ=000003 *** I D M S VERB=48 BIND Record F REC-->OFFICE ADDR=00040400 Caller=CAO2IDMS DMLSEQ=000004 *** I D M S VERB=48 BIND Record REC-->NON-HOSP-CLAIM ADDR=00040450 Caller=CAO2IDMS DMLSEQ=000005 *** I D M S VERB=48 BIND Record REC-->JOB ADDR=00040870 Caller=CAO2IDMS DMLSEQ=000006 *** I D M S VERB=48 BIND Record REC-->INSURANCE-PLAN ADDR=00040998 Caller=CAO2IDMS DMLSEQ=000007 *** I D M S VERB=48 BIND Record REC-->HOSPITAL-CLAIM ADDR=00040A20 Caller=CAO2IDMS DMLSEQ=000008 *** I D M S VERB=48 BIND Record REC-->EXPERTISE ADDR=00040B50 Caller=CAO2IDMS DMLSEQ=000009 *** I D M S VERB=48 BIND Record REC-->EMPOSITION ADDR=00040B60 Caller=CAO2IDMS DMLSEQ=000010 *** I D M S VERB=48 BIND Record REC-->EMPLOYEE ADDR=00040B80 Caller=CAO2IDMS DMLSEQ=000011 *** I D M S VERB=48 BIND Record REC-->DEPARTMENT ADDR=00040BF8 Caller=CAO2IDMS DMLSEQ=000012 *** I D M S VERB=48 BIND Record REC-->DENTAL-CLAIM ADDR=00040C30 Caller=CAO2IDMS DMLSEQ=000013 *** I D M S

The first page of the CA-IDMS report displays the following information:

A

Displays the genlevel and version of CA IDMS/DB.

B

Displays the userid used to submit the job and the job type.

C

Displays the DBNODE, DBNAME, DICTNODE, and DICTNAME that were used.

D

Displays the SYSIDMS parameters that were used.

E

Displays the subschema name.

F

Displays a trace of DML verbs for the subschema (the number of commands displayed in the trace is a user-specifiable option).

Currencies for all areas, records, and sets in the subschema at the time of the ABEND are displayed. An example follows:

 *************************************                                           * Currencies for subschema=EMPSS01  *                                            * Compiled: 2007-08-07  13.51.57    *                                           *************************************                                                                                                                            Current DBKEY=X'01250505' (75013:5)         For Area EMP-DEMO-REGION             Current DBKEY=X'01259801' (75160:1)         For Area ORG-DEMO-REGION                                                                                              Current DBKEY=X'01259801' (75160:1)         For Record DEPARTMENT                Current DBKEY=X'01250505' (75013:5)         For Record EMPLOYEE                                                                                                   Current DBKEY=X'01250505' (75013:5)         For Set DEPT-EMPLOYEE                  Owner DBKEY=X'01259601' (75158:1)         For Set DEPT-EMPLOYEE                  Prior DBKEY=X'01251701' (75031:1)         For Set DEPT-EMPLOYEE                   Next DBKEY=X'01251809' (75032:9)         For Set DEPT-EMPLOYEE                                                                                                 Current DBKEY=X'01250505' (75013:5)         For Set EMP-COVERAGE                   Owner DBKEY=X'01250505' (75013:5)         For Set EMP-COVERAGE                   Prior DBKEY=X'01256404' (75108:4)         For Set EMP-COVERAGE               

Buffer information is displayed for each record in the subschema, as shown:

   Record Name         Record Size   Bind Buff   'Prev' Buff   'Curr' Buff           -----------         -----------   ---------   -----------   -----------             A                    B            C            D             E                COVERAGE               20         00040FD8     * none *      * none *            DENTAL-CLAIM           932        00040C30     * none *      * none *            DEPARTMENT             56         00040BF8     363BC888      363BC8C0            EMPLOYEE               120        00040B80     363BC908      363BC980            EMPOSITION             32         00040B60     * none *      * none *            EXPERTISE              12         00040B50     * none *      * none *            HOSPITAL-CLAIM         300        00040A20     * none *      * none *            INSURANCE-PLAN         132        00040998     * none *      * none *            JOB                    296        00040870     * none *      * none *            NON-HOSP-CLAIM         1052       00040450     * none *      * none *            OFFICE                 76         00040400     * none *      * none *            SKILL                  76         000403B0     * none *      * none *            STRUCTURE              12         000403A0     * none *      * none *       

The buffer information consists of the following:

A

Displays the name of the record.

B

Displays the size of the bind buffer.

C

Displays the address of the bind buffer.

D

Displays previous buffer address.

E

Displays current buffer address.

The buffer information is followed by displays of the previous, current, and bind record images for accessed records, as shown:

*********************************************** * Previous image for record DEPARTMENT * A *********************************************** ADDRESS 363BC888 LENGTH 00000038 (DECIMAL 56) ADDRESS OFFSET 363BC888 000000 F2F0F0F0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 *2000 * 363BC8A8 000020 40404040 40404040 40404040 40404040 40404040 40404040 * * *********************************************** * Current image for record DEPARTMENT * B *********************************************** ADDRESS 363BC8C0 LENGTH 00000038 (DECIMAL 56) ADDRESS OFFSET 363BC8C0 000000 F2F0F0F0 C1C3C3D6 E4D5E3C9 D5C740C1 D5C440D7 C1E8D9D6 D3D34040 40404040 *2000ACCOUNTING AND PAYROLL * 363BC8E0 000020 40404040 40404040 40404040 40404040 40F0F0F1 F1000000 * 0011 * ************************************************ * Bind image for record DEPARTMENT * C ************************************************ LINE# LEVEL/FIELD NAME VALUE/LOCATION DEFINITION ------ ---------------------------- ----------------------------- ----------------------------------------------- 000396 01 DEPARTMENT BLW=0000+000B40 (00040BF8) 000397 02 DEPT-ID-0410 9999 9(4) 000398 02 DEPT-NAME-0410 *ACCOUNTING AND PAYROLL * X(45) (+000032) * * 000399 02 DEPT-HEAD-ID-0410 11 9(4) 000400 02 FILLER LOW-VALUES XXX

A

Displays the previous record image for the record.

B

Displays the current record image for the record.

C

Displays the bind record image for the record. The record image is mapped if these conditions are met:

Otherwise, the address, length, and contents of the record are displayed in dump format.

Snaps of the CA IDMS/DB VIB (Variable IB50 for subschema) and CA IDMS/DB VARS are displayed as following:

******************** * CA-IDMS VIB snap * ******************** ADDRESS 36459008 LENGTH 00001658 (DECIMAL 5,720) ADDRESS OFFSET 36459008 000000 E5C2F5F0 00000005 363BBD88 363BBE0E 363BBEE0 363BBEF2 363BBE2E 00000000 *VB50.......h.......\...2........* 36459028 000020 00000000 00000000 00000000 00000000 3640DD08 3643A348 3645A6D4 3645B128 *................. ....t...wM....* 36459048 000040 00000000 00000000 00000000 00000000 00000000 00000000 00000008 36459B54 *................................* 36459068 000060 000642F8 D3D6C3D3 00000003 00000000 00075FC0 363BC2F0 363BC2F0 364593A0 *...8LOCL..........¬{..B0..B0..l.* 36459088 000080 36459148 36459194 363BC2F0 00000000 00000000 40000000 00000000 08000000 *..j...jm..B0........ ...........* 364590A8 0000A0 0000FF08 C5D4D7C4 C5D4D640 00000000 3643AA70 3643A4F0 3645A6FC F0F0F0F0 *....EMPDEMO ..........u0..w.0000* 364590C8 0000C0 00000000 01250505 C3C1D6F2 C9C4D4E2 00000000 3643AA70 3643AA70 3643AA70 *........CAO2IDMS................* 364590E8 0000E0 00000022 00000000 00000000 3643AA70 3645A8F4 3643B6B4 3643B4D8 3645ADA4 *..................y4.......Q...u* 36459108 000100 00000000 0B220B22 0B220B22 00000000 00000000 01250505 3643AA70 00000000 *................................* 36459128 000120 01000000 00000000 00000000 3643A348 F0F461F0 F361F0F8 F1F3F0F6 F3F6F2F8 *..............t.04/03/0813063628* 36459148 000140 00000009 00000000 00000009 00000000 00000000 00000000 00000000 0000000C *................................* 36459168 000160 0000000B 00000019 00000000 00000000 00000000 00000000 00000000 00000001 *................................* 36459188 000180 00000003 D3D6C3D3 00000003 00000000 00000000 00000000 00000000 00000000 *....LOCL........................* . . . . . . . . . . . . ********************* * CA-IDMS VARS snap * ********************* ADDRESS 3645A6D4 LENGTH 00000A54 (DECIMAL 2,644) ADDRESS OFFSET 3645A6D4 000000 E5C1D9E2 40404040 C5D4D7E2 E2F0F140 00000000 3641DC98 00000000 00000000 *VARS EMPSS01 .......q........* 3645A6F4 000020 3641DC98 00000000 04038003 01250505 01250505 3643AA70 36459008 3641480C *...q............................* 3645A714 000040 00000000 00000000 00000000 00000000 FFFFFFFF 000124F9 0001252A 0001252A *.......................9........* 3645A734 000060 000124FE 0001252A 0001252A 000124FA 000124FD 000124FD 04038003 FFFFFFFF *................................* 3645A754 000080 FFFFFFFF 00000000 36459008 364149E0 00000000 00000000 00000000 00000000 *...............\................* 3645A774 0000A0 FFFFFFFF 0001255D 00012575 00012575 00012562 00012575 00012575 0001255E *.......).......................;* 3645A794 0000C0 00012561 00012561 04038003 01259801 01259801 3643A9D8 36459008 36414BB4 *.../.../......q...q...zQ........* 3645A7B4 0000E0 00000000 00000000 00000000 00000000 FFFFFFFF 0001258F 000125A7 000125A7 *...........................x...x* 3645A7D4 000100 00012594 000125A7 000125A7 00012590 00012593 00012593 FFFFFFFF FFFFFFFF *...m...x...x.......l...l........* 3645A7F4 000120 FFFFFFFF 00000000 00000000 00000000 00000000 00000000 00000000 FFFFFFFF *................................* 3645A814 000140 0005B0B0 FFFFFFFF FFFFFFFF FFFFFFFF 00000000 00000000 00000000 00000000 *................................* 3645A834 000160 00000000 00000000 FFFFFFFF 0005B0B0 FFFFFFFF FFFFFFFF FFFFFFFF 00000000 *................................* 3645A854 000180 00000000 00000000 00000000 00000000 00000000 FFFFFFFF 0005B0B0 FFFFFFFF *................................*

Finally, CA SymDump Batch shows the following areas:

SUBSCHEMA=EMPSS01 Compiled=2007-08-07 13.51.57 A Subschema Structure is Network and Unbound B Area Name Segment ----------------- -------- EMP-DEMO-REGION n/a INS-DEMO-REGION n/a C ORG-DEMO-REGION n/a Record Name Stored Rec ID Area Name Data Length Prefix Length Procedures -------------------------- ------ ------ --------------- ----------- ------------- ---------------------- COVERAGE VIA 400 INS-DEMO-REGION 20 20 DENTAL-CLAIM VIA 405 INS-DEMO-REGION 936 12 DEPARTMENT D CALC 410 ORG-DEMO-REGION 56 16 EMPLOYEE CALC 415 EMP-DEMO-REGION 120 72 EMPOSITION VIA 420 EMP-DEMO-REGION 32 24 EXPERTISE VIA 425 EMP-DEMO-REGION 12 20 HOSPITAL-CLAIM VIA 430 INS-DEMO-REGION 300 8 INSURANCE-PLAN CALC 435 INS-DEMO-REGION 132 8 JOB CALC 440 ORG-DEMO-REGION 300 24 IDMSCOMP Before STORE IDMSCOMP Before MODIFY IDMSDCOM After GET . . . . . . Chain Sorted-> CALC Next,Prior Owner -------> SR1 Next=00 Prior=04 Member ------> SR6 E Next=00 Prior=04 Member ------> SR7 Next=00 Prior=04 Ckey Offset=16 Length=16 Data Type=Character Member ------> DEPARTMENT Next=00 Prior=04 Ckey Offset=16 Length=4 Data Type=Numeric (Unsigned) Member ------> EMPLOYEE Next=00 Prior=04 Ckey Offset=72 Length=4 Data Type=Numeric (Unsigned) Member ------> INSURANCE-PLAN Next=00 Prior=04 Ckey Offset=8 Length=3 Data Type=Character Member ------> JOB Next=00 Prior=04 Ckey Offset=28 Length=4 Data Type=Numeric (Unsigned) Member ------> OFFICE Next=00 Prior=04 Ckey Offset=16 Length=3 Data Type=Character Member ------> SKILL Next=00 Prior=04 Ckey Offset=20 Length=4 Data Type=Numeric (Unsigned) Chain Last --> COVERAGE-CLAIMS Next,Prior Owner -------> COVERAGE Next=12 Prior=16 Via Member --> DENTAL-CLAIM Next=00 Prior=04 Via Member --> HOSPITAL-CLAIM Next=00 Prior=04 Via Member --> NON-HOSP-CLAIM Next=00 Prior=04

The preceding screen consists of the following information:

A

Displays the compile date and time of the subschema.

B

Displays the subschema structure and whether it is bound or unbound.

C

Displays the associated segment for each area, if applicable.

D

Displays detailed information about each record in the subschema, including storage mode, record ID, area name, data length, prefix length, and db procedures.

E

Displays detailed information about each set in the subschema, including owner record, member records, set type, and set pointers.