Extremely pureXML in DB2 10 for z/OS

218 Extremely pureXML in DB2 10 for z/OS

9.13 REPAIR

Use the REPAIR utility on XML objects to perform the following tasks:

 Set the status of an XML column to invalid.

 Delete a corrupted XML document and its NODEID index entries.

The most common use for the REPAIR utility for XML objects is to take corrective action after

you run CHECK DATA with SHRLEVEL CHANGE on a table space with XML columns.

CHECK DATA with SHRLEVEL CHANGE operates on shadow data sets, so it does not

modify XML columns or XML table spaces. Instead, CHECK DATA generates REPAIR

statements that you can run to delete invalid XML documents and to mark the corresponding

XML columns as invalid.

For examples of invoking the REPAIR utility when diagnosing problems with XML data, see

10.5, “Diagnostics” on page 242.

9.14 REPORT

When you specify REPORT TABLESPACESET, the output report includes XML objects in the

list of members in the table space set.

The sample output in Example 9-20 shows a table space set for a table that contains an XML

column.

Example 9-20 REPORT utility JCL (and TABLESPACESET option) and output

//XMLR4LD JOB (999,POK),'DB0B',CLASS=A,

// MSGCLASS=T,NOTIFY=XMLR4,TIME=1440,REGION=0M

/*JOBPARM SYSAFF=SC63,L=9999

// JCLLIB ORDER=(DB0BM.PROCLIB)

//UTIL EXEC DSNUPROC,SYSTEM=DB0B,UID='TEMP',UTPROC=''

//DSNUPROC.SYSIN DD *

REPORT TABLESPACESET DSN00242.BKRTORCS

1DSNU000I 315 16:50:26.26 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP

DSNU1044I 315 16:50:26.28 DSNUGTIS - PROCESSING SYSIN AS EBCDIC

0DSNU050I 315 16:50:26.28 DSNUGUTC - REPORT TABLESPACESET DSN00242.BKRTORCS

DSNU587I -DB0B 315 16:50:26.29 DSNUPSET - REPORT TABLESPACE SET WITH TABLESPACE

DSN00242.BKRTORCS

TABLESPACE SET REPORT:

TABLESPACE : DSN00242.BKRTORCS

TABLE : XMLR4.BK_TO_CSTMR_STMT

INDEXSPACE : DSN00242.IRDOCIDB

INDEX : XMLR4.I_DOCIDBK_TO_CSTMR_STMT

XML TABLESPACE SET REPORT:

TABLESPACE : DSN00242.BKRTORCS

BASE TABLE : XMLR4.BK_TO_CSTMR_STMT

COLUMN : BK_TO_CSTMR_STMT

XML TABLESPACE : DSN00242.XBKR0000

XML TABLE : XMLR4.XBK_TO_CSTMR_STMT

Chapter 9. Utilities with XML 219

XML NODEID INDEXSPACE: DSN00242.IRNODEID

XML NODEID INDEX : XMLR4.I_NODEIDXBK_TO_CSTMR_STMT

DSNU580I 315 16:50:26.29 DSNUPORT - REPORT UTILITY COMPLETE - ELAPSED TIME=00:00:00

NOTE: The same result is produced if you use the following:

REPORT TABLESPACESET DSN00242.XBKR0000

When you specify REPORT RECOVERY, the output report includes recovery-related

information. Use REPORT RECOVERY to find information that is necessary for recovering a

table space, index, or a table space and all of its indexes. This approach is particularly useful

for point-in-time recovery.

Example 9-21 shows the JCL for the REPORT utility with the RECOVERY option for the base

table space and the output of the utility run.

Example 9-21 REPORT utility JCL (and RECOVERY option for base table space) and output

//XMLR4LD JOB (999,POK),'DB0B',CLASS=A,

// MSGCLASS=T,NOTIFY=XMLR4,TIME=1440,REGION=0M

/*JOBPARM SYSAFF=SC63,L=9999

// JCLLIB ORDER=(DB0BM.PROCLIB)

//UTIL EXEC DSNUPROC,SYSTEM=DB0B,UID='TEMP',UTPROC=''

//DSNUPROC.SYSIN DD *

REPORT RECOVERY TABLESPACE DSN00242.BKRTORCS

1DSNU000I 315 17:02:40.42 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TEMP

DSNU1044I 315 17:02:40.45 DSNUGTIS - PROCESSING SYSIN AS EBCDIC

0DSNU050I 315 17:02:40.45 DSNUGUTC - REPORT RECOVERY TABLESPACE DSN00242.BKRTORCS

DSNU581I -DB0B 315 17:02:40.45 DSNUPREC - REPORT RECOVERY TABLESPACE DSN00242.BKRTORCS

DSNU593I -DB0B 315 17:02:40.46 DSNUPREC - REPORT RECOVERY ENVIRONMENT RECORD:

MINIMUM RBA: 000000000000

MAXIMUM RBA: FFFFFFFFFFFF

MIGRATING RBA: 000000000000

DSNU582I -DB0B 315 17:02:40.46 DSNUPPCP - REPORT RECOVERY TABLESPACE DSN00242.BKRTORCS

SYSCOPY ROWS AND SYSTEM LEVEL BACKUPS

TIMESTAMP = 2010-11-04-22.02.43.096801, IC TYPE = *C*, SHR LVL = , DSNUM = 0000,

START LRSN =000066569186

DEV TYPE = , IC BACK = , STYPE = L, FILE SEQ = 0000,

PIT LRSN = 000000000000

LOW DSNUM = 0000, HIGH DSNUM = 0000, OLDEST VERSION = 0000, LOGICAL PART = 0000,

LOGGED = Y, TTYPE =

JOBNAME = , AUTHID = , COPYPAGESF = -1.0E+00

NPAGESF = -1.0E+00 , CPAGESF = -1.0E+00

DSNAME = DSN00242.BKRTORCS , MEMBER NAME = ,

INSTANCE = 01, RELCREATED = M

................................................................................

................................................................................

................................................................................

TIMESTAMP = 2010-11-10-18.12.48.246523, IC TYPE = F , SHR LVL = R, DSNUM = 0000,

START LRSN =000069667C5E

DEV TYPE = 3390 , IC BACK = , STYPE = , FILE SEQ = 0000,

PIT LRSN = 000000000000

LOW DSNUM = 0001, HIGH DSNUM = 0001, OLDEST VERSION = 0000, LOGICAL PART = 0000,

LOGGED = Y, TTYPE =

JOBNAME = XMLR4LD , AUTHID = XMLR4 , COPYPAGESF = 3.0E+00

NPAGESF = 3.4E+01 , CPAGESF = 0.0E0

DSNAME = DSN00242.BKRTORCS.F.D2010314.T231248.COPY , MEMBER NAME = ,

INSTANCE = 01, RELCREATED = M