DB2 instance unable to start and results in SQL1072C error
How to resolve the issue of DB2 instance not starting up due to SQL1072C error?
SQL1072C error normally indicates there are some instance files that might have been corrupted due in-proper instance shutdown.
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
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.
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