1325 - 使用 Sysmaster 数据库管理和优化 IBM Informix 服务器.pdf

1、International Informix User Group We speak InformixOrlando,FLOctober 69IBM TechXchange2025Session ID:1325Session Title:Managing and Optimizing the IBM Informix Server using the Sysmaster DatabaseLester KnutsenRetired DBA,Advanced DataTools CorporationLester Knutsen Retired DBALester Knutsen is a ret

2、ired DBA.Lester was Founder and President of Advanced DataTools Corporation and has built and managed Informix database systems since 1983.Lester is an Informix IBM Lifetime Champion.Lester was one of the founders of the Washington Area Informix User Group and the International Informix Users G703-2

3、56-02672How to use the Sysmaster Database to measure the health and performance of your IBM Informix Server.3Agenda What is the Sysmaster Database?How do we measure the basic CPU and IO levels of the Server?What indexes are needed?How can we fit more tables into memory?How can we reduce the Buffer c

4、hurn rate?How do we monitor Memory usage?How do we monitor Database Statistics?Extra Scripts45What is the Sysmaster Database?A database that peeks intothe shared memory structuresof an INFORMIX-Dynamic ServerScript to create the Sysmaster Database:$INFORMIXDIR/etc/sysmaster.sqlSysmaster Documentatio

5、nhttps:/ to Create the Sysmaster Database$INFORMIXDIR/etc/sysmaster.sql78PagePagePagePagePagePagePagePageResident Memory SegmentVirtual Memory SegmentMessage Memory SegmentInformix Control Structures in Memory are the Sysmaster DatabaseLRULRULRULRUControl Structures Sysmaster DatabaseDictionary cach

6、eWorking StorageSort SpacePageSame Data as Onstatonstat-p9Sysmasterselect*from sysprofile 1011Sysmaster Database Contains:Server information Dbspace&chunk information Database&table information User session information Currently running SQL12Performance of Queries on Sysmaster DatabaseThe data is in