Restore library error

[Former Member]

As part of a system copy to a new machine I am trying to restore the R3<SID>DATA library. 32169 objects restored but 67 did not. The first error message I find is CPD3231 Data conversion error on default value for field CUOBJ. IBM did not have a ready answer and they are still working on it. Has anyone run into something like this before? The CCSID of the target and source system is set to 500.

Thanks for your help.

Alan Novick

[Former Member]

During System copy, any of us can have same issue. Can you please share the SQL statement or the steps that one needs to perform to correct such errors?

[Former Member]

Sai,

You make a good point. I thought my problem was strange and rare but it is possible that others may run into the same problem or something similar. The problem was that field CUOBJ in file MARC was initialized with 17 zeros and it should have been initialized with 18 zeros. This occurred in production but not in development or QA. We are on 4.6C currently and ASCII, which is apparently implemented in Unicode. To correct the problem I ran the statement below using the SQL facility of iSeries navigator. I had not used this facility before, it was almost worth having the problem to get to know this great tool.

UPDATE R3PRDDATA.MARC

SET CUOBJ =

UX'003000300030003000300030003000300030003000300030003000300030003000300030'

WHERE HEX(CUOBJ) LIKE '%300000000033%'

[Former Member]

There was an invalid default value for one of the fields in MARC. IBM gave me an SQL statement to correct it. All 67 objects that did not restore were related to MARC. Once the field default was set properly everything restored.