Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 11:39 AM
alan_sec
Guest
 
Posts: n/a
Default No start database manager command was issued. SQLSTATE=57019

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.

  #2  
Old November 12th, 2005, 11:39 AM
Gert van der Kooij
Guest
 
Posts: n/a
Default Re: No start database manager command was issued. SQLSTATE=57019

In article <1124350625.043973.58040@g47g2000cwa.googlegroups. com>,
alan_sec (aklikic@yahoo.com) says...
[color=blue]
> 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
>[/color]

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.
  #3  
Old November 12th, 2005, 11:39 AM
Anton Versteeg
Guest
 
Posts: n/a
Default Re: No start database manager command was issued. SQLSTATE=57019

alan_sec wrote:[color=blue]
> 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.
>[/color]
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
  #4  
Old November 12th, 2005, 11:39 AM
Knut Stolze
Guest
 
Posts: n/a
Default Re: No start database manager command was issued. SQLSTATE=57019

Anton Versteeg wrote:
[color=blue]
> alan_sec wrote:[color=green]
>> 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.[/color]
>
> 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.[/color]

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
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,164 network members.