Strange -805 after V7/V8 migration

Meir Zohar

Strange -805 after V7/V8 migration
Happy holidays all...

Just in time for change freeze and right after migrating from v7 to v8 we're
seeing a strange DB2 behavior change that perhaps some of you have seen as
well.

Site is running a small distributed application.

ProgA accesses DB2A and calls ProgB that accesses DB2B.

ProgB has a bound package on DB2B which is also bound as remote using PKLIST
on the ProgA plan (DB2B.collid.package-id).

Communications DB appears to be correct and three part names access DB2B
from DB2A with no issues.

Contokens ,versions etc appear to be in order ..

When running ProgA (PlanA) , we get a -805 , 02 on DB2A..package-id.contoken
from the call from ProgB.

Allegedly this worked fine on v7, and for some reason we no longer locate
the remote package as DB2 appears to override all LOCATIONS in SYSPACKLIST
with the CURRENTSERVER value ...

Any ideas?

Pleasant holidays ...



Meir Zohar
CISSP, IBM Certified DBA for DB2 for z/OS V8/V9

Tel: +972 3 5747860
Fax: +972 3 5747864
Mob: +972 54 5747350
email: [login to unmask email]


______________________________________________________________________

* 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

Fred Edgar

Re: Strange -805 after V7/V8 migration
(in response to Meir Zohar)
I think you'll need to bind one of the packages on both DB2's, probably ProgB in your
case. You might need to specify SQLERROR CONTINUE on DB2A to get it to bind
"successfully". This has been a pain for us. We've resolved it by having a program in
the middle that is bound to all DB2's. We call it and it does the connect to the appropriate
DB2 before calling what would be your ProgB. Hope that helps. V7 and before made
more sense to me.

Fred




Meir Zohar <[login to unmask email]> wrote:
Happy holidays all...

Just in time for change freeze and right after migrating from v7 to v8 we're
seeing a strange DB2 behavior change that perhaps some of you have seen as
well.

Site is running a small distributed application.

ProgA accesses DB2A and calls ProgB that accesses DB2B.

ProgB has a bound package on DB2B which is also bound as remote using PKLIST
on the ProgA plan (DB2B.collid.package-id).

Communications DB appears to be correct and three part names access DB2B
from DB2A with no issues.

Contokens ,versions etc appear to be in order ..

When running ProgA (PlanA) , we get a -805 , 02 on DB2A..package-id.contoken
from the call from ProgB.

Allegedly this worked fine on v7, and for some reason we no longer locate
the remote package as DB2 appears to override all LOCATIONS in SYSPACKLIST
with the CURRENTSERVER value ...

Any ideas?

Pleasant holidays ...



Meir Zohar
CISSP, IBM Certified DBA for DB2 for z/OS V8/V9

Tel: +972 3 5747860
Fax: +972 3 5747864
Mob: +972 54 5747350
email: [login to unmask email]


______________________________________________________________________

* 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



______________________________________________________________________

* 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

James Campbell

Re: Strange -805 after V7/V8 migration
(in response to Fred Edgar)
One of the features of DB2 pre-V8 was that a program did not need to be bound locally if it
only used a EXEC SQL CONNECT locally (or a restricted set of other statements). In V8 it
does. Search the V8 documentation for PKGLDTOL - a V7 zparm that highlighted this
situation.

Bind ProgB on DB2A and make sure it is in the PKLIST.

James Campbell

On 24 Dec 2008 at 18:42, Meir Zohar wrote:

> Happy holidays all...
>
> Just in time for change freeze and right after migrating from v7 to v8 we're
> seeing a strange DB2 behavior change that perhaps some of you have seen as
> well.
>
> Site is running a small distributed application.
>
> ProgA accesses DB2A and calls ProgB that accesses DB2B.
>
> ProgB has a bound package on DB2B which is also bound as remote using PKLIST
> on the ProgA plan (DB2B.collid.package-id).
>
> Communications DB appears to be correct and three part names access DB2B
> from DB2A with no issues.
>
> Contokens ,versions etc appear to be in order ..
>
> When running ProgA (PlanA) , we get a -805 , 02 on DB2A..package-id.contoken
> from the call from ProgB.
>
> Allegedly this worked fine on v7, and for some reason we no longer locate
> the remote package as DB2 appears to override all LOCATIONS in SYSPACKLIST
> with the CURRENTSERVER value ...
>
> Any ideas?
>
> Pleasant holidays ...
>
>
>
> Meir Zohar


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * 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

Meir Zohar

Re: Strange -805 after V7/V8 migration
(in response to James Campbell)
Thanks James,

I've also seen that Willie Favero wrote a piece about this same zparm being
"the one that will ruin your v8 migration" about three years ago.

Happy holidays

Meir Zohar
CISSP, IBM Certified DBA for DB2 for z/OS V8/V9

Tel: +972 3 5747860
Fax: +972 3 5747864
Mob: +972 54 5747350
email: [login to unmask email]

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of James Campbell
Sent: Thursday, December 25, 2008 4:26 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Strange -805 after V7/V8 migration

One of the features of DB2 pre-V8 was that a program did not need to be
bound locally if it
only used a EXEC SQL CONNECT locally (or a restricted set of other
statements). In V8 it
does. Search the V8 documentation for PKGLDTOL - a V7 zparm that
highlighted this
situation.

Bind ProgB on DB2A and make sure it is in the PKLIST.

James Campbell

On 24 Dec 2008 at 18:42, Meir Zohar wrote:

> Happy holidays all...
>
> Just in time for change freeze and right after migrating from v7 to v8
we're
> seeing a strange DB2 behavior change that perhaps some of you have seen as
> well.
>
> Site is running a small distributed application.
>
> ProgA accesses DB2A and calls ProgB that accesses DB2B.
>
> ProgB has a bound package on DB2B which is also bound as remote using
PKLIST
> on the ProgA plan (DB2B.collid.package-id).
>
> Communications DB appears to be correct and three part names access DB2B
> from DB2A with no issues.
>
> Contokens ,versions etc appear to be in order ..
>
> When running ProgA (PlanA) , we get a -805 , 02 on
DB2A..package-id.contoken
> from the call from ProgB.
>
> Allegedly this worked fine on v7, and for some reason we no longer locate
> the remote package as DB2 appears to override all LOCATIONS in SYSPACKLIST
> with the CURRENTSERVER value ...
>
> Any ideas?
>
> Pleasant holidays ...
>
>
>
> Meir Zohar


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * 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

______________________________________________________________________

* 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