Copying Db2 entries

You can copy associated and not associated Db2® entries to other Db2 entries or to new Db2 entries.

About this task

Go to the step that applies to your environment:
  • To copy an associated Db2entry to another associated Db2 entry or to an entry that is not associated, go to step 1.
  • To copy an associated Db2 entry to a new entry, go to step 2.
  • To copy a Db2 entry that is not associated to a new entry, go to step 3.

Procedure

  1. To copy an associated Db2 entry to another associated Db2entry or to an entry that is not associated, complete the following steps:
    1. Specify C against a Db2 entry in the associated list of Db2 entries on the Customizer Workplace panel, and press Enter.
      The Copy Associated DB2 Entry panel is displayed.
    2. Select one or more Db2 entries to which information will be copied by specifying the / line command, and press Enter.
      The Associated column indicates whether the Db2 entry is associated.
      Tip: To copy information into all of the Db2 Entries in the list, issue the SELECTALL primary command, and press Enter.
      The Copy DB2 Parameter Values panel is displayed.
    3. Specify an option for copying common and product specific Db2 parameter values.
      Common Db2 parameter values apply to all Db2 entries for all products that you have customized by using Tools Customizer. Product-specific Db2 parameter values apply only to the product that you are currently customizing.
      • To copy the common Db2 parameter values and the product specific Db2 parameter values, specify option 1, and press Enter.
      • To copy only the product specified Db2 parameter values, specify option 2, and press Enter.
      In some cases, the Db2 parameter values might contain the Db2 subsystem ID as an isolated qualifier in data set names. For example, in the DB01.DB01TEST.DB01.SANLLOAD, data set name, the DB01 subsystem ID is isolated in the first and third qualifiers but is not isolated in the second qualifier. When the Db2 subsystem ID is an isolated qualifier in data set names, the Change DB2 Subsystem ID in DB2 Parameter Values panel is displayed. Otherwise, the Customizer Workplace panel is displayed.
    4. If the Change DB2 Subsystem ID in DB2 Parameter Values panel is displayed, specify an option for changing the subsystem IDs. Otherwise, skip this step.
      • To change the subsystem ID in isolated qualifiers in data set names, specify option 1, and press Enter.
      • To use the same subsystem ID in all values, specify option 2, and press Enter.
      The Customizer Workplace panel is displayed with the copied associated entry in the list.
  2. To copy an associated Db2 entry to a new entry, complete the following steps:
    1. Specify C against a Db2 entry in the associated list of Db2 entries on the Customizer Workplace panel, and press Enter.
      The Copy Associated DB2 Entry panel is displayed.
    2. Issue the CREATE command.
      The Create DB2 Entries panel is displayed.
    3. Specify the SSID, the group attach name, or both in the appropriate columns for each new Db2 entry, and press Enter.
      Tip: To add rows for additional entries, specify the Inn line command, where nn is the number of entries to be created, and press Enter.
      The Copy Associated DB2 Entry panel is displayed with the new entries in the list. The new entries are preselected.
    4. Press Enter to complete the copy process.
      The Customizer Workplace panel is displayed with the copied entries in the list.
  3. To copy a Db2 entry that is not associated to a new entry, complete the following steps:
    1. Issue the ASSOCIATE command on the Customizer Workplace panel.
      The Associate DB2 Entry for Product panel is displayed.
    2. Select one or more Db2 entries by specifying the / line command, and press Enter.
      The Copy a DB2 Entry panel is displayed.
    3. Specify the SSID, the group attach name, or both in the appropriate columns for the new Db2 entry, and press Enter.
      The Associate DB2 Entry for product panel is displayed with the copied entry in the list.
    4. If you want to associate the copied entry, specify A against it, and press Enter.
      The Customizer Workplace panel is displayed with the copied entries in the list.

What to do next

Edit any of the parameters or generate the jobs.