No start database manager command was issued. SQLSTATE=57019

Question

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 1

This looks like something is wrong with the installation. There should be some hints on what DB2 ran into in the db2diag.log file (look under ~/sqllib/db2dump/db2diag.log).

What you could do if the db2diag.log does not provide a clue is to verify your installation is correct. DB2 includes a tool for that named "db2val". Here is the link to the documentation of db2val for version 9.7. Just run "db2val" as the instance owner and check the output.

Answer 2

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