A fix is available
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 number
JR49562
Reported component name
FEDERATION SERV
Reported component ID
5724N9700
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-03-09
Closed date
2014-11-10
Last modified date
2014-11-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
FEDERATION SERV
Fixed component ID
5724N9700
Applicable component levels
R970 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021