Installation and Upgrade Guide

10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DB2 Parameters Page

Enter or review parameters for Db2 for z/OS bulk data movement.

DB2: Select this option to use Db2 for z/OS tables as a data source for bulk data movement.
This setting corresponds to the <db2exec> variable in the INSTPARM file.
DB2 Subsystem ID: The Db2 subsystem ID (SSID) or data-sharing group name for the data source.

Default is DSN1.

This setting corresponds to the <ssid> or <ssid4> variable in the INSTPARM file. The <ssid4> value is padded with spaces.
Load Library: The data set name of the Db2 SDSNLOAD load library. This value is optional if the z/OS LNKLST concatenation includes the Db2 load library.

Default is DSN910.SDSNLOAD.

This setting corresponds to the <db2load> variable in the INSTPARM file.
DB2 Exit: The data set name of the Db2 SDSNEXIT load library.

If the z/OS LNKLST concatenation includes the Db2 exit library, this value is optional.

Default is DSN910.SDSNEXIT .

This setting corresponds to the <db2exit> variable in the INSTPARM file.
Bulk Plan Name: The name of Db2 plan for PowerExchange bulk data movement. This name can be no longer than eight characters.

Default is PWXBKVxn, where x is a letter and n is a number that together correspond to the PowerExchange version. For example, for PowerExchange 10.1, the default name is PWXBKVA1.

This setting corresponds to the <db2plan> variable in the INSTPARM file.
Bulk Plan Owner Name: The owner name that PowerExchange uses to bind the Db2 plan and packages for bulk data movement created during the installation process.

Default is the
Logon ID
value from the
Select Global Parameters
page.

This setting corresponds to the <zcreator> variable in the INSTPARM file.
Package Collection Suffix: A suffix that PowerExchange appends to Db2 package collection IDs in the BIND PACKAGE statements in the BIND control members. This suffix can be up to 62 characters in length. If you plan to run more than one PowerExchange version in your environment, you can use the suffix to differentiate the packages for the version that you are installing.

If the InstParm file contains a value for this field from a previous installation and you are performing a full installation or upgrade installation, the default value is taken from the InstParm file. You can edit this value, if necessary. If you are performing a hotfix installation, the default value is also taken from the InstParm file. However, you can edit the value only if the hotfix includes the DBRMXMIT file, which requires a rebind of the Db2 plan and packages.

This setting corresponds to the <db2pkgsuffix> variable in the INSTPARM file.

In the

DSNTEP2

group box:

Name: The DSNTEP2 program name.

Default is DSNTEP2.

This setting corresponds to the <db2dsntep2name> variable in the INSTPARM file.
Plan: The DSNTEP2 plan name.

Default is DSNTEP91.

This setting corresponds to the <db2instplan> variable in the INSTPARM file.
DB2 RUNLIB: The data set name of the load library that contains the DSNTEP2 program. PowerExchange uses the DSNTEP2 program to run Db2 commands.

Default is DSN910.RUNLIB.LOAD.

This setting corresponds to the <db2runlib> variable in the INSTPARM file.

Advanced Parms: Enables you to define advanced parameters.

To change an advanced parameter value, complete the following steps:

In the
Value
column, click the cell for the parameter.

To sort parameters, click a column header. For example, to sort by parameter name, click the
Parameter Name
header.

Enter the parameter value, and click
OK
.

If you define advanced parameters, you cannot restore these parameters to default values by using the
Restore Defaults
button.
Restore Defaults: Restores default values.

Rename Saved Search

Table of Contents

Installation and Upgrade Guide

Installation and Upgrade Guide

DB2 Parameters Page

DB2 Parameters Page