Changes to data structures via Specification component
You specify the changes to data structures through the Specification component. You can select objects from the Db2 catalog and describe changes to be performed on those objects. You can modify and delete objects by using the ALTER and DROP commands. You can also create new objects by using the LIKE or CREATE command. Specification stores the changes in the CD tables using the work ID name as the identifier.
| For more information, view the Quick Course Performing Specification. |
You specify changes to the data structures in the same way that you specify the data structures for a migration. You can specify the names of the data structures that you want to appear in a mixed list on the Object Specification panel.
From the mixed list, you can specify the objects that you want to change. The Mixed List panel displays lists of different types of Db2 data structures.
Command ===>
Scroll. . CSR
WORKID . . . . : RDACRJ.ALTER1 Commands: CANCEL
Type action next to object and press Enter.
E=Edit L=Like D=Drop U=Undo
Objects 1 to 12 of 215
More: +
Act Object-Type Objects
************************************ TOP **************************************
DB . . . . . . J1ALLB
TSI. . . . . J1ALLB M01ICP
TBQ. . . . J1ALLB T_M01ICP
IXC. . . J1ALLB I_M01ICP1
#TR . . . J1ALLB TRM01ICP1
#VW . . . J1ALLB BV_M01ICP<>L_SELCOLS
#VW . . . J1ALLB BV_M01ICP<>L_SELCOLS
#VW . . . J1ALLB VW_M01ICP<>SELALL_BV
TS . . . . . J1ALLB M02SSEG
TBQ. . . . J1ALLB T_M02SSEG
IX . . . J1ALLB I_M02SSEG1
IX . . . J1ALLB I_M02SSEG2
For a list of the abbreviations for object types that Specification uses in the Mixed List panel, as well as the data types for the object names, see Db2-object-types.
You can use action codes (or Command line commands) on the Mixed List panel to indicate the type of action that you want to perform. Some of the actions that you can perform in the Mixed List panel are described in the following table.
Mixed List actions
Act | Action | Description |
|---|---|---|
AX | Auxiliary Object (LOB) | Displays the auxiliary objects for LOB columns that are associated with a base table. |
D | Drop | Excludes the data structure that is explicitly marked for migration (or implicitly marked in the migrate options) from being included in the migration or marks the data structure to be dropped. |
E | Edit | Specifies the creation of data structures on the destination subsystem that are a modified version of those on the origin subsystem. |
L | Like | Specifies the creation of a single data structure on the destination subsystem using the data structure from the origin subsystem as a template. Dependent structures are not created. You can also use the C (Create) action code to create a data structure without a template. |
U | Undo | Reverses the action. |
XM | Auxiliary Object (XML) | Displays the auxiliary objects for XML columns that are associated with a base table. You can only view the name of an auxiliary object for an XML column. You cannot drop, like, or edit the object. |
You can also use the following command-line commands on the Mixed List panel:
- DROPALL marks all of the data structures to be dropped. This command is the equivalent of typing D in the Act column for all data structures.
- UNDOALL reverses the action on all data structures. This command is the equivalent of typing U in the Act column for all data structures.
For more information about the commands that you can use in the Mixed List panel, see Command-and-syntax-reference.
Identification of changes to data structures
When you specify a change to an object, an asterisk (*) and a change-level indicator appears on a list panel adjacent to the Act column.
The following table describes each of the indicators that relate to changing data structures.
Change-level indicators
Indicator | Description |
|---|---|
A | Indicates that you changed one or more object attributes |
D | Indicates that you dropped an object |
L | Indicates that you LIKEd, copied, inserted, or added an object |
@ | Indicates that you changed at least one auxiliary object that is associated with a base table If you change the base table, the appropriate indicator overrides the @ indicator. For more information about auxiliary objects, see Changes-to-auxiliary-objects-for-a-LOB-column. |
$ | Indicates that you estimated the space for an object |
When you request a change to a data structure, only the definition of the data structure and the requested changes are saved in the Change Definition (CD) tables. The specified changes do not occur in the Db2 catalog until you analyze the changes, generate a worklist, and execute the worklist.
This section contains the following topics: