Creating indexes for better performance with IBM TSOM historical queries.
通过创建索引提高IBMTSOM历史数据查询性能。
The following examples show you how to switch to the login context of a DB2 instance owner named tsom.
下面的例子将介绍如何切换到一个名为tsom 的DB2实例拥有者登录上下文。
However, if you see any problem related to applheapsz, you can dynamically modify it later without affecting the working of IBM TSOM.
然而,如果您遇到任何与 applheapsz 有关的问题,您可以在之后在不影响IBMTSOM工作的情况下动态地修改它。
However, you should use 64 bit IBM DB2 with IBM TSOM, because a 64 bit installation better addresses memory than a 32-bit installation.
然而,您应该使用64位IBMDB 2作为IBMTSOM数据库,因为64位数据库比32位数据库能够更好地处理内存。
The following DB2 command shows output that includes the current setting of these parameters, with tsom as the database name used by IBM tsom.
以下的DB 2命令显示输出包括了这些参数的当前设置,其中tsom是IBM tsom所使用的数据库名。
All tables in the database are created in the default table space USERSPACE1, and buffer pool IBMDEFAULTBP in the default installation of IBM TSOM.
数据库的所有表都是在IBMTSOM默认安装的默认表空间userspace1和缓冲池IBMDEFAULTBP中创建的。
IBM TSOM depends on the underlying database management system for functions like correlation, configuration, historical searches, and report generation.
IBMTSOM是依靠底层的数据库管理系统来实现诸如相关性分析、配置、历史搜索和生成报表等功能。
The following sections show different aspects of performance tuning that you must take into account when you configure IBM DB2 for optimal usage with IBM TSOM.
下面的章节将介绍您在配置IBMDB2以实现最优的 IBM TSOM 所需要的各个方面性能优化操作。
By default all the different IBM TSOM tables are created in the default table space, so you should use a separate table space for event data and event table indexes.
默认情况下,不同的IBMtsom表是在默认表空间创建的,所以您应该使用另一个表空间来存储事件数据和事件表索引。
IBM TSOM USES range partitioning for event tables, so you can detach a partition, archive the detached partition on an external storage, or drop the detached partition.
IBMTSOM使用范围分区实现事件表,所以您可以分离一个分区,将分离的分区保存在一个外部存储上,或者删除所分离的分区。
IBM TSOM USES range partitioning for event tables, so you can detach a partition, archive the detached partition on an external storage, or drop the detached partition.
IBMTSOM使用范围分区实现事件表,所以您可以分离一个分区,将分离的分区保存在一个外部存储上,或者删除所分离的分区。
应用推荐