SAP table SQ1000_RST (iSeries: SQL Information (Database Monitor ))

SAP table SQ1000_RST has 3 primary key fields being SYSID,IPLTIME,QQKEY.

Field Description Data Type Length Decimals Checktable Data Element
SYSID Name of SAP System CHAR 8 0 SYSYSID
IPLTIME Text field length 14 CHAR 14 0 CHAR14
QQKEY iSeries: Key Field (Database Monitor) CHAR 17 0 QQKEY
QQTIME iSeries: Record Creation Timestamp (Database Monitor) CHAR 26 0 QQTIME
QQJOB iSeries: Job Name (Database Monitor) CHAR 10 0 QQJOB
QQUSER iSeries: Job User (Database Monitor) CHAR 10 0 QQUSER
QQJNUM iSeries: Job Number (Database Monitor) CHAR 6 0 QQJNUM
QQUDEF iSeries: User-defined Field (Database Monitor) CHAR 18 0 QUDEF
QQPLIB iSeries: Package/Program Library (Database Monitor) CHAR 10 0 QQPLIB
QQPNAM iSeries: Package/Program Name (Database Monitor) CHAR 10 0 QQPNAM
QQCNAM iSeries: Cursor Name (Database Monitor) CHAR 18 0 QQCNAM
QQSNAM iSeries: Statement Name (Database Monitor) CHAR 18 0 QQSNAM
QQCNT iSeries: No. of Executions of a Statement (Database Monitor) DEC 15 0 QQCNT
QQAVGT iSeries: Average Time (Database Monitor) DEC 15 0 QQAVGT
QQMINT iSeries: Minimum Time (Database Monitor) DEC 15 0 QQMINT
QQMAXT iSeries: Maximum Time (Database Monitor) DEC 15 0 QQMAXT
QQOPNT iSeries: Open time (Database Monitor) DEC 15 0 QQOPNT
QQFETT iSeries: FETCH time (Database Monitor) DEC 15 0 QQFETT
QQCLST iSeries: CLOSE time (Database Monitor) DEC 15 0 QQCLST
QQOTHT iSeries: Any other time (Database Monitor) DEC 15 0 QQOTHT
QQLTU iSeries: Time Last Used (Database Monitor) CHAR 26 0 QQLTU
QQMETU iSeries: Timest. of Most Expensive Stmt. (Database Monitor) CHAR 26 0 QQMETU
QQAPRT iSeries: Timestamp of Access Plan Rebuild (Database Monitor) CHAR 26 0 QQAPRT
QQFULO iSeries: Number of FULL OPENs (Database Monitor) DEC 15 0 QQFULO
QQPSUO iSeries: Number of PSEUDO OPENs (Database Monitor) DEC 15 0 QQPSUO
QQTOTR iSeries: Total Rows in Table (Database Monitor) DEC 15 0 QTOTR
QQRROW iSeries: Result Rows (Database Monitor) DEC 15 0 QQRROW
QQSTF iSeries: Statement Function (Database Monitor) CHAR 1 0 QQSTF
D Delete
I Insert
L DDL
O Other (Commit, Rollback,...)
S Select
U Update
QQSTOP iSeries: Statement Operation (Database Monitor) CHAR 2 0 QQSTOP
QQODPI iSeries: ODP Implementation (Database Monitor) CHAR 1 0 QQODPI
QQHVI iSeries: Host Variable Implementation (Database Monitor) CHAR 1 0 QQHVI
QQAPR iSeries: Reason Code for Access Plan Rebuild CHAR 4 0 QQAPR
QQDACV iSeries: Data Conversion (Database Monitor) CHAR 1 0 QQDACV
QQCTS iSeries: Number of Table Scans (Database Monitor) DEC 15 0 QQCTS
QQCIU iSeries: Index Usage (Database Monitor) DEC 15 0 QQCIU
QQCIC iSeries: Number of Index Creates (Database Monitor) DEC 15 0 QQCIC
QQCSO iSeries: No. of Sorts (Database Monitor) DEC 15 0 QQCSO
QQCTF iSeries: No. of Temporaray File Creates (Database Monitor) DEC 15 0 QQCTF
QQCIA iSeries: Index Advice (Database Monitor) DEC 15 0 QQCIA
QQCAPR iSeries: No of Access Plan Rebuilds (Database Monitor) DEC 15 0 QQCAPR
QQARSS iSeries: Average Result Set Size (Database Monitor) DEC 15 0 QQARSS
QQC11 iSeries: Reserved Field (Database Monitor) CHAR 1 0 QQC11
QQC12 iSeries: Reserved Field (Database Monitor) CHAR 1 0 QQC12
QQC21 iSeries: Reserved Field (Database Monitor) CHAR 2 0 QQC21
QQC22 iSeries: Reserved Field (Database Monitor) CHAR 2 0 QQC22
QQI1 iSeries: Reserved Field (Database Monitor) INT4 10 0 QQI1
QQI2 iSeries: Reserved Field (Database Monitor) INT4 10 0 QQI2
QQC301 iSeries: Reserved Field (Database Monitor) CHAR 30 0 QQC301
QQC302 iSeries: Reserved Field (Database Monitor) CHAR 30 0 QQC302
QQ1000 iSeries: Reserved Field (Database Monitor) CHAR 255 0 QQ1000
TOTTIME iSeries: Total Time (Database Monitor) DEC 15 0 TOTTIME