- 论坛徽章:
- 0
|
informix数据怎么恢复!!!!
RSAM Version 5.01.UD3 -- Fast Recovery (CKPT REQ) -- Up 01:54:04 -- 9904 Kbytes
Message Log File: /usr/informix/online.log
Files are Full -- Backup is Needed
10:29:41 Logical Log Files are Full -- Backup is Needed
10:29:42 Logical Log Files are Full -- Backup is Needed
10:29:43 Logical Log Files are Full -- Backup is Needed
10:29:44 Logical Log Files are Full -- Backup is Needed
10:29:45 Logical Log Files are Full -- Backup is Needed
10:29:46 Logical Log Files are Full -- Backup is Needed
10:29:47 Logical Log Files are Full -- Backup is Needed
10:29:48 Logical Log Files are Full -- Backup is Needed
Configuration File: /usr/informix/etc/tbconfig
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: tbconfig.std
# Sccsid: @(#)tbconfig.std 9.1.1.1 1/11/92 19:15:16
# Description: INFORMIX-OnLine Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /usr/informix/rootdbs # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 500000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing root dbspace mirror
MIRROROFFSET 0 # Offset into mirror device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Name of dbspace that contains physical log
PHYSFILE 20000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 10000 # Size of each logical log file (Kbytes)
# Message Files
MSGPATH /usr/informix/online.log # OnLine message log pathname
CONSOLE /dev/null # System console message pathname
# Archive Tape Device
TAPEDEV /dev/null # Archive tape device pathname
TAPEBLK 16 # Archive tape block size (Kbytes)
TAPESIZE 150000 # Max amount of data to put on tape (Kbytes)
# Logical Log Backup Tape Device
LTAPEDEV /dev/null # Logical log tape device pathname
LTAPEBLK 16 # Logical log tape block size (Kbytes)
LTAPESIZE 150000 # Max amount of data to put on log tape (Kbytes)
# Identification Parameters
SERVERNUM 0 # Unique id associated with this OnLine instance
DBSERVERNAME online # Unique name of this OnLine instance
# Shared Memory Parameters
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
USERS 50 # Maximum number of concurrent user processes
TRANSACTIONS 50 # Maximum number of concurrent transactions
LOCKS 2000 # Maximum number of locks
BUFFERS 4000 # Maximum number of shared memory buffers
TBLSPACES 500 # Maximum number of active tblspaces
CHUNKS 8 # Maximum number of chunks
DBSPACES 8 # Maximum number of dbspaces and blobspaces
PHYSBUFF 128 # Size of physical log buffers (Kbytes)
LOGBUFF 128 # Size of logical log buffers (Kbytes)
LOGSMAX 12 # Maximum number of logical log files
CLEANERS 1 # Number of page-cleaner processes
SHMBASE 0x0 # Shared memory base address
CKPTINTVL 300 # Checkpoint interval (in seconds)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent)
LTXHWM 80 # Long TX high-water mark (percent)
LTXEHWM 90 # Long TX exclusive high-water mark (percent)
# Machine- and Product-Specific Parameters
DYNSHMSZ 0 # Dynamic shared memory size (Kbytes)
GTRID_CMP_SZ 32 # Number of bytes to use in GTRID comparision
DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env.
TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)
SPINCNT 0 # No. of times process tries for latch
STAGEBLOB # Reserved for INFORMIX-OnLine/Optical
# System Page Size
BUFFSIZE 2048 # Page size (do not change!)
Users
address flags pid user tty wait tout locks nreads nwrites
800019f0 ------D 1993 informix tty03 0 0 0 6 2
80001a60 ------D 0 informix tty03 0 0 0 0 0
80001ad0 ------F 1994 informix 0 0 0 0 0
80001b40 --B---- 0 0 0 0 0 0
80001bb0 S-A-X-M 1997 informix tty03 80001474 0 0 0 0
80001c20 S-----M 2160 informix ttyp0 80001474 0 0 0 0
6 active, 50 total
Transactions
address flags user locks log begin isolation retrys coordinator
80002fd0 A---- 800019f0 0 0 NOTRANS 0
80003370 A---- 80001a60 0 0 NOTRANS 0
80003710 A-B-- 80001b40 0 37 COMMIT 0
80003ab0 A---- 80001bb0 0 0 COMMIT 0
80003e50 A---- 80001c20 0 0 COMMIT 0
5 active, 50 total
Latches with lock or user set
name address lock wait user
loglog 80001474 1 1 800019f0
Locks
address wtlist owner lklist type tblsnum rowid size
0 active, 2000 total, 128 hash buckets
Buffers
address user flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
0 modified, 4000 total, 4096 hash buckets, 2048 buffer size
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
0 80020c90 1 1 1000001 10000e 5005 318 0 0 1
1 80020d90 1 1 1000002 10000f 4 3 1 6 1
2 active, 500 total, 128 hash buckets
Dbspaces
address number flags fchunk nchunks flags owner name
8000e9d0 1 1 1 1 N informix rootdbs
1 active, 8 total
Chunks
address chk/dbs offset size free bpages flags pathname
8000e510 1 1 0 250000 81353 PO- /usr/informix/rootdbs
1 active, 8 total
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 64 0 0 0.00
phybegin physize phypos phyused %used
10139a 10000 4510 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 1 64 2 1 1 2.0 1.0
address number flags uniqid begin size used %used
80041fd0 1 U-B---- 37 103aaa 5000 5000 100.00
80041fec 2 U-B---- 38 104e32 5000 5000 100.00
80042008 3 U-B---- 39 1061ba 5000 5000 100.00
80042024 4 U-B---- 40 107542 5000 5000 100.00
80042040 5 U-B---- 41 1088ca 5000 5000 100.00
8004205c 6 U---C-L 42 109c52 5000 5000 100.00
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
11 15 27 59.26 4 5 2 0.00
isamtot open start read write rewrite delete commit rollbk
15 3 3 3 0 1 0 0 0
ovtbls ovlock ovuser ovbuff usercpu syscpu numckpts flushes
0 0 0 0 0.03 0.10 1 3
bufwaits lokwaits lockreqs deadlks dltouts lchwaits ckpwaits compress
0 0 0 0 0 2 0 0 |
|
免费注册
楼主: dsjyb
发表于 2003-06-10 10:00
