Using PowerExchange ODBC Connections in a Data Archive Retirement Project

Back Next

Configure the PowerExchange Listener JCL on z/OS

Configure the PowerExchange Listener JCL before starting the PowerExchange Listener the first time. PowerExchange provides PowerExchange Listener JCL in the following members of the RUNLIB library:

PWXLSTNR runs PowerExchange as a started task.

STARTLST runs PowerExchange as a batch job.

When you ran the XIZZZ998 job during installation, the PWXLSTNR member was copied to the PROCLIB library.

Verify that the STEPLIB DD concatenation in the PowerExchange Listener JCL includes the load libraries for your source DBMSs.

Usually, the PowerExchange LOADLIB library occurs before the data-source load libraries in the concatenation.

The STEPLIB concatenation in the STARTLST member includes the load libraries for all data sources in a proper order.

Verify that the PARM statement specifies the node name that is defined in the LISTENER statement of the DBMOVER configuration file.

In the REGION parameter of the EXEC statement, enter a region size. The region size indicates the amount of storage to allocate for running the PowerExchange Listener.

The sample JCL specifies a region size of 128 MB in the EXEC statement.

Informatica recommends a region size of 0M, which indicates no storage limit.

If you omit the REGION parameter, the system default applies.

Verify that the TIME parameter in the EXEC statement is set to NOLIMIT. The NOLIMIT setting enables the PowerExchange Listener job to run without a time limit and prevents timeout-related abends that might occur with abend code S322.

If the SECURITY statement in the DBMOVER configuration file is set to 1 or 2, APF-authorize the PowerExchange LOADLIB library and any other load libraries in the STEPLIB DD concatenation of the PowerExchange Listener JCL.

For more information, see the

PowerExchange Bulk Data Movement Guide

Step 1: Install and Configure PowerExchange on z/OS

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal