System Output › Integrity Analysis Report › From/Thru Page Range Errors

From/Thru Page Range Errors

An example of a record that falls outside its designated from/thru page range is shown in Figure 4.21. The record does not participate in a set that was audited and that does not contain other integrity errors.

Here is a description of the fields that make up the Before Image Report.

Lines 1 thru 5 - Before Image Report header.

Line 6 - Informative message--indicates a from/thru page range error.

RECORD NAME - Name of the record.

ID - Record identifier.

DBKEY - Db-key of the database record.

FROM PAGE - From page number.

THRU PAGE - Thru page number.

RECORD DATA - First 67 characters of data.

 CA-TOOLS                  RELEASE                     CA IDMS/DB AUDIT       DATE               TIME            PAGE
                           Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0005
 *********************************************************************************************************************
 ************************************************  B E F O R E   I M A G E  ******************************************
 *********************************************************************************************************************
 xxxx031I RECORD DBKEYS OUTSIDE SPECIFIED FROM/THRU PAGE RANGES . . .
     ---RECORD NAME-- -ID- --DBKEY---    FROM PAGE     THRU PAGE   ----------------------RECORD DATA----------------------
     TEACHER          1001 88,003-004       88,002        88,002   00012TOM       SAMPLER    ANY     BS           01040000
     TEACHER          1001 88,003-006       88,002        88,002   00034KEVIN     SINGER     ART     BS           01059400
     TEACHER          1001 88,003-005       88,002        88,002   00026RONNIE    RHYME      MUSIC   BS           01055000
     TEACHER          1001 88,004-003       88,002        88,002   00029CLARENCE  FORD       MATH    BS,MS,PHD    01058000
     TEACHER          1001 88,006-002       88,002        88,002   00030JOHN      SOSA       ART     BA           01059000
     TEACHER          1001 88,004-002       88,002        88,002   00021JILL      ENDRIC     ANY     BS           01049000
     TEACHER          1001 88,015-005       88,002        88,002   00031MAUREEN   HARRIS     SCIENCE BS           01059100
     TEACHER          1001 88,005-002       88,002        88,002   00033ROGER     CABE       MUSIC   NOT ENOUGH   01059300
     TEACHER          1001 88,006-003       88,002        88,002   00035TRACIE    LERNER     MUSIC   TOO MUCH     01059500
     TEACHER          1001 88,003-003       88,002        88,002   00003THOMAS    BLACK      MATH    BS/MATH      00950000
     TEACHER          1001 88,012-001       88,002        88,002   00004JACK      CORD       MATH    BS/MATH      00960000
     TEACHER          1001 88,015-002       88,002        88,002   00007DANNY     DUDLEY     MATH    BS/MATH      00990000
     TEACHER          1001 88,011-001       88,002        88,002   00013ARTHUR    AMBER      ANY     BS           01041000
     TEACHER          1001 88,011-003       88,002        88,002   00018PAT       DRIER      ANY     BS           01046000
     TEACHER          1001 88,011-002       88,002        88,002   00014DON       SELTER     ANY     BS           01042000
     TEACHER          1001 88,011-004       88,002        88,002   00019JOE       HENNY      ANY     BS           01047000
     TEACHER          1001 88,012-003       88,002        88,002   00009JEAN      ABLE       ANY     BS           01010000
     TEACHER          1001 88,012-006       88,002        88,002   00027BURT      NOLL       SCIENCE NONE         01056000
     TEACHER          1001 88,012-004       88,002        88,002   00022JOHN      HENRY      ANY     BS           01049100
     TEACHER          1001 88,012-005       88,002        88,002   00023GARY      WEBB       ANY     BS           01049200
     TEACHER          1001 88,012-007       88,002        88,002   00028VINCENT   RIDER      MUSIC   BS           01057000
     TEACHER          1001 88,014-001       88,002        88,002   00011MIKE      MOLER      ANY     BS           01030000
     TEACHER          1001 88,014-002       88,002        88,002   00016KAREN     GAVIN      ANY     BS           01044000

Figure 4.21: From/Thru Page Range Errors