SQ1000_DB4 - iSeries: SQL Information (Database Monitor)

iSeries: SQL Information (Database Monitor) information is stored in SAP table SQ1000_DB4.
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".

Fields for table SQ1000_DB4

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SYSIDName of SAP SystemXSYSYSIDCHAR8
IPLTIMEText field length 14XCHAR14CHAR14
QQKEYiSeries: Key Field (Database Monitor)XQQKEYCHAR17
QQTIMEiSeries: Record Creation Timestamp (Database Monitor)QQTIMECHAR26
QQJOBiSeries: Job Name (Database Monitor)QQJOBCHAR10
QQUSERiSeries: Job User (Database Monitor)QQUSERCHAR10
QQJNUMiSeries: Job Number (Database Monitor)QQJNUMCHAR6
QQUDEFiSeries: User-defined Field (Database Monitor)QUDEFCHAR18
QQPLIBiSeries: Package/Program Library (Database Monitor)QQPLIBCHAR10
QQPNAMiSeries: Package/Program Name (Database Monitor)QQPNAMCHAR10
QQCNAMiSeries: Cursor Name (Database Monitor)QQCNAMCHAR18
QQSNAMiSeries: Statement Name (Database Monitor)QQSNAMCHAR18
QQCNTiSeries: No. of Executions of a Statement (Database Monitor)QQCNTDEC8
QQAVGTiSeries: Average Time (Database Monitor)QQAVGTDEC8
QQMINTiSeries: Minimum Time (Database Monitor)QQMINTDEC8
QQMAXTiSeries: Maximum Time (Database Monitor)QQMAXTDEC8
QQOPNTiSeries: Open time (Database Monitor)QQOPNTDEC8
QQFETTiSeries: FETCH time (Database Monitor)QQFETTDEC8
QQCLSTiSeries: CLOSE time (Database Monitor)QQCLSTDEC8
QQOTHTiSeries: Any other time (Database Monitor)QQOTHTDEC8
QQLTUiSeries: Time Last Used (Database Monitor)QQLTUCHAR26
QQMETUiSeries: Timest. of Most Expensive Stmt. (Database Monitor)QQMETUCHAR26
QQAPRTiSeries: Timestamp of Access Plan Rebuild (Database Monitor)QQAPRTCHAR26
QQFULOiSeries: Number of FULL OPENs (Database Monitor)QQFULODEC8
QQPSUOiSeries: Number of PSEUDO OPENs (Database Monitor)QQPSUODEC8
QQTOTRiSeries: Total Rows in Table (Database Monitor)QTOTRDEC8
QQRROWiSeries: Result Rows (Database Monitor)QQRROWDEC8
QQSTFiSeries: Statement Function (Database Monitor)QQSTFCHAR1
QQSTOPiSeries: Statement Operation (Database Monitor)QQSTOPCHAR2
QQODPIiSeries: ODP Implementation (Database Monitor)QQODPICHAR1
QQHVIiSeries: Host Variable Implementation (Database Monitor)QQHVICHAR1
QQAPRiSeries: Reason Code for Access Plan RebuildQQAPRCHAR4
QQDACViSeries: Data Conversion (Database Monitor)QQDACVCHAR1
QQCTSiSeries: Number of Table Scans (Database Monitor)QQCTSDEC8
QQCIUiSeries: Index Usage (Database Monitor)QQCIUDEC8
QQCICiSeries: Number of Index Creates (Database Monitor)QQCICDEC8
QQCSOiSeries: No. of Sorts (Database Monitor)QQCSODEC8
QQCTFiSeries: No. of Temporaray File Creates (Database Monitor)QQCTFDEC8
QQCIAiSeries: Index Advice (Database Monitor)QQCIADEC8
QQCAPRiSeries: No of Access Plan Rebuilds (Database Monitor)QQCAPRDEC8
QQARSSiSeries: Average Result Set Size (Database Monitor)QQARSSDEC8
QQC11iSeries: Reserved Field (Database Monitor)QQC11CHAR1
QQC12iSeries: Reserved Field (Database Monitor)QQC12CHAR1
QQC21iSeries: Reserved Field (Database Monitor)QQC21CHAR2
QQC22iSeries: Reserved Field (Database Monitor)QQC22CHAR2
QQI1iSeries: Reserved Field (Database Monitor)QQI1INT44
QQI2iSeries: Reserved Field (Database Monitor)QQI2INT44
QQC301iSeries: Reserved Field (Database Monitor)QQC301CHAR30
QQC302iSeries: Reserved Field (Database Monitor)QQC302CHAR30
QQ1000iSeries: Reserved Field (Database Monitor)QQ1000CHAR255
TOTTIMEiSeries: Total Time (Database Monitor)TOTTIMEDEC8
Privacy Policy