suche 36x36

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
News ÜbersichtNews Übersicht
News Übersicht
Informix NewsInformix News
Informix News
Scout NewsblogScout Newsblog
Scout Newsblog
NewsletterNewsletter
Newsletter
News ArchivNews Archiv
News Archiv