DB2 FOR LUW / DB2FORLUW / 970 - DB2

SQL0901N could be raised for inserting into a table with a 
trigger which is calling MQ UDF.  This may occur after adding a 
column 
to the subject table.  The problem may also happen if 
the trigger is calling other UDF that can not process 
expressions as input parameter. 
 
1. create a trigger on table, calling MQ wrapper function 
MQSEND. 
 
CREATE OR REPLACE TRIGGER FFFFFFFFF 
    AFTER INSERT ON TTTTTTT 
    REFERENCING? NEW_TABLE AS NEWT 
    FOR EACH STATEMENT 
BEGIN ATOMIC SELECT DB2MQ1C.MQSEND (DIGITS (NEWT.C1) CONCAT 
':ADD') FROM NEWT ; -- 
END; 
 
2. Conduct an insert, which would fire the trigger, intially 
this will not cause error 
 
INSERT INTO TTTTTTT(C1) VALUES (987654322); 
 
 
3. Alter table by adding columns 
 
ALTER TABLE TTTTTTT ADD COLUMN C2 CHARACTER(20) NOT NULL DEFAULT 
' ' 
 
 
4. The table-alter operation could cause incorrect internal 
format of the query and trigger to be changed, which in turn 
causes the query to hit the limitation of DB2MQ1C.MQSEND that 
can not process expressions as input parameter 
 
INSERT INTO TTTTTTT(C1) VALUES (987654322) 
 
DB21034E? The command was processed as a SQL statement because 
it was not a valid Command Line Processor command.? During SQL 
processing it returned: 
SQL0901N? The SQL statement failed because of a non-severe 
system error. Subsequent SQL statements can be processed.? 
(Reason "Internal error: invalid request@MQ_UnfencedServer 
::get_value".)  SQLSTATE=58004

**************************************************************** 
* USERS AFFECTED:                                              * 
* The user is running MQ UDF.                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97FP9.                                       * 
****************************************************************

Recreate the trigger can bypass the error.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

The problem is firstly fixed on DB2  V97FP9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC89970 IC96486 IC96707 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

25.01.2013
16.12.2013
16.12.2013

9.7.FP9