DB2 - Problem description
Problem IT20837 | Status: Closed |
DB2 MAY RETURN AN UNEXPECTED ERROR OR ABEND WHILE CASTING TO A UDT | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
DB2 may return an unexpected error: SQL0901N "Error in formatting CAST source type name" or abend while casting to a UDT. The stack will look like the following: sqloDumpEDU sqldDumpContextP9sqeBsuEduiiiiiPKcPvi sqlrr_dump_ffdcP8sqlrr_cbii sqlzeDumpFFDCP8sqeAgentjP5sqlcai sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitPc sqlnn_erdsiiiiiz sqlnq_semPP8stknode_i10actiontypePhP3loc sqlnp_smactnP8sqlnp_cbi sqlnp_parserP8sqlnp_cb sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_ cmpl_enviiPP9sqlnq_qur sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_ cmpl_env sqlrr_cmplP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModehP5sqldaPi PjPP9sqlri_shdP11compileInfo sqlra_recreate_pkgP8sqlrr_cbiicP15sqlra_func_pathh sqlra_rebind_pkgP8sqlrr_cbPhsS1_sS1_iicP15sqlra_func_path sqlrr_rebindP14db2UCinterfaceP12bind_options sqljs_ddm_rebindP14db2UCinterfaceP13sqljDDMObject sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCint erface sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T sqeAgent6RunEDUEv sqzEDUObj9EDUDriverEv sqloEDUEntry clone | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 9. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem was first fixed in DB2 UDB Version 10.5 FixPack 9. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.06.2017 19.07.2018 19.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |