SQ3004_DB4 - iSeries: Temporary Files (Database Monitor)

iSeries: Temporary Files (Database Monitor) information is stored in SAP table SQ3004_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 SQ3004_DB4

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SYSIDName of SAP SystemXSYSYSIDCHAR8SQ1000_DB4
IPLTIMEText field length 14XCHAR14CHAR14
QQKEYiSeries: Key Field (Database Monitor)XQQKEYCHAR17
QQKEY2iSeries: 2nd Key Field of Database Monitor FilesXQQKEY2DEC8
QQTIMEiSeries: Record Creation Timestamp (Database Monitor)QQTIMECHAR26
QQQDTNiSeries: Query Definition Template NumberQQDTNDEC8
QQQDTLiSeries: Query Definition Template LevelQQDTLDEC8
QQMATNiSeries: Mat. QDT Number (Database Monitor)QMATNDEC8
QQMATLiSeries: Mat. QDT Level (Database Monitor)QMATLDEC8
QQTLNiSeries: System Name of Library (Database Monitor)QQTLNCHAR10
QQTFNiSeries: System Name of Table (Database Monitor)QTFNCHAR30*
QQTTIMiSeries: Create Time of Temporary Table (Database Monitor)QQTTIM_TFDEC8
QQTMPRiSeries: Rows in Temporary Table (Database Monitor)QTMPRDEC8
QQDFVLiSeries: Default Values in Temp. Table (Database Monitor)QQDFVLCHAR1
QQRCODiSeries: Reason Code for Temp. Table (Database Monitor)QQRCODTMFCHAR2
QQLTLNiSeries: Library Name (Database Monitor)QQLTLNCHAR128
QQLTFNiSeries: Table Name (Database Monitor)QQLTFNCHAR128
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
Privacy Policy