CDC Guide for z/OS

10.5.6
- 10.5.8
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Sample Schema Verification Report and Abend Messages

The sample schema verification report shows the messages and information that are displayed when schema verification fails.

In this example, schema verification fails because the schema in the capture registration contains a column that is not defined in the DB2 catalog. This situation can occur if a column was removed from the table after the table was registered.

The following example report shows the output and abend messages that are printed:

PWXEDM177502I Table 'ABCOOK1.PLOB2A' the DB2 schema does not match the active profile schema. DB2 log time = 2017-05-04-20.47.33.379616.
   ----------------------- DB2 Catalog ------------------------ | ------------------- PWX Registration -----------------------
   Create timestamp =  2017-05-04-20.39.29.360081               |
   Alter  timestamp =  2017-05-04-20.45.14.567313               |
   #   NL Column Name                    Datatype Len   Pr Sc N | #   NL Column Name                    Datatype Len   Pr Sc N
   --- -- ------------------------------ -------- ----- -- -- - | --- -- ------------------------------ -------- ----- -- -- -
   1   3  KEY                            Integer  4     0  0  N | 1   3  KEY                            Integer  4     0  0  N
   2   3  C01                            CLOB     0     0  0  Y | 2   3  C01                            CLOB     0     0  0  Y
   3   28 DB2_GENERATED_ROWID_FOR_LOBS   ROWID    17    0  0  N | 3   28 DB2_GENERATED_ROWID_FOR_LOBS   ROWID    17    0  0  N
   4   7  NEWCOL1                        CLOB     0     0  0  Y |
PWXEDM177511E Table 'ABCOOK1.PLOB2A' Schema verification failed.
PWXEDM172807E ABEND issued by schema verification, Abend code=3680, Reason=10040001.

Field Descriptions

The following table describes the fields in the example schema verification report:

Field	Description
Create timestamp	Date and time when the DB2 table schema was created and registered.
Alter timestamp	Date and time when the DB2 table schema and schema registration were last altered.
#	Sequential number of the column in the DB2 table and associated schema registration.
NL	Length of the column name in the DB2 table and associated schema registration.
Column Name	Name of the column in the DB2 table and associated schema registration.
Datatype	Datatype of the column in the DB2 table and associated schema registration.
Len	Length of the column in the DB2 table and associated schema registration.
Pr	Precision of the column in the DB2 table and associated schema registration.
Sc	Scale of the column in the DB2 table and associated schema registration.
N	Whether the column in the DB2 table and associated schema registration can have null values.

Rename Saved Search

Table of Contents

CDC Guide for z/OS

CDC Guide for z/OS

Sample Schema Verification Report and Abend Messages

Sample Schema Verification Report and Abend Messages

Field Descriptions