Troubleshooting
Problem
Problem Db2 Connect/Activate Database can fails with SQL1224N. In the db2diag.log you may see the following: db2diag.log:
2017-06-28-12.17.09.531736+060 E16362E505 LEVEL: Event PID : 7731
TID : 140430654039808 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-7 APPID:
*LOCAL.db2inst1.170628111708 AUTHID : DB2INST1
HOSTNAME: myhost1 EDUID : 22 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect,
probe:1000 START : DATABASE: SAMPLE : ACTIVATED: NO
2017-06-28-12.17.09.619290+060 E16868E593 LEVEL: Severe PID : 7729
TID : 139878524249856 PROC : db2wdog 0 [db2inst1] INSTANCE: db2inst1 NODE : 000
HOSTNAME: myhost1 EDUID : 2 EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog,
probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred.
All DB2 processes associated with this instance have been shutdown. Diagnostic information has been recorded.
Contact IBM Support for further assistance.
2017-06-28-12.17.09.620595+060 E17462E468 LEVEL: Error PID : 7729
TID : 139878524249856 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1 NODE : 000 HOSTNAME: myhost1
EDUID : 2 EDUNAME: db2wdog 0 [db2inst1] FUNCTION: DB2 UDB,
base sys utilities, sqleWatchDog, probe:8959 DATA #1 : Process ID,
4 bytes 7731 DATA #2 : Hexdump, 8 bytes 0x00007F3801BFD1E8 : 0101 0000 0B00 0000 ........
You may also find you are not able to perform the following SQL or commands:
You may also find you are not able to perform the following SQL or commands:
CREATE DATABASE /usr/local/bin/db2ls /instance/db2iupdt /instance/db2icrt These can all cause the same issue or generate a core dump. If you can extract the stack you may find it show as : db2ls_exec: 0 0x00007f91e25141fe in __intel_ssse3_rep_memcpy () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #1 0x00007f91e242edcf in ListOfIDs::operator=(ListOfIDs const&) () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #2 0x00007f91e24239ee in Languages::Languages(Languages const&) () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #3 0x00007f91e24286e3 in Product::Product(char*, int, char*, char*, Prereqs const&, Components const&, Components const&, Components const&, Languages const&, unsigned long, ...) () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #4 0x00007f91e22817b3 in ProductList::ProductList(int) () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #5 0x00007f91e2426e4e in ProductList::getInstance() () from /home/db2inst1/sqllib/lib64/libdb2ure2.so.1 #6 0x0000000000404c90 in runQuery(char*) () #7 0x0000000000404377 in main ()
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Operating System \/ Hardware - Other OS\/Hardware","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
10.5, 11.1
Operating system(s):
Linux, Windows
Document number:
564151
Modified date:
01 May 2025
UID
swg22005620
Manage My Notification Subscriptions