这个APAR会导致连接挂起。 收集"db2pd -latch" 和 “db2pd -stack all”的话,你会看到好多EDU在等待SQLO_LT_sqeLocalDatabase__dblatch。同时有一个EDU的stack大致如下:
semtimedop
sqloWaitEDUWaitPost
sqeIcoordCB::WaitForSanityCheck
sqeIcoordCB::DispatchIndependentDBAgent
ABPIcoordAgent::spawnIcoordAgent
ABPDispatcher::spawnAgent
ABPDispatcher::activateTaskProContexts
abpActivateTaskProContexts
pdCreateDumpCleanupTask
pdLogInternal
pdOSSeLoggingCallback
ossLog
OSSHIPCSemaphoreEx::create
另外一个EDU拿着SQLO_LT_sqeLocalDatabase__dblatch,但是在等待一个上面EDU拿着的latch:
__nanosleep
sqloSpinLockConflict
SqloOSResourcePosixSemSlotManager::search
sqloNLCKInit
SQLP_GLFH_CB::lock
sqlpgOpenGLFH
sqlpgReadGLFHFromDiskAndMigrate
sqeTopologyInfo::load
sqleGetTopologyInfo
sqeApplication::CreateDbMemberTopologyView
sqeLocalDatabase::RegisterApp
sqeLocalDatabase::SubsequentConnect
sqeDBMgr::StartUsingLocalDatabase
sqeApplication::AppStartUsing
sqleSubAgentStartUsing
sqeApplication::AppSecondaryStartUsing
其它EDU在等待SQLO_LT_sqeLocalDatabase__dblatch。
这个APAR有workaround, 就是把DIAGSIZE设置成0以关闭rotating diag log。




