Sample SCCBSET JCL and output (PTF BPJ1993 applied)
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
//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 12/19/2017 11:25:10 **
(c) COPYRIGHT 2018 BMC SOFTWARE, INC.
BMCSCC80223I SOLUTION COMMON CODE V12.01.00
BMCSCC80223I MAINT: BPJ1524 BPJ1541 BPJ1542 BPJ1568 BPJ1604 BPJ1611 BPJ1620
BMCSCC80223I MAINT: BPJ1622 BPJ1623 BPJ1626 BPJ1639 BPJ1655 BPJ1665 BPJ1682
BMCSCC80223I MAINT: BPJ1687 BPJ1697 BPJ1700 BPJ1701 BPJ1707 BPJ1713 BPJ1727
BMCSCC80223I MAINT: BPJ1758 BPJ1762 BPJ1769 BPJ1770 BPJ1781 BPJ1800 BPJ1801
BMCSCC80223I MAINT: BPJ1804 BPJ1855 BPJ1859 BPJ1862 BPJ1876 BPJ1885 BPJ1886
BMCSCC80799I CONNECTED TO DB2 SSID = DEJM VERSION = 121501
BMCSCC80799I DB2 CURRENT FUNCTION LEVEL = 121500
BMCSCC80799I DB2 HIGHEST ACTIVATED FUNCTION LEVEL = 121500
BMCSCC80799I DB2 CATALOG LEVEL = 121500
BMCSCC80799I RUN WITH THE SCCHELP DD TO SEE PROGRAM HELP INFORMATION
SET CURRENT SQLID = RDAJLW
;
BMCSCC80570I COMMAND COMPLETE RC = 0
REPORT OBJECTSET PUBLIC.DEL*
OBJECTS
SPECIFICATION
;
BMCSCC80591I PROCESSING OBJECTSET PUBLIC.DEL_1
BMC8SCC0591I PROCESSING OBJECTSET PUBLIC.DEL_2
BMCSCC80570I COMMAND COMPLETE RC = 0
DELETE OBJECTSET PUBLIC.DEL*
;
BMCSCC80591I PROCESSING OBJECTSET PUBLIC.DEL_1
BMCSCC80591I PROCESSING OBJECTSET PUBLIC.DEL_2
BMCSCC80570I COMMAND COMPLETE RC = 0
BMCSCC80531I 3 COMMANDS WERE PROCESSED
BMCSCC80571I PROGRAM COMPLETE RC = 0
For information about SCCPRINT, see Specifying the SCCBSET data set DD statements.
Sample report output in SCCOBJS
** OBJECTSET OBJECTS REPORT 12/19/2017 11:25:10 **
Object Set Name PUBLIC.Q2182799
Date Created 2017-12-19-09.09.09
Created by RDAJLW2
Date Updated 2017-12-19-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 12/20/2017 09:54:49 **
Object Set Name PUBLIC.Q2182799_A
Date Created 2017-12-20-08.40.38
Created by RDAJLW2
Date Updated 2017-12-20-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 2017-12-20-08.43.02
Created by RDAJLW2
Date Updated 2017-12-20-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
SET CURRENT SQLID for SCCBSET (PTF BPJ1993 applied)
CREATE OBJECTSET syntax and option descriptions (PTF BPJ1993 applied)
DELETE OBJECTSET syntax and option descriptions (PTF BPJ1993 applied)
REPORT OBJECTSET syntax and option descriptions (PTF BPJ1993 applied)
Comments
Log in or register to comment.