Migration Db2 v7.1 to v8

Michael Kaminski

Migration Db2 v7.1 to v8
We are currently planning our migration to Db2 v8 and we want to prepare
the applications area with any know issues or concerns that they should
be aware of in advance. Other than what I've found in the
Installation/Release manuals I was hoping someone might share their
experiences in this area.



Thanks,

Michael A. Kaminski
Trustmark Insurance
[login to unmask email]

P Please consider the environment before printing this e-mail





NOTICE: This e-mail message and all attachments transmitted with it may
contain confidential, sensitive, or protected information intended solely
for the use of the addressee. If the reader of this message is not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or its
attachments is strictly prohibited. If you have received this message in
error, please notify the sender immediately by telephone or by electronic
mail and delete this message and all copies and backups thereof. Thank
you.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Michael Kaminski

Re: Migration Db2 v7.1 to v8
(in response to Michael Kaminski)
Has anyone encountered any problems in a SELECT statement when a host
variable is smaller than the actual data and may require application
changes?


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Kaminski, Michael
Sent: Wednesday, January 07, 2009 6:19 AM
To: [login to unmask email]
Subject: [DB2-L] Migration Db2 v7.1 to v8


We are currently planning our migration to Db2 v8 and we want to prepare
the applications area with any know issues or concerns that they should
be aware of in advance. Other than what I've found in the
Installation/Release manuals I was hoping someone might share their
experiences in this area.



Thanks,

Michael A. Kaminski
Trustmark Insurance
[login to unmask email]

P Please consider the environment before printing this e-mail




NOTICE: This e-mail message and all attachments transmitted with it may
contain confidential, sensitive, or protected information intended
solely
for the use of the addressee. If the reader of this message is not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or
its
attachments is strictly prohibited. If you have received this message
in
error, please notify the sender immediately by telephone or by
electronic
mail and delete this message and all copies and backups thereof. Thank
you.





________________________________



IDUG 2009 - North America * May 11-15 * Denver, Colorado, USA
< http://idug.org/lsna >




IDUG.org < http://www.idug.org > was recently updated requiring members
to use a new password. You should have gotten an e-mail with the
temporary password assigned to your account. Please log in and update
your member profile. If you are not already an IDUG.org member, please
register here. < http://www.idug.org/component/juser/register.html >



NOTICE: This e-mail message and all attachments transmitted with it may
contain confidential, sensitive, or protected information intended solely
for the use of the addressee. If the reader of this message is not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or its
attachments is strictly prohibited. If you have received this message in
error, please notify the sender immediately by telephone or by electronic
mail and delete this message and all copies and backups thereof. Thank
you.



______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Chris Bowen

Re: Migration Db2 v7.1 to v8
(in response to Michael Kaminski)
<SNIP>
On Wed, 7 Jan 2009 14:09:10 -0600, Kaminski, Michael
[login to unmask email]> wrote:

Has anyone encountered any problems in a SELECT statement when a host
variable is smaller than the actual data and may require application
changes?
<\SNIP>

Sort of. In our case the host variable was OK but the SQLDA SQLVAR
description defined it as too small and caused a -804 SQLCODE under DB2 V8
but not under previous DB2 releases.

We had the problem with a host variable used for a LIKE predicate against a
VARCHAR column. In some cases the data being used exceeded the actual
length of the column because escape characters were being added to handle
known ocurrances of '_' and/or '%' (wild card characters).

Our application is written in Assembler and builds its own SQLDAs. The
program that was working with the LIKE predicate set the associated SQLDA
SQLLEN entry to the maximum length of the original column.

Where the data was such that the predicate data expanded beyond the original
column length the storage pointed to by the SQLDA SQLDATA variable was set
up in VARCHAR format and had the correct length for the data present.

When the program ran under DB2 V7 (or at least the level of DB2 V7 we had to
hand) with data that caused this situation to occur it executed without
problems.

When the same scenario was encountered under DB2 V8 an SQL -804 occurred.
It appears that cross checking of the SQLVAR SQLLEN entry to the actual data
presented has been tightened - can't seriously argue with that.

The solution was to set the SQLLEN for the SQLDA entry to match the actual
data. We reminded ourselves that in this situation the SQLDA SQLVAR entry
is describing the host variable and that we must detach our thoughts from
the original column definition.

Luckily, or unluckily, situations where VARCHAR data is long enough and
contains enough wild card characters for this column / host variable length
paradox to occur are very infrequent.

All part of life's rich tapestry.
Chris Bowen
The usual disclaimers apply.



______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Richard Humphris

Re: Migration Db2 v7.1 to v8
(in response to Chris Bowen)
Hi Michael,

We ran into a application using a server with an old version of
Websphere Application Server release 4 (and JRE 1.3) and found the
application failed to work with DB2 V8. The problem was the SQL being
generated used an invalid date format according to DB2 V8 (that was
previously acceptable on DB2 V7). Later versions of WAS would have
worked, but because the application let locking default it was ok on WAS
4 (default row level locking) but bad on later WAS releases (default
table level locking).

So we had to backoff v8 until application re-writes their code to
migrate it to a newer version of WAS.

Thanks,
Rich Humphris


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Kaminski, Michael
Sent: Wednesday, January 07, 2009 6:19 AM
To: [login to unmask email]
Subject: [DB2-L] Migration Db2 v7.1 to v8


We are currently planning our migration to Db2 v8 and we want to
prepare the applications area with any know issues or concerns that they
should be aware of in advance. Other than what I've found in the
Installation/Release manuals I was hoping someone might share their
experiences in this area.



Thanks,

Michael A. Kaminski
Trustmark Insurance
[login to unmask email]


P Please consider the environment before printing this e-mail




NOTICE: This e-mail message and all attachments transmitted
with it may
contain confidential, sensitive, or protected information
intended solely
for the use of the addressee. If the reader of this message is
not the
intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this
message or its
attachments is strictly prohibited. If you have received this
message in
error, please notify the sender immediately by telephone or by
electronic
mail and delete this message and all copies and backups thereof.
Thank
you.





________________________________



IDUG 2009 - North America * May 11-15 * Denver, Colorado,
USA < http://idug.org/lsna >




IDUG.org < http://www.idug.org > was recently updated requiring
members to use a new password. You should have gotten an e-mail with
the temporary password assigned to your account. Please log in and
update your member profile. If you are not already an IDUG.org member,
please register here.
< http://www.idug.org/component/juser/register.html >



E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the
addressee(s) and may contain confidential and/or legally privileged information. If you are not the
intended recipient of this message or if this message has been addressed to you in error, please
immediately alert the sender by reply e-mail and then delete this message and any attachments. If you
are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or
storage of this message or any attachment is strictly prohibited.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html