Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Information About the Equifax Securit... Rohit Umarjikar PC Guides & IT News 6 Mon Sep 11, 2017 9:10 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us