473,604 Members | 2,483 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 64957
In article <11************ *********@g47g2 000cwa.googlegr oups.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
1815
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 start database and then it gave me error SQL1026N The database manager is already active. Even after stopping and starting database as well as db2admin again, problem is still there
2
16888
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: db2 => activate database sample SQL1032N No start database manager command was issued. SQLSTATE=57019 db2 => db2start /home/db2inst2/sqllib/adm/db2star2: relocation error: /home/db2inst2/sqllib/adm/db2star2: undefined symbol: sqloset
3
4448
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 crashes. Subsequent connections receive the Caused by: COM.ibm.db2.jdbc.DB2Exception:
0
1476
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 the instances i.e., i created 3 instances and along with that it is showing the error that DBA0102W Unable to detect nodetype for instance - "TEST".
4
4202
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 command is already in progress. db2inst1@pjbrlnx:~> db2 create db lnxkaka on /ges SQL1032N No start database manager command was issued. SQLSTATE=57019 db2inst1@pjbrlnx:~>
2
8744
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
11400
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 hpsinst@hps3602::/hpsinst> db2start 08/22/2007 17:06:41 0 0 SQL1042C An unexpected system error occurred. SQL1032N No start database manager command was issued. SQLSTATE=57019 current db2level DB2 v8.1.1.128 and fixpack is 14
2
3537
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 issued. SQLSTATE=57019 DBA0102W Unable to detect nodetype for instance - "STRDB (DB2)
3
7009
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 Windows XP SP2 512MB RAM 80GB HDD, x64. At the very end of installation I got following message:
0
7997
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
7929
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8409
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
6739
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5882
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3907
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3955
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2434
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1266
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.