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.

Related topics

Command-and-syntax-reference

Considerations-for-each-type-of-checking

Examples-of-CHECK-PLUS-jobs

Types-of-checking

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

//         JOBCARD
//*===================================================================
//*====  CHECK DATA for table space set report only               ====
//*================================================================*
//*  Use your DB2 subsystem name inplace of "DB2SYS" parm parameter.  *
//*  Use your DB2 product install libraries for STEPLIBS ;            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*================================================================*
//CHECK11  EXEC PGM=ACKUMAIN,
//         PARM=(DB2SYS,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 ACKRIDBB.ACKRITSA REPORT ONLY
           SCOPE ALL
/*
//SYSPRINT  DD DSN=ACK.EXAMPL11.SYSPRINT,
//           UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//UTPRINT   DD SYSOUT=*
//SYSDISC   DD DSN=ACK.EXAMPL11.SYSDISC,
//             DISP=(NEW,CATLG,CATLG),
//             UNIT=WORK,SPACE=(CYL,(1,1))
//SYSERR    DD DSN=ACK.EXAMPL11.SYSERR,
//             DISP=(NEW,CATLG,CATLG),
//             UNIT=WORK,SPACE=(CYL,(1,1))


SYSPRINT for example 11

1                               *****  B M C   C H E C K   P L U S   F O R   D B 2    V13R1.00  *****
                                             (C) COPYRIGHT 1993 - 2022 BMC SOFTWARE, INC.
               CHECK PLUS TECHNOLOGY IS PROTECTED BY ONE OR MORE OF THE FOLLOWING U.S. PATENTS: 5,579,515 AND 6,163,783
-BMC50001I UTILITY EXECUTION STARTING    3/01/2022   14:41:28 ...
 BMC50002I UTILITY ID = 'ACKEX11'.  DB2 SUBSYSTEM ID = 'DEJM'.  OPTION MODULE = 'ACK$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=12.1.510
 BMC50471I REGION=0M,BELOW 16M=8.6M,ABOVE 16M=1,006.1M,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=15.9E,AVAILABLE=15.9E,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0033637,JOB=ACKEX11,STEP=CHECK11,CPU=8561-615 (z15)/1.71,76.0G
0
 BMC50471I CHECK PLUS FOR DB2--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
 BMC50471I   MAINT: BPJ1541  BPJ1713  BPJ2211
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0556  BPE0557  BPE0560
0
 BMC50471I DRNDELAY=3                              LOADDECP=NO                             SQLDELAY=3
 BMC50471I DRNRETRY=10                             LOCKROW=YES                             SQLRETRY=100
 BMC50471I DRNWAIT=NONE                            MAXP=5                                  UXSTATE=SUP
 BMC50471I DSER=NO                                 MSGLEVEL=1                              WBUFFS=20
 BMC50471I DSPLOCKS=NONE                           OPNDB2ID=YES                            WORKUNIT=SYSALLDA
 BMC50471I FILECHK=WARN                            PLAN=ACK1310T                           XBLKS=3
 BMC50471I FORCE_AT=(START,3)                      SMAX=16                                 ZIIP=ENABLED
 BMC50471I FORCE_RPT=NO                            SMCORE=(0K,0K)
 BMC50471I FORCE=NONE                              SORTNUM=32
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1210
 BMC50471I SUBSYSTEM DEFAULT       = DEJM
 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)
 BMC50471I IMPLICIT TIME ZONE      = CURRENT (-06:00)


 BMC50658I DB2 CURRENT FUNCTION LEVEL IS V12R1M509
 BMC50659I DB2 CATALOG LEVEL IS V12R1M509
 BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V12R1M509
 BMC50661I DB2 CODE LEVEL IS V12R1M510

 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCRELS       ='ACKIB2.BMCRELS'
 BMC50471I BMC_BMCFKEY       ='ACKIB2.BMCFKEY'
 BMC50471I BMC_BMCPKEY       ='ACKIB2.BMCPKEY'
 BMC50471I BMC_BMCKEYS       ='ACKIB2.BMCKEYS'
0
0
 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

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0


 

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