Troubleshooting
Problem
Data collection for Non-Temporary Tablespace Usage view timed out due to bad performance of data collection query.
Symptom
Non-Temporary Tablespace Usage view shows no data for ITCAM Extended Oracle agent.
The krzagent log shows the following log messages for each data collection of RDB_TablespaceNormal_Usage.
(5E0B56C0.0001-D:cps_socket.cpp,1777,"collectData") Data collection timed out waiting for response from attribute group 'RDB_TablespaceNormal_Usage' for request id '5531'.
The krzclient log shows the following log messages for each data collection of RDB_TablespaceNormal_Usage.
(5E09A118.0000-2:krzociwrap.cpp,64,"Ora_Wrapper::StmtExecuteTimeOut") Reset context at StmtExecuteTimeOut
(5E09A118.0001-2:krzociwrap.cpp,107,"Ora_Wrapper::ResetContext") The database execution is broken by krzclient
(5E09A118.0002-2:krzociwrap.cpp,108,"Ora_Wrapper::ResetContext") The request start time is:2019-11-30 10:59:50, the time out is 177.000000, current time is:2019-11-30 11:02:48
(5E09A118.0003-2:krzocibase.cpp,733,"Ora_DumpStatement") Statement type is 1, state is 1, sql function code is 0
(5E09A118.0004-2:krzocibase.cpp,738,"Ora_DumpStatement") SQL is select * from (
+5E09A118.0004 select
+5E09A118.0004 nvl(b.tablespace_name,nvl(a.tablespace_name,'UNKOWN')) TNAME,
+5E09A118.0004 round(b.Kbytes_alloc,2) * 100 KBYTES,
...
...
(5E09A118.0005-2:krzociwrap.cpp,111,"Ora_Wrapper::ResetContext") Calling OCIBreak to cancel the execution
(5E09A118.0006-2:krzocibase.cpp,659,"Ora_ErrorMsg::printOCIError") Oracle error at Ora_Wrapper::SessionEnd, Instance is
(5E09A118.0007-2:krzocibase.cpp,660,"Ora_ErrorMsg::printOCIError") Status code is -1
(5E09A118.0008-2:krzocibase.cpp,666,"Ora_ErrorMsg::printOCIError") Oracle error at Ora_Wrapper::SessionEnd, error code is:3127, error message is:Error while trying to retrieve text for error ORA-03127
Document Location
Worldwide
[{"Type":"SW","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3JRN","label":"Tivoli Composite Application Manager for Applications"},"ARM Category":[{"code":"a8m50000000L0n5AAC","label":"ITCAM-for-Applications-\u003EOracle Extended Agent-\u003ETroubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
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
Modified date:
19 May 2021
UID
ibm16453643