SQ1000_DB4 is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of SQ1000_DB4 in SAP.
- Table description : iSeries: SQL Information (Database Monitor)
- Module : BC-DB-DB4
- Parent Module : BC
- Package : STU4
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SQ1000_DB4 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| SYSID | Name of SAP System | SYSYSID | SYCHAR08 |
| IPLTIME | Text field length 14 | CHAR14 | CHAR14 |
| QQKEY | iSeries: Key Field (Database Monitor) | QQKEY | QQKEY |
| QQTIME | iSeries: Record Creation Timestamp (Database Monitor) | QQTIME | QQTIME |
| QQJOB | iSeries: Job Name (Database Monitor) | QQJOB | QQJOB |
| QQUSER | iSeries: Job User (Database Monitor) | QQUSER | QQUSER |
| QQJNUM | iSeries: Job Number (Database Monitor) | QQJNUM | QQJNUM |
| QQUDEF | iSeries: User-defined Field (Database Monitor) | QUDEF | QQC18 |
| QQPLIB | iSeries: Package/Program Library (Database Monitor) | QQPLIB | QQC10 |
| QQPNAM | iSeries: Package/Program Name (Database Monitor) | QQPNAM | QQC10 |
| QQCNAM | iSeries: Cursor Name (Database Monitor) | QQCNAM | QQC18 |
| QQSNAM | iSeries: Statement Name (Database Monitor) | QQSNAM | QQC18 |
| QQCNT | iSeries: No. of Executions of a Statement (Database Monitor) | QQCNT | QQDEC150 |
| QQAVGT | iSeries: Average Time (Database Monitor) | QQAVGT | QQDEC150 |
| QQMINT | iSeries: Minimum Time (Database Monitor) | QQMINT | QQDEC150 |
| QQMAXT | iSeries: Maximum Time (Database Monitor) | QQMAXT | QQDEC150 |
| QQOPNT | iSeries: Open time (Database Monitor) | QQOPNT | QQDEC150 |
| QQFETT | iSeries: FETCH time (Database Monitor) | QQFETT | QQDEC150 |
| QQCLST | iSeries: CLOSE time (Database Monitor) | QQCLST | QQDEC150 |
| QQOTHT | iSeries: Any other time (Database Monitor) | QQOTHT | QQDEC150 |
| QQLTU | iSeries: Time Last Used (Database Monitor) | QQLTU | QQTIME |
| QQMETU | iSeries: Timest. of Most Expensive Stmt. (Database Monitor) | QQMETU | QQTIME |
| QQAPRT | iSeries: Timestamp of Access Plan Rebuild (Database Monitor) | QQAPRT | QQTIME |
| QQFULO | iSeries: Number of FULL OPENs (Database Monitor) | QQFULO | QQDEC150 |
| QQPSUO | iSeries: Number of PSEUDO OPENs (Database Monitor) | QQPSUO | QQDEC150 |
| QQTOTR | iSeries: Total Rows in Table (Database Monitor) | QTOTR | QQDEC150 |
| QQRROW | iSeries: Result Rows (Database Monitor) | QQRROW | QQDEC150 |
| QQSTF | iSeries: Statement Function (Database Monitor) | QQSTF | QQSTF |
| QQSTOP | iSeries: Statement Operation (Database Monitor) | QQSTOP | QQC21 |
| QQODPI | iSeries: ODP Implementation (Database Monitor) | QQODPI | QQC11 |
| QQHVI | iSeries: Host Variable Implementation (Database Monitor) | QQHVI | QQC11 |
| QQAPR | iSeries: Reason Code for Access Plan Rebuild | QQAPR | QQC41 |
| QQDACV | iSeries: Data Conversion (Database Monitor) | QQDACV | QQC11 |
| QQCTS | iSeries: Number of Table Scans (Database Monitor) | QQCTS | QQDEC150 |
| QQCIU | iSeries: Index Usage (Database Monitor) | QQCIU | QQDEC150 |
| QQCIC | iSeries: Number of Index Creates (Database Monitor) | QQCIC | QQDEC150 |
| QQCSO | iSeries: No. of Sorts (Database Monitor) | QQCSO | QQDEC150 |
| QQCTF | iSeries: No. of Temporaray File Creates (Database Monitor) | QQCTF | QQDEC150 |
| QQCIA | iSeries: Index Advice (Database Monitor) | QQCIA | QQDEC150 |
| QQCAPR | iSeries: No of Access Plan Rebuilds (Database Monitor) | QQCAPR | QQDEC150 |
| QQARSS | iSeries: Average Result Set Size (Database Monitor) | QQARSS | QQDEC150 |
| QQC11 | iSeries: Reserved Field (Database Monitor) | QQC11 | QQC11 |
| QQC12 | iSeries: Reserved Field (Database Monitor) | QQC12 | QQC12 |
| QQC21 | iSeries: Reserved Field (Database Monitor) | QQC21 | QQC21 |
| QQC22 | iSeries: Reserved Field (Database Monitor) | QQC22 | QQC22 |
| QQI1 | iSeries: Reserved Field (Database Monitor) | QQI1 | QQI1 |
| QQI2 | iSeries: Reserved Field (Database Monitor) | QQI2 | QQI2 |
| QQC301 | iSeries: Reserved Field (Database Monitor) | QQC301 | QQC301 |
| QQC302 | iSeries: Reserved Field (Database Monitor) | QQC302 | |
| QQ1000 | iSeries: Reserved Field (Database Monitor) | QQ1000 | |
| TOTTIME | iSeries: Total Time (Database Monitor) | TOTTIME | QQDEC150 |
SQ1000_DB4 related tables
| Table | Note |
|---|---|
| SQ1000_DB4 | iSeries: SQL Information (Database Monitor) |
| SQ1000_RST | iSeries: SQL Information (Database Monitor ) |
| SQTEXT_DB4 | iSeries: SQL Statement Text (Database Monitor) |
| SQ3000_DB4 | iSeries: Table Scans (Database Monitor) |
| SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) |
| SQ3002_DB4 | iSeries: Created Indexes (Database Monitor) |
| SQ3003_DB4 | iSeries: Sorts (Database Monitor) |
| SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) |
| SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) |
| SQ3008_DB4 | iSeries: Subqueries (Database Monitor) |
| /SDF/SQLHIST | SQL Monitor: Delta records for top SQL statements |
| DB4OX | iSeries: CCMS Object Existence Check |
| DB4_CLUSTER | iSeries: Temporary Statistics Data |
| SQHVAR_DB4 | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. |
| AMSK | SQL trace header info in application monitor |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP