DB2 FOR LUW / DB2FORLUW / A10 - DB2

Even though there are locks held on a table the MON_GET_LOCKS 
table function shows no rows when queried using table_schema and 
table_name. 
 
To reproduce 
 
- db2 "create table test.test (a char(3))" 
- db2 +c "insert into test.test values('111')" 
- db2 +c "select * from sysibmadm.locks_held where tabschema = 
'TEST' and tabname = 'TEST' " 
==> 2 locks 
- db2 +c "select * from table 
(MON_GET_LOCKS(CLOB('<table_schema>TEST</table_schema><table_nam 
e>TEST</table_name>'),-1)) AS T " 
==> none 
 
The issue does not occur on Windows.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 and Fix Pack 2                   * 
****************************************************************

The following query will show the locks (Substitute schema and 
table name appropriately) 
db2 +c "select * from table(MON_GET_LOCKS(CLOB(''),-2)) where 
tab_file_id = (select tableid from syscat.tables where 
tabname='TEST' and tabschema='TEST')"

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 Version 10.1 and Fix Pack 2

keiner bekannt / siehe Local-Fix

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

04.11.2012
17.12.2012
17.12.2012