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
Hmmm...do you have IgnoreWarnings=1 in the db2cli.ini?
Ed
Hi,
what is the codepage in the database? Might be you have charcters that are not defined in the database codepage
regards Egon
DB2 uses 819.
Did this ever get resolved?
If so what was the resolution?
Thanks ----
Ed
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.