Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Local Security Service non-retryable error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pankaj_kulkarni111

New User


Joined: 17 Aug 2006
Posts: 13
Location: Pune

PostPosted: Tue Nov 18, 2008 3:21 am    Post subject: DB2 Local Security Service non-retryable error
Reply with quote

I'm getting the below error when I run the job

Error:
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Local Security Service non-retryable error.|

I think this is because of my TSO id doesn’t have permission to connect the DB2 through ODBC.
Kindly suggest from where I can get the external query execute permission for my TSO/DB2 id?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 18, 2008 3:55 am    Post subject:
Reply with quote

Hello,

Suggest you talk with your dba and your security admins.
Back to top
View user's profile Send private message
pankaj_kulkarni111

New User


Joined: 17 Aug 2006
Posts: 13
Location: Pune

PostPosted: Sat Dec 13, 2008 10:15 pm    Post subject: Reply to: DB2 Local Security Service non-retryable error
Reply with quote

Solution for this:

Whenever any user tries to connect to DB2 via external DBMS like Oracle, Datastage or any other, then if he does not have permission for an external query execute, he won't be able to execute the programs.

The user needs a REMOTE access for that DB2 environment i.e. remote access for DB2V, DB2T etc). This is done by the Security administrators. They need to grant the access to DB2 files.

Which DB2 files? - I'll post on Tuesday. I donn know as of npw
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Dec 14, 2008 12:41 am    Post subject: Reply to: DB2 Local Security Service non-retryable error
Reply with quote

Good to hear you have a solution - thanks for letting us know icon_smile.gif

Your explanation will help someone else in the future icon_wink.gif

d
Back to top
View user's profile Send private message
pankaj_kulkarni111

New User


Joined: 17 Aug 2006
Posts: 13
Location: Pune

PostPosted: Wed Dec 17, 2008 1:20 am    Post subject: Reply to: DB2 Local Security Service non-retryable error
Reply with quote

If say user using the DB2V system on DB2 then he needs access for

DSNR profiles DB2V.BATCH
AND
DB2V.DIST

I'm specifically interested in posting this because I struggled along with my security admin for 2 days to get this worked!

Njoy
Pankaj
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts SDSF and SAF security danik56 TSO/ISPF 3 Wed Mar 15, 2017 12:51 pm
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am
No new posts Row not found Sql error GaganGarg DB2 7 Tue Mar 07, 2017 6:29 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us