Sample SCCBSET JCL and output

This section presents the following samples of JCL and output for SCCBSET:

SCCBSET command syntax

The following sample shows the following command syntax:

SET CURRENT SQLID
CREATE OBJECTSET
REPORT OBJECTSET
DELETE OBJECTSET

Related topics

SET-CURRENT-SQLID-for-SCCBSET

CREATE-OBJECTSET-syntax-and-option-descriptions

DELETE-OBJECTSET-syntax-and-option-descriptions

REPORT-OBJECTSET-syntax-and-option-descriptions

SCCIN-DD-syntax-rules

Managing-object-sets-with-SCCBSET

//SCC0001 EXEC PGM=SCCBSET,PARM=’DEJM’,REGION=8M
//STEPLIB   DD DISP=SHR,DSN=SCC.STEPLIB
//                 DD DISP=SHR,DSN=SYS3.DEJM.DSNEXIT
//                 DD DISP=SHR,DSN=CSGI.DB2V12M.DSNLOAD
//SCCERROR DD SYSOUT=*
//SCCPRINT DD SYSOUT=*
//SCCHELP   DD SYSOUT=*
//SCCOBJS   DD SYSOUT=*
//SCCSPEC   DD SYSOUT=*
//SCCOPTS   DD *
  PLANNAME NGTPLAN
  COLLECTIONID BMCSCC
  BINDQUALIFIER NGT121D
  PUBLICPLAN NO
  TEMPTABLESTOGROUP SYSDEFLT
/*
//SCCIN     DD *
     SET CURRENT SQLID = RDAJLW;
     CREATE OBJECTSET PUBLIC.Q2183456
        REPLACE YES
       DESCRIPTION "TEST EXCLUDEPARTS"
        INCLUDE TABLESPACE RMDDB48.*
              BYPART NO
              INCLUDEIX YES
              INCLUDERI NO
              INCLUDELOB NO
              INCLUDEXML NO
              INCLUDEHISTORY NO
              INCLUDEARCHIVE NO
;
    REPORT OBJECTSET PUBLIC.Q2183456
       OBJECTS
       SPECIFICATION
  ;
    DELETE OBJECTSET PUBLIC.Q2183456
  ;
/*
//

Program Options (SCCOPTS DD)

The following example shows the data definitions for the program options override. You can override one or more program options using the following SCCOPTS DD statement:

//SCCOPTS DD *
  PLANNAME NGTPLAN
  COLLECTIONID BMCSCC
  BINDQUALIFIER NGT121D
  PUBLICPLAN NO
  TEMPTABLESTOGROUP SYSDEFLT
/*

For details about these options, see Specifying the SCCBSET data set DD statements.

Important

Dynamic Bind is called.

Syntax (SCCIN DD)

The following figure shows sample output for SCCHELP:

SET CURRENT SQLID = sqlid (optional)
DELETE OBJECTSET creator.name
REPORT OBJECTSET creator.name
       OBJECTS
       SPECIFICATON

CREATE OBJECTSET creator.name
       DESCRIPTION text (max 60 characters)
       REPLACE NO
       LIKE creator.name
           RETAIN OBJECTS YES

       INCLUDE TABLESPACE database name.tablespace name.owner
             DSNUM n or n:n or ALL
           EXCLUDE database name.tablespace name.owner
             DSNUM n or n:n or ALL
           BYPART YES | NO
           INCLUDEIX YES | NO
           INCLUDERI YES | NO
           INCLUDELOB YES | NO | BASE | ONLY
           INCLUDEXML YES | NO | BASE | ONLY
          INCLUDEHISTORY YES | NO | BASE | ONLY
          INCLUDEARCHIVE YES | NO | BASE | ONLY

      EXCLUDE TABLESPACE database name.tablespace name.owner
            EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

      INCLUDE TABLE creator.table name
            INCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM

      EXCLUDE TABLE creator.table name
          EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

      INCLUDE INDEX creator.index name
            DSNUM n or n:n or ALL
          EXCLUDE index name
            DSNUM n or n:n or ALL
          BYPART YES | NO

      EXCLUDE INDEX creator.index name
            DSNUM n or n:n or ALL
          BYPART YES | NO

      INCLUDE INDEXSPACE creator.index space name
            DSNUM n or n:n or ALL
          EXCLUDE index space name
            DSNUM n or n:n or ALL
          BYPART YES | NO

      EXCLUDE INDEXSPACE creator.index space name
            DSNUM n or n:n or ALL
          BYPART YES | NO

     INCLUDE PACKAGE collid.package.version
          INCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM

     EXCLUDE PACKAGE collid.package.version
          EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

      INCLUDE PLAN plan name
          INCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM

      EXCLUDE PLAN plan name
          EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

      INCLUDE STOGROUP stogroup name
          INCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM
        EXCLUDE STOGROUP stogroup name
          EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

      INCLUDE OBJECTSET object set name
          EXCLUDEOBJECTSET object set name

     EXCLUDE OBJECTSET object set name

      INCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'TS', DBNAME, NAME
          FROM SYSIBM.SYSTABLESPACE
          WHERE DBNAME = 'XXXXXXX'
          #ENDSQL

      INCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'IX', CREATOR, NAME, CREATOR, NAME
          FROM SYSIBM.SYSINDEXES
          WHERE DBNAME = 'XXXXXXX'
          #ENDSQL

     INCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'SG', CREATOR, NAME, CREATOR, NAME
          FROM SYSIBM.SYSSTOGROUP
          WHERE NAME = 'XXXXXXX'
          #ENDSQL

         INCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM

      EXCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'TS', DBNAME, NAME
          FROM SYSIBM.SYSTABLESPACE
          WHERE DBNAME = 'XXXXXXX'
          #ENDSQL

      EXCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'IX', CREATOR, NAME, CREATOR, NAME
          FROM SYSIBM.SYSINDEXES
          WHERE DBNAME = 'XXXXXXX'
          #ENDSQL

     EXCLUDE SQL #BEGINSQL - SQL statements - #ENDSQL
          #BEGINSQL
          SELECT 'SG', CREATOR, NAME, CREATOR, NAME
          FROM SYSIBM.SYSSTOGROUP
          WHERE NAME = 'XXXXXXX'
          #ENDSQL

         EXCLUDE parameters same as INCLUDE TABLESPACE except for DSNUM and EXCLUDE

          The SQL statements must be exactly as shown in the examples
          and cannot deviate except in the WHERE clause.

Important

The INCLUDE statement determines the objects that comprise the object set.
You can provide multiple INCLUDE statements to define an object set.
You can provide multiple EXCLUDE parameters to filter out objects from an object set.
SCC is the creating-product code in the object set.

Sample output for SCCPRINT

** SOLUTION COMMON CODE OBJECTSET PROCESSING 02/02/2022 13:22:20 **

(c) COPYRIGHT 2022 BMC SOFTWARE, INC.

BMCSCC80223I SOLUTION COMMON CODE V13.01.00 BASE
BMCSCC80223I MAINT: BPJ1541 BPJ1713 BPJ2211

BMCSCC80799I CONNECTED TO DB2 SSID = DEJM VERSION = 121510
BMCSCC80799I   DB2 CURRENT FUNCTION LEVEL = 121509
BMCSCC80799I   DB2 HIGHEST ACTIVATED FUNCTION LEVEL = 121509
BMCSCC80799I   DB2 CATALOG LEVEL = 121509

BMCSCC80799I RUN WITH THE SCCHELP DD TO SEE PROGRAM HELP INFORMATION

BMCSCC80799I EXECUTING WITH PROGRAM OPTIONS:
BMCSCC80799I PLANNAME=SCCB1310
BMCSCC80799I COLLECTIONID=BMCSCCB
BMCSCC80799I BINDQUALIFIER=BMCARMA
BMCSCC80799I PUBLICPLAN=NO
BMCSCC80799I TEMPTABLESTOGROUP=SYSDEFLT

  SET CURRENT SQLID = RDAJLW
  ;
BMCSCC80570I COMMAND COMPLETE RC = 0

  CREATE OBJECTSET PUBLIC.JLWTEST
         INCLUDE TABLESPACE RMDDB45.BS45P*
             BYPART YES
             INCLUDERI      NO
             INCLUDEIX      YES
             INCLUDELOB     YES
             INCLUDEXML     YES
             INCLUDEHISTORY NO
  ;
BMCSCC80591I PROCESSING OBJECTSET PUBLIC.JLWTEST
BMCSCC80570I COMMAND COMPLETE RC = 0

For information about SCCPRINT, see Specifying the SCCBSET data set DD statements.

Sample report output in SCCOBJS

** OBJECTSET OBJECTS REPORT 03/09/2022 11:25:10 **

Object Set Name PUBLIC.Q2182799
Date Created    2022-03-09-09.09.09
Created by      RDAJLW2
Date Updated 2022-03-09-09.09.09
Updated by      RDAJLW2
Description
Create product ARM
Object Set type
Number objects 1

TYPE T DSNUM    0
RMDDB40.TS40N01

Sample report output in SCCSPEC

NOTE: OBJECTSET Specifications are built by the CREATE OBJECTSET INCLUDE statements.

** OBJECTSET SPECIFICATION REPORT 03/09/2022 09:54:49 **

Object Set Name PUBLIC.Q2182799_A
Date Created 2022-03-09-08.40.38
Created by      RDAJLW2
Date Updated 2022-03-09-09.28.17
Updated by      RDAJLW2
Description     test for jlw xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxyz
Create product ARM
Object Set type
Number objects 1048

   Type         DSnum Indexes RI By Part LOBs XML History Clone Archive
   TS NAME        0       Y      Y     Y     Y    Y     Y      Y      Y
     RMDDB4*.*.*
   TB NAME                Y      Y     Y     N    N     N      Y      N
    RMD.T01N01<8081>
  TB NAME                Y      Y     Y     N    N     N      Y      N
    RMD.T01N03<8081>
  TB NAME                Y      Y     Y     N    N     N      Y      N
    RMD.T01P01<E282AC>
  TB NAME                Y      Y     Y     N    N     N      Y      N
    RMD.T01P03<E282AC><DE90><DE90>
  STOGROUP               Y      Y     Y     N    N     N      Y      N
    RMD*
  PLAN NAME              Y      Y     Y     N    N     N      Y      N
    RMDINSTL.BMCACP
  PACKAGE                Y      Y     Y     N    N     N      Y      N
    APTDBST.BMCAPT.APT_1211_DEV
  PACKAGE                Y      Y     Y     N    N     N      Y      N
    APTDBST.BMCAPT.APT_1212_PGMR_KJD
  DYN SQL                Y      Y     Y     N    N     N      Y      N

SELECT 'TS', SC.DBNAME, SC.TSNAME, SC.DSNUM
FROM SYSIBM.SYSTABLEPART TP, SYSIBM.SYSCOPY SC
WHERE TP.DBNAME = 'RMDDB46'
AND SC.DBNAME = TP.DBNAME
AND ( SC.DSNUM = TP.PARTITION OR
(SC.DSNUM = 0 AND TP.PARTITION <> 0))
AND NOT EXISTS (
SELECT * FROM SYSIBM.SYSCOPY SC2
WHERE SC.DBNAME = SC2.DBNAME AND SC.TSNAME = SC2.TSNAME
AND SC.DSNUM = SC2.DSNUM
AND SC2.ICTYPE IN('F')
AND SC2.TIMESTAMP >= CURRENT TIMESTAMP - 7 DAYS )
FOR READ ONLY WITH UR

   IS NAME        0       Y      Y     Y     N    N     N      Y      N
     RMDBM99.IC43P1
   IS NAME        0       Y      Y     Y     N    N     N      Y      N
     RMDBM99.IC43P32K
   IS NAME        0       Y      Y     Y     N    N     N      Y      N
     RMDBM99.IC43S1
   OBJECTSET              Y      Y     Y     N    N     N      Y      N
     HZE.RMPBR2.*
   EXCL IX        0       Y      Y     Y     N    N     N      Y      N
     ACP.IC43P1
   EXCL TS        0       Y      Y     Y     N    N     N      Y      N
     RMDDB01.TS01N01.*

Object Set Name PUBLIC.Q2182799_B
Date Created 2022-03-09-08.43.02
Created by      RDAJLW2
Date Updated 2022-03-09-08.43.02
Updated by      RDAJLW2
Description
Create product ARM
Object Set type
Number objects 7449

   Type         DSnum Indexes RI By Part LOBs XML History Clone Archive
   EXCEPTION              Y      Y     Y     N    N     N      Y      N
     CheckPend=Y CopyPend=N LPL=N RecvPend=N StopErr=N
     ErrorRange=N AdvisoryReorg=N
     AdvisoryRebuild=N InformationalCopy=N AuxiliaryCheck=N
     AuxiliaryWarn=N GRECP=N
     RebuildPend=N ReorgPend=N
     PersistentReadOnly=N ReadorReplicationOnly=N

On this page