Start of change

Invoking Db2 Table Editor from Db2 Admin Tool

IBM® Db2 Table Editor for z/OS® is a product that makes it easy to view and modify your Db2 table data. If you have Db2 Table Editor installed, you can launch it from Db2 Admin Tool.

Before you begin

To be able to invoke Db2 Table Editor from Db2 Admin Tool, Db2 Table Editor must be enabled during the customization of Db2 Admin Tool. Specifically, the following fields on the DB2 Parameters (CCQPDB2) panel must be set:
  • Enable Db2 Table Editor must be set to YES
  • Table Editor CLIST(mbr) must list the CLIST member
Optionally, set the Pass accelerator name to Table Editor field to indicate whether you want accelerator information to be passed to Db2 Table Editor.

For details on setting these values during customization, see Defining Db2 parameters.

Procedure

To invoke Db2 Table Editor from Db2 Admin Tool:

  1. On the DB2 Administration Menu (ADB2) panel, specify option 1, and press Enter.
  2. On the System Catalog (ADB21) panel, specify option T and optionally any search criteria at the bottom of the panel to find the table that you want to edit, and press Enter.
  3. On the Tables, Views, and Aliases (ADB21T) panel, specify the EDIT line command next to the desired table, and press Enter.
    If Pass accelerator name to Table Editor was set to YES on the DB2 Parameters (CCQPDB2) panel and the table to be edited is associated with at least one accelerator, the DB2 Accelerators (ADBPZAC) panel displays a list of accelerators that are related to the selected table. Otherwise, Db2 Table Editor opens, and no accelerators are listed.
  4. If the DB2 Accelerators (ADBPZAC) panel is displayed, use the following commands to select the accelerators that you want Db2 Table Editor to use, and press Enter:
    +
    Specify this line command next to any accelerator to select it.
    ALL
    Specify this primary command on the command line to select all accelerators listed.
    NONE
    Specify this primary command on the command line to specify that you do not want to pass any accelerator information to Db2 Table Editor.

    The selected accelerator or accelerators must be active. If a selected accelerator is not active, the accelerator name is not passed to Db2 Table Editor. If none of the selected accelerators are active, the following message is displayed to prompt you to activate at least one of them:

    Selected acceletor is not active, please start it or select command NONE to work without accelerator

What to do next

For instructions on how to use Db2 Table Editor, see Db2 Table Editor 4.5.0.
End of change