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 IT04555 Status: Closed

SQLUDCONVERTTIMESTAMPTOSQLOTIME ERROR MESSAGE WHILE DOING ONLINE BACKUP

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
SQLUDCONVERTTIMESTAMPTOSQLOTIME ERROR MESSAGE WHILE DOING ONLINE 
BACKUP 
 
Error message in db2diag.log 
============================== 
 
2014-09-16-01.54.35.506270-240 E49989A456         LEVEL: Error 
PID     : 5324                 TID  : 2862        PROC : db2sysc 
0 
INSTANCE: db2lr1               NODE : 000         DB   : LR1 
APPHDL  : 0-2876               APPID: *LOCAL.db2lr1.140916054026 
AUTHID  : LR1ADM 
EDUID   : 2862                 EDUNAME: db2agent (LR1) 0 
FUNCTION: DB2 UDB, database utilities, 
sqludConvertTimestampToSqlotime, probe:228 
DATA #1 : String, 14 bytes 
00000101000000 
 
2014-09-16-01.54.35.672173-240 E50446A417         LEVEL: Info 
PID     : 5324                 TID  : 2862        PROC : db2sysc 
0 
INSTANCE: db2lr1               NODE : 000         DB   : LR1 
APPHDL  : 0-2876               APPID: *LOCAL.db2lr1.140916054026 
AUTHID  : LR1ADM 
EDUID   : 2862                 EDUNAME: db2agent (LR1) 0 
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:904 
MESSAGE : Backup complete. 
 
 
IBM DB2 uses the timestamp 00000101000000 as a representation of 
the beginning of time, for some database operations. 
When trying to convert this to a system timestamp we will error 
as it is none representable. 
The error message is just informational.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* UPGRADE TO DB2 V9.7FP11                                      * 
****************************************************************
Local Fix:
NA
Solution
FIRST FIXED IN DB2 V9.7FP11
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.09.2014
12.08.2015
12.08.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList