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 RDz Json restful service Kevin Vaz IBM Tools 4 Thu Jun 29, 2017 10:44 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am


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