469,306 Members | 1,590 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,306 developers. It's quick & easy.

DDF Security?

I'm getting a security error when accessing DB2 9.1 from DB2 connect
-
db2 =connect to [mainframe] user [userid] USING [password]
SQL30082N Security processing failed with reason "15" ("PROCESSING
FAILURE") SQLSTATE=08001
The mainframe spits out the following message -
DSNL030I -DB9G DSNLTSEC DDF PROCESSING FAILURE FOR 610
LUWID=GADC3343.FFFE.C325BB499FB1
AUTHID=[userid], REASON=00F30013

How can I tell what is causing the error?

Regards,
MVSGuy
Oct 15 '08 #1
3 13544
Hi
It's hard to say what's the problem ( no more M/F DB2 in my site),
but it looks like that user is not authorized to connect to DB2 .

Please have look DSNDBM1 and DDF syslog .

Is the user_id DDF RACF user id or enduser id ?

There's good DB2 list server mainly focus on M/F ,
http://www.idugdb2-l.org/cgi-bin/wa?A0=DB2-L

On Oct 16, 3:25�am, mvsguy <kkin...@fuse.netwrote:
I'm getting a security error when accessing DB2 9.1 from DB2 connect
-
db2 =connect to [mainframe] user [userid] USING [password]
SQL30082N �Security processing failed with reason "15" ("PROCESSING
FAILURE") SQLSTATE=08001
The mainframe spits out the following message -
DSNL030I �-DB9G DSNLTSEC DDF PROCESSING FAILURE FOR 610
LUWID=GADC3343.FFFE.C325BB499FB1
AUTHID=[userid], REASON=00F30013

How can I tell what is causing the error?

Regards,
MVSGuy
Oct 15 '08 #2
Please have look DSNDBM1 *and DDF syslog .

There's nothing in any of the started task message logs, sysout, or
the console log.
Is the user_id DDF RACF user id or enduser id ?
I have tried both, with the same result. I've confirmed the end user
id is SYSADM, which should have all the access possible.
There's good DB2 list server mainly focus *on M/F ,http://www.idugdb2-l..org/cgi-bin/wa?A0=DB2-L
Thank you, I wasn't aware of that one. I've posted my message there
too.

Thank you,
kk
Oct 16 '08 #3
You need to define a profile for the subsystem(s). For instance, my
subsystems are called TEK1 and TEK2. I would execute the following:
RDEFINE DSNR TEK*.* UACC(READ)
SETR RACLIST(DSNR) REFRESH

This is documented in the admin guide here:

http://publib.boulder.ibm.com/infoce...oc/db29lib.htm

Todd.
mvsguy wrote:
I'm getting a security error when accessing DB2 9.1 from DB2 connect
-
db2 =connect to [mainframe] user [userid] USING [password]
SQL30082N Security processing failed with reason "15" ("PROCESSING
FAILURE") SQLSTATE=08001
The mainframe spits out the following message -
DSNL030I -DB9G DSNLTSEC DDF PROCESSING FAILURE FOR 610
LUWID=GADC3343.FFFE.C325BB499FB1
AUTHID=[userid], REASON=00F30013

How can I tell what is causing the error?

Regards,
MVSGuy
Nov 12 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by robert | last post: by
116 posts views Thread by Mike MacSween | last post: by
4 posts views Thread by Ashish | last post: by
reply views Thread by prithvi g via .NET 247 | last post: by
7 posts views Thread by Magdelin | last post: by
3 posts views Thread by Velvet | last post: by
1 post views Thread by Jeremy S. | last post: by
2 posts views Thread by Budhi Saputra Prasetya | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.