(PTF BPJ1993) Managing object sets with SCCBSET

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, RECOVERY MANAGER for DB2, Workbench for DB2.


  • The SCCBSET program does not require password checking.
  • The dynamic bind process is called.

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 *                 
     REPLACE YES                 
     INCLUDE TABLE                   
     INCLUDEIX NO                
     INCLUDE TABLESPACE              
     INCLUDEIX NO;               

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

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. Subselects are supported.

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

Deleting object sets

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 (PTF BPJ1993) DELETE OBJECTSET syntax and option descriptions.

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 (PTF BPJ1993) SCCIN DD syntax rules.

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

Was this page helpful? Yes No Submitting... Thank you