Setting up a SmartSwitch rules table

For each subsystem, use the following procedure to set up the SmartSwitch rules table and alias. This procedure uses sample DDL that is supplied by the Db2 Utilities Common Code PTF BQU0257.

Copy the sample DDL from the D2USAMP library member D2USSDDL added by PTF BQU0257.

In the copy, you can replace the variables (identified by angle brackets) with your own values.

Observe the following guidelines:

Value	Guideline
Database	The default value is the database in which other BMC table spaces (for example, BMCUTIL and BMCSYNC) are located. If you selected another database during installation, specify that database in the sample DDL.
Table space	We strongly recommends that you do not change the default value.
Buffer pool	You can specify your own value (provided that the buffer pool size is 4K).
Storage group	You can specify your own value.
Table space creator	Do not change the default value.
Index	We strongly recommends that you do not change the default values.
Constraints	Do not change the default values.
Alias for BMC AMI Command Center for Db2	The alias qualifiers are Axx112D, the Installation System defaults for each of the BMC AMI Utilities products. If you changed the qualifier of product synonyms when you installed LOADPLUS, specify that qualifier value. The alias creator must be the qualifier used during installation. It is the same as the qualifier used for the synonym definitions for the BMCUTIL and BMCSYNC tables. Do not change the alias creator values.
Alias for LOADPLUS

Line in the sample DDL	Value	Guideline
1	Database	The default value is the database in which other BMC table spaces (for example, BMCUTIL and BMCSYNC) are located. If you selected another database during installation, specify that database in the sample DDL.
3	Table space	We strongly recommends that you do not change the default value.
3	Buffer pool	You can specify your own value (provided that the buffer pool size is 4K).
6 and 35	Storage group	You can specify your own value.
8	Table space creator	Do not change the default value.
32	Index	We strongly recommends that you do not change the default values.
39, 42, and 45	Constraints	Do not change the default values.
48	Alias for BMC AMI Command Center for Db2	The alias qualifiers are Axx112D, the Installation System defaults for each of the BMC AMI Utilities products. If you changed the qualifier of product synonyms when you installed LOADPLUS, specify that qualifier value. The alias creator must be the qualifier used during installation. It is the same as the qualifier used for the synonym definitions for the BMCUTIL and BMCSYNC tables. Do not change the alias creator values.
54	Alias for LOADPLUS

Sample DDL

CREATE DATABASE <databaseName>;

  CREATE TABLESPACE <tableSpaceName> IN <databaseName> BUFFERPOOL <bufferPool>
     COMPRESS NO MAXPARTITIONS 1 SEGSIZE 4 CCSID EBCDIC
     MAXROWS 255 FREEPAGE 10 PCTFREE 10 DSSIZE 4G
     USING STOGROUP <storageGroup> PRIQTY -1 SECQTY -1;

  CREATE TABLE <tableSpaceCreator>.<tableSpaceName>
  (LAST_UPD_TIMESTAMP TIMESTAMP   NOT NULL WITH DEFAULT
  ,LAST_UPD_USERID    CHAR(8)     NOT NULL WITH DEFAULT USER
                                  FOR SBCS DATA
  ,SCHEMA_VERSION     SMALLINT    NOT NULL WITH DEFAULT 1
  ,LPAR               CHAR(8)     NOT NULL WITH DEFAULT '%'
                                  FOR SBCS DATA
  ,SSID               CHAR(8)     NOT NULL WITH DEFAULT '%'
                                  FOR SBCS DATA
  ,AUTHID             CHAR(8)     NOT NULL WITH DEFAULT '%'
                                  FOR SBCS DATA
  ,DBNAME             CHAR(8)     NOT NULL WITH DEFAULT '%'
                                  FOR SBCS DATA
  ,SPNAME             CHAR(8)     NOT NULL WITH DEFAULT '%'
                                  FOR SBCS DATA
  ,OBJTYPE            CHAR(3)     NOT NULL WITH DEFAULT 'ALL'
                                  FOR SBCS DATA
  ,UTILITY            CHAR(8)     NOT NULL WITH DEFAULT 'ALL'
                                  FOR SBCS DATA
  ,RULE               CHAR(16)    NOT NULL WITH DEFAULT 'FORCE_CLASSIC'
                                  FOR SBCS DATA
  ,COMMENT            VARCHAR(256) WITH DEFAULT FOR SBCS DATA)
  IN <databaseName>.<tableSpaceName>;

  CREATE UNIQUE INDEX <indexSpaceCreator>.<indexSpaceName> ON <indexSpaceCreator>.<tableSpaceName>
        (LPAR   DESC, SSID    DESC, AUTHID DESC, DBNAME DESC
        ,SPNAME DESC, OBJTYPE DESC, UTILITY DESC )
      CLUSTER USING STOGROUP <storageGroup> PRIQTY -1 SECQTY -1
               ERASE NO FREEPAGE 10 PCTFREE 10 PIECESIZE 4G;

  ALTER TABLE BMCUTIL.CMN_BMCSWITCH
      ADD CONSTRAINT SMARTSWITCH_RULE_TEXT
          CHECK (RULE IN ('FORCE_CLASSIC','ALLOW_NGT','REPORT_NGT,'FORCE_NO_SWITCH','ALLOW_SWITCH','REPORT_SWITCH));
  ALTER TABLE BMCUTIL.CMN_BMCSWITCH
      ADD CONSTRAINT SMARTSWITCH_UTILITY_NAME
          CHECK (UTILITY IN ('UNLOAD','REORG','LOAD' ,'ALL'));
  ALTER TABLE BMCUTIL.CMN_BMCSWITCH
      ADD CONSTRAINT SMARTSWITCH_OBJECT_TYPE
          CHECK (OBJTYPE IN ('PBG','ALL'));

  CREATE ALIAS ACT112D.BMC_BMCSMARTSWITCH FOR <tableSpaceCreator.tableSpaceName>;

  CREATE ALIAS ADU112D.BMC_BMCSMARTSWITCH FOR <tableSpaceCreator.tableSpaceName>;

  CREATE ALIAS AMU112D.BMC_BMCSMARTSWITCH FOR <tableSpaceCreator.tableSpaceName>;

  CREATE ALIAS ARU112D.BMC_BMCSMARTSWITCH FOR <tableSpaceCreator.tableSpaceName>;

Setting up a SmartSwitch rules table

On this page