Creating auxiliary objects for a single partition in a partitioned table space

In this task, you perform the following subtasks:

1. Specify a template.
2. Create the auxiliary table space.
3. Create the auxiliary table.
4. Create the auxiliary index.
5. Review the list of auxiliary objects.
6. (Optional) Undo changes to the auxiliary objects.

To specify a template

1. On the BMC AMI Change Manager for Db2 Main Menu, select WORKID, and press Enter.
2. On the WORKID Action Menu, type the name of the WORKID or type a wildcard pattern to display a list of work IDs. Then, select Specify DB2 definitions and press Enter.
3. On the Object Specification panel, specify the name of a partitioned table space (or use wildcard characters). Then, press Enter.The Mixed List panel is displayed.
4. Type CO in the Act column adjacent to the base table (TBB) that contains a LOB column.The Table Columns List panel is displayed.
5. Type CAX in the Act column adjacent to the LOB column name and press Enter.The Create Auxiliary Tablespace Template panel is displayed.

To create the auxiliary table space

1. On the Create Auxiliary Tablespace Template panel, select Create single object.

2. Specify the attributes for the table space.

   Tip

   Some object names might be too long to be displayed on a panel. To view a long object name, position the cursor on the object name and press the ZOOM (F4) key.

   1. Specify the name of the table space.
   2. Specify the owner of the table space.
   3. Specify the attributes for the table space. To specify additional attributes, type S to select More Tablespace Attributes.
   4. Specify whether the parent database already exists in the Db2 catalog.
   5. Press END.The auxiliary table space is saved in the CD tables. The Create Auxiliary Table panel is displayed.

To create the auxiliary table

1. Specify the owner of the table.
2. Specify the name of the table.
3. Specify the name of the table space.
4. Specify a label for the table.

5. Specify whether the parent (auxiliary) table space already exists in the Db2 catalog.

   Important

   In this example, the auxiliary table space does not exist.

6. Specify the partition number for which you want to create the auxiliary table.

7. To specify a comment for the table, type S to select Table Comment.

   Tip

   Some object names might be too long to be displayed on a panel. To enter a long object name, position the cursor on the object name and press the ZOOM (F4) key.

8. Press END.The auxiliary table is saved in the CD tables.

To create the auxiliary index

1. Specify the owner of the index.
2. Specify the name of the index.
3. Specify the owner of the table.
4. Specify the name of the table.
5. Specify values for the attributes. To specify additional attributes, type S to select More Attributes.

6. Specify whether the parent (auxiliary) table already exists in the Db2 catalog.

   Important

   In this example, the auxiliary table does not exist.

7. To specify a comment for the index, type S to select Comment.
8. Press END.The auxiliary index is saved in the CD tables.

To review the list of auxiliary objects

1. On the Table Columns List panel, type AX in the Act column adjacent to the LOB column name to review the list of auxiliary objects for the base table.The Auxiliary Objects List panel is displayed. The auxiliary table space, table, and index for each partition are listed for the partition that you specified, as shown in the following figure.

   Tip

   Some object names might be too long to be displayed on a panel. To view a long object name, position the cursor on the object name and press the ZOOM (F4) key.

   ALUSAXL ER   --------------------- Auxiliary Objects List ---------------------
   Command ===>                                                    Scroll. . CSR
                                                                                 
   WORKID . . . . .  RDACRJ.LOBTEST                              Commands: CANCEL
                                                                                
   Base Table . . .  RDACRJ.T_L01PS                                              
                                                                                 
   Type action next to object and press Enter.                                   
      E=Edit  L=Like  D=Drop  U=Undo                                              
                                                            Objects 7 to 12 of 12
                                                                    More:   -    
   Act     Object-Type    Objects                            Column          Part
           TS . . . . . . CJACML01   L01PSL1C                                    
             TB . . . . .   RDACRJ     T_L01PSL1C            XCLOB              3
               IX . . . .     RDACRJ     I_L01PSL1C                              
        L  TS . . . . . . CJACML01   LATSP                                       
        L    TB . . . . .   RDACRJ     LATP                  XCLOB              4
        L      IX . . . .     RDACRJ     LIXP                                    
   *********************************** BOTTOM ************************************
2. Press END.The Mixed List panel is displayed. The *@ marker adjacent to the base table (TBB) object indicates that auxiliary objects were created or modified for the base table.
3. On the Mixed List panel, press END until the WORKID Action Menu is displayed.

To undo changes to auxiliary objects

1. In the Mixed List panel, type AX in the Act column adjacent to the modified base table (TBB).

2. In the Auxiliary Objects List panel, remove the requested changes to the auxiliary objects. Perform one of the following tasks:

   • To undo changes to all of the objects listed, type UNDOALL on the Command line.
   • To undo changes to one or more of the objects listed, type U in the Act column adjacent to the auxiliary objects.

   Now that the auxiliary objects have been created, you can analyze a work ID and execute a worklist.