| View previous topic :: View next topic |
| Author |
Message |
hari haran
Beginner
Joined: 22 Jun 2004
Posts: 10
Topics: 4
|
 Posted: Mon Dec 10, 2007 8:27 pm Post subject: Connectivity between mainframe and unix box |
 |
|
Hi,
We have a job at mainframe end that queries a DB2 table maintained in a Solaris Box. Recently the ID was deleted from the Unix Box which caused our jobs to fail. We recreated the ID in the Unix Box but the jobs are now failing with Authentication issues (-30082).
The entry in SYSIBM.IPNAMES at mainframe end has SECURITY_OUT value as 'A'. Hence I think the password is not supplied from mainframe end for authentication.
As the recreated ID in the unix box has a new password do we need to rebind the plan / packages at mainframe end. Pls advice.
Thanks,
Hari Haran. S |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12394
Topics: 75
Location: San Jose
|
| Posted: Wed Dec 12, 2007 11:50 am Post subject: |
|
|
hari haran,
What is the reason-code and reason-string with sqlcode of -30082. The reason code and reason string should tell you as to what exactly is the problem.
Also remember that whenever an ID is deleted , the ID privileges are also Dropped. So when you recreate the ID , make sure that you also have the DBA/Sys admin to grant the privileges once again.
Hope this helps...
Cheers
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
