DB2 FOR LUW / DB2FORLUW / 970 - DB2

$ db2 "SELECT count(*) FROM 
TABLE(MON_GET_LOCKS(CLOB('<table_schema>SCHEMA</table_schema><ta 
ble_name>TABLE</table_name><lock_mode>IN:IS:IX</lock_mode>'),-1 
))" 
 
1 
----------- 
SQL0171N  The data type, length or value of the argument for the 
parameter in position "1" of routine "MON_GET_LOCKS" is 
incorrect. Parameter name:  "SEARCH_ARGS/TABLE_SCHEMA". 
SQLSTATE=42815 
 
You can create a reproduction if you add a clause to the query 
that has a colon in it, such as <lock_mode>.  If you put it 
before the <table_schema> clause the query will work, but it you 
put it after the query will fail.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 fix pack 10.                             * 
****************************************************************

N/A

First fixed in DB2 v9.7 fix pack 10.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.04.2014
29.01.2015
29.01.2015

9.7.FP10