473,320 Members | 1,732 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.

Lost/compromise db2admin password

Hi IBMers,

I haven't used the db2 v8.1 on my win OS for a while, now, all of a
sudden, it became a stranger to me or vice versa, to start with, db2
db server can no longer starts, it complained about logon failure, I
managed to find the db2admin logon pwd, however, to no avail; searched
the NG for clue, got something like "get dbm cfg", it won't help,
minic "get dbm db2admin", "get dbm pwd|pasword" neither helped.

So, help, I'm "drowning", TIA.

Don
Nov 12 '05 #1
6 21173
On 2004-04-08, DonLi scribbled:
Hi IBMers,

I haven't used the db2 v8.1 on my win OS for a while, now, all of a
sudden, it became a stranger to me or vice versa, to start with, db2
db server can no longer starts, it complained about logon failure, I
managed to find the db2admin logon pwd, however, to no avail; searched
the NG for clue, got something like "get dbm cfg", it won't help,
minic "get dbm db2admin", "get dbm pwd|pasword" neither helped.

So, help, I'm "drowning", TIA.

Don


On Windows NT/2000/XP, DB2 usually uses Windows itself to handle
authentication. Hence, there is no way to ask DB2 "what is the password
for user X?" (just as you cannot ask Windows "what is the password for
user X?"). Which is not to say that Windows passwords are 100% safe and
couldn't be cracked - they can be, and this _may_ be what has happened
in your case.

However, you may also have password policies set, such as "passwords
expire after 180 days" or similar. In this case, it may be that the
password for the db2admin user has now expired and the DB2 services are
no longer capable of logging on using the password they have. If this
is the case, you can probably get around it by setting the "Password
never expires" option for the db2admin user.

Otherwise, you'll need to reset the password for the db2admin user (I'd
recommend doing this anyway just to assuage any paranoia), and set all
the DB2 services that logon using db2admin to use the new password.

Note that, to change the password (and optionally userid) used by the
DB2 administrator server (usually the service called "DB2 - DB2DAS00"),
you should use the following command line instead of changing it
manually in the Services console:

db2admin SETID <username> <password>

I seem to remember this avoids some problem that can occur with the
manual method - but can't remember exactly what or where I read it.

HTH, Dave.

--
Dave
Remove "_nospam" for valid e-mail address

"Never underestimate the bandwidth of a station wagon full of CDs doing
a ton down the highway" -- Anon.
Nov 12 '05 #2
Thank you very much for the explanation and the remedy. Executing
db2admin SETID <username> <password>
at Command Window was successful, and I tried to start the DB2-DB2
service and then DB2DAS service, also reversed the sequence, also
tried to started all other DB2 related services first, however, both
of these two services failed to start, respective err msgs: 8000 and
22204. Just searched the NG for clue to these two errors respectively
to no avail. Would appreciate your further assistance in this
important matter very much.
"Dave Hughes" <da*********@waveform.plus.com> wrote in message news:<xn****************@usenet.plus.net>...
On 2004-04-08, DonLi scribbled:
Hi IBMers,

I haven't used the db2 v8.1 on my win OS for a while, now, all of a
sudden, it became a stranger to me or vice versa, to start with, db2
db server can no longer starts, it complained about logon failure, I
managed to find the db2admin logon pwd, however, to no avail; searched
the NG for clue, got something like "get dbm cfg", it won't help,
minic "get dbm db2admin", "get dbm pwd|pasword" neither helped.

So, help, I'm "drowning", TIA.

Don


On Windows NT/2000/XP, DB2 usually uses Windows itself to handle
authentication. Hence, there is no way to ask DB2 "what is the password
for user X?" (just as you cannot ask Windows "what is the password for
user X?"). Which is not to say that Windows passwords are 100% safe and
couldn't be cracked - they can be, and this _may_ be what has happened
in your case.

However, you may also have password policies set, such as "passwords
expire after 180 days" or similar. In this case, it may be that the
password for the db2admin user has now expired and the DB2 services are
no longer capable of logging on using the password they have. If this
is the case, you can probably get around it by setting the "Password
never expires" option for the db2admin user.

Otherwise, you'll need to reset the password for the db2admin user (I'd
recommend doing this anyway just to assuage any paranoia), and set all
the DB2 services that logon using db2admin to use the new password.

Note that, to change the password (and optionally userid) used by the
DB2 administrator server (usually the service called "DB2 - DB2DAS00"),
you should use the following command line instead of changing it
manually in the Services console:

db2admin SETID <username> <password>

I seem to remember this avoids some problem that can occur with the
manual method - but can't remember exactly what or where I read it.

HTH, Dave.

Nov 12 '05 #3
DB2 doesn't store any information on your user db2admin or any other
users. It's useless to ask DB2 for password. Check if you can login
with db2admin user and password on your OS or you can reset your
password on OS if you have system
admin previlege. This might solve your problem.

I hope this helps.

Amar.

do***@yahoo.com (DonLi) wrote in message news:<9a**************************@posting.google. com>...
Thank you very much for the explanation and the remedy. Executing
db2admin SETID <username> <password>
at Command Window was successful, and I tried to start the DB2-DB2
service and then DB2DAS service, also reversed the sequence, also
tried to started all other DB2 related services first, however, both
of these two services failed to start, respective err msgs: 8000 and
22204. Just searched the NG for clue to these two errors respectively
to no avail. Would appreciate your further assistance in this
important matter very much.
"Dave Hughes" <da*********@waveform.plus.com> wrote in message news:<xn****************@usenet.plus.net>...
On 2004-04-08, DonLi scribbled:
Hi IBMers,

I haven't used the db2 v8.1 on my win OS for a while, now, all of a
sudden, it became a stranger to me or vice versa, to start with, db2
db server can no longer starts, it complained about logon failure, I
managed to find the db2admin logon pwd, however, to no avail; searched
the NG for clue, got something like "get dbm cfg", it won't help,
minic "get dbm db2admin", "get dbm pwd|pasword" neither helped.

So, help, I'm "drowning", TIA.

Don


On Windows NT/2000/XP, DB2 usually uses Windows itself to handle
authentication. Hence, there is no way to ask DB2 "what is the password
for user X?" (just as you cannot ask Windows "what is the password for
user X?"). Which is not to say that Windows passwords are 100% safe and
couldn't be cracked - they can be, and this _may_ be what has happened
in your case.

However, you may also have password policies set, such as "passwords
expire after 180 days" or similar. In this case, it may be that the
password for the db2admin user has now expired and the DB2 services are
no longer capable of logging on using the password they have. If this
is the case, you can probably get around it by setting the "Password
never expires" option for the db2admin user.

Otherwise, you'll need to reset the password for the db2admin user (I'd
recommend doing this anyway just to assuage any paranoia), and set all
the DB2 services that logon using db2admin to use the new password.

Note that, to change the password (and optionally userid) used by the
DB2 administrator server (usually the service called "DB2 - DB2DAS00"),
you should use the following command line instead of changing it
manually in the Services console:

db2admin SETID <username> <password>

I seem to remember this avoids some problem that can occur with the
manual method - but can't remember exactly what or where I read it.

HTH, Dave.

Nov 12 '05 #4
Yeah, I'm able to log on as db2Admin from OS, however, this same user
failed to start DB2 - DB2 service, though this user belongs to sys
admin group. Oh, forget it, DB2 is not my priority for now. Thanks
though.

he*******@yahoo.com (Amar) wrote in message news:<47**************************@posting.google. com>...
DB2 doesn't store any information on your user db2admin or any other
users. It's useless to ask DB2 for password. Check if you can login
with db2admin user and password on your OS or you can reset your
password on OS if you have system
admin previlege. This might solve your problem.

I hope this helps.

Amar.

do***@yahoo.com (DonLi) wrote in message news:<9a**************************@posting.google. com>...
Thank you very much for the explanation and the remedy. Executing
db2admin SETID <username> <password>
at Command Window was successful, and I tried to start the DB2-DB2
service and then DB2DAS service, also reversed the sequence, also
tried to started all other DB2 related services first, however, both
of these two services failed to start, respective err msgs: 8000 and
22204. Just searched the NG for clue to these two errors respectively
to no avail. Would appreciate your further assistance in this
important matter very much.
"Dave Hughes" <da*********@waveform.plus.com> wrote in message news:<xn****************@usenet.plus.net>...
On 2004-04-08, DonLi scribbled:

> Hi IBMers,
>
> I haven't used the db2 v8.1 on my win OS for a while, now, all of a
> sudden, it became a stranger to me or vice versa, to start with, db2
> db server can no longer starts, it complained about logon failure, I
> managed to find the db2admin logon pwd, however, to no avail; searched
> the NG for clue, got something like "get dbm cfg", it won't help,
> minic "get dbm db2admin", "get dbm pwd|pasword" neither helped.
>
> So, help, I'm "drowning", TIA.
>
> Don

On Windows NT/2000/XP, DB2 usually uses Windows itself to handle
authentication. Hence, there is no way to ask DB2 "what is the password
for user X?" (just as you cannot ask Windows "what is the password for
user X?"). Which is not to say that Windows passwords are 100% safe and
couldn't be cracked - they can be, and this _may_ be what has happened
in your case.

However, you may also have password policies set, such as "passwords
expire after 180 days" or similar. In this case, it may be that the
password for the db2admin user has now expired and the DB2 services are
no longer capable of logging on using the password they have. If this
is the case, you can probably get around it by setting the "Password
never expires" option for the db2admin user.

Otherwise, you'll need to reset the password for the db2admin user (I'd
recommend doing this anyway just to assuage any paranoia), and set all
the DB2 services that logon using db2admin to use the new password.

Note that, to change the password (and optionally userid) used by the
DB2 administrator server (usually the service called "DB2 - DB2DAS00"),
you should use the following command line instead of changing it
manually in the Services console:

db2admin SETID <username> <password>

I seem to remember this avoids some problem that can occur with the
manual method - but can't remember exactly what or where I read it.

HTH, Dave.

Nov 12 '05 #5
On 2004-04-09, DonLi scribbled:
Thank you very much for the explanation and the remedy. Executing
db2admin SETID <username> <password>
at Command Window was successful, and I tried to start the DB2-DB2
service and then DB2DAS service, also reversed the sequence, also
tried to started all other DB2 related services first, however, both
of these two services failed to start, respective err msgs: 8000 and
22204. Just searched the NG for clue to these two errors respectively
to no avail. Would appreciate your further assistance in this
important matter very much.

[snip]

Just looked up SQL8000 in the DB2 Message Reference, Volume 2 which
reads:

"Explanation: A valid license key could not be found and the evaluation
period has expired.

User Response: Install a license key for the fully entitled version of
the product. You can obtain a license key for the product by contacting
your IBM representative or authorized dealer."

So, assuming you do actually have a license, and that you don't have a
expired try-and-buy installation, the problem could be that the "DB2
Licensing Server" service isn't started, or is failing to start. Take a
look in the services control panel to check whether it's started, and
try and start it if not.

Failing that, there's an application you can start which allows you to
list and maintain the licenses for DB2 - unfortunately, I can't
remember it off-hand right now - but it should be somewhere under the
Start menu group containing the other DB2 apps like Control Center, etc.

Also, I couldn't find any information on message SQL22204 (assuming it
is an SQL error message - could you post any other output you got with
this message?)

HTH, Dave.
--
Dave
Remove "_nospam" for valid e-mail address

"Never underestimate the bandwidth of a station wagon full of CDs doing
a ton down the highway" -- Anon.
Nov 12 '05 #6
DonLi wrote:
Yeah, I'm able to log on as db2Admin from OS, however, this same user
failed to start DB2 - DB2 service, though this user belongs to sys
admin group. Oh, forget it, DB2 is not my priority for now. Thanks
though.


You have to use the Windows "Services" application
to update the password that is used when the
service is started.

Start -- Run -- services.msc
The userid & pwd entry fields are located on the LogOn tab.

--
Eric Diamond/New York

e-mail address brought to you by
http://whois.ibm.com and the letter "J"
Nov 12 '05 #7

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

Similar topics

1
by: Anthony Davis | last post by:
Hello All, I have been using the MySQL control center and had my usernames and passwords for the MySQL server stored in the control center. I recently lost everything on my PC including the...
3
by: Lan W via DBMonster.com | last post by:
Hi, I tried to issue the command: db2admin start on my db2 UDB 8.2 with AIX 5.2 server. It gives me the error: SQL4401C The DB2 Administration Server encountered an error during startup. ...
6
by: a_hartmann_andersen | last post by:
Hi Guys Here is the problem: Im bored changing the local administrator password for a set of servers in a domain. So I though that I would write myself a little tool in C# to do that. I found...
0
by: nm31 | last post by:
I am using DB2 8.1 I have resetted the db2admin password from the My computer>Properties>Manage>Users>db2admin>set password. After that when I go to db2 command prompt and type list...
2
by: RoopaHemanth | last post by:
hi all, The following is the scenario and also the problem description a. We have a win2k server on which we had installed the DB2 8.1 server. It was running fine. b. Recently, we installed and...
3
by: randeeparora | last post by:
Guys, I desperately need some help here. I have lost my root password and I am unable to login in. Every time on the CL prompt I am asked for a password and I obviuosly can't get through. I also...
4
by: imranshaiks786 | last post by:
I lost my administrator password and there is no other users to login. How can I still login to my system?
1
by: Shandelzare | last post by:
I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server,...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
1
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: 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...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.