No start database manager command was issued. SQLSTATE=57019

database db2 database-administration
Sathish Kumar picture Sathish Kumar · Jul 31, 2015 · Viewed 49.7k times · Source

I am new to DB2 and I have installed DB2 9.7.

I created an instance which is shown below

[sathish@oc3855733574 ~]$ db2ilist
sathish

Settings of /etc/services is shown below

DB2_sathish     60000/tcp
DB2_sathish_1   60001/tcp
DB2_sathish_2   60002/tcp
DB2_sathish_END 60003/tcp
DB2_TMINST      50000/tcp

But, when I start using 'db2start' it throws the following error

07/31/2015 10:26:20     0   0   SQL1042C  An unexpected system error occurred.
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

I installed DB2 using 'root' and starting 'DB2' from 'instance' (sathish in this case)

Any help or URL link will be of great use

Thanks Sathish Kumar

Answer

Sathish Kumar picture Sathish Kumar · Aug 13, 2015

I had a look into db2diag.log file and I got a unusual hack from one of the website

I followed the steps mentioned below and it worked

a)   db2trc on -f db2trace.out
b)   db2start
c)   db2trc off

Related questions

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More
How to update multiple columns in single update statement in DB2

I want to update multiple columns of a table in DB2 with single Update statement. Any hint or idea will be appreciable. Thanks.

Read More
Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this. SELECT DAYS (CURRENT …

Read More