数据库监视器视图 3025-相异处理
显示数据库监视器 QQQ3025的 SQL 逻辑视图格式。
Create View QQQ3025 as
(SELECT QQRID as Row_ID,
QQTIME as Time_Created,
QQJFLD as Join_Column,
QQRDBN as Relational_Database_Name,
QQSYS as System_Name,
QQJOB as Job_Name,
QQUSER as Job_User,
QQJNUM as Job_Number,
QQI9 as Thread_ID,
QQUCNT as Unique_Count,
QQUDEF as User_Defined,
QQQDTN as Unique_SubSelect_Number,
QQQDTL as SubSelect_Nested_Level,
QQMATN as Materialized_View_Subselect_Number,
QQMATL as Materialized_View_Nested_Level,
QVP15E as Materialized_View_Union_Level,
QVP15A as Decomposed_Subselect_Number,
QVP15B as Total_Number_Decomposed_SubSelects,
QVP15C as Decomposed_SubSelect_Reason_Code,
QVP15D as Starting_Decomposed_SubSelect,
QVRCNT as Unique_Refresh_Counter,
QVPARPF as Parallel_Prefetch,
QVPARPL as Parallel_PreLoad,
QVPARD as Parallel_Degree_Requested,
QVPARU as Parallel_Degree_Used,
QVPARRC as Parallel_Degree_Reason_Code,
QQEPT as Estimated_Processing_Time,
QVCTIM as Estimated_Cumulative_Time,
QQREST as Estimated_Rows_Selected,
QQSMINTF as Plan_Iteration_Number
FROM UserLib/DBMONTable
WHERE QQRID=3025)
| 视图列名 | 表列名 | 描述 |
|---|---|---|
| 行标识 | QQRID | 行标识 |
| TIME_CREATED | QQTIME | 创建时间行 |
| 连接列 | QQJFLD | 连接列 (每个作业唯一) |
| 关系数据库名称 | QQRDBN | 关系数据库名 |
| System_name | QQSYS | 系统名称 |
| JOB_NAME | QQJOB | 作业名 |
| 作业用户 | QQUSER | 作业用户 |
| 作业号 | QQJNUM | 作业号 |
| 线程标识 | QQI9 | 线程标识 |
| 唯一计数 | QQUCNT | 唯一计数 (每个查询唯一) |
| 用户定义 | QQUDEF | 用户 定义 列 |
| Unique_SubSelect_Number | QQQDTN | 唯一子查询号 |
| SubSelect_Nested_Level | QQQDTL | 子查询 嵌套 级别 |
| 具体化 View_Subselect_Number | QQMATN | 具体化视图子查询号 |
| 具体化视区 _ 内斯泰德级 | QQMATL | 具体化视图嵌套级别 |
| 具体视图统一级别 | QVP15E | 具体化视图并集级别 |
| 分解-子选择号 | QVP15A | 分解的查询子查询号,在所有分解的子查询中唯一 |
| Total_Number_Decomposed_SubSelects | QVP15B | 分解的子选择总数 |
| Decomposed_SubSelect_Reason_Code | QVP15C | 分解的查询子选择原因码 |
| Starting_Decomposed_SubSelect | QVP15D | 第一个分解子查询的分解查询子查询号 |
| 唯一刷新计数器 | QVRCNT | 唯一刷新计数器 |
| 并行预取 | QVPARPF | 并行预取 (Y/N) |
| Parallel_PreLoad | QVPARPL | 并行预装入 (已使用索引) |
| 并行 Degree_requested | QVPARD | 已请求并行度 (已使用索引) |
| 已使用的并行设备 | QVPARU | 已使用并行度 (已使用索引) |
| 并行 Degree_Reason_Code | QVPARRC | 并行处理受限的原因 (已使用索引) |
| 估算处理时间 | QQEPT | 估算的处理时间 (以秒计) |
| 估算累积时间 | QVCTIM | 估计累积时间 (以秒计) |
| 已选择 estimated_Rows_Selected | QQREST | 估计的选择行数 |
| 计划迭代次数 | QQSMINTF | AQP 计划迭代次数,原始优化 = 1 |