IBM Informix数据库系统日常监控操作技术手册1・监控数据库系统软件的逻辑日志文件是否正常被备份, 防止出现当逻辑日志文件满了而没备份导致数据库停机；使用onstat -1命令监控逻辑口志的使用，监控输出中的Flag标志字段，注 意第位，如果是'・'，则表明此逻辑日志没有备份该标识位的详细描述如下：Describes the status of the I-ogical Ix)g using the following coded values:Position 1:AFUPosition 3:BPosition 5:CPosition 7:LNewly addedFree logUsed logBacked upCurrently active logContains last checkpoint record如果数据库系统采用Onbar进行系统的备份和恢复，也可以直接监控 $INFORMIXDIR/etc/ixbar.servernum日志文件，观察目前备份的状态2. 监控数据库的数据库磁盘空间；IBM Informix数据库系统的数据存储空间成为dbspace,毎个dbspace可以 包括多个chunkso使用如卜命令可以监控到某个dbspacece中chunk的空间使用情况：oncheck -pe dbspace_name输出入下:DBspace Usage Report: dataspaceChunk Pathname8 /home/informix/1 DS940/datachk 1DescriptionOwner: informix Created: 09/29/2005Free447SizeSize500Used53OffsetRESERVED PAGES02CHUNK FREELIST PAGE21testzengz'infbnnix'.TBLSpace350FREE5344753Total Used:Total Free: 447Chunk PathnameSizeUsedFree10 /home/informix/IDS940/datachk2500034997DescriptionOffsetSizeRESERVED PAGES09CHUNK FREELIST PAGB21FREE34997Total Used: 3Total Free: 4997通过监控dbspace中每个chunk的Total Used和Total Free,可以知道目前 数据库系统实际对磁盘空间的占用情况。
注意，Total Used和Total Free是以数 据页为单位的3. 监控数据库系统中锁资源的占用情况；通过onstat-k命令监控数据库系统中锁资源的占用情况，具体的输出如下:LocksaddresswtlistownerIklisttypetbls numrowidkey#/bsiza03b5280a14d6b40s1000022020a03b5540a14d6b4a03b6e0HDR+X600023402K- 1a03b5ac0a14d6b4a03b6b4HDR+X600020302K- 1a03b5d80a14d6b4a03b630HDR+X6000234030a03b6040a14c5e40S1000022020a03b6300a14d6b4a03b840HDR+X600023402K-3a03b65c0a14d2800s1000022020a03b688a14ca18a14dae8a03bef4HDR+U60001f30a0a03b6b4a14d280a14d6b4a03c264HDR+X6000203020a03b6e00a14d6b4a03c41cHDR+X6000234020a03b70c0a14d6b4a03bbb0HDR+X600023403K-3a03b7380a14c5e4a03b604IX60002000a03b7640a14d280a03b65cIX60002000a03b7900a14ce4c0s1000022020a03b7bc0a14ca180s1000022020a03b7e80a14ca18a03b7bcIX60001f00a03b8140a14bd7c0S100002 2020a03b8400a14d6b4a03b554HDR+X600023 402K・2a03b86c0a14bd7ca03b814IX600020 00a03b8980a14c1b00s1000022020a03b9f80a14d6b4a03b5d8HDR+X600023403K- 1a03bbb00a14d6b4a03b9f8HDR+X600023403K-2a03bd680a14dae80HDR+S1000022020a03bef40a14dae8a03bd68HDR+IX60001f00a03c0ac0a14d6b4a03b5acHDR+X600020302K-2a03c2640a14d6b4a03b528HDR+IX60002000a03c41c0a14d6b4a03c0acHDR+IX6000230027 active, 2000 total, 2048 hash buckets详细的描述如下:Column HeadingColumn DescriptionSee AlsoaddressTh© in-memor}T address of the lock structure・wtlistThe address of the first userthread waiting for this lock.onstat -uownerThe address corresponding to the userthread which holds this lock.on stat -uIklistThe address of the next lock owned by this userthread・ A zero indicates the end of the list.缈eDescribes the type of lock being held using one or more of the following coded values:HDR HeaderB Bvte lockJS SharedX ExclusiveI IntentU UpdateIX Intent exclusiveIS Intent sharedSIX Shared, intent exclusivetblsnumThe tablespace number fc)r the item that is locked・Tblspace Numbers Database TblspacerowidTh© rowid, page or 0, within the tblspace upon which the lock is held・ROWIDTh© index key number or the number of bytes locked for a VARCHAR.4. 监控数据库系统中内存的占用情况；通过onstat -g seg和onstat -g mem命令监控数据库系统对内存的使用, 其中，onstat-g seg显示的是对共享内存短的使用情况。
Segment Summary:(resident segments are not locked)idkey addr sizeovhaclassblkusedblkfree74001381648385aOOOOOO999424824R118474011381648386a0f40008192000720V44455672021381648387a8c4000573440604M673描述信息如下:COLUMN DEFINITIONSColumn HeadingColumn DescriptionSee AlsoidThe shared memory identifier returned froin the call to shmgctQ for acquiring shared memory- segments・keyThe key passed to shmget()? based on the value of SERVERNUM.addrThe in-memory address of the shared memory segmen匸sizeThe size of the shared memory segment in bytes.OvhdThe number of bytes of overhead within this segment required to track information.ClassThe segment type for this block of shared memoryr・R ResidentV VirtualM MessageBlkusedThe number of 8I< blocks in the segment that have bccn used.BlkfreeThe number of 8K blocks remaining in the segment.onstat-g mem显示内存池的详细使用情况，如下:Pool Summary:name class addr totalsize freesize #allocfrag #freefragreside ntRa0020105324801011222res-buffRa0840104259841420822globalVa0f601023756810。