If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > "Informix mirror"

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-11-02, 23:29
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Question "Informix mirror"

I'm adding an extra chunk for mirroring my roodbs dbspace. The problem is that how can I know that the mirror dbspace is really synchronizing with the rootdbs?
Reply With Quote
  #2 (permalink)  
Old 11-15-02, 01:38
dananio dananio is offline
Registered User
 
Join Date: Mar 2002
Posts: 112
re

from mirror concept , put in data in a time it go into 2 disks synchronously if you want to proof the mirror concept you have to delete the link that point to rootdbses' chunk if mirror bring up and system continue working , it's ok
Reply With Quote
  #3 (permalink)  
Old 11-16-02, 00:50
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Re: re

After I've created the chunk, it has been tested ok. My point is that is there any command to see where the current chunk size is same with the mirror chunk to get accurate answer for syncronizing. I tried to use 'onstat -d' and 'onstat -D' but in -d I don't understand why the free in mirror chunk is zero. In -D I don't understand the 'page Rd and pageWr'. Pls Advice. THanks
Reply With Quote
  #4 (permalink)  
Old 11-22-02, 14:35
tn5353 tn5353 is offline
Registered User
 
Join Date: Nov 2002
Posts: 10
Re: re

Basically, the onstat -D shows how many pages had been written and read from that chunk since the database has been onlined. You can check the write number to see is there any increment. This way, for sure data is being updated.
I also use the onstat -Dr and using the grep command to get the only chunks I am looking at for my data performance.

Quote:
Originally posted by sengchoon
After I've created the chunk, it has been tested ok. My point is that is there any command to see where the current chunk size is same with the mirror chunk to get accurate answer for syncronizing. I tried to use 'onstat -d' and 'onstat -D' but in -d I don't understand why the free in mirror chunk is zero. In -D I don't understand the 'page Rd and pageWr'. Pls Advice. THanks
Reply With Quote
  #5 (permalink)  
Old 11-22-02, 23:11
sengchoon sengchoon is offline
Registered User
 
Join Date: Aug 2002
Posts: 21
Re: re

Actually, I'm trying to write a script to compare the size of the main dbspaces cunk with mirror chunk so that i now that whether the mirror chunk really have whatever that is inside main dbspace. mybe an example like current main dbspace free size = 100000KB and mirror chunk free size = 90000KB. In this case, I will know that the mirror chunk is still have 10000KB to synchronize with main dbspace. That's why I'm trying to find out the command to check mirror chunk.


Quote:
Originally posted by tn5353
Basically, the onstat -D shows how many pages had been written and read from that chunk since the database has been onlined. You can check the write number to see is there any increment. This way, for sure data is being updated.
I also use the onstat -Dr and using the grep command to get the only chunks I am looking at for my data performance.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On