home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC68536 Status: Closed

EVMON_FORMAT_UE_TO_TABLES() RECEIVING "SQL0818N A TIMESTAMP
CONFLICT OCCURRED."

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Package xdb was modified between 9.7 FP0 and 9.7 FP1. The 
timestamp of the package was updated, and this requires the 
database to be rebound with the new package. However, the auto 
rebind logic was missing in the code. 
 
The above resulted in function EVMON_FORMAT_UE_TO_TABLES() 
receiving "SQL0818N A timestamp conflict occurred."
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All using a SPUTIL package on a database that was migratedto * 
* a more recent fixpak.                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* same as error description above                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* install version 9.7 FP3 or above.                            * 
****************************************************************
Local Fix:
bind the database manually with xdb.lst
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in version 9.7 FP3
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC68564 IC69725 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.05.2010
20.09.2010
20.09.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList