Hi,

I have installed DB2 9.5, on AiX 6.1. System time and DB2 database time are not same. Anyone has any idea why do they differ?


System date is:
> date
Fri Apr 25 05:27:05 2008

> db2 create db test
DB20000I The CREATE DATABASE command completed successfully.
> db2 connect to test

Database Connection Information

Database server = DB2/AIX64 9.5.0
SQL authorization ID = DB295A64
Local database alias = TEST

> db2 "SELECT current time FROM sysibm.sysdummy1"

1
--------
01:27:11

1 record(s) selected.

Timezone in /etc/environment is set as TZ=GMT+5.30

Thanks,
Jui