473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL30082N, Reason 19


I'm having big problems with the Development Center right now - see other
thread - so I'm hand-coding a UDF. I've managed to get the UDF fully
prepared without any errors but now I'm getting a runtime error I don't
understand.

When I execute a query that tries to use my UDF, I get SQL30082N, Reason 19
("USERID DISABLED or RESTRICTED"). I don't understand why DB2 has a problem
with my ID; I'm sure that the Userid and Password are correct. Also, when I
look at the User and Group Objects for this database in the Control Center,
it acknowledges that the ID is fully authorized to execute the UDF in
question; in fact it has the EXECUTE privilege with the ability to GRANT it
to others. The ID also has all privileges on the database and on the table
that I'm querying with the UDF.

However, there is one confirmation for the SQL30082N:

2005-03-08-20.52.00.650000-300 I165519H257 LEVEL: Severe
PID : 1600 TID : 3068
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 44 bytes
check password failed with rc = -2146500483

Can anyone tell me what I need to do to make DB2 accept my ID?

--
Henry

Nov 12 '05 #1
8 12803
Henry Reardon wrote:
I'm having big problems with the Development Center right now - see other
thread - so I'm hand-coding a UDF. I've managed to get the UDF fully
prepared without any errors but now I'm getting a runtime error I don't
understand.

When I execute a query that tries to use my UDF, I get SQL30082N, Reason 19
("USERID DISABLED or RESTRICTED"). I don't understand why DB2 has a problem
with my ID; I'm sure that the Userid and Password are correct. Also, when I
look at the User and Group Objects for this database in the Control Center,
it acknowledges that the ID is fully authorized to execute the UDF in
question; in fact it has the EXECUTE privilege with the ability to GRANT it
to others. The ID also has all privileges on the database and on the table
that I'm querying with the UDF.

However, there is one confirmation for the SQL30082N:

2005-03-08-20.52.00.650000-300 I165519H257 LEVEL: Severe
PID : 1600 TID : 3068
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 44 bytes
check password failed with rc = -2146500483

Can anyone tell me what I need to do to make DB2 accept my ID?


-2146500483 = 0x800F007D = USERID SUSPENDED

Check whether userid you are using is suspended or not.

Jan M. Nelken
Nov 12 '05 #2
Hi Henry

Check the userid has been disabled,or the userid has been
restricted from accessing the operating
environment at this time.

Cheers
Guru

Henry Reardon wrote:
I'm having big problems with the Development Center right now - see other thread - so I'm hand-coding a UDF. I've managed to get the UDF fully
prepared without any errors but now I'm getting a runtime error I don't understand.

When I execute a query that tries to use my UDF, I get SQL30082N, Reason 19 ("USERID DISABLED or RESTRICTED"). I don't understand why DB2 has a problem with my ID; I'm sure that the Userid and Password are correct. Also, when I look at the User and Group Objects for this database in the Control Center, it acknowledges that the ID is fully authorized to execute the UDF in question; in fact it has the EXECUTE privilege with the ability to GRANT it to others. The ID also has all privileges on the database and on the table that I'm querying with the UDF.

However, there is one confirmation for the SQL30082N:

2005-03-08-20.52.00.650000-300 I165519H257 LEVEL: Severe
PID : 1600 TID : 3068
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20 DATA #1 : String, 44 bytes
check password failed with rc = -2146500483

Can anyone tell me what I need to do to make DB2 accept my ID?

--
Henry


Nov 12 '05 #3
Hi Henry,
Are you able to login to system(OS) using that username and
password??

Thiru.
WantedToBeDBA.

Nov 12 '05 #4
"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in
news:yq********************@rogers.com:
Henry Reardon wrote:
I'm having big problems with the Development Center right now - see
other thread - so I'm hand-coding a UDF. I've managed to get the UDF
fully prepared without any errors but now I'm getting a runtime error
I don't understand.

When I execute a query that tries to use my UDF, I get SQL30082N,
Reason 19 ("USERID DISABLED or RESTRICTED"). I don't understand why
DB2 has a problem with my ID; I'm sure that the Userid and Password
are correct. Also, when I look at the User and Group Objects for this
database in the Control Center, it acknowledges that the ID is fully
authorized to execute the UDF in question; in fact it has the EXECUTE
privilege with the ability to GRANT it to others. The ID also has all
privileges on the database and on the table that I'm querying with
the UDF.

However, there is one confirmation for the SQL30082N:

2005-03-08-20.52.00.650000-300 I165519H257 LEVEL: Severe
PID : 1600 TID : 3068
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage,
probe:20 DATA #1 : String, 44 bytes
check password failed with rc = -2146500483

Can anyone tell me what I need to do to make DB2 accept my ID?


-2146500483 = 0x800F007D = USERID SUSPENDED

Check whether userid you are using is suspended or not.

According to Windows, the ID in question is set to "Password never
expires". The "Account is disabled" checkbox is NOT checked. That means
it's not suspended, right? (I've never had to do much with Windows
userid management. I set up the ID in question 3 years ago and it has
worked fine ever since without having to do anything with it.)

Is there anything else that would explain this error, especially
something that would get set during the installation of DB2, like the
authentication values?

---

By the way, where did you look up -2146500483 (or x800F007D) to
determine that it meant 'USERID SUSPENDED'? I searched on both values
and didn't see anything that translated them to 'USERID SUSPENDED'. I
can imagine getting more such codes in db2diag.log so it would be handy
to know how to translate them to meaningful values.

Henry

--
Henry

Nov 12 '05 #5
"Guru" <gu*********@gmail.com> wrote in news:1110348052.530177.196660
@z14g2000cwz.googlegroups.com:
Hi Henry

Check the userid has been disabled,or the userid has been
restricted from accessing the operating
environment at this time.

Cheers
Guru

Henry Reardon wrote:
I'm having big problems with the Development Center right now - see

other
thread - so I'm hand-coding a UDF. I've managed to get the UDF fully
prepared without any errors but now I'm getting a runtime error I

don't
understand.

When I execute a query that tries to use my UDF, I get SQL30082N,

Reason 19
("USERID DISABLED or RESTRICTED"). I don't understand why DB2 has a

problem
with my ID; I'm sure that the Userid and Password are correct. Also,

when I
look at the User and Group Objects for this database in the Control

Center,
it acknowledges that the ID is fully authorized to execute the UDF in

question; in fact it has the EXECUTE privilege with the ability to

GRANT it
to others. The ID also has all privileges on the database and on the

table
that I'm querying with the UDF.

However, there is one confirmation for the SQL30082N:

2005-03-08-20.52.00.650000-300 I165519H257 LEVEL: Severe
PID : 1600 TID : 3068
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage,

probe:20
DATA #1 : String, 44 bytes
check password failed with rc = -2146500483

Can anyone tell me what I need to do to make DB2 accept my ID?

--
Henry



See my reply to Jan Nelken. The ID appears to be fine (not suspended) if
I'm reading the panel in Windows correctly.


--
Henry

Nov 12 '05 #6
Henry Reardon wrote:
By the way, where did you look up -2146500483 (or x800F007D) to
determine that it meant 'USERID SUSPENDED'? I searched on both values
and didn't see anything that translated them to 'USERID SUSPENDED'. I
can imagine getting more such codes in db2diag.log so it would be handy
to know how to translate them to meaningful values.


http://www-306.ibm.com/software/data...eturncodes.pdf
If you claim uour userid is clean and innocent - just reset it and change
password. If the problem still persissts take a trace and either try to attract
my attention or open a PMR with IBM Support

Jan M. Nelken

(jasinek at attglobal dot net)
Nov 12 '05 #7
"Jan M. Nelken" <Un**********@Invalid.Domain> wrote in
news:vr********************@rogers.com:
Henry Reardon wrote:
By the way, where did you look up -2146500483 (or x800F007D) to
determine that it meant 'USERID SUSPENDED'? I searched on both values
and didn't see anything that translated them to 'USERID SUSPENDED'. I
can imagine getting more such codes in db2diag.log so it would be
handy to know how to translate them to meaningful values.
http://www-306.ibm.com/software/data...upport/techatt
/returncodes.pdf

Thank you, that could be very useful for debugging problems!

If you claim uour userid is clean and innocent - just reset it and
change password. If the problem still persissts take a trace and
either try to attract my attention or open a PMR with IBM Support

Okay, I'll try that in a while; I'm working on other things for the moment.

I appreciate your help!

--
Henry

Nov 12 '05 #8

Just to followup on this series of posts - someone may find this handy in a
Google search some day - my problem has now been resolved.

If I'm understanding this correctly - and I'm not terribly strong on
Windows administration stuff so I could be wrong - the problem was that my
ID, which worked perfectly well in DB2 Version 7, would not work in DB2
Version 8 because it had no password. (The password on the ID was set to
never expire and the ID had never actually had a password.)

I created a password for the ID and found that my script ran fine as soon
as I had done that. I had to supply the right password to the script and
then everything worked as it had in Version 7.

Does that make sense to people who understand Windows administration and
how it interacts with DB2 Version 8? Unless I hear otherwise, I'll assume
it does and consider the issue resolved.

The only thing that bothers me is that I thought DB2 objected to things
like blank passwords back around Version 5, if not Version 2, which makes
me wonder how I got away with this blank password through Version 6 and 7.
(This ID has existed since I bought this computer 3 years ago back when I
was still running DB2 Version 6.)

--
Henry

Nov 12 '05 #9

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

Similar topics

1
by: Stefano Tesini | last post by:
Hi all, when i drop a table, i take his error : SQL0902C System error (REASON CODE = "122"). Why ? Ver UDB Server nt 7.1.0 Ver UDB Cli 7.1.0 Win 98 or XP the error is the same.
9
by: shorti | last post by:
db2 V8.2 I have been looking for a good way to log the 'reason code' when we hit an sqlcode that uses them. From what I can tell the reason code is stored in sqlca.sqlerrmc. But, there seems...
3
by: edmundleungs | last post by:
I have a db2 account on AIX. After connecting to AIX using SSH, i use the account to connect to DB. When I use "db2 connect <DB name>", it works fine. However, when i use "db2 connect to <DB...
8
by: Challenge | last post by:
Hi, I got error, SQL1768N Unable to start HADR. Reason code = "7", when I tried to start hadr primary database. Here are the hadr configuration of my primary db: HADR database role ...
1
by: edmundleungs | last post by:
It is found that a DB is setup for sometime. One day, the user suddenly cannot connect to DB. We found that the case is as follow: 1. User can connect to DB by issuing command db2 connect...
1
by: 73blazer | last post by:
Hello, We've got a nice running instance at 8.1FP7 (8.2), everything has been running very well on it. This morning,certain users get the following message 08001- SQL30082N Attempt to...
4
by: Odd Bjørn Andersen | last post by:
I have installed DB2 9 Enterprise Edition on my laptop (Windows xp prof. ed.). But when I try to connect to any of my local databases I get this error: SQL30082N Security processing failed with...
2
by: BD | last post by:
Hi, all. I'm trying to implement a REFRESH IMMEDIATE MQT to help with performance of a particularly sluggish query. I cannot create it with REFRESH IMMEDIATE, because of reason code "10",...
1
by: mvsguy | last post by:
I'm installing DB2 9.1 on z/OS 1.9 and am trying to test DRDA. Can anyone tell me where to find documentation on SQL30082N, RC=22? Thank you, kk BACKGROUND: After tracing the 'CONNECT'...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.