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

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• 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