473,406 Members | 2,619 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,406 software developers and data experts.

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.

Nov 12 '05 #1
3 64903
In article <11*********************@g47g2000cwa.googlegroups. com>,
alan_sec (ak*****@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.
Nov 12 '05 #2
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
Nov 12 '05 #3
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
Nov 12 '05 #4

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

Similar topics

0
by: Jagdip Singh | last post by:
Hi all, I wanted to created sample database and issued db2sampl command which gave me error SQL1032N No start database manager command was issued. SQLSTATE=57019 I issued db2start command to...
2
by: Herbert | last post by:
Hallo colleques, I get during the following error message "SQL1035N No database manager command was issued. SQLSTATE=57019", when issuing the following command on the Command Line Processor:...
3
by: deegs_ca | last post by:
Here is my jdbc info url = jdbc:db2://LXPP04913:60000/TEST driver = COM.ibm.db2.jdbc.net.DB2Driver For some reason as I'm importing data via a jdbc client Db2 gets through a few rows and then...
0
by: narayana | last post by:
hi friends when i entered into DB2UDB v8.2(enterprise edition server) control center under my local server. AT All systems i entered into my systems and click the instances it is showing all...
4
by: jbaron | last post by:
I have just successfully installed DB2 8.2 under SLES8.2 and when trying to create a new database I get the following error: db2inst1@pjbrlnx:~> db2start SQL6036N START or STOP DATABASE MANAGER...
2
by: anujs | last post by:
Hi members, Please let me know how to solve the problem while initializing the DB2. the message is - IBM] SQL1032N No start database manager command was issued. SQLSTATE=57019.
0
by: kally | last post by:
Hi, I tried to do ML_upgradation for aix server...but when db2 guys tried to start the service its ending up with error...i have pasted the error below..could anybody suggest me on this..pls ...
2
by: amoldhingra | last post by:
Hi all, I'm new to DB2 and want to create a new database in DB2. I tried doing so with the help of DB2 help but it's giving me following error: SQL1032N No start database manager command was...
3
by: Ivan Delic | last post by:
Hi all! This is my first email message about DB2 Universal database so don't mind if it looks like confusion. Recently I have installed DB2 UDB (Try and by Version) on my OS. It is, as follows ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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
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
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,...
0
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...

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.