Hi everybody, i need some help please.

I have installed DB2 UDB 7.2 on Windows and created database and it
worked fine (i could access it from control centar nad using eclipse
plug-in DB2Explorer). Two days after, when i wanted to access my
database i got this message:

[IBM][CLI Driver] SQL1032N No start database manager command was
issued. SQLSTATE=57019

I tried accessing DB2 database using DBExplorer, and it head same
affect.

I tried starting db2 from cmd (db2start). But i get this message:

DB2 : The service did not start due to a logon failure.

SQL1042C An unexpected system error occured. SQLSTATE=58004

License is OK, number of license processors is OK.

Can someone help me please.
Thanx.

In article <1124350625.043973.58040@g47g2000cwa.googlegroups. com>,
alan_sec (aklikic@yahoo.com) says...

> I tried starting db2 from cmd (db2start). But i get this message:
>
> DB2 : The service did not start due to a logon failure.
>
> SQL1042C An unexpected system error occured. SQLSTATE=58004
>

Most likely the user which is defined at the DB2 service definition
does have a problem. The password may be incorrect or the user is
disabled.

alan_sec wrote:
> Hi everybody, i need some help please.
>
> I have installed DB2 UDB 7.2 on Windows and created database and it
> worked fine (i could access it from control centar nad using eclipse
> plug-in DB2Explorer). Two days after, when i wanted to access my
> database i got this message:
>
> [IBM][CLI Driver] SQL1032N No start database manager command was
> issued. SQLSTATE=57019
>
> I tried accessing DB2 database using DBExplorer, and it head same
> affect.
>
> I tried starting db2 from cmd (db2start). But i get this message:
>
> DB2 : The service did not start due to a logon failure.
>
> SQL1042C An unexpected system error occured. SQLSTATE=58004
>
> License is OK, number of license processors is OK.
>
> Can someone help me please.
> Thanx.
>
I have had this problem when I changed the password of the userid that
did the install of DB2. Sometimes resetting the password back to its old
value solved the problem, other times it did't and I ended up
reinstalling DB2.

--
Anton Versteeg
IBM Netherlands

Anton Versteeg wrote:

> alan_sec wrote:
>> Hi everybody, i need some help please.
>>
>> I have installed DB2 UDB 7.2 on Windows and created database and it
>> worked fine (i could access it from control centar nad using eclipse
>> plug-in DB2Explorer). Two days after, when i wanted to access my
>> database i got this message:
>>
>> [IBM][CLI Driver] SQL1032N No start database manager command was
>> issued. SQLSTATE=57019
>>
>> I tried accessing DB2 database using DBExplorer, and it head same
>> affect.
>>
>> I tried starting db2 from cmd (db2start). But i get this message:
>>
>> DB2 : The service did not start due to a logon failure.
>>
>> SQL1042C An unexpected system error occured. SQLSTATE=58004
>>
>> License is OK, number of license processors is OK.
>
> I have had this problem when I changed the password of the userid that
> did the install of DB2. Sometimes resetting the password back to its old
> value solved the problem, other times it did't and I ended up
> reinstalling DB2.

On Windows, you will find under Start -> Settings -> Control Panel ->
Administrative Tools -> Services a series of services related to DB2. To
prevent such logon-failures mentioned above, I changed all those services
to use the "Local System account" in the "Log On" tab. (I have Win2K
here.) With that change I never encountered any problems after the
password was changed.

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena