Optional database monitor SQL view format
These examples show the different optional SQL view format that you can create with the SQL shown. The column descriptions are explained in the tables following each example. These views are not shipped with the system, and you must create them, if you choose to do so. These views are optional and are not required for analyzing monitor data.
Any rows that have a row identification number (QQRID) of 5000 or greater are for internal database use.
- Database monitor view 1000 - SQL Information
Displays the SQL logical view format for database monitor QQQ1000. - Database monitor view 3000 - Table Scan
Displays the SQL logical view format for database monitor QQQ3000 - Database monitor view 3001 - Index Used
Displays the SQL logical view format for database monitor QQQ3001 - Database monitor view 3002 - Index Created
Displays the SQL logical view format for database monitor QQQ3002. - Database monitor view 3003 - Query Sort
Displays the SQL logical view format for database monitor QQQ3003. - Database monitor view 3004 - Temp Table
Displays the SQL logical view format for database monitor QQQ3004. - Database monitor view 3005 - Table Locked
Displays the SQL logical view format for database monitor QQQ3005. - Database monitor view 3006 - Access Plan Rebuilt
Displays the SQL logical view format for database monitor QQQ3006. - Database monitor view 3007 - Optimizer Timed Out
Displays the SQL logical view format for database monitor QQQ3007. - Database monitor view 3008 - Subquery Processing
Displays the SQL logical view format for database monitor QQQ3008. - Database monitor view 3010 - Host Variable & ODP Implementation
Displays the SQL logical view format for database monitor QQQ3010. - Database monitor view 3011 - Array Host Variables
Displays the SQL logical view format for database monitor QQQ3011. - Database monitor view 3012 - Global Variables
Displays the SQL logical view format for database monitor QQQ3012. - Database monitor view 3014 - Generic QQ Information
Displays the SQL logical view format for database monitor QQQ3014. - Database monitor view 3015 - Statistics Information
Displays the SQL logical view format for database monitor QQQ3015. - Database monitor view 3018 - STRDBMON/ENDDBMON
Displays the SQL logical view format for database monitor QQQ3018. - Database monitor view 3019 - Rows retrieved
Displays the SQL logical view format for database monitor QQQ3019. - Database monitor view 3020 - Index advised (SQE)
Displays the SQL logical view format for database monitor QQQ3020. - Database monitor view 3021 - Bitmap Created
Displays the SQL logical view format for database monitor QQQ3021. - Database monitor view 3022 - Bitmap Merge
Displays the SQL logical view format for database monitor QQQ3022 - Database monitor view 3023 - Temp Hash Table Created
Displays the SQL logical view format for database monitor QQQ3023. - Database monitor view 3025 - Distinct Processing
Displays the SQL logical view format for database monitor QQQ3025. - Database monitor view 3026 - Set operation
Displays the SQL logical view format for database monitor QQQ3026. - Database monitor view 3027 - Subquery Merge
Displays the SQL logical view format for database monitor QQQ3027. - Database monitor view 3028 - Grouping
Displays the SQL logical view format for database monitor QQQ3028. - Database monitor view 3030 - Materialized query tables
Displays the SQL logical view format for database monitor QQQ3030. - Database monitor view 3031 - Recursive common table expressions
Displays the SQL logical view format for database monitor QQQ3031.
Parent topic: Database monitor formats