DB2 FOR LUW / DB2FORLUW / 970 - DB2

With federated object and running SYSPROC.NNSTAT with the Method 
2 option, we can fail with SQL0206N. 
 
eg. 
$db2 "set passthru MS1" 
DB20000I  The SQL command completed successfully. 
 
$db2 "drop table dbo.DATA_TMP" 
DB20000I  The SQL command completed successfully. 
 
$db2 "CREATE TABLE dbo.DATA_TMP ( INJECTEDSECURITYID int 
NOT NULL, FIELDID            int          NOT NULL, VALDATE 
datetime     NULL, NUMVALUE           varchar(255) COLLATE 
SQL_Latin1_General_CP1_CI_AS NULL, REFVALUEID         int 
NULL, VALIDFROM          datetime     NULL, VALIDTO 
datetime     NULL, SECURITYID         int          NOT NULL, 
CONSTRAINT PK_data_TMP PRIMARY KEY CLUSTERED 
(INJECTEDSECURITYID,FIELDID,SECURITYID) WITH ( FILLFACTOR = 90 ) 
)" 
DB20000I  The SQL command completed successfully. 
 
$db2 "set passthru reset" 
DB20000I  The SQL command completed successfully. 
 
$db2 "drop nickname nt2" 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0204N  "IIDEV4.NT2" is an undefined name.  SQLSTATE=42704 
 
$db2 'CREATE NICKNAME "NICK_COMMON"."DATA_TMP" FOR 
"MS1"."dbo"."DATA_TMP"' 
DB20000I  The SQL command completed successfully. 
 
$db2 "CALL 
SYSPROC.NNSTAT('MS1','NICK_COMMON','DATA_TMP','FIELDID',NULL,2,N 
ULL,?)" 
SQL0206N  "NICK_COMMON" is not valid in the context where it is 
used.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgraed to v9.7 Fixpack 9 or Higher                          * 
****************************************************************

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
 

First Fixed in v9.7 Fixpack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95402 IC96283 
follow-up : 

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

31.05.2013
16.12.2013
16.12.2013

9.7.FP9