|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.
To execute the JCL script on the DB2 z/OS server, it is necessary to have the following privileges:
Note: to grant SELECT authority to access the DB2 Catalog, use this command:
GRANT AUTHORITY_TYPE ON TABLE TABLENAME TO USER;
For example, to grant SELECT authority on the table SYSIBM.SYSTABLES to CASTEXT (user running the Extractor), use the following command:
GRANT SELECT ON TABLE SYSIBM.SYSTABLES TO CASTEXT;
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.
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.
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
Windows FTP client via the command line
QUOTE SITE TRAIL
Manually add NOTRUNC to additional option field.
IND$FILE GET ‘CAST.DB2.TABLE’ ASCII CRLF NOTRUNC
Manually add STRIP.BLANKS (NO) to SYSOPTS option field. For example:
Please see IBM Sterling Connect:Direct process language documentation for more information.
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:
The syntax for the zosXtrChecker.exe tool is as follows:
zosXtrChecker.exe file | /? [mode] [compact]
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.
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