DB2 FOR LUW / DB2FORLUW / A10 - DB2

Create Nickname statement can't accept a nickname as the remote 
object if the remote nickname's STATS_TIME attribute is invalid. 
 
The root cause of this issue is that the remote nickname's 
STATS_TIME attribute gets invalid when its remote table's CARD 
attribute is -1. 
 
For example, if there is a remote nickname "RNICK" with 
STATS_TIME attribute as below: 
 
db2 => select stats_time from syscat.tables where tabname = 
'RNICK' 
 
STATS_TIME 
-------------------------- 
0000-00-00-00.00.00.000000 
 
  1 record(s) selected. 
 
Then, we can't create a nickname on this nickname: 
 
db2 => create nickname LNICK for rserver.schema.rnick 
DB21034E The command was processed as an 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 "cannot 
convert stats 
timestamp value ".) SQLSTATE=58004 
 
The previous APAR JR35191 actually doesn't fix this issue 
completely.

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users trying to create a nickname base on a nickname.    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v10.1 fp4.                                        * 
****************************************************************

Run NNSTAT with method 2 to collect statistic data for the 
remote nickname, so STATS_TIME will be set to correct value.

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

The problem is firstly fixed on v10.1 fp4.

not known / see Local fix

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

08.10.2013
02.06.2014
02.06.2014