DB2 FOR LUW / DB2FORLUW / A50 - DB2

After upgrade of the federated database, NNSTAT on DRDA 
nicknames may fail with SQL0181N "The string representation of a 
 datetime value is out of range"   or  SQL0180N: The syntax of 
the string representation of a datetime value is incorrect. 
 
The problem starts to happen on V97FP9, it is a regression of 
APAR JR47912. 
 
To reproduce: 
 
1.  On data source: 
CREATE TABLE DB2INST1.TT(C1 INT) 
RUNSTATS ON TABLE DB2INST1.TT ON ALL COLUMNS AND INDEXES ALL 
ALLOW WRITE ACCESS 
 
2.  On Federated server: 
 
create wrapper drda 
create server serv type DB2/UDB version 9.7 wrapper drda 
authorization "<userid>" password "<password"  options(dbname 
'<db name>') 
create user mapping for <user id> server serv 
options(remote_authid '<remote userid>', remote_password 
'<password>') 
create nickname db2inst1.nn for serv.db2inst1.tt 
 
 
=>  db2 "CALL 
NNSTAT('SERV','DB2INST1','NN','/tmp/stat.txt',?,?)" 
SQL20274W  Some of the nickname statistics cannot be updated. 
 
=> cat /tmp/stat.txt 
Start log... 
 
 
Processing nickname "NN". 
 
An attempt to create a nickname on table "DB2INST1 .NN_DB2II" 
failed. An error was returned when executing the CREATE NICKNAME 
statement. 
 
 Could not read the remote stats time properly 
nnstat.SQC, Line 4278 : SQL0180N  The syntax of the string 
representation of a datetime value is incorrect. 
 
With this fix, you may recreate nickname whose stats time might 
be some incorrect format.

**************************************************************** 
* USERS AFFECTED:                                              * 
* The users are running NNSTAT on DRDA nicknames after         * 
* upgrading the federated database.                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4 (also known as Fix    * 
* Pack 4) or higher.                                           * 
****************************************************************

Use NNSTAT with method 2.

Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)

not known / see Local fix

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

14.03.2014
15.09.2014
14.10.2014