IBM Support

DB2 instance unable to start and results in SQL1072C error

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.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Instance","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21968633