DB2 - Problembeschreibung
Problem IC77911 | Status: Geschlossen |
SET STATEMENT EXECUTED FROM WITHIN A STORED PROCEDURE MAY CAUSE DB2 ABEND | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
On DB2 version 950, Executing environment variable directly from within a stored procedure may cause instance trap. Stack trace (v950 FixPack 7) ======================= 0x00002AAAABBC6EFA sqlnq_pid 0x00002AAAACE346DC sqlnq_set_register 0x00002AAAABE0B1A4 sqlnp_parser Ox00002AAAABE08ADD sqlnp_mainP12sqlnq_strings 0x00002AAAABDCFA30 sqlnn_cmplP8sqeAgent 0x00002AAAABDCF1B5 sqlnn_cmplP8sqeAgent 0x00002AAAAC04F3ED sqlra_compile_var 0x00002AAAAC05705C sqlra_find_var 0x00002AAAAD5BF203 sqlri_ddl_get_section 0x00002AAAAD5BE90F sqlri_ddl_common 0x00002AAAAD5BE3D2 sqlriddl 0x00002AAAADE8C0AC sqlriSectInvoke 0x00002AAAAD45C0E6 sqlrr_execute_immediate 0x00002AAAAD44DC88 sqlrr_execimmd 0x00002AAAAC81CE73 sqljs_ddm_excsqlimm db2diag.log ============ PID : 10296 TID : 46912895969600PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-46896 APPID: 10.66.27.3.36280.110801122044 AUTHID : db2inst1 EDUID : 44778 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0 MESSAGE : RDS UCINTFC: pStatementText = DATA #1 : Hexdump, 647 bytes 0x00002AAB327B18A0 : 6372 6561 7465 2070 726F 6365 6475 7265 create procedure 0x00002AAB327B18B0 : 206F 706D 2E4F 504D 5F40 5938 4658 5954 opm.OPM_@Y8FXYT 0x00002AAB327B18C0 : 5F44 4C43 4B5F 4556 4D4F 4E5F 5741 5443 _DLCK_EVMON_WATC 0x00002AAB327B18D0 : 4844 4F47 2829 2062 6567 696E 2064 6563 HDOG() begin dec 0x00002AAB327B18E0 : 6C61 7265 2073 716C 7374 6D74 2076 6172 lare sqlstmt var 0x00002AAB327B18F0 : 6368 6172 2833 3030 293B 6465 636C 6172 char(300);declar 0x00002AAB327B1900 : 6520 6576 6D6F 6E30 5F65 7869 7374 7320 e evmon0_exists 0x00002AAB327B1910 : 696E 7465 6765 723B 6465 636C 6172 6520 integer;declare 0x00002AAB327B1920 : 7674 6162 7363 6865 6D61 3020 7661 7263 vtabschema0 varc 0x00002AAB327B1930 : 6861 7228 3130 3029 3B20 6465 636C 6172 har(100); declar 0x00002AAB327B1940 : 6520 7674 6162 6E61 6D65 3020 7661 7263 e vtabname0 varc 0x00002AAB327B1950 : 6861 7228 3130 3029 3B53 454C 4543 5420 har(100);SELECT 0x00002AAB327B1960 : 636F 756E 7428 3129 2069 6E74 6F20 6576 count(1) into ev 0x00002AAB327B1970 : 6D6F 6E30 5F65 7869 7374 7320 4652 4F4D mon0_exists FROM 0x00002AAB327B1980 : 2053 5953 4341 542E 4556 454E 544D 4F4E SYSCAT.EVENTMON 0x00002AAB327B1990 : 4954 4F52 5320 5748 4552 4520 5550 5045 ITORS WHERE UPPE 0x00002AAB327B19A0 : 5228 4556 4D4F 4E4E 414D 4529 203D 2027 R(EVMONNAME) = ' 0x00002AAB327B19B0 : 4F50 4D44 4059 3846 5859 5427 203B 5345 OPMD@Y8FXYT' ;SE 0x00002AAB327B19C0 : 4C45 4354 2054 4142 5343 4845 4D41 2C20 LECT TABSCHEMA, 0x00002AAB327B19D0 : 5441 424E 414D 4520 696E 746F 2076 7461 TABNAME into vta 0x00002AAB327B19E0 : 6273 6368 656D 6130 2C20 7674 6162 6E61 bschema0, vtabna 0x00002AAB327B19F0 : 6D65 3020 4652 4F4D 2053 5953 4341 542E me0 FROM SYSCAT. 0x00002AAB327B1A00 : 4556 454E 5454 4142 4C45 5320 5748 4552 EVENTTABLES WHER 0x00002AAB327B1A10 : 4520 4556 4D4F 4E4E 414D 4520 3D20 274F E EVMONNAME = 'O 0x00002AAB327B1A20 : 504D 4440 5938 4658 5954 2720 3B69 6620 PMD@Y8FXYT' ;if 0x00002AAB327B1A30 : 6576 6D6F 6E30 5F65 7869 7374 7320 3E20 evmon0_exists > 0x00002AAB327B1A40 : 3020 7468 656E 2073 6574 2065 7665 6E74 0 then set event 0x00002AAB327B1A50 : 206D 6F6E 6974 6F72 204F 504D 4440 5938 monitor OPMD@Y8 0x00002AAB327B1A60 : 4658 5954 2053 5441 5445 203D 2030 3B73 FXYT STATE = 0;s 0x00002AAB327B1A70 : 6574 2073 716C 7374 6D74 203D 2027 6472 et sqlstmt = 'dr 0x00002AAB327B1A80 : 6F70 2074 6162 6C65 2027 2063 6F6E 6361 op table ' conca 0x00002AAB327B1A90 : 7420 7674 6162 7363 6865 6D61 3020 636F t vtabschema0 co 0x00002AAB327B1AA0 : 6E63 6174 2027 2E27 2063 6F6E 6361 7420 ncat '.' concat 0x00002AAB327B1AB0 : 7674 6162 6E61 6D65 303B 6578 6563 7574 vtabname0;execut 0x00002AAB327B1AC0 : 6520 696D 6D65 6469 6174 6520 7371 6C73 e immediate sqls 0x00002AAB327B1AD0 : 746D 743B 7365 7420 7371 6C73 746D 7420 tmt;set sqlstmt 0x00002AAB327B1AE0 : 3D20 2744 524F 5020 4556 454E 5420 4D4F = 'DROP EVENT MO 0x00002AAB327B1AF0 : 4E49 544F 5220 4F50 4D44 4059 3846 5859 NITOR OPMD@Y8FXY 0x00002AAB327B1B00 : 5427 3B65 7865 6375 7465 2069 6D6D 6564 T';execute immed 0x00002AAB327B1B10 : 6961 7465 2073 716C 7374 6D74 3B65 6E64 iate sqlstmt;end 0x00002AAB327B1B20 : 2069 663B 656E 64 if;end | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * SET STATEMENT EXECUTED FROM WITHIN A STORED PROCEDURE MAY * * CAUSE * * DB2 ABEND * **************************************************************** * RECOMMENDATION: * * Upgrade to v9.5 Fixpack 9 * **************************************************************** | |
Local-Fix: | |
Set the variable indirectly by first assigning it to a string and then executing the string. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in v9.5 Fixpack 9 or higher | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC78003 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.08.2011 08.03.2012 08.03.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP9 | |
Problem behoben lt. FixList in der Version | |
9.5.0.9 |