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 -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

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