CA Fast Load returns message PFL8017E UNSUPPORTED OBJECT TYPE INPUT DATASET VBS loading table with XML column(s).

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

Executing CA Fast Load for DB2 for z/OS (PFL) loading a table with XML column(s) and receiving the following messages:

PFL0303I - Unsupported object type - XML Column Type - Processing passed to IBM due to UTIL PARMLIB

PFL8017E - Unsupported object type, IBM Utility Interface bypassed due to Input Dataset VBS format

The input file was created by CA Fast Unload for DB2 for z/OS (PFU) with OUTPUT-FORMAT VARIABLE which creates the unload file as RECFM VBS when the table is defined with XML column(s).

Environment

Release:
Component: PFL

Resolution

Verify that syntax FORMAT SPANNED YES is specified in the load control cards in the SYSIN DD as in the following example:

FASTLOAD
INDDN SYSULD
INPUT-FORMAT SEQ
FORMAT SPANNED YES
OUTPUT-CONTROL BUILD
RESUME NO REPLACE
STARTUP-ACCESS FORCE
SORT-CLINDX
INTO TABLE creator.tablename