OLTP applications should not be performing large sorts.
OLTP应用程序不应该执行大型排序。
As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.
作为OLTP应用程序的经验法则,可在多个设备上使用dms表空间。
For this reason, bitmap indexes are not appropriate for many OLTP applications.
因为这个原因,位图索引不适合于OLTP应用。
Some fine tuning to the logger to make it more efficient and to improve the performance of OLTP applications.
对logger的微调,以使得它更高效,并提高OLTP应用程序的性能。
For OLTP applications, there should be less sorting and temp space required and only a handful of concurrent cursors opened at a time.
对于OLTP应用程序,所需的排序和临时空间会比较少,一次只打开少数并发游标。
For OLTP applications, it is very important to place the log files on a separate physical device where their high activity will not negatively impact other work on the same hard disk drive.
对于OLTP应用程序,将日志文件放置在单独的物理设备上是极其重要的,因为这样它们的频繁活动就不会给在同一硬盘驱动器上的其他工作带来不良影响。
DB2 tuning is outside the scope of this article, but you can refer to DB2 tuning Tips for OLTP Applications and the Administering section of the DB2 information Center for more information.
DB 2调优超出了本文的范围,但您可以参考oltp应用程序的DB 2调优技巧和DB 2信息中心的Administering部分了解更多信息。
Batch and query applications typically do a lot of sequential processing, while data access for OLTP tends to be more random in nature.
批处理和查询应用程序通常要进行大量的顺序处理,而用于OLTP的数据访问往往更具有随机性。
This includes both OLTP and Data Warehouse applications.
这包括OLTP和数据仓库应用程序。
Sequential Numbers are often used in OLTP-like applications to generate primary keys required by the relational model.
连续数字在oltp类应用程序中常常用于生成关系模型所需的主键。
Sequential scans are typical in decision support system (DSS) applications but rare with OLTP access patterns.
顺序扫描一般在决策支持系统(DSS)应用程序中很常见,但很少出现在OLTP访问模式中。
TXSeries for Multiplatforms is a distributed CICS (Customer Information Control System) Online Transaction Processing (OLTP) environment for mixed language applications.
TXSeriesfor Multiplatforms是一个用于混合语言应用程序的分布式CICS(客户信息控制系统)在线事务处理 (OLTP)环境。
For example, OLTP-like applications would typically benefit from smaller pages sizes since operations tend to be quick updates a single row retrievals.
例如,诸如oltp的应用程序一般受益于较小的页面大小,因为操作趋向于为快速更新单行检索。
Online transaction processing (OLTP) systems are used by applications to record transactional information in real time.
在线事务处理(OLTP)系统,是应用程序用来记录实时事务信息的。
Online transaction processing (OLTP) systems are used by applications to record transactional information in real time.
在线事务处理(OLTP)系统,是应用程序用来记录实时事务信息的。
应用推荐