Fast Load abend - IEC146I 513-04

You are running Platinum Fast Load job and the job fails on you with an "IEC146I 513-04" error.

IEC146I 513-04 means
"An OPEN macro instruction was issued for a magnetic tape data set allocated to a device that already has an open data set on it. Make sure that the first data set is closed before the second is opened, or allocate the second data set to a different device. This error may be due to a
previous abnormal end associated with the same unit in the same step. If so, correct the error causing the previous abnormal end."

Problem:
As per the above message, you are trying open the dataset for two different purposes in the same job step.

In your LOAD card, see what you've specified for INDDN. In my case, I had specified INDDN SYSREC.

Fast Load user guide says "If you will be performing an OUTPUT-CONTROL ALL type load, and you want to specify INDDN SYSREC, you must also specify UNLDDN and change its default value. Otherwise, Unicenter Fast Load will try to use SYSREC as an input and a work file."

OUTPUT-CONTROL ALL is the default. I noticed that I didn't have a UNLDDN DD name in my JCL.

Fix:
Either specify a UNLDDN DD in your JCL step or change INDDN to something other than SYSREC. I changed it to SYSULD and it worked.

CA Intertest (Batch) Tips

If you use CA's Intertest for Batch to debug your batch COBOL programs or stored procedures, read on.

There are a few commands that you use frequently. Set them commands in PFKEYS for ease of use:

STEP 1 - Set steps to go in each run to 1 (I usually set it to PF4)
GO - Run as many steps as described in the STEP command (I usually set it to PF5)
RUN - Run until the next breakpoint (I usually set it to PF6)
KUP - Scroll Up in the Data Display Window (I usually set it to PF17)
KDOWN - Scroll Down in the Data Display Window (I usually set it to PF18)

Sample Job: CA/Platinum Fast Unload

Here is a sample job to run CA/Platinum Fast Unload utility:

Platinum Fast Load Error "PFL8013E"

If a Fast Load job fails with PFL8013E (Error Description: A table within Table Space that has multiple versioned rows is not supported for this release of Unicenter Fastload. Reason: This DB2 V8 feature is not yet supported by Unicenter Fast Load. Processing terminates), it could be because the tablespace is in AREO (Advisory Reorg pending) status. This happens in a DB2 V8 NFM subsystem, with Fast Load (version r11.5) Resume NO REPLACE option specified.

How will you fix this? There are a few options that you can try:

1. Run REORG utility on the tablespace and retry loading.

2. If that doesn't work, drop and recreate the table and then load the table using Fast Load

3. If that doesn't work, try IBM LOAD. That should definitely work.