Strange Error while loading a file

[rick]

Hello,
I am getting a strange error when loading a file MP (AIX) CMOD 8.5.0.6, DB2 9.07.0004

APK440I ACIF AT IM43P11 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
arsload: 09/09/13 11:09:58 Indexing completed
arsload: 09/09/13 11:09:58 -- Loading started, 42082 bytes to process
OnDemand Load Id = >763-1-0-658FAA-15658-15948<
An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsadmp.c, Line=1669
Failed while attempting to load the database
Loaded 0 rows into the database
arsload: 09/09/13 11:10:05 Loading failed
arsload: Processing failed for file >/XX/XX/XX/XX/XXXXXXXXXXXXXXX.ARD<
arsload: 09/09/13 11:10:05 -- Unloading started
OnDemand UnLoad Successful - LoadId(763-1-0-658FAA-15658-15948) Rows Deleted(0)



Verifying the system log, I get the below message in the message no 13

DB Error: [IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be converted was replaced with a substitute character.  -- SQLSTATE=01517, SQLCODE=0, File=arsdoc.c, Line=4216


DB Error: Warning:  Unexpected SQL_SUCCESS_WITH_INFO -- SQLSTATE=Not Defined, SQLCODE=1, File=arsdoc.c, Line=4216


The code page used is EBCDIC 500 and there are no strange characters in indexes. Any insights on this error would be helpful

[Ed_Arnold]

Hmmm...do you have IgnoreWarnings=1 in the db2cli.ini?

Ed

[ewirtz]

Hi,

what is the codepage in the database? Might be you have charcters that are not defined in the database codepage

regards Egon

[rick]

DB2 uses 819. 

[Ed_Arnold]

Did this ever get resolved?

If so what was the resolution?

Thanks ----

Ed

[Justin Derrick]

This has happened to me once before -- I ended up converting the database to unicode, and making the AG fields bigger.  Thankfully, I noticed this during a major migration, so I was able to do this to the AG configuration while moving the database.

-JD.