论坛 › Informix › 请教贴 onstat -u

foxyzhou 发表于 2010-01-07 17:42

请教贴 onstat -u

onstat-u 输出结果中第二栏位的旗标各个字母所代表的含义？

liaosnet 发表于 2010-01-07 22:00

原帖由 foxyzhou 于 2010-1-7 17:42 发表 http://bbs3.chinaunix.net/images/common/back.gif
onstat-u 输出结果中第二栏位的旗标各个字母所代表的含义？


Describes the status of the userthread using the following coded values:

Position 1:
        B        Waiting on a buffer
        C        Waiting on a checkpoint
        G        Waiting on write of the Logical Log                         buffer
        L        Waiting on a lock
        S        Waiting on a mutex
        T        Waiting on a transaction
        X        Waiting on a transaction cleanup
        Y        Waiting on a condition

Position 3:
        A        DBSpace backup thread
        B        Begin work
        P        Preparing/prepared
        X        XA prepare
        C        Commiting/committed
        R        Aborting/aborted
        H        Heuristic aborting/aborted

Position 4:
        P        Primary thread for a session

Position 5:
        R        Reading (RSAM Call)
        X        Critical Write

Position 7:
        B        BTree clean thread
        C        Terminated user thread waiting for                         cleanup
        D        Daemon thread
        F        Page cleaner thread (flusher)
        M        On-Monitor thread

foxyzhou 发表于 2010-01-08 11:04

THANKS

查看完整版本: 请教贴 onstat -u