On Apr 19, 11:48 am, annoir <ann...@gmail.com> wrote:
> I am trying to create a stored procedure using the DB2 Connect
> Development Center. I am able to create the project, connect to the
> remote database on the mainframe and create the stored procedure.
> However, when I build I get the following message:
>
> [IBM][CLI Driver][DB2] SQL0567N "I01" is not a valid authorization
> ID. SQLSTATE=42503
> I01.ED_MAINLINE_PERSON - Build failed.
>
> The options for the database connection are as follows:
>
> SQL ID = I01
> Package Owner = I01
> Build Owner = I01
>
> These are identical to what another programmer uses who can build
> stored procedures. We've checked the ACF permissions on the mainframe
> and I have the identical rights as the other programmers.
>
> We are stumped and it clearly appears to be some sort of access
> problem but we can't figure out what is missing.
>
> One of the programmers had me try and set the current SQL ID in the
> command editor and I was unable to. She thought this was significant
> but we don't know how to address this.
>
> Help!
>
> Ann Williams

Hi Ann,

In addition to what Ven said, you need to talk to your administrator
about setting up the Work
Load Manager environment. There is a good chapter in the redbook:
"DB2 for z/OS Stored Procedures,
Through the Call and Beyond", http://publib-b.boulder.ibm.com/abst...7083.html?Open.
that deals with setting up your mainframe for access by DB2
Development Center.

Marichu Scanlon
IBM