Delivery Manager Tool - Extraction - Fatal Error - DB2 zOS - java.io.FileNotFoundExcept while choosing schema to extract

Purpose (problem description)

Error encountered in DMT, after selecting manifest file and when we try to choose schema to extract.
Option used is : CAST extractor output for DB2 zOS

Error during parsing of schema file list : D:\DEF.DBASE
java.io.FileNotFoundExcept: D:...\DEF.DBASE
The system cannot find the file specified

This error can be seen in the extraction log. To see the log location, refer the section Possible location for logs of the page : CAST Management Studio - Information - How to find logs

Observed in CAST AIP

ReleaseYes/No
8.0.x
7.3.x
7.2.x
7.0.x

Observed on RDBMS

This section is not applicable for this page(DMT)

RDBMSYes/No
Oracle ServerNA
Microsoft SQL ServerNA
CSS2NA
CSS1NA

Step by Step scenario

  1. Launch DMT
  2. Select DB2 ZOS
  3. Select manifest file
  4. Try to choose schema to extract
  5. Error encountered

Relevant customer’s input

Get the DB2 extraction and log

Action Plan

  1. Get the input
  2. Observe the Manifest file if the format is correct or there is any junk char or number at the end of each row as shown in the attached screenshot
  3. If there is , the solution is to remove such char/number and redo the steps
  4. Please cross check with customer if these junk numbers are added during the transfer.
  5. If yes, then ensure that you use the DB2 FTP tool with the parameter LOCSITE TRAILINGBLANKS when transferring schema data from the host server to your Windows platform prior to using the DB2 zOS Extractor.

Notes/comments

Reference call no 29214

Related Pages