2196 - 主动式 Informix 管理.pdf

1、#2196Proactive Informix AdministrationMike W8 October 2025Keep Things Running!Monitor instances Take proactive action Administration Performance Operations not failing1Informix Engine Limitations Maximums Max pages/partition Serial value Max number of rows Limits vary by versionhttps:/ Release notes

2、($INFORMIXDIR/release/en_us/0333)Be proactive!2Maximum Data Pages Maximum data pages per partition:16,775,134 Index pages per partition:2,147,483,6473WARNING:partition xxxxx:no more pagespartition xxxxx:no more extentsMaximum Data Pages Once the maximum pages allocated,will still be room to add rows

3、 until used space is hits maximum Once all the space is used,cannot add more rows application failures Space released when rows deleted wont show in pages used Use Art Kagels printfreeB utility to see how many free pages4Maximum Data PagesCheck number of pages used and number of extents with:oncheck

4、-pt 5TBLspace Report for xxxxprd:xxx_adm.xxxxxxxx_history Physical Address 6:99541955 Creation date 11/01/2019 07:25:25 TBLspace Flags 902 Row Locking TBLspace contains VARCHARS TBLspace use 4 bit bit-maps Maximum row size 428 Number of special columns 7 Number of keys 0 Number of extents 82 Current

5、 serial value 1 Current SERIAL8 value 1 Current BIGSERIAL value 1 Current REFID value 1 Pagesize(k)2 First extent size 8 Next extent size 2097152 Number of pages allocated 16777215 Number of pages used 16536578 Number of data pages 16388726 Number of rows 165214781 Partition partnum 6301036 Partitio

6、n lockid 6301036Maximum Data Pages6select first 5 n.dbsname1,10,n.tabname1,20,i.ti_nptotal np_total,round(i.ti_nptotal/16777215)*100,1)perc_fullfrom systabnames n,systabinfo iwhere n.partnum=i.ti_partnumorder by 3 desc;dbsname tabname np_total np_used perc_maxxxxxprd xx_history 16777215 16536578 100