Topic
  • 7 replies
  • Latest Post - ‏2011-12-02T00:32:42Z by Sarbjit_Singh_Gill
Sarbjit_Singh_Gill
Sarbjit_Singh_Gill
9 Posts

Pinned topic Informix Last Backup Success Details ??

‏2011-11-24T10:08:00Z |
Hello All,

Can some one help me find info about most recent backup whether success or failure.

I really don't know what backup method is being used; but is there a way to find alert log entries indicating a failure.

Please show me an example.

Regards
Updated on 2011-12-02T00:32:42Z at 2011-12-02T00:32:42Z by Sarbjit_Singh_Gill
  • andreasl
    andreasl
    383 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-11-24T10:52:00Z  
    Hello,

    you could look into the database server message log (MSGPATH onconfig parameter) for an "Archive on ...space_list... Completed" message (which could also end on "with <n> corrupted pages detected", so this still would be a successfull backup).

    Programatically you could use alarm 16 (s.a. Event alarm IDs).

    HTH,
    Andreas
  • Sarbjit_Singh_Gill
    Sarbjit_Singh_Gill
    9 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-11-24T15:25:04Z  
    • andreasl
    • ‏2011-11-24T10:52:00Z
    Hello,

    you could look into the database server message log (MSGPATH onconfig parameter) for an "Archive on ...space_list... Completed" message (which could also end on "with <n> corrupted pages detected", so this still would be a successfull backup).

    Programatically you could use alarm 16 (s.a. Event alarm IDs).

    HTH,
    Andreas
    Great, my friend,Andreas

    Sure this helped me. Being originally from DB2, currently stuck in informix, just accepetd to help someone on informix.

    How does informix do REORG on tables and indexes. I mean defrag.
    Any clue or link is needed.

    Regards
  • andreasl
    andreasl
    383 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-11-24T15:46:54Z  
    Great, my friend,Andreas

    Sure this helped me. Being originally from DB2, currently stuck in informix, just accepetd to help someone on informix.

    How does informix do REORG on tables and indexes. I mean defrag.
    Any clue or link is needed.

    Regards
    Just search for 'defrag' in the docs, the might serve as a starting point.

    If not on Informix 11.70 (but 11.50 at least), you'd be limitted to 'repack' and 'shrink' which can achieve a similar combined result.

    HTH,
    Andreas
  • andreasl
    andreasl
    383 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-11-24T15:48:13Z  
    Great, my friend,Andreas

    Sure this helped me. Being originally from DB2, currently stuck in informix, just accepetd to help someone on informix.

    How does informix do REORG on tables and indexes. I mean defrag.
    Any clue or link is needed.

    Regards
    Just search for 'defrag' in the docs, the Whats new in Informix 11.70 page might serve as a starting point.

    If not on Informix 11.70 (but 11.50 at least), you'd be limitted to 'repack' and 'shrink' which can achieve a similar combined result.

    HTH,
    Andreas
  • Sarbjit_Singh_Gill
    Sarbjit_Singh_Gill
    9 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-11-26T15:40:55Z  
    • andreasl
    • ‏2011-11-24T15:48:13Z
    Just search for 'defrag' in the docs, the Whats new in Informix 11.70 page might serve as a starting point.

    If not on Informix 11.70 (but 11.50 at least), you'd be limitted to 'repack' and 'shrink' which can achieve a similar combined result.

    HTH,
    Andreas
    Thanks,

    but my versions are 7, 9 and 10.

    so only way seems to unload the data, recreate the table and load the data back.

    regards
  • andreasl
    andreasl
    383 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-12-01T09:48:38Z  
    Thanks,

    but my versions are 7, 9 and 10.

    so only way seems to unload the data, recreate the table and load the data back.

    regards
    Oh yes, then you're bound to more traditional ways of reorganizing your tables. One more alternative would be the ALTER FRAGMENT ... INIT IN ... statement that wouldn't save you the hassle of taking the table 'offline', but would do all the copying/dropping/recreating for you.

    Don't forget to include/alter extent sizing from the beginning ;-)

    HTH,
    Andreas
  • Sarbjit_Singh_Gill
    Sarbjit_Singh_Gill
    9 Posts

    Re: Informix Last Backup Success Details ??

    ‏2011-12-02T00:32:42Z  
    • andreasl
    • ‏2011-12-01T09:48:38Z
    Oh yes, then you're bound to more traditional ways of reorganizing your tables. One more alternative would be the ALTER FRAGMENT ... INIT IN ... statement that wouldn't save you the hassle of taking the table 'offline', but would do all the copying/dropping/recreating for you.

    Don't forget to include/alter extent sizing from the beginning ;-)

    HTH,
    Andreas
    Ok, Thanks,

    Sarbjit