- 论坛徽章:
- 0
|
online.log内容
18:11:58 Assert Failed: Memory block header corruption detected in mt_shm_free 1
18:11:58 Informix Dynamic Server Version 7.31.UD1
18:11:58 Who: Session(3624, informix@137c001f, 1228, 713364840)
Thread(3666, sqlexec, 2a82cad8, 1)
File: mtshpool.c Line: 2794
18:11:58 Results: Pool repaired
18:11:58 Action: Please notify Informix Technical Support.
18:12:00 See Also: /tmp/af.123a8eed, shmem.123a8eed.0
18:12:20 Assert Failed: Memory block header corruption detected in mt_shm_malloc_segid 2
18:12:20 Informix Dynamic Server Version 7.31.UD1
18:12:20 Who: Session(3624, informix@137c001f, 1228, 713364840)
Thread(3666, sqlexec, 2a82cad8, 1)
File: mtshpool.c Line: 2794
18:12:20 Results: Pool repaired
18:12:20 Action: Please notify Informix Technical Support.
18:12:22 See Also: /tmp/af.123a8eed, shmem.123a8eed.1
18:12:24 Assert Failed: Memory block header corruption detected in mt_shm_malloc_segid 2
18:12:24 Informix Dynamic Server Version 7.31.UD1
18:12:24 Who: Session(3624, informix@137c001f, 1228, 713364840)
Thread(3666, sqlexec, 2a82cad8, 1)
File: mtshpool.c Line: 2794
18:12:24 Results: Unable to repair pool
18:12:24 Action: Please notify Informix Technical Support.
18:12:26 See Also: /tmp/af.123a8eed, shmem.123a8eed.2
af.文件内容
18:11:58 Found during mt_shm_free 1
18:11:58 Pool '3624' (0x2afaa014)
18:11:58 Bad block header 0x2b3643fc
blk-64
2b3643bc: 00000000 00000000 00000000 00000000 ........ ........
2b3643cc *
2b3643dc: ffffffff 00000000 00000000 00000000 ........ ........
2b3643ec: 00000000 00000000 00000000 00000000 ........ ........
blk+64
2b3643fc: 34343132 31343031 3032362b fc030000 44121401 026+....
2b36440c: f58b6c56 1440362b 00000000 2c43362b ..lV.@6+ ....,C6+
2b36441c: 00000000 00000000 00000000 00000000 ........ ........
2b36442c *
18:11:58 Bad block removed from pool
18:11:58
18:11:58 Informix Dynamic Server Version 7.31.UD1 Software Serial Number AAD#J222610
18:11:58 Assert Failed: Memory block header corruption detected in mt_shm_free 1
18:11:58 Who: Session(3624, informix@137c001f, 1228, 713364840)
Thread(3666, sqlexec, 2a82cad8, 1)
File: mtshpool.c Line: 2794
18:11:58 Results: Pool repaired
18:11:58 Action: Please notify Informix Technical Support.
---------------------------------
Begin System Alarm Program Output
---------------------------------
Assertion Failure Type: FAILURE
Host Name: GD-JM-EP-XZ-SERVER
Database Server Name: jhsy
Time of failure: Mon Sep 19 18:11:58 CST 2005
AF file: /tmp/af.123a8eed
Shared memory file: None
System Blocking: OFF
===========------------- - - - - - -
tail -100 /opt/informix/online.log:
18:11:58 Assert Failed: Memory block header corruption detected in mt_shm_free 1
18:11:58 Informix Dynamic Server Version 7.31.UD1
18:11:58 Who: Session(3624, informix@137c001f, 1228, 713364840)
Thread(3666, sqlexec, 2a82cad8, 1)
File: mtshpool.c Line: 2794
18:11:58 Results: Pool repaired
18:11:58 Action: Please notify Informix Technical Support.
===========------------- - - - - - -
/opt/informix/bin/onstat -g ath:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:49 -- 458384 Kbytes
Threads:
tid tcb rstcb prty status vp-class name
2 2a7db538 0 2 sleeping forever 3lio lio vp 0
3 2a7db7b4 0 2 sleeping forever 4pio pio vp 0
4 2a7dba30 0 2 sleeping forever 5aio aio vp 0
5 2a7dbcac 0 2 sleeping forever 6msc msc vp 0
6 2a7e2124 0 2 sleeping forever 7aio aio vp 1
7 2a7e231c 2a828014 4 ready 1cpu main_loop()
8 2a7e2534 0 2 running 8soc soctcppoll
9 2a7e27b0 0 3 sleeping forever 1cpu soctcplst
10 2a7e2a7c 2a828510 2 sleeping forever 1cpu flush_sub(0)
11 2a7e2cfc 0 2 sleeping forever 9aio aio vp 2
12 2a7e2f78 0 2 sleeping forever 10aio aio vp 3
13 2a7e31f4 0 2 sleeping forever 11aio aio vp 4
14 2a7e3470 0 2 sleeping forever 12aio aio vp 5
15 2a7e36ec 0 2 sleeping forever 13aio aio vp 6
16 2a7e3968 0 2 sleeping forever 14aio aio vp 7
17 2a7e3be4 0 2 sleeping forever 15aio aio vp 8
18 2a7e3e60 0 2 sleeping forever 16aio aio vp 9
19 2a80303c 0 2 sleeping forever 17aio aio vp 10
20 2a8032b8 0 2 sleeping forever 18aio aio vp 11
21 2a803534 0 2 sleeping forever 19aio aio vp 12
22 2a8037b0 0 2 sleeping forever 20aio aio vp 13
23 2a803a2c 0 2 sleeping forever 21aio aio vp 14
24 2a803ca8 0 2 sleeping forever 22aio aio vp 15
25 2a825844 0 2 sleeping forever 23aio aio vp 16
26 2a825a3c 0 2 sleeping forever 24aio aio vp 17
27 2a825c54 0 2 sleeping forever 25aio aio vp 18
28 2a825ed0 0 2 sleeping forever 26aio aio vp 19
29 2acee26c 2a828a0c 3 sleeping forever 1cpu aslogflush
30 2acee4e8 2a828f08 2 sleeping secs: 23 1cpu btclean
46 2ad203a0 2a829dfc 4 ready 1cpu onmode_mon
3315 2aef63a0 2a82a7f4 2 cond wait netnorm 1cpu sqlexec
3377 2af6e124 2a82d4d0 2 cond wait netnorm 1cpu sqlexec
3520 2af3e3a0 2a82c0e0 2 cond wait netnorm 1cpu sqlexec
3530 2af2661c 2a82dec8 2 cond wait netnorm 1cpu sqlexec
3534 2ae7e124 2a829404 2 cond wait netnorm 1cpu sqlexec
3553 2af0e61c 2a82f2b8 2 cond wait netnorm 1cpu sqlexec
3555 2ad68124 2a82edbc 2 cond wait netnorm 1cpu sqlexec
3624 2af26898 2a82d9cc 2 cond wait netnorm 1cpu sqlexec
3644 2af6a534 2a82a2f8 2 cond wait netnorm 1cpu sqlexec
3662 2af76124 2a82f7b4 2 cond wait netnorm 1cpu sqlexec
*3666 2ada0124 2a82cad8 2 running 1cpu sqlexec
===========------------- - - - - - -
/opt/informix/bin/onstat -g stk 3666 light:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:49 -- 458384 Kbytes
Stack for thread: 3666 sqlexec
base: 0x2b4e0000
len: 40960
pc: 0x08348506
tos: 0x2b4e962c
state: running
vp: 1
0x08348506 (oninit)mt_system(0x2b4e9a80, 0x85223e5, 0x2afaa014, 0x8521abf, 0x2b4e9980, 0x2a85156
0x0835ebb6 (oninit)afhandler(0x2, 0x2b4e9cd4, 0x85223e5, 0x2b0577cc, 0x1, 0x852246e)
0x0835e6cf (oninit)affail_interface(0x2b4e9cd4, 0x85223e5, 0x2b0577cc, 0x852246e, 0xaea, 0x2afaa060)
0x08358623 (oninit)recover_pool_bad_block(0x2afaa014, 0x2b3643fc, 0x8521abf, 0x1, 0x2b364014, 0x2afaa014)
0x08356c75 (oninit)mt_shm_free(0x2afaa014, 0x2b364410, 0x2, 0x2b4ed1f4, 0x2b4e9fa0, 0x8321b31)
0x08321b59 (oninit)do_rhpfree(0x2b36401c, 0x2afaa014, 0x2b4e9fbc, 0x8195831, 0x2b36401c, 0x2b4ed1f4)
0x08321b31 (oninit)rhpfree (0x2b36401c, 0x2b4ed1f4, 0xb, 0x4, 0x401a2a00, 0x2b4e9fc
0x08195831 (oninit)releasesdb(0x2b4ed1f4, 0x2b4e9fe4, 0x81792d9, 0xa, 0x7, 0x0)
0x0816ea26 (oninit)sq_release(0xa, 0x7, 0x0, 0x0, 0x2b5bf208, 0x2b4e9ff
0x081792d9 (oninit)sqmain (0x0, 0x0, 0x0, 0x0, 0x0, 0xffffffff)
0x08349d69 (oninit)startup (0xffffffff, 0x2b4ea044, 0x2b35e000, 0x2000, 0x5684a045, 0x2b4ea03
0x00000000 (***nosymtab***)0x0
===========------------- - - - - - -
/opt/informix/bin/onstat -u:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
2a828014 ---P--D 1 root - 0 0 0 151 1798
2a828510 ---P--F 0 root - 0 0 0 0 5006
2a828a0c ---P--- 5 root - 0 0 0 0 42
2a828f08 ---P--B 6 root - 0 0 0 0 0
2a829404 Y--P--- 3492 informix JHSY1 2b289444 0 1 0 0
2a829dfc ---P--D 9 root - 0 0 0 0 0
2a82a2f8 Y-BP--- 3602 informix 华仔 2b34c410 0 5 1186 482
2a82a7f4 Y--P--- 3273 informix CHERRY 2b34dd08 0 1 30 0
2a82c0e0 Y--P--- 3478 informix ZY-XERDL 2b34c09c 0 1 0 0
2a82cad8 ---P---*3624 informix 222-8V0E 0 0 2 35 0
2a82d4d0 Y-BP--- 3335 informix THREE 2b34cd18 0 3 39 132
2a82d9cc Y--P--- 3582 informix 222-8V0E 2b34dfb0 0 1 12 0
2a82dec8 Y--P--- 3488 informix A2 2b34cc4c 0 1 2 0
2a82edbc Y--P--- 3513 informix 222-8V0E 2b34d950 0 1 0 0
2a82f2b8 Y-BP--- 3511 informix ZY-XERDL 2b34d6a8 0 4 44 33
2a82f7b4 Y--P--- 3620 informix GD 2b34d2ac 0 1 60 0
16 active, 128 total, 30 maximum concurrent
===========------------- - - - - - -
/opt/informix/bin/onstat -g ses 3624:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
3624 informix 222-8V0E 1228 137c001f 1 180224 45208
tid name rstcb flags curstk status
3666 sqlexec 2a82cad8 ---P--- 2516 running
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
3624 V 2afaa014 180224 135016 600 29
name free used name free used
overhead 0 108 scb 0 80
opentable 0 2484 filetable 0 616
ru 0 220 log 0 2148
temprec 0 3900 keys 0 140
ralloc 0 1020 gentcb 0 7724
ostcb 0 2592 sort 0 52
sqscb 0 20484 rdahead 0 148
hashfiletab 0 276 osenv 0 416
sqtcb 0 1628 fragman 0 152
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
3624 SELECT jhsy3 CR Not Wait 0 0 9.24
Current statement name : pbb1a0882
Current SQL statement :
select cj_name from cjfl where trim ( cjdm ) =substr ( trim ( ? ) , 1 , 10
)
Last parsed SQL statement :
select cj_name from cjfl where trim ( cjdm ) =substr ( trim ( ? ) , 1 , 10
)
===========------------- - - - - - -
/opt/informix/bin/onstat -g sql 3624:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
3624 SELECT jhsy3 CR Not Wait 0 0 9.24
Current statement name : pbb1a0882
Current SQL statement :
select cj_name from cjfl where trim ( cjdm ) =substr ( trim ( ? ) , 1 , 10
)
Last parsed SQL statement :
select cj_name from cjfl where trim ( cjdm ) =substr ( trim ( ? ) , 1 , 10
)
===========------------- - - - - - -
/opt/informix/bin/onstat -c:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Configuration File: /opt/informix/etc/onconfig.jhsy
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /opt/informix/data/rootdbs
# Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 2000000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 1000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 22 # Number of logical log files
LOGSIZE 500 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
ALARMPROGRAM /opt/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS 1
# System Archive Tape Device
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 102400 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /dev/null # Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 102400 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME jhsy # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,1,20,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 1 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 200000 # Maximum number of locks
BUFFERS 200000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 64 # Physical log buffer size (Kbytes)
LOGBUFF 64 # Logical log buffer size (Kbytes)
LOGSMAX 32 # Maximum number of logical log files
CLEANERS 1 # Number of buffer cleaner processes
SHMBASE 0x10000000 # Shared memory base address
SHMVIRTSIZE 8000 # initial virtual shared memory segment size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>;unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
# To determine the page size used by Dynamic Server on your platform
# see the last line of output from the command, 'onstat -b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker threads
ON_RECVRY_THREADS 1 # Default number of online worker threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 30 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /opt/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables
CDR_LOGBUFFERS 2048 # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR queue (Kbytes)
CDR_LOGDELTA 30 # % of log space allowed in queue memory
CDR_NUMCONNECT 16 # Expected connections per server
CDR_NIFRETRY 300 # Connection retry (seconds)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
# Backup/Restore variables
BAR_ACT_LOG /opt/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
# Informix Storage Manager variables
ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to
# update $INFORMIXDIR/bin/onbar. Change to
# ism_catalog -create_bootstrap -pool <new name>;
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group
# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic Server)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off # List of dbspaces to skip
# OPTCOMPIND
# 0 =>; Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 =>; If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 =>; Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
LBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 =>; Heterogeneous Commit is enabled
# 0 (or any other value) =>; Heterogeneous Commit is disabled
HETERO_COMMIT 0
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES 1
# Status of restartable restore
RESTARTABLE_RESTORE off
===========------------- - - - - - -
/opt/informix/bin/onstat -s:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Latches with lock or userthread set
name address lock wait userthread
===========------------- - - - - - -
/opt/informix/bin/onstat -k:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
1011dda4 0 2a82f7b4 0 HDR+S 100002 204 0
1011ddd8 0 2a82f2b8 1011eb74 HDR+S 100002 201 0
1011de74 0 2a82a2f8 1011ea08 HDR+X 10026d 12400 0
1011e0b0 0 2a82f2b8 1011ec78 HDR+X 100144 41cd00 0
1011e0e4 0 2a82d4d0 1011e354 HDR+X 100144 41c900 0
1011e2ec 0 2a82d4d0 0 S 100002 204 0
1011e354 0 2a82d4d0 1011e2ec IX 100144 0 0
1011e660 0 2a82c0e0 0 S 100002 204 0
1011e694 0 2a82a2f8 1011de74 HDR+X 10026d 12300 1
1011e6c8 0 2a82cad8 0 S 100002 204 0
1011e730 0 2a82d9cc 0 S 100002 204 0
1011e798 0 2a82a7f4 0 S 100002 204 0
1011e7cc 0 2a82a2f8 1011e694 IS 100045 0 0
1011e938 0 2a82cad8 1011e6c8 HDR+IS 100045 0 0
1011ea08 0 2a82a2f8 1011ed14 HDR+IX 10026d 0 0
1011eaa4 0 2a82edbc 0 S 100002 204 0
1011eb74 0 2a82f2b8 0 S 100002 204 0
1011ec78 0 2a82f2b8 1011ddd8 HDR+IX 100144 0 0
1011ed14 0 2a82a2f8 0 S 100002 204 0
1011ee80 0 2a829404 0 S 100002 204 0
1011ef1c 0 2a82dec8 0 S 100002 204 0
21 active, 200000 total, 65536 hash buckets
===========------------- - - - - - -
/opt/informix/bin/onstat -b:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Buffers
address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
0 modified, 0 resident, 200000 total, 262144 hash buckets, 2048 buffer size
===========------------- - - - - - -
/opt/informix/bin/onstat -t:
Informix Dynamic Server Version 7.31.UD1 -- On-Line -- Up 2 days 04:56:50 -- 458384 Kbytes
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident
1 2b322204 8 1 1a 0 0 0 0 0 0 0
2 2b322014 8 1 28 0 0 0 0 0 0 0
4 2a827a40 0 1 100001 10000e 750 730 0 0 15 0
6 2afd6014 0 1 100003 100010 24 20 10 175 3 0
25 2afd6318 0 11 10002e 10003b 56 53 32 565 7 0
52 2b07e118 0 3 10004b 101b50 61757 61757 54696 108071 1 0
64 2b09de10 0 2 100057 101b5c 30653 30653 21834 193015 1 0
73 2b142f30 0 2 100096 100ca0 39885 39664 27023 158167 1 0
456 2b05acc4 0 3 100215 186a29 23624 23293 19821 138741 118 0
493 2b284ae8 0 1 10023b 186c27 15448 15432 12970 373803 64 0
578 2a827dd8 0 1 200001 200004 50 31 0 0 1 0
579 2a85b628 0 1 300001 300004 50 2 0 0 1 0
580 2a85b8f4 0 1 400001 400004 50 2 0 0 1 0
13 active, 580 total |
|
免费注册
发表于 2005-09-19 19:36
