DST change and DB2 Connect v8.2

Steve Whittaker

DST change and DB2 Connect v8.2
Anyone want to venture an opinion as to if this new Fixpak 14 for the
Daylight Savings Time fix would have to be applied to the DB2 Connect
product??

We're running DB2 Connect v8.2 Enterprise Edition on a couple Linux
servers and we're running DB2 Connect Admin Client v8.2 on a whole lot
of desktops.

I can't get a definitive answer from IBM as to whether this DST fixpak
really impacts DB2 Connect since we are just passing SQL through from
the desktops to the EE server to DB2 on z/OS and then back again.

Anyone got any other thoughts on this? Or is this one of those 'your
better off just putting it on and being safe' type of fixes? :-)

Thanks:
--Steve....

Steve Whittaker
DB2/DBA @ Progress Energy, INC
Mail Drop: TPP 11-A4
Raleigh, NC
email: [login to unmask email]
Ph: 919-546-7267



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mark McCormack

DST change
(in response to Steve Whittaker)
The start and end dates for Daylight Savings Time in the U.S. and Canada
change in 2007. Fixes are required to a number of DB2 related products.
See the link and abstract shown below.

Steve Whittaker posted a question yesterday concerning DB2 Connect. My
question today concerns the <potentially ambiguous> reference to ' (DB2
UDB) '. Does that refer to DB2 only on LUW, or does it also involve DB2
on mainframes? (The specifics for us: z/OS 1.7 and DB2v8 NFM,
maintenance level approximately April, 2006). Does anyone have any
specifics to offer?

Mark

http://www-1.ibm.com/support/docview.wss?uid=swg21248542

Here is an extract

Abstract
In March 2007, the effective dates of Daylight Savings Time (DST) in the
U.S. and Canada will change. You must take action to address this issue
if you are using DB2(r) Version 9 for Linux(r), UNIX(r), and Windows(r),
DB2 Universal Database(tm) (DB2 UDB), DB2 Connect(tm), DB2 Query
Patroller, DB2 Control Center, and user-created Java(tm) applications.




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ray Williams

Re: DST change
(in response to Mark McCormack)
I don't have specifics but wanted to share another link. IBM has a
"master" link for all their products that indicates the impact of the
"new" daylight savings time on each product. There are different entry
points, for example by OS or by product etc. It is very handy, thanks
IBM.



http://www.ibm.com/support/alerts/daylightsavingstimealert.html







Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McCormack, Mark A
Sent: Thursday, January 04, 2007 9:43 AM
To: [login to unmask email]
Subject: [DB2-L] DST change



The start and end dates for Daylight Savings Time in the U.S. and Canada
change in 2007. Fixes are required to a number of DB2 related products.
See the link and abstract shown below.

Steve Whittaker posted a question yesterday concerning DB2 Connect. My
question today concerns the <potentially ambiguous> reference to ' (DB2
UDB) '. Does that refer to DB2 only on LUW, or does it also involve DB2
on mainframes? (The specifics for us: z/OS 1.7 and DB2v8 NFM,
maintenance level approximately April, 2006). Does anyone have any
specifics to offer?

Mark

http://www-1.ibm.com/support/docview.wss?uid=swg21248542
< http://www-1.ibm.com/support/docview.wss?uid=swg21248542 >

Here is an extract

Abstract
In March 2007, the effective dates of Daylight Savings Time (DST) in the
U.S. and Canada will change. You must take action to address this issue
if you are using DB2(r) Version 9 for Linux(r), UNIX(r), and Windows(r),
DB2 Universal Database(tm) (DB2 UDB), DB2 Connect(tm), DB2 Query
Patroller, DB2 Control Center, and user-created Java(tm) applications.



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cathy Taddei

Re: DST change
(in response to Ray Williams)
I followed that link and found this:

DB2(r) for z/OS(r) itself is not expected to be affected by this change.
However, in order to ensure that date information stored by DB2 is
recorded correctly, we recommend that you take two actions, as
applicable to your environment:

1. Using z/OS features, set your system clock to UTC, with an
appropriate offset for your time zone. At transitions to and from
daylight savings time, you only need to change the offset, not the
system clock.
2. If you use Java with DB2 for z/OS, ensure that you have applied a
daylight savings time fix to your SDK. Details on Java versions and
latest service can be found at:
http://www.ibm.com/servers/eserver/zseries/software/java/

I think the operative words here are "not...affected by this change".
Which makes sense, because DST changes were always a manual thing on the
mainframe. However, I have written some date conversion routines that
will be affected, as I suspect many shops have.

Cathy
________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Williams, Ray [WHQKO]
Sent: Thursday, January 04, 2007 7:54 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DST change



I don't have specifics but wanted to share another link. IBM has a
"master" link for all their products that indicates the impact of the
"new" daylight savings time on each product. There are different entry
points, for example by OS or by product etc. It is very handy, thanks
IBM.



http://www.ibm.com/support/alerts/daylightsavingstimealert.html







Ray Williams
DBA - WHQKO
United Airlines
(847) 700-4359

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of McCormack, Mark A
Sent: Thursday, January 04, 2007 9:43 AM
To: [login to unmask email]
Subject: [DB2-L] DST change



The start and end dates for Daylight Savings Time in the U.S. and Canada
change in 2007. Fixes are required to a number of DB2 related products.
See the link and abstract shown below.

Steve Whittaker posted a question yesterday concerning DB2 Connect. My
question today concerns the <potentially ambiguous> reference to ' (DB2
UDB) '. Does that refer to DB2 only on LUW, or does it also involve DB2
on mainframes? (The specifics for us: z/OS 1.7 and DB2v8 NFM,
maintenance level approximately April, 2006). Does anyone have any
specifics to offer?

Mark

http://www-1.ibm.com/support/docview.wss?uid=swg21248542
< http://www-1.ibm.com/support/docview.wss?uid=swg21248542 >

Here is an extract

Abstract
In March 2007, the effective dates of Daylight Savings Time (DST) in the
U.S. and Canada will change. You must take action to address this issue
if you are using DB2(r) Version 9 for Linux(r), UNIX(r), and Windows(r),
DB2 Universal Database(tm) (DB2 UDB), DB2 Connect(tm), DB2 Query
Patroller, DB2 Control Center, and user-created Java(tm) applications.


------------------------------------------------------------------------------

This email is confidential and may be legally privileged.

It is intended solely for the addressee. Access to this email by anyone else, unless expressly approved by the sender or an authorized addressee, is unauthorized.

If you are not the intended recipient, any disclosure, copying, distribution or any action omitted or taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender, delete this e-mail and destroy all copies.

======

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm