RMA231E altering a DATE column to TIMESTAMP using RC/Migrator
search cancel

RMA231E altering a DATE column to TIMESTAMP using RC/Migrator

book

Article ID: 99442

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

Executing an RC/Migrator for Db2 for z/OS (RCM) ALTER to modify a table to convert column OLDCOL, which is in DATE format (local), to a column NEWCOL,
which is Timestamp format, results in error message RMA231E message:

RMA231E ERROR OCCURED DURING GENERATION OF LOAD CONTROL CARDS FOR TABLE: 
`tbcreator.tbname 
OLD NAME colname , NEW colname

Cause

The problem is directly related to the DECP parameters DATE and DATELEN set to LOCAL and 10 respectively.
Batch Processor Unload does not support locally defined formats and this explains the RMA231E error that you are experiencing for this ALTER.

Resolution

The recommendation therefore is to use the IBM Unload utility instead of the Batch Processor Utility. IBM UNLOAD support was added in release r19 for RC/Update and RC/Migrator and can be activated through Model Services.  The solution for this problem is to use IBM UNLOAD/IBM LOAD combination.