473,836 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.C325BB499F B1
AUTHID=[userid], REASON=00F30013

How can I tell what is causing the error?

Regards,
MVSGuy
Oct 15 '08 #1
3 13998
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.n etwrote:
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.C325BB499F B1
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.C325BB499F B1
AUTHID=[userid], REASON=00F30013

How can I tell what is causing the error?

Regards,
MVSGuy
Nov 12 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
5651
by: robert | last post by:
well, talk about timely. i'm tasked to implement a security feature, and would rather do so in the database than the application code. the application is generally Oracle, but sometimes DB2. Oracle has what it calls package DBMS_RLS, which implements application ignorant row level security. scanning this group yielded "you can't do that; use views". then i dug out DB2Mag qtr 1 2004, and there is MLS for v8/390. from this article,...
116
7603
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data and some who couldn't but that it wasn't important right now. And I said, 'sure, we can do that later'. So now I've developed an app without any thought to security and am trying to apply it afterwards. Doh!, doh! and triple doh!
4
7989
by: Ashish | last post by:
Hi Guys I am getting the following error while implementing authentication using WS-security. "Microsoft.Web.Services2.Security.SecurityFault: The security token could not be authenticated or authorized ---> System.Exception: WSE565: The password provided the SecurityTokenManager does not match the one on the incoming token. at Microsoft.Web.Services2.Security.Tokens.UsernameTokenManager.VerifyPlainText
0
1525
by: prithvi g via .NET 247 | last post by:
Hi I am a newbie to .NET remoting, I am trying to implementauthorization using SSPI example provided by Michael Barnett. Ihave included the required dll(Microsoft.Samples.Security.SSPI.dll andMicrosoft.Samples.Runtime.Remoting. Security in both my clientand server. I have have defined my config files as follows for client <?xml version="1.0" encoding="utf-8" ?> <configuration> <system.runtime.remoting> <application> <channels>...
1
3405
by: Earl Teigrob | last post by:
Background: When I create a ASP.NET control (User or custom), it often requires security to be set for certain functionality with the control. For example, a news release user control that is comprised of a DataGrid may have separate permissions for adding, deleting and updating a news item. Problem Up until now, I have been implementing security directly inside the control. I will test directly against the security model to see if...
7
1989
by: Magdelin | last post by:
Hi, My security team thinks allowing communication between the two IIS instances leads to severe security risks. Basically, we want to put our presentation tier on the perimeter network and the business tier inside the fire wall or internal network. The biz tier will be developed and deployed as web services on IIS. I know microsoft recommends this architecture but I am not able to convince my security team. They say IIS is vulnerable...
0
4361
by: Jay C. | last post by:
Jay 3 Jan. 11:38 Optionen anzeigen Newsgroups: microsoft.public.dotnet.framework.webservices.enhancements Von: "Jay" <p.brunm...@nusurf.at> - Nachrichten dieses Autors suchen Datum: 3 Jan 2006 02:38:30 -0800 Lokal: Di 3 Jan. 2006 11:38 Betreff: Referenced security token could not be retrieved Antworten | Antwort an Autor | Weiterleiten | Drucken | Einzelne Nachricht | Original anzeigen | Entfernen | Missbrauch melden
3
2257
by: Velvet | last post by:
I ran FxCop on one of the components for my web site and the security rules what me to add " tags like the ones listed below: This breaks my ASP.NET application. So my question is, what should these
1
1922
by: Jeremy S. | last post by:
..NET's code Access Security enables administrators to restrict the types of things that a .NET application can do on a local computer. For example, a ..NET Windows Forms application can be prevented from writing to the Registry or writing a file to the local disk. My question: Is this feature unique to .NET? Or is it just as easy for enterprise network administrators to prevent COM applications from writing to the Registry and doing...
2
2422
by: Budhi Saputra Prasetya | last post by:
Hi, I managed to create a Windows Form Control and put it on my ASP .NET page. I have done the suggestion that is provided by modifying the security settings. From the stack trace, I would assume that the code throws exception when it is trying to retrieve the processes list that has certain name. Below is the code that I use to retrieve the processes. Process processes = Process.GetProcessesByName("xxxx");
0
9816
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
9668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10840
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10254
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7790
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6978
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5823
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4448
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4013
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.