When increasing table length, a LOAD with MISMATCH=IGNORE getting error DB13008E INPUT RECORD LENGTH nnn DOES NOT MATCH THE TABLE ttt RECORD LENGTH

book

Article ID: 8348

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

I changed the length of table AAA from 200 to 300.

When running a DBUTLTY LOAD with MISMATCH=IGNORE, I'm getting error:

DB13008E INPUT RECORD LENGTH 200 DOES NOT MATCH THE TABLE AAA RECORD LENGTH 300

 

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Resolution

The DBUTLTY LOAD function with MISMATCH=IGNORE is only valid for use with compressed records. 

When changing the table definition by adding fields, the correct way to reformat the record is to use the DDRMFLM dictionary utility.

 

Additional Information

See DDRMFLM - Converting Field Definitions in DocOps