Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

PowerExchange Substitution Variables for Netport Jobs

PowerExchange Substitution Variables for Netport Jobs

To control and customize netport jobs, PowerExchange provides substitution variables. Prior to submitting a netport job to
z/OS
, PowerExchange resolves the defined substitution variables in the skeleton netport JCL with the appropriate values.
The skeleton JCL member is identified in the fifth positional parameter of the NETPORT statement in the DBMOVER configuration file.
The sample JCL in the NETJCL member of the RUNLIB library demonstrates how to enter substitution variables to form unique data set names. You can include the variables in a netport job that is based on the sample CAPXJCL, GDGJCL, IMSJCL, or TAPEJCL JCL.
The following table describes the substitution variables:
Substitution Variable
Where Used in the JCL
Description
%CLIENT
Fourth positional parameter on the first line of the PARMS statement
Unique 16-byte hexadecimal identifier that includes the job name of the PowerExchange Listener.
%CPNODE
First positional parameter on the first line of the PARMS statement
The
cpnode
parameter value from the NETPORT statement that PowerExchange used to submit the netport job.
%CPPORT
Third positional parameter on the first line of the PARMS statement
The
cpport
parameter value from the NETPORT statement that PowerExchange used to submit the netport job.
%DATE_YYMMDD
DD statement
Current Gregorian date.
%DATE_YYYYDDD
DD statement
Current Julian date.
%DMX_ECSA
Keyword parameter on the second line of the PARMS statement
The hexadecimal address of the ECSA memory that holds the time of the latest update to the DATAMAPS file.
Use the DMX_ECSA keyword parameter to enter this substitution variable on the second line in the PARMS DD, as follows:
DMX_ECSA=%DMX_ECSA
This parameter is optional. Include it if you use data maps caching and want to enable a netport job to initialize quickly in an environment where APF authorization is not allowed. For example, use this parameter an environment where access to IMS databases is through DL/I.
If you do not use data maps caching, this parameter is ignored.
%IMSID
-
A substitution variable for the IMS SSID.
if you specify an IMS SSID override in the PowerCenter
IMS SSID Override
session property for a source or target or in the
IMS SSID
advanced parameter for a database row test, the override value replaces the substitution variable for the session or row test.
If you do not specify an IMS SSID override but you use an ODBA data map with a BMP netport job, the IMS SSID from the data map replaces the substitution variable.
If an IMS SSID is not available from the data map or entered as an IMS SSID override, the substitution variable is replaced by a NULL value. In this case, IMS determines which IMS subsystem to access based on the load libraries specified in the netport job.
%N
n
JOB statement
Value of the numeric counter with the length of
n
. Valid values for the length are from 1 through 7.
The PowerExchange Listener maintains a separate value for each possible numeric counter, and increases the value by one each time that numeric counter is used. For example, if netport JCL specifies %N3 in two places in the JCL, the first occurrence is assigned a value of 001 and the second occurrence is assigned a value of 002. The next netport job that references %N3 is assigned 003, and so on.
%PSBNAME
-
A substitution variable for the PSB name.
If you specify a PSB name override in the PowerCenter
IMS PSBNAME Override
session property for a source or target or in the PowerExchange Navigator
PSB Name
advanced parameter for a database row test, the override value replaces the substitution variable for the session or row test. By using the substitution variable with an override, you can use the same JCL and same set of NETPORT and LISTENER statements for multiple PSBs. You do not need to edit the DBMOVER statements and restart the PowerExchange Listener.
If you do not specify a PSB name override but you use an ODBA data map with a DL/I or BMP access method override, this substitution variable is replaced by the PSB name from the data map.
This substitution variable has no effect on the %1 variable in the NETPORT statement. This variable gets the PSB name from the sixth positional parameter in the NETPORT statement.
Also, in the netport JCL, you can allocate a database member to the netport job, which is used for accessing the required database data sets. If this database member has the same name as the PSB, you can add an INCLUDE statement in the JCL that uses the %PSBNAME variable. For example:
//DBALLOC INCLUDE MEMBER=%PSBNAME
By using this variable with PSB overrides, you can allocate other database members to the job.
%PWD
JOB statement
The password of the user ID that connected to the PowerExchange Listener. To avoid exposing passwords, you should only use this substitution variable on the PASSWORD parameter of the JOB card.
%SOCKNO
Second positional parameter on the first line of the PARMS statement
Socket number on which the connection to the PowerExchange Listener was made.
%SMFTASK
-
If the STATS statement in the DBMOVER member specifies recording to SMF, this variable is the PowerExchange task number. Otherwise, the value is 00000.
%TIME_HHMMSS
DD statement
Current time, in
24-hour
clock time format.
%USER
JOB statement
The user ID that connected to the PowerExchange Listener.
%1
-
An optional substitution variable that the sample IMSJCL member of the RUNLIB library uses to populate the PSB parameter in the DLIBATCH PROC. Enter this variable as the sixth positional parameter in the NETPORT statement in the DBMOVER member.
%2
-
An optional substitution variable. Enter it as the seventh positional parameter in the NETPORT statement in the DBMOVER member.
%3
-
An optional substitution variable. Enter it as the eighth positional parameter in the NETPORT statement in the DBMOVER member.
%4
-
An optional substitution variable. Enter it as the ninth positional parameter in the NETPORT statement in the DBMOVER member.
%5
-
An optional substitution variable. Enter it as the tenth positional parameter in the NETPORT statement in the DBMOVER member.
%6
-
An optional substitution variable. Enter it as the eleventh positional parameter in the NETPORT statement in the DBMOVER member.
%7
-
An optional substitution variable. Enter it as the twelfth positional parameter in the NETPORT statement in the DBMOVER member.
%8
-
An optional substitution variable. Enter it as the thirteenth positional parameter in the NETPORT statement in the DBMOVER member.