Copying Db2 entries
You can copy associated and not associated Db2 entries to other Db2 entries or to new Db2 entries.
About this task
- 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
-
To copy an associated Db2 entry to
another associated Db2entry or to an entry
that is not associated, complete the following steps:
-
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.
-
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.
-
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. -
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.
-
Specify C against a Db2 entry in the associated list of
Db2
entries on the Customizer Workplace panel, and press Enter.
- To copy an associated Db2 entry to a new entry, complete the following
steps:
- 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.
- Issue the CREATE command. The Create DB2 Entries panel is displayed.
-
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.
- Press Enter to complete the copy process.
The Customizer Workplace panel is displayed with the copied entries in the list.
- Specify C against a Db2 entry in the associated list of
Db2 entries on the Customizer Workplace panel,
and press Enter.
- To copy a Db2 entry
that is not associated to a new entry, complete the following steps:
- Issue the ASSOCIATE command on the Customizer
Workplace panel. The Associate DB2 Entry for Product panel is displayed.
- Select one or more Db2 entries
by specifying the / line command, and press Enter. The Copy a DB2 Entry panel is displayed.
-
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.
- 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.
- Issue the ASSOCIATE command on the Customizer
Workplace panel.