您将发现,与用于关系数据和索引的已有的计数器相对应,DB 2 9为XML数据提供了新的缓冲池快照监视器元素。
You will find that DB2 9 offers new buffer pool snapshot monitor elements for XML data that match the existing counters for relational data and indexes.
问题查询:这些查询只返回超过重要性能计数器阈值的行,例如缓冲池命中率不到90%的行。
Problem queries: These queries return only rows that exceed thresholds for important performance counters, for example, rows with buffer pool hit ratio lower than 90%.
然后再将寄存器127用作循环计数器,将寄存器126用作基指针,并在每个值上执行convert _ to_upper,直到到达缓冲区的底部为止。
You then use register 127 as your loop counter and register 126 as your base pointer, and perform convert_to_upper on each value until you get to the end of the buffer.
应用推荐