Why do I receive messages PFU0174E and PFU0175E when unloading a DECIMAL (1,0) to CHAR (1) column using Fast Unload?

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

Why do I receive the following messages when using CA Fast Unload for DB2 for z/OS (PFU) on a column that was altered from DECIMAL(1,0) to CHAR(1):

PFU0174E - SELECT#01 REQUESTS AN UNSUPPORTED CONVERSION BETWEEN: 

PFU0175E - SEL#0001 COL: CRITICAL_NON_MON COLTYP:DECIMAL LEN:00001 , 
PFU0176E - INTO FLD:CRITICAL_NON_MON FLDTYP:CHAR ............. LEN 

 

 

 

 

 

 

Environment

Release:
Component: PFU

Resolution

A DECIMAL(1,0) takes 2 bytes of physical storage and requires a CHAR(2) to account for the sign.

If PFU is requested as part of a CA RC/Migrator for DB2 for z/OS (RCM) strategy, in this case it will automatically generate a CA BP Unload after the PFU messages because the conversion is not supported in PFU.