Unanswered: db2 needs to be restarted with change in timezone ??
I have a db2 8.1 server on AIX 5.3. Initially, I had the timezone of CDT on my aix server, later I had changed to IST. Now, my question is do we have restart the db2 database to get reflected with new timezone ???
No, prev we havnt restartd the DB or server or app running on it. But, we were able to see new date on the AIX server, but wasnt reflecting the change when users connect thru toad or any other application to DB. Here we just want to be 100% sure that aix server needs to restartd or DB or both ??