The following error occurs in the analysis log:
Unable to find 'S:\...\CAST.DB2.SYSDTYP' file due to one of the following reasons
A- DB2 for z/OS extracted file doesn't match expected format.
B- You have supply a filter file that doesn't accept objects described in the file.
To fix the problem do one of following operations
Modify your filter file in order to add required objects group (see online help)
Check 'CAST.DB2.MANIFEST' reference file for columns description.
If the extractor contents has been modified to generate files in another way,
please get the latest version and try again.
Following the error message, the analysis fails with Execution result=error.
This issue occurs if the format of extracted file is not correct.
In the files, each column is represented by two columns. First column (having size 11 character string) shows the size of the column in digits, whereas the second column shows data.
Check if the provided extracted file format is correct or not. This can be done by following steps.
- Open the file
- Check if each column and its associated data have correct size.
- If the format is not correct then correct it and reanalyze the job
As for example, the size of the columns is not correct in "CAST.DB2.SYSDTYP" as shown below:
8 8 SYSIBM
8 BLOB 8 SYSIBM
8 CHAR 8 SYSIBM
8 CLOB 8 SYSIBM
8 DATE 8 SYSIBM
Here the first column had only digit 8 when it should be 18, because the next column showing the size in digits starts from 30th column. which means first 11 character is for column showing size in digits and next 18 is for the actual data, which becomes 29(11+18) and hence next column showing size in digits start from 30th column.
The size for second column is also not correct, it should be 6 not 8.