Search code examples
databasedb2database-administration

No start database manager command was issued. SQLSTATE=57019

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

Solution

  • 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