need to know when was a dbspace went down.

Posted in 2011

JACK PAPA — Mon, 24 Jan 2011 11:22:29 — source: IIUG Forums & Mailing Lists

Hi All, I would like to know when my dbspace went down... I didn't find from the log... is there a way i can find from the systables? 70dc0318 10 10 0 524287 0 PD-- /chunks/chunks024_device0000 70dc0498 11 10 0 524287 0 PD-- /chunks/chunks024_dat0102 70dc0918 14 13 0 512048 0 PD-- /chunks/chunks024_dat0000_0000 70dc0a98 15 10 0 524287 0 PD-- /chunks/chunks024_dat0103 70dc1018 18 10 1 524286 0 PD-- /chunks/chunks024_dat0104 70dc1a98 25 13 1 524286 0 PD-- /chunks/chunks024_dat000002 70dc1c18 26 10 1 524286 0 PD-- /chunks/chunks024_dat0105 70dc1d98 27 10 0 512000 0 PD-- /chunks/chunks024_dat0106

↪ replying to JACK PAPA

Art Kagel — Mon, 24 Jan 2011 15:22:05 — source: IIUG Forums & Mailing Lists

There SHOULD be messages in the MSGPATH log. That's the only way to know when from inside informix. Try querying the system logs since it may have been an OS error that caused the chunks to be marked down. Art On Jan 24, 2011 4:22 AM, "JACK PAPA" <informix2009@gmail.com> wrote: > Hi All, > > I would like to know when my dbspace went down... I didn't find from the > log... is there a way i can find from the systables? > > 70dc0318 10 10 0 524287 0 PD-- /chunks/chunks024_device0000 > 70dc0498 11 10 0 524287 0 PD-- /chunks/chunks024_dat0102 > 70dc0918 14 13 0 512048 0 PD-- /chunks/chunks024_dat0000_0000 > 70dc0a98 15 10 0 524287 0 PD-- /chunks/chunks024_dat0103 > 70dc1018 18 10 1 524286 0 PD-- /chunks/chunks024_dat0104 > 70dc1a98 25 13 1 524286 0 PD-- /chunks/chunks024_dat000002 > 70dc1c18 26 10 1 524286 0 PD-- /chunks/chunks024_dat0105 > 70dc1d98 27 10 0 512000 0 PD-- /chunks/chunks024_dat0106 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --20cf3054a5b17116ec049a9929c0

Glossary

dbspace