We unloaded data from the Prod server tables and are trying to load to the Pre Prod server in an application running on MVS on Mainframes. We are using Unload and load utilities . However we are getting the following error for DECIMAL and VARCHAR columns while loading data onto the Pre Prod server tables.
1. CONVERSION ERROR FOR GMDMVP1.HELP_TEXT
ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR'

2. RECORD (3) WILL BE DISCARDED DUE TO INVALID 'INVSTGN_OWNER_NM' COLUMN
SPECIFICATION FOR GMDMVP1.WEB_SECURITY

What we have seen is that Prod is having DB2 V8 whereas Pre Prod is having DB2 V9 .Could this version difference be a reason for this issue? Please advise.We are doing a data refresh urgently needed for the client for fron end server migration and appreciate your help on this.

The UNLOAD utility generates a load control statement ( SYSPUNCH DD ... ). Do you use that card or another ? If it's an other compare those cards for any difference.

Are the table definitions identical ( maybe 'INVSTGN_OWNER_NM' is nullable in Prod but is not in PreProd )

Do you use any definitions on the ProdServer which were introduced in Version 9 ( BIGINT e.g. )

Have a look at the discarded record. What is the content of the field 'INVSTGN_OWNER_NM' ?

GMDMVP1.HELP_TEXT could not be packed-decimal. It's following from name of the column.

Maybe you use the old "load control statement"

Lenny