Sunday, November 2, 2008

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.

No comments: