Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

Changes to auxiliary objects for a LOB column

You use the Auxiliary Objects List panel to edit, like, or drop auxiliary objects for a LOB column. The panel lists only auxiliary table spaces, tables, and indexes.

Success

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.ALTER1                                Commands: CANCEL

Base Table . . : J1ALL1B.TBT12IM

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 **************************************
        TS . . . . . . J1ALL1B    LD2RWHW5
          TB . . . . .   J1ALL1B    TBT12COLCLD2RWHV7C   COLCL_11            1
            IX . . . .     J1ALL1B    ITBT12COLCLD2RWMXU
*********************************** BOTTOM ************************************

The auxiliary objects are grouped by each partition and are sorted by the LOB column name and partition number. Orphaned auxiliary objects are displayed in the Unattached Objects section at the end of the list. The Auxiliary Objects List panel uses the same object-type abbreviations as the Mixed List panel.

As in the Mixed List panel, you can use action codes (or Command line commands) in the Auxiliary Objects List panel to indicate the type of action that you want to perform. You can only edit, like, drop, or undo an action on an auxiliary object for a LOB column in the Auxiliary Objects List panel.

This section contains the following topics:

Related topic

Changes-to-data-structures-via-Specification-component


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1