Wie ermittelt man die Chunks/Dbspaces, wenn der Server nicht läuft?
Das Kommando
oncheck -pr
liefert nach einer Wartezeit von ca. 1 Minute eine Ausgabe der Form:
shared memory not initialized for INFORMIXSERVER 'ol_1150_0'
Validating IBM Informix Dynamic Server reserved pages
Validating PAGE_PZERO...
Identity IBM Informix Dynamic Server Copyright 2001, 2008 IBM Corporation.
Database system state 0
Database system flags 0x2
Page Size 4096 (b)
Date/Time created 07/17/2008 10:08:18
Version number of creator 16
Last modified time stamp 0
Index Page Logging OFF
HA Disk Owner <null>
Validating PAGE_CONFIG...
ROOTNAME rootdbs
ROOTPATH C:IFMXDATAol_1150_0
ootdbs_dat.000
ROOTOFFSET 0 (k)
ROOTSIZE 204800 (k)
MIRROR 0
MIRRORPATH
MIRROROFFSET 0 (k)
DB_LIBRARY_PATH
JVPHOME C:PROGRA~1IDS11.50extendkrakatoa
JVPJAVAHOME C:PROGRA~1IDS11.50extendkrakatoajre
JVPJAVAVM jsig;dbgmalloc;hpi;jvm;java;net;zip;jpeg
JVPLOGFILE C:PROGRA~1IDS11.50extendkrakatoaol_1150_0_jvp.log
JVPPROPFILE C:PROGRA~1IDS11.50extendkrakatoa.jvpprops_ol_1150_0
JVPJAVALIB in
JDKVERSION 1.4
JVMTHREAD green
JVPCLASSPATH C:PROGRA~1IDS11.50extendkrakatoakrakatoa.jar; C:PROGRA~1IDS11.50extendkrakatoajdbc.jar
JVPDEBUG 0
PHYSFILE 40000 (k)
LOGFILES 12
LOGSIZE 10000 (k)
MSGPATH C:PROGRA~1IDS11.50ol_1150_0.log
CONSOLE C:PROGRA~1IDS11.50conol_1150_0.log
TAPEDEV c:\tmp\tape TAPEBLK 16 (k)
TAPESIZE 0 (k) LTAPEDEV c:\tmp\tape2
LTAPEBLK 16 (k) LTAPESIZE 0 (k)
DBSERVERNAME ol_1150_0
SERVERNUM 0
DEADLOCK_TIMEOUT 60 (s)
RESIDENT 0 LOCKS 20000
BUFFERPOOL size=4K,buffers=10000,lrus=8, lru_min_dirty=50.000000,lru_max_dirty=60.000000
PHYSBUFF 128 (k)
LOGBUFF 64 (k)
...
Validating PAGE_1CKPT & PAGE_2CKPT...
Using check point page PAGE_2CKPT.
Time stamp of checkpoint 0x1fa9001
Time of checkpoint 05/20/2009 15:13:31
Physical log begin address 5:55030
Physical log size 10000 (p)
Physical log position at Ckpt 2378
Logical log unique identifier 247
Logical log position at Ckpt 0x446044 (Page 1094, byte 68)
Checkpoint Interval 12701
DBspace descriptor page 1:4
Chunk descriptor page 1:6
Mirror chunk descriptor page 1:8
Log file number 1
Unique identifier 237
Log file flags 0x15 Log file in use
& Log file has been backed up
& Log written to archive tape
Physical location 1:12763
Log size 2500 (p)
Number pages used 2500
Date/Time file filled 04/20/2009 08:05:52
Time stamp 0x1eca104
Log file number 2
Unique identifier 238
Log file flags 0x15 Log file in use
& Log file has been backed up
& Log written to archive tape
Physical location 1:15263
Log size 2500 (p)
Number pages used 2500
Date/Time file filled 04/21/2009 08:04:36
Time stamp 0x1edefe4
Log file number 3
Unique identifier 239
Log file flags 0x5 Log file in use
& Log file has been backed up
Physical location 1:17763
Log size 2500 (p)
Number pages used 2500
Date/Time file filled 04/30/2009 08:01:53
Time stamp 0x1efa690 ...
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_1DBSP.
DBspace number 1
DBspace name rootdbs Flags 0x40001
No mirror chunks
Number of chunks 2
First chunk 1
Date/Time created 07/17/2008 10:08:19
Partition table page number 14
Pagesize (k) 4
Logical Log Unique Id 102
Logical Log Position 0x2d526c
Oldest Logical Log Unique Id 247
Last Logical Log Unique Id -1
Time of last physical restore 12/18/2008 12:17:22
DBspace archive status Archive Level 0
Real Time Archive Began 04/21/2009 12:21:14
Time Stamp Archive Began 32418323
Logical Log Unique Id 239
Logical Log Position 0x31d298
DBspace number 2 DBspace name dat01
Flags 0x40001
No mirror chunks
Number of chunks 2
First chunk 2
Date/Time created 07/17/2008 10:12:16
Partition table page number 4
Pagesize (k) 4
Logical Log Unique Id 102
Logical Log Position 0x2d526c
Oldest Logical Log Unique Id 247
Last Logical Log Unique Id -1
Time of last physical restore 12/18/2008 12:17:22
DBspace archive status Archive Level 0
Real Time Archive Began 04/21/2009 12:21:14
Time Stamp Archive Began 32418323
Logical Log Unique Id 239
Logical Log Position 0x31d298 ...
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_1PCHUNK.
Chunk number 1 Flags 0x30040
Chunk is online Chunk path C:IFMXDATAol_1150_0
ootdbs_dat.000
Chunk offset 0 (p)
Chunk size 51200 (p)
Number of free pages 19584
DBspace number 1
Next chunk in DBspace 6
Chunk number 2
Flags 0x30040
Chunk is online
Chunk path c:/IFMXDATA/ol_1150_0/ol_1150_0_dat.000
Chunk offset 0 (p)
Chunk size 7500 (p)
Number of free pages 0
DBspace number 2
Next chunk in DBspace 5
Chunk number 3
Flags 0x34040
Chunk is online & Part of an sbspace
Chunk path C:/IFMXDATA/ol_1150_0/sbs.000
Chunk offset 0 (p)
Chunk size 1000 (p)
Number of free pages 56
DBspace number 3
Chunk number 4
Flags 0x30040
Chunk is online
Chunk path C:/IFMXDATA/ol_1150_0/cdrdbs.000
Chunk offset 0 (p) Chunk size 750 (p)
Number of free pages 3
DBspace number 4
Next chunk in DBspace 7 ...
Diese Ausgabe besteht aus mehreren Teilen:
- allgemeine Informationen über den Datenbankserver
- Information zu Logical Logs
- Information zu den Dbspaces in dieser Instanz
- Information zu den Chunks
- Information zur letzen Sicherung jedes DBSpaces

















