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

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:

Quote:

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

Please have look DSNDBM1 *and DDF syslog .

There's nothing in any of the started task message logs, sysout, or
the console log.

Quote:

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.

Quote:

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

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:

Quote:

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

DDF Security?

re: DDF Security?

re: DDF Security?

re: DDF Security?

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about