Managing object sets with SCCBSET (PTF BPJ1993 applied)

An object set represents a collection of table spaces, indexes, or both. You can use the SCCBSET program to create, delete, or report the contents of object sets.

This feature is particularly useful if you do not have any of the following products available for managing object sets: DASD MANAGER PLUS for DB2, BMC AMI Recovery Manager for Db2, and BMC AMI Command Center for Db2.

Creating object sets with SCCBSET

You can use the CREATE OBJECTSET command to create an object set based on indexes, index space names, plans, packages, storage groups, user-defined SQL, table name, or table spaces.

You can also copy an existing object set to retain the same utility options.

Additionally, you can create a dynamic object set, which is an empty object set (an object set for which no objects are found that meet the definition) that is automatically populated with objects as they are created. A dynamic object set enables you to prepare for objects that do not yet exist. For example, if you know that a new application will be added to your system, you can set up the object sets in advance. After the objects are created, dynamic object sets automatically find and add them to relevant jobs.

You can use multiple INCLUDE statements in the CREATE OBJECTSET syntax. For example, you can use the following syntax:

//SCCIN     DD *                 
  CREATE OBJECTSET RDAJTR.TEST_BYDEF2
     REPLACE YES                 
     DESCRIPTION 'CREATE BY DEF '
     INCLUDE TABLE                   
       JTR.T40N                  
     INCLUDEIX NO                
     INCLUDE TABLESPACE              
       SCCDBJTR.TS40P1           
     INCLUDEIX NO;               
   ...
   ...
   ...                                                
/*

For more information, see CREATE OBJECTSET syntax and option descriptions (PTF BPJ1993 applied).

Creating user-defined SQL object sets

You can create object sets with user-defined SQL with the SCCSQL DD statement and INCLUDE SQL syntax:

• With the SCCSQL DD statement, you specify the file with the SQL statement.
• With the INCLUDE SQL syntax, you specify the SQL in line, delimited by #BEGINSQL and #ENDSQL.
  You can enter multiple INCLUDE SQL statements in a CREATE OBJECTSET statement. The INCLUDE SQL syntax supports a limited number of key words for including related objects. Sub selects are supported.

For more information about the SCCSQL DD statement, see SCCSQL DD statement and example.

For more information about the INCLUDE SQL syntax, see INCLUDE SQL.

Deleting object sets

You can delete multiple object sets with a single command by using wildcards in the object sets name.

Deleting an object set removes only the object sets definition from the repository and has no effect on the objects within the object set.

For more information, see DELETE OBJECTSET syntax and option descriptions (PTF BPJ1993 applied).

Reporting object set information

You can generate reports about one or more object sets with the following information:

• Objects within the object set (written to file SCCOBJS)
• Object set specification (written to file SCCSPEC)

Generate reports for multiple object sets with a single command by using wildcards in the object set name. For more information about wildcards, see SCCIN DD syntax rules (PTF BPJ1993 applied).

For more information, see REPORT OBJECTSET syntax and option descriptions (PTF BPJ1993 applied).