Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ZDATE_LARGE_TIME_DIFF (After migrating DB2 8.2 / 9.5)

Hello,

AIX 6.1

After migrating DB2 8.2 / 9.5 and upgrade the kernel (640-374 (level)) in the SAP logon appears the dump:

ZDATE_LARGE_TIME_DIFF (Large Time Difference Between Application Server and Database).

The local clock may have been set incorrectly or the application server

and the database may be operating in different time zones. Check that

the times and time zones of the application server and database server

match. Then restart the system.

Local time in internal format................ 1303740690

Database time................................ 20110425151130

SAP Release.............. "620"

Character set............ "en_US.ISO8859-1"

The error probably occurred when installing the

R/3 system.

There is a considerable time difference between the local time of the

application server and that of the database, which prevents your SAP

System from operating correctly.

Time difference between DB and appl. server.. 3600 s

Local time zone.............................. "UTC+0 sec (GRNLNDST )"

Local time................................... "2011/04/25 14:11:30 "

UTC time..................................... "2011/04/25 14:11:30"

Local time in internal format................ 1303740690

Database time................................ 20110425151130

get the error corrected immediately.

Local time................................................ "2011/04/25 14:11:30

"

UTC time.................................................. "2011/04/25

14:11:30"

Local time in internal representation..................... 1303740690

Database time............................................. 20110425151130

I checked the date with the root users, db2 <sid> ,<sid> adm and are equal. I checked the environment variable TZ = GRNLNDST.

Bank and SAP have already stopped and left Stopped 01:00 pm. The error continues.

Any ideas?

Former Member
Not what you were looking for? View more on this topic or Ask a question