Getting Source DBD Information from the IMS Catalog
Getting Source DBD Information from the IMS Catalog
PowerExchange requires access to IMS database definitions (DBDs) in source format for creating data maps in the PowerExchange Navigator. PowerExchange also requires DBD information in DBGEN format for creating capture registrations in the PowerExchange Navigator and for performing IMS unload processing. You can configure PowerExchange to access DBD information directly from the IMS catalog instead from the DBDLIB library.
When properly configured, PowerExchange can transparently get DBD information for IMS source objects from the IMS catalog by using the following IMS tools:
IMS catalog API
. This API consists of the DFS3CATQ assembly program in the IMS
xxx
.SDFSRESL.RESLIB library and the DFS3CATQ macro in the IMS
xxx
.SDFSMAC library. The API gets DBD information in DBGEN format from the IMS catalog when you create capture registrations for IMS log-based or synchronous CDC sources in the PowerExchange Navigator or perform IMS unload processing. PowerExchange requires the high-level qualifier of the bootstrap data set if the IMS control region is not running or if you are using an IMS version earlier than IMS 15.
IMS Catalog Library Builder Utility, DFS3LU00
. The utility gets DBD information in source format from the IMS catalog and writes this DBD information to a PDSE that you pre-allocated. When you create data maps in the PowerExchange Navigator, PowerExchange retrieves the source metadata from the PDSE. After the metadata is imported to the Navigator machine for data map creation, PowerExchange deletes the information from the PDSE so that no PDSE maintenance is required.
Use of the IMS catalog is optional in PowerExchange and IMS. However, certain IMS functionality, such as database versioning and the management of run-time application control blocks requires the IMS catalog. For more information see the IBM IMS documentation.
For PowerExchange to use the IMS catalog API to get metadata for IMS sources, provide the high-level qualifier of the bootstrap data set in the IMSBSDS statement in the DBMOVER configuration file.
For PowerExchange to use the IMS Catalog Library Builder Utility, DFS3LU00, to retrieve DBD information from the IMS catalog, perform the following configuration tasks:
Allocate a partitioned data set extended (PDSE) to hold output from the IMS Catalog Library Builder Utility, DFS3LU00.
Customize the PowerExchange Listener JCL or PROC to specify the DD statements required for IMS catalog use.
In the DBMOVER configuration member on the PowerExchange Listener machine, define the following statements:
IMSID. You must specify an
ims_ssid
value that matches the
ims_ssid
in the IMSBSDS statement.
IMSBSDS. Make sure the
ims_ssid
in this statement matches the
ims_ssid
in the IMSID statement.
LU00FILE. Enter the name of the PDSE that you created to store DBD output from the IMS Catalog Library Builder Utility, DFS3LU00.
When you add data maps for IMS source objects in the PowerExchange Navigator, be sure to configure the following fields:
On the
Name
page, select
Import Record Definitions
.
On the
DL/1 Batch Access Method
page, enter an IMS SSID value that matches the
ims_ssid
value that you specified in the IMSBSDS statement in the DBMOVER configuration file.
On the
Import Copybook - Source Details
page, select
Remote
under
Source
and select
DBD
in the
Type
field.
On the
Import Copybook - Remote DBD Details
page, in the
File Name
field, enter the name of a PDS along with the DBD member name that you want to look for in the IMS catalog.
For more information, see the "IMS Bulk Data Movement" chapter in the
PowerExchange Bulk Data Movement Guide
and the "IMS Log-Based Change Data Capture" chapter in the