IBM Support

DB2 instance unable to start and results in SQL1072C error

Technote (FAQ)


Question

How to resolve the issue of DB2 instance not starting up due to SQL1072C error?

Cause

SQL1072C error normally indicates there are some instance files that might have been corrupted due in-proper instance shutdown.

Answer

In order to resolve the issue, try the following:

1) First do db2_kill and ipclean to clean up all the relavant ipc resources related with DB2

=> db2_kill -all

=> ipclean

NOTE*: On UNIX-based systems, you can use the "ipcs | grep instance_ID" command to list all IPC resources owned by the instance id, and the "ipcrm -[q|m|s] ID" command to remove them).

2) Run db2iupdt command to resource all the instance files to sqllib

3) Restart the DB2 instance.

Document information

More support for: DB2 for Linux, UNIX and Windows
Database Objects/Config - Instance

Software version: 9.5, 9.7, 9.8, 10.1, 10.5

Operating system(s): AIX, Linux, Solaris, Windows

Reference #: 1968633

Modified date: 12 May 2016