Question & Answer
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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21968633