Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see CHECK PLUS for DB2 13.1.

Example 11: CHECK DATA for table space set report only

In this example, CHECK PLUS produces a table space set report without actually checking the data.

The report lists all table spaces in the specified TABLESPACE SET that are related by Db2-defined RI, and user-defined RI rules that are saved in the CHECK PLUS RI rules tables. Had the command statement specified additional user-defined RI that was not saved in the RI rules tables, the report would have included those table spaces as well.

Because this job is a report only and finds no errors, the utility completes with return code 0.

Command options for example 11

Command options used in JCL

Description

TABLESPACESET

Checks all referential constraint relationships and table check constraints in a relational set

REPORT ONLY

Produces a table space set report without actually checking the data

SCOPE ALL

Checks all rows of all specified tables


JCL for example 11

//                JOB
//CHECK11         EXEC PGM=ACKUMAIN,
//                PARM=(DECA,ACKEX11,NEW,,'MSGLEVEL(1)')
//STEPLIB         DD DISP=SHR,DSN=product.libraries
//                DD DISP=SHR,DSN=DB2.DSNEXIT
//                DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN            DD *
  CHECK DATA TABLESPACESET ACKRIDB1.ACKRITS1 REPORT ONLY
             SCOPE ALL
/*
//SYSPRINT   DD DSN=ACK.EXAMP11.SYSPRINT,
//            UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//UTPRINT    DD SYSOUT=*
//SYSDISC    DD DSN=ACK.EXAMPL11.SYSDISC,
//              DISP=(MOD,CATLG,CATLG),
//              UNIT=WORK,SPACE=(CYL,(1,1))
//SYSERR    DD DSN=ACK.EXAMPL11.SYSERR,
//             DISP=(MOD,CATLG,CATLG),
//             UNIT=WORK,SPACE=(CYL,(1,1))


SYSPRINT for example 11

               ***** B M C  C H E C K  P L U S  F O R  D B 2 V10R1.00  *****
                            (C) COPYRIGHT 1993 - 2011 BMC SOFTWARE, INC.
       CHECK PLUS TECHNOLOGY IS PROTECTED BY ONE OR MORE OF THE FOLLOWING U.S. PATENTS: 5,579,515; 6,163,783; AND 5,860,069
BMC50001I UTILITY EXECUTION STARTING 2/10/2011 10:45:39 ...
BMC50002I UTILITY ID = 'ACKEX11'. DB2 SUBSYSTEM ID = 'DEDR'. OPTION MODULE = 'ACK$OPTS'.
BMC50471I z/OS 1.10.0,PID=HBB7750,DFSMS FOR Z/OS=1.10.0,DB2=9.1.0
BMC50471I REGION=0M,BELOW 16M=8844K,ABOVE 16M=1409064K,IEFUSI=NO,CPUS=3
BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040320M,MEMLIMIT SET BY:REGION=0

BMC50471I CHECK PLUS FOR DB2--V10.01.00
BMC50471I  NO MAINTENANCE TO REPORT
BMC50471I DB2 UTILITIES COMMON CODE--V10.01.00
BMC50471I  NO MAINTENANCE TO REPORT
BMC50471I SOLUTION COMMON CODE--V10.01.00
BMC50471I  NO MAINTENANCE TO REPORT
BMC50471I BMCSORT ENGINE--V02.03.01
BMC50471I  NO MAINTENANCE TO REPORT
BMC50471I BMC STATS API--V10.01.00
BMC50471I  NO MAINTENANCE TO REPORT

BMC50471I ACFORTSS=YES             LOCKROW=YES                SQLDELAY=3
BMC50471I DRNDELAY=3               MAXP=5                     SQLRETRY=100
BMC50471I                          DRNRETRY=10                MSGLEVEL=1 UXSTATE=SUP
BMC50471I DRNWAIT=NONE             OPNDB2ID=YES               WBUFFS=20
BMC50471I DSER=NO                  PLAN=ACKQA                 WORKUNIT=SYSALLDA
BMC50471I DSPLOCKS=NONE            SMAX=16                    XBLKS=3
BMC50471I FILECHK=WARN             SMCORE=(0K,0K)             ZIIP=ENABLED
BMC50471I LOADDECP=NO              SORTNUM=32

BMC50471I DB2 DSNHDECP MODULE SETTINGS:
BMC50471I VERSION                     = 910
BMC50471I SUBSYSTEM DEFAULT           = DEDR
BMC50471I CHARACTER SET               = ALPHANUM
BMC50471I DATE FORMAT                 = USA
BMC50471I TIME FORMAT                 = USA
BMC50471I LOCAL DATE LENGTH           = 0
BMC50471I LOCAL TIME LENGTH           = 0
BMC50471I DECIMAL POINT               = PERIOD
BMC50471I DECIMAL ARITHMETIC          = 15
BMC50471I DELIMITER                   = DEFAULT
BMC50471I SQL DELIMITER               = DEFAULT
BMC50471I ENCODING SCHEME             = EBCDIC
BMC50471I APPL. ENCODING SCHEME       = EBCDIC
BMC50471I MIXED                       = NO
BMC50471I EBCDIC CCSID                = (37,65534,65534)
BMC50471I ASCII CCSID                 = (819,65534,65534)
BMC50471I UNICODE CCSID               = (367,1208,1200)

BMC50028I DB2 MODE = NFM
BMC50471I BMC_BMCUTIL         ='BMCUTIL.CMN_BMCUTIL'
BMC50471I BMC_BMCSYNC         ='BMCUTIL.CMN_BMCSYNC'
BMC50471I BMC_BMCHIST         ='BMCUTIL.CMN_BMCHIST'
BMC50471I BMC_BMCRELS         ='BMCUTIL.CMN_RELS'
BMC50471I BMC_BMCFKEY         ='BMCUTIL.CMN_FKEY'
BMC50471I BMC_BMCPKEY         ='BMCUTIL.CMN_PKEY'
BMC50471I BMC_BMCKEYS         ='BMCUTIL.CMN_KEYS'

BMC50102I CHECK DATA TABLESPACESET ACKRIDBB.ACKRITSA REPORT ONLY
BMC50102I            SCOPE ALL

BMC52691I TABLESPACE SET REPORT

BMC52692I TABLESPACE          TABLE DEPENDENT               TABLE CONSTRAINT
BMC52694I                     CREATOR NAME                  CREATOR NAME

BMC52693I ACKRIDBB.ACKRITSA ACK       TB1_LONG_NAME_FOR+

BMC52693I ACKRIDBB.ACKRITSB ACK       TB2_LONG_NAME_FOR+ ACK             TB1_LONG_NAME_FOR+ EXBT1FK1

BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topics

Command-and-syntax-reference

Examples-of-CHECK-PLUS-jobs


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*