Fast Load fails with: PFL1105E - VARCHAR unload from Source Load to Target.

book

Article ID: 4373

calendar_today

Updated On:

Products

CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Running Fast Unload from the Source object and Loading the Target with the unload file, it fails with: PFL1105E - VARCHAR  input col xxx exceeds DB2 catalog maximum length  

Cause

The Source DDL mismatch to the Target.  

Environment

DB2 V10 NFM Release R17.

Resolution

Drop and recreate the Target object to match the Source object.