DB2 - Problembeschreibung
Problem IC73588 | Status: Geschlossen |
INSTANCE MAY ABEND DURING REVALIDATION OF VIEW THAT HAS AN UN-TYPED NULL AS AN OUTPUT COLUMN | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Revalidation of a VIEW that contains an un-typed NULL as an output column may abend the instance. Stack trace from such an abend may look something like: <various> sqlrlInsertColumn sqlrlrsc sqlrlcrv_sw sqlnq_view_mod_catalogs sqlnq_ddl_create_view_end sqlnn_regen_view sqlrl_regen_view sqlrl_regen_view sqlnq_check_referenced_qtb sqlnq_check_referenced_qtb sqlnq_handle_from_table_ref sqlnq_handle_from_table_ref sqlnq_sem sqlnp_parser sqlnp_parser sqlnp_main sqlnn_cmpl ... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * Revalidation of a VIEW that contains an un-typed NULL as an * * output column may abend the instance. * * * * Stack trace from such an abend may look something like: * * <various> * * sqlrlInsertColumn * * sqlrlrsc * * sqlrlcrv_sw * * sqlnq_view_mod_catalogs * * sqlnq_ddl_create_view_end * * sqlnn_regen_view * * sqlrl_regen_view * * sqlrl_regen_view * * sqlnq_check_referenced_qtb * * sqlnq_check_referenced_qtb * * sqlnq_handle_from_table_ref * * sqlnq_handle_from_table_ref * * sqlnq_sem * * sqlnp_parser * * sqlnp_parser * * sqlnp_main * * sqlnn_cmpl * * ... * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 4. * **************************************************************** | |
Local-Fix: | |
- Affected view(s) may be recreated explicitly, i.e., CREATE OR REPLACE VIEW ... - To avoid the issue for future revalidations, explicitly cast all the NULL column definitions, i.e., CREATE OR REPLACE VIEW ... CAST(null AS VARCHAR(1)) AS col_1, CAST(null AS VARCHAR(1)) AS col_2... Both workarounds will behave exactly semantically identically as the original view. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 4. | |
Workaround | |
- Affected view(s) may be recreated explicitly, i.e., CREATE OR REPLACE VIEW ... - To avoid the issue for future revalidations, explicitly cast all the NULL column definitions, i.e., CREATE OR REPLACE VIEW ... CAST(null AS VARCHAR(1)) AS col_1, CAST(null AS VARCHAR(1)) AS col_2... Both workarounds will behave exactly semantically identically as the original view. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 29.12.2010 05.05.2011 05.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |