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

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
    369 Posts
    ACCEPTED ANSWER

    Re: Informix Last Backup Success Details ??

    ‏2011-11-24T10:52:00Z  in response to Sarbjit_Singh_Gill
    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
      ACCEPTED ANSWER

      Re: Informix Last Backup Success Details ??

      ‏2011-11-24T15:25:04Z  in response to andreasl
      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
        369 Posts
        ACCEPTED ANSWER

        Re: Informix Last Backup Success Details ??

        ‏2011-11-24T15:46:54Z  in response to Sarbjit_Singh_Gill
        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
        369 Posts
        ACCEPTED ANSWER

        Re: Informix Last Backup Success Details ??

        ‏2011-11-24T15:48:13Z  in response to Sarbjit_Singh_Gill
        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
          ACCEPTED ANSWER

          Re: Informix Last Backup Success Details ??

          ‏2011-11-26T15:40:55Z  in response to andreasl
          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
            369 Posts
            ACCEPTED ANSWER

            Re: Informix Last Backup Success Details ??

            ‏2011-12-01T09:48:38Z  in response to Sarbjit_Singh_Gill
            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