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.
heyhi_999@yahoo.com (Amar) wrote in message news:<476fd0ca.0404091440.112be3bf@posting.google. com>...[color=blue]
> 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.
>
>
>
>
donli@yahoo.com (DonLi) wrote in message news:<9a172893.0404090552.74198c6f@posting.google. com>...[color=green]
> > 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" <dave_nospam@waveform.plus.com> wrote in message news:<xn0dgt0vqlzn97v000@usenet.plus.net>...[color=darkred]
> > > 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.[/color][/color][/color]
