DB2 Question

Carol Srna

DB2 Question
Hello. I have set up RRS and WLM for DB2 Stored Procedures.



The DBAs are testing Business Object/Stored Procedure Builder using DB2
Connect. All of the pieces work fine when testing on SYSC, which is a
Monoplex.



When they test on SYSB, which is in a Sysplex with SYSA, they cannot
connect.

I am OS/390 2.10 and DB2 v7. They receive DB2 -908 error.



Thanks for any advice, suggestions, comments...





John H. Maenpaa Jr.

Re: DB2 Question
(in response to Carol Srna)
SQL0908N "<bind-type>" error using "<auth-id>" authority BIND,
REBIND, or AUTO_REBIND operation is not allowed.

Sounds like the DB2 Connect and Stored Procedure Builder packages weren't
bound on the new DB2 subsystem.

The
On Tuesday 07 January 2003 09:26 am, Carol Srna wrote:
> Hello. I have set up RRS and WLM for DB2 Stored Procedures.
>
>
>
> The DBAs are testing Business Object/Stored Procedure Builder using DB2
> Connect. All of the pieces work fine when testing on SYSC, which is a
> Monoplex.
>
> When they test on SYSB, which is in a Sysplex with SYSA, they cannot
> connect.
>
> I am OS/390 2.10 and DB2 v7. They receive DB2 -908 error.
>
> Thanks for any advice, suggestions, comments...

--
John Maenpaa
Yevich, Lawson and Associates
www.ylassoc.com



Myron Miller

Re: DB2 Question
(in response to John H. Maenpaa Jr.)

First thing I'd check is to see if all of the DB2 connect packages have been correctly bound on SYSB (SYSA).

Myron
Carol Srna <[login to unmask email]> wrote:
Hello. I have set up RRS and WLM for DB2 Stored Procedures.



The DBAs are testing Business Object/Stored Procedure Builder using DB2 Connect. All of the pieces work fine when testing on SYSC, which is a Monoplex.



When they test on SYSB, which is in a Sysplex with SYSA, they cannot connect.

I am OS/390 2.10 and DB2 v7. They receive DB2 -908 error.



Thanks for any advice, suggestions, comments...







---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now