DB2 Package Bind : Failing with SQLCODE -551

Santoshkumar Sala · New User Joined: 18 Jul 2010 Posts: 12 Location: Mumbai

Hi Team,
Please help me for below issue.

Details:
1) My RACF ID has access to 2 RACF Groups : 1) G10 2) G20

Table 1 has access to G10
Table 2 has access to G20

I am using both the tables in my Program. While binding my Package I get SQL CODE -551.

If the OWNER(G10) is provided in the Package then Table 2 is failing with SQLCODE -551.
If the OWNER (G20) is provided in the Package then Table 1 is failing with SQLCODE -551.

Is there any way to provide multiple OWNER's while binding the package.

Thanks in advance.

rajesh1183 · New User Joined: 07 Jan 2008 Posts: 98 Location: Hyderabad

try creating Synonym as G10.Table2 for the table G20.Table2. And create your package with owner = G10

Santoshkumar Sala · New User Joined: 18 Jul 2010 Posts: 12 Location: Mumbai

Hi Rajesh,
Thanks for the info.