JR49562: NNSTAT MAY FAIL WITH SQL0181N/SQL0180N ERROR WITH METHOD 0 OR 1

DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• 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.
  

Local fix

• Use NNSTAT with method 2.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The users are running NNSTAT with method 0 or 1.             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 for LUW V9.7FP10 or higher level.             *
  ****************************************************************
  

Problem conclusion

• The problem is firstly fixed on V9.7FP10.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  JR49622 JR49623 JR49624 IT00237

Fix information

• Fixed component name

  FEDERATION SERV

• Fixed component ID

  5724N9700

Applicable component levels

• R970 PSY

     UP