home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT00237 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* 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.                                           * 
****************************************************************
Local-Fix:
Use NNSTAT with method 2.
Lösung
Fixed in DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4)
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.03.2014
15.09.2014
14.10.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList