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

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

book

Article ID: 4373

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS 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  

Environment

DB2 V10 NFM Release R17.

Cause

The Source DDL mismatch to the Target.  

Resolution

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