473,511 Members | 10,700 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

userid disabled or restricted in DB2 8.2

Hi,

I am seeing a weird problem with DB2 8.2. When we connect to the
database using the following command in db2 CLP

db2 connect to <dbname> user <user> using <passwd>

I get the following error,

"userid disabled or restricted"

For this the DB2 suggests the following.
1.open the DB2 CLP
2.Type the command db2 connect to <dbname> user <user> using <passwd>

3.If you encounter error such as userid disabled or restricted, type
the command

db2secv82 /u <usergroup>

3.Start the db2 (db2secv82 command stops the database)

4.They also say that this is because of the new security feature
"Enable OS Security" option during installation or migration of DB2 8.2

5.The problem is that every time (say after a system restart)i need to
reissue this command for the users to access the db2 objects

Is there any way to permanently resolve this issue in DB2 8.2

Thanks
Sriram

Nov 12 '05 #1
1 7902
You might usually see this error if the account is locked out.

Nov 12 '05 #2

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

Similar topics

30
2537
by: Sean R. Lynch | last post by:
I've been playing around with Zope's RestrictedPython, and I think I'm on the way to making the modifications necessary to create a capabilities-based restricted execution system. The idea is to...
30
5409
by: Mason A. Clark | last post by:
If I use javascript on my page, how likely is it that the viewer will not have javascript? Anyone have data? Mason C
4
1778
by: Nigel Greenwood | last post by:
A colleague is having difficulty getting JavaScript to work in a webpage he's viewing offline in IE6. Apparently JS is enabled & works in webpages viewed online. Are there any obvious remedies? ...
4
1221
by: Trint Smith | last post by:
I did have UserID as 'Dim UserID As String'. Ok, when I made it 'Public UserID As String', in the Public Area of one program and took out all the 'local' declairations of it, even in the other...
1
6751
by: chaitu | last post by:
Hi, I have an issue. When a developer tries to connect using an USERID and a ped it gives SQL30082N Attempt to establish connection failed with security reason "19" ("USERID DISABLED or...
3
2627
by: Paul Rudin | last post by:
I'm occasionally seeing tracebacks like this: Traceback (most recent call last): File "logging/__init__.py", line 744, in emit File "logging/__init__.py", line 630, in format File...
3
2121
by: Jim | last post by:
Using either EW or VSE2008, I want to have a GridView that will: - Insert the logged in user's UserId from either the User table or the membership table when the user inserts a record. - When the...
4
1637
by: sjohnson1984 | last post by:
Hello all, I have a form which is generated using a database query - the recordset is filled with agent details, login time and the like, and there are as many rows in the table as records in the...
0
7251
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,...
0
7148
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...
0
7367
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,...
1
7089
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5673
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5072
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...
0
3230
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
790
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
451
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.