Abstract: INFORMIX is one of the most popular database in finance industry in China. Its configure parameters have important influence on its performance. According the result of inspect INFORMIX performance on the data warehouse system of the commercial bank, some faults in performance of INFORMIX data warehouse system are found out through a long time monitor. The paper takes some measures of system optimization in virtual process, share memory, and data extraction. The performance of the system is improved by optimization, because the method of analysis and process question is universality, and it is worthy of reference to similar system.

Key words: INFORMIX, performance monitor, system optimization

摘要： INFORMIX是国内金融行业使用最多的大型数据库之一，其配置参数对系统性能有重要影响。该文针对某省商业银行数据仓库系统性能存在的问题，通过对INFORMIX性能监测，确定系统瓶颈，并在此基础上，给出了在虚拟处理器、共享内存、查询优化器、数据抽取方面的优化措施。实践表明，通过调优使系统性能得到了明显改善。该文中提出的分析与处理问题的方法具有一定的通用性，所采取的优化策略对类似系统具有借鉴意义。

关键词: INFORMIX数据库, 性能监控, 系统优化

CLC Number: 

• TP391