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