Running the extractor job

The CAST DB2 for z/OS extractor always saves its results in the same data sets. As a result, if you want to save several extractions, then you must make sure you transfer the results of each extraction into different directories prior to carrying out the next extraction. This will avoid overwriting the previous results with new results.

Once the JCL script has been adapted to the execution environment, it can then be submitted.

Required privileges

To execute the JCL script on the DB2 z/OS server, it is necessary to have the following privileges:

Tempspace

STEP15 of the JCL script can require a lot of TEMPSPACE for the ORDER BY clause. This depends on the number of objects and dependencies to extract - please ensure that a large tempspace is allotted.

Output

The extractor will query the DB2 system catalog by connecting to the DB2 subsystem and produce 26 files containing information about database structures and elements. They constitute a coherent group of data and so it is important to save them into the same directory.

These files must then be transferred onto the CAST analysis workstation via FTP so that they can be packaged by the CAST Delivery Manager Tool. They constitute a coherent group of data and so it is important to save them into the same directory. When transferring extraction results from the host server to your Windows platform after using the DB2 zOS Extractor, please ensure that you follow these instructions to ensure that data is correctly transferred to Windows and no trailing spaces are removed.

Transfer generated files to a Windows based network location that can be accessed by the CAST Delivery Manager Tool

There are a variety of methods that can be used to transfer the output of the DB2 z/OS extractor to a Windows based network location ensuring that no trailing spaces are removed. The table below lists the methods that CAST has previous experience of and the options you should add to ensure that the trailing blanks are not removed:

Tool used for file transfer

Options to add

Sample command (generated in case of GUI)

z/OS FTP tool

LOCSITE TRAILINGBLANKS

LOCSIte TRAILingblanks

Windows FTP client via the command line

QUOTE SITE TRAIL 

  • Open an FTP connection to the system on which the DB2 Extractor was run
  • Navigate to the location of the files created by the DB2 z/OS extractor
  • Enter quote site trail in to the command prompt
  • Use the GET option to transfer the files to your your local hard drive

IND$FILE

Manually add NOTRUNC to additional option field.

 
Please note that ASCII CRLF is generated automatically.

IND$FILE GET ‘CAST.DB2.TABLE’ ASCII CRLF NOTRUNC

Sterling Connect:Direct

Manually add STRIP.BLANKS (NO) to SYSOPTS option field. For example:

Please see IBM Sterling Connect:Direct process language documentation for more information.

Validate output

zosXtrChecker.exe

A tool named "zosXtrChecker.exe" is delivered with CAST which allows the consistency of the extraction files to be verified. In addition, it can also compact the data files by removing the unnecessary blank characters. Once you have transferred the extracted files to the CAST Administration workstation you should run this tool.

This tool requires the CAST AIP distribution to be executed. Input parameters are as follows:

Required syntax

The syntax for the zosXtrChecker.exe tool is as follows:

zosXtrChecker.exe file | /? [mode] [compact]

Examples

To run the tool with default settings, please use the following - this will use the MANIFEST file you have specified and will check that all files declared in the MANIFEST are present.

%CAST_INSTALLATION_LOCATION%\zosXtrChecker.exe  D:\extraction\my.MANIFEST

To specify a particular mode and to run the compact action:

%CAST_INSTALLATION_LOCATION%\zosXtrChecker.exe  D:\extraction\my.MANIFEST 1 1

To specify multiple modes (modes 0, 1 and 4 = 5) and to run the compact action:

%CAST_INSTALLATION_LOCATION%\zosXtrChecker.exe  D:\extraction\my.MANIFEST 5 1