The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
with Tags:
hang
X
X
Why db2 was hung while waiting for log files to be archived to third party vendor ?
Occasionally you may see DB2 hung and it may be because of a problem in the third party vendor used to archive db2 logs. We have tried to explain the problem, its identification and solution below. The third party vendor used in our example below is TSM, please note we have seen the below issue with Veritas Netbackup as well. You may find the following messages in db2diag.log while db2 is hung : 2018-04-19-18.20.19.542647+480 E1644436A430 LEVEL: Info PID : 10289678 ... [More]
Tags: tsm hang db2 logs archive netbackup connections |
DB2 does not accept new connections while db2diag.log shows log archival to third party vendor in progress
When DB2 archiving a log file to vendor program (for example TSM), if TSM does not respond to DB2 (neither success nor failed), and if the database is deactivating during the "non-response" window, DB2 will get stuck in the deactivting process and hence cannot accept new connections to the database Please refer the technote : DB2 does not accept new connections if it is archiving a log file to vendor program and database is deactivating at the same time http://www-01.ibm.com/support/docview.wss?uid=swg21690867... [More]
Tags: hang db2 archival deactivate was log tsm connections |
Unexpected DB2LUW hang while using Vintella Authentication Services plug-in
There are few Technote and Document out there on this already. But, wanted to share this as some customers still faced this issue lately. The symptom is reported as sudden hang in Db2 database. Nothing progressing. CPU, memory and I/O were abnormally idle in the box. That is an indication that nothing really running and stuck some where. No locking or latching. A quick running of "db2pd -stack all" will... [More]
Tags: plug-in db2luw hang vintella ibm-blog authentication |
In Db2 LUW if unknown hangs are being experienced better to check if DB2SLEEP registry is set or not
I am sharing this as we had a situation lately in a big 3 member 2 CF Purescale setup where there were hangs in the members being experienced without much notable reasons. When checked the setup closely it was found out the DB2SLEEP registry was turned ON in this instance for some reason and it was left that way accidentally. DB2SLEEP is an internal undocumented registry setting used only by Db2 Support team for advanced level of diagnostics collection. The registry will put the instance in the sleep state so that more... [More]
Tags: db2luw db2sleep hang |
DB2 HANG DATA COLLECTION
Problem definition: - Every DBA has encountered a problem when the database is not responding and had to use the failover mechanism to bring the service back up. In this article, we will move from defining different types of hangs and what to collect to debug the problem. Scope of this document is single partitioned database hosted on Linux/Unix and Windows. This data collection is to get close to the complete data set i.e. covering recursion, latching and other symptoms but sometime support might have to ask more debug data is the problem... [More]
Tags: db2fodc db2hang hang |
75 ways to demystify DB2 #60: Techtip : Hang of db2 uncatalog/catalog command
Hello DB2 mates, Hope all is going well for you. In a multiple databases environment, we sometimes configure remote catalogue information for target databases like followings. $ db2 catalog tcpip node <nodename> remote <IP or hostname> server <Port number> $ db2 catalog db <dbname> as <db alias> at node <nodename> And in some cases, we need to reconfigure this information. For example, if you regularly change the port number of target system DB2 instance, the client catalog information should be changed as... [More]
Tags: uncatalog catalog hang slow ibm-blog performance db2 |
