Creating auxiliary objects for a nonpartitioned table space

The CAX action code is used to create the auxiliary table spaces, tables, and indexes that are required for a base table that contains a LOB column.

In this procedure, you perform the following subtasks:

1. Specify a base table.
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 base table

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 nonpartitioned table space (or use wildcard characters). Then, press Enter.
4. On the Mixed List panel, type CO in the Act column adjacent to the base table (TBB) that contains a LOB column.
5. On the Table Columns List panel, type CAX in the Act column adjacent to the LOB column name and press Enter.

To create the auxiliary table space

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.

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 the partition number for which you want to create the auxiliary table. For nonpartitioned table spaces, the partition number should be 0 (zero).
6. Specify whether the parent table space already exists in the Db2 catalog.

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 view 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. On the Create Auxiliary Index panel, specify the attributes for the index.

   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 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 table already exists in the Db2 catalog.
   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.

2. On the Table Columns List panel, 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.

To review the list of auxiliary objects

1. On the Mixed List panel, type AX in the Act column adjacent to the base table to review the list of auxiliary objects for the base table.The Auxiliary Objects List is displayed. The new auxiliary table space, table, and index are listed, 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.ALT03                                Commands: CANCEL
                                                                                
   Base Table . . .  RDACRJ.T_L12SS                                              
                                                                                 
   Type action next to object and press Enter.                                   
      E=Edit  L=Like  D=Drop  U=Undo                                              
                                                              Objects 1 to 3 of 3
                                                                    More:        
   Act     Object-Type    Objects                            Column          Part
   ************************************ TOP **************************************
        L  TS . . . . . . CJACML01   ATSL12SS                                    
        L    TB . . . . .   RDACRJ     ATL12SS               XCLOB              0
        L      IX . . . .     RDACRJ     AIL12SS                                 
   *********************************** BOTTOM ************************************
2. 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.
   • 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.