Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Where to find Last Backup details ??

    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 or success ??

    Please show me an example.

    Regards

  2. #2
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Some one gave a clue to check alarm 16

    How do we check alarms, is there any catalog table foe events or alarms ??

    please help !!

  3. #3
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi

    look in the informix log file, and search for messages like this
    Code:
    2011-06-14 14:27:13 Level 0 Archive started on rootdbs, data01, data02
    2011-06-14 14:28:14 Archive on rootdbs, data01, data02 Completed.
    As per the backup methode, you have the choice between ontape and onbar.
    You will find clues of which is being used by looking at the $ONCONFIG file.
    * If the TAPEDEV parameter is filled with an existing device name, except /dev/null, chances are that the method used is ontape.
    * look at the file named by the BAR_ACT_LOG parameter: if you see activity with relevant datetimes, and explicit events, you can say that onbar is used.

    Hope this helps
    Eric

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks, Eric, sure this has helped me.

    This is complete info long awaited.

    Thanks

  5. #5
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    My pleasure :-)

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Mr Eric,

    Thanks for your help, glad that I have written a function to help one of my co-worker dba.

    This place is using onbar via netbackup. I wanted to cover other possibility - ontape.

    Is this possible to find any activity log file for ontape. Or can you sum up few lines in such log file ?

    Best Regards
    Last edited by DBFinder; 12-03-11 at 14:46.

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    BTW,

    My Message log does not have the date part as you indicated. That is making it hard to process.

    rgds

  8. #8
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Mr DBFinder :-)

    Could you post your informix log file ( value of MSGPATH in your $ONCONFIG file) So I can take a look at it?

    If too big, this can be via ftp.

    By the way, what version of IDS do you run?

    Cheers
    Eric

  9. #9
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Attached,

    It was too big , so I truncated.
    Rgds

    Code:
    Sun Jun 13 11:30:29 2004
    
    11:30:29  Checkpoint Completed:  duration was 0 seconds.
    11:30:29  Checkpoint loguniq 10, logpos 0x15b018
    
    11:30:32  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
    11:35:10  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
    11:35:11  Checkpoint Completed:  duration was 0 seconds.
    11:35:11  Checkpoint loguniq 10, logpos 0x15c358
    
    11:55:34  Checkpoint Completed:  duration was 0 seconds.
    11:55:34  Checkpoint loguniq 10, logpos 0x16b018
    
    12:15:46  Checkpoint Completed:  duration was 0 seconds.
    12:15:46  Checkpoint loguniq 10, logpos 0x16c018
    
    
    Sun Jun 20 11:30:29 2004
    
    11:30:29  Checkpoint Completed:  duration was 0 seconds.
    11:30:29  Checkpoint loguniq 10, logpos 0x16d018
    
    11:30:29  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
    11:34:57  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
    11:34:58  Checkpoint Completed:  duration was 0 seconds.
    11:34:58  Checkpoint loguniq 10, logpos 0x16e358
    
    11:55:05  Checkpoint Completed:  duration was 0 seconds.
    11:55:05  Checkpoint loguniq 10, logpos 0x17d018
    
    12:15:17  Checkpoint Completed:  duration was 0 seconds.
    12:15:17  Checkpoint loguniq 10, logpos 0x17e018
    
    
    Sun Jun 27 11:30:31 2004
    
    11:30:31  Checkpoint Completed:  duration was 0 seconds.
    11:30:31  Checkpoint loguniq 10, logpos 0x17f018
    
    11:30:31  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
    11:34:35  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
    11:34:35  Checkpoint Completed:  duration was 0 seconds.
    11:34:35  Checkpoint loguniq 10, logpos 0x180358
    
    11:54:41  Checkpoint Completed:  duration was 0 seconds.
    11:54:41  Checkpoint loguniq 10, logpos 0x18f018
    
    12:14:53  Checkpoint Completed:  duration was 0 seconds.
    12:14:53  Checkpoint loguniq 10, logpos 0x190018
    
    
    Tue Jun 29 15:06:34 2004
    
    15:06:34  Checkpoint Completed:  duration was 0 seconds.
    15:06:34  Checkpoint loguniq 10, logpos 0x227018
    
    15:26:48  Checkpoint Completed:  duration was 0 seconds.
    15:26:48  Checkpoint loguniq 10, logpos 0x231018
    
    15:47:01  Checkpoint Completed:  duration was 0 seconds.
    15:47:01  Checkpoint loguniq 10, logpos 0x232018
    
    
    Wed Jun 30 09:37:58 2004
    
    09:37:58  Checkpoint Completed:  duration was 0 seconds.
    09:37:58  Checkpoint loguniq 10, logpos 0x238018
    
    09:58:11  Checkpoint Completed:  duration was 0 seconds.
    09:58:11  Checkpoint loguniq 10, logpos 0x23b018
    
    10:18:24  Checkpoint Completed:  duration was 0 seconds.
    10:18:24  Checkpoint loguniq 10, logpos 0x23c018
    
    
    Sun Jul  4 11:30:31 2004
    
    11:30:31  Checkpoint Completed:  duration was 0 seconds.
    11:30:31  Checkpoint loguniq 10, logpos 0x23d018
    
    11:30:31  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
    11:34:52  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
    11:34:52  Checkpoint Completed:  duration was 0 seconds.
    11:34:52  Checkpoint loguniq 10, logpos 0x23e358
    
    11:55:12  Checkpoint Completed:  duration was 0 seconds.
    11:55:12  Checkpoint loguniq 10, logpos 0x24d018
    
    12:15:24  Checkpoint Completed:  duration was 0 seconds.
    12:15:24  Checkpoint loguniq 10, logpos 0x24e018
    
    
    Tue Jul  6 10:43:41 2004
    
    10:43:41  Checkpoint Completed:  duration was 0 seconds.
    10:43:41  Checkpoint loguniq 10, logpos 0x25e018
    
    11:03:53  Checkpoint Completed:  duration was 0 seconds.
    11:03:53  Checkpoint loguniq 10, logpos 0x25f018
    
    11:24:05  Checkpoint Completed:  duration was 0 seconds.
    11:24:05  Checkpoint loguniq 10, logpos 0x260018
    
    15:06:27  Checkpoint Completed:  duration was 0 seconds.
    15:06:27  Checkpoint loguniq 10, logpos 0x263018
    
    15:26:40  Checkpoint Completed:  duration was 0 seconds.
    15:26:40  Checkpoint loguniq 10, logpos 0x264018
    
    15:46:46  Checkpoint Completed:  duration was 0 seconds.
    15:46:46  Checkpoint loguniq 10, logpos 0x265018
    
    
    Sun Jul 11 11:30:28 2004
    
    11:30:28  Checkpoint Completed:  duration was 0 seconds.
    11:30:28  Checkpoint loguniq 10, logpos 0x266018
    
    11:30:29  Level 0 Archive started on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11
    11:35:16  Archive on rootdbs, physical, logical, dsc01, dsc02, dsc03, dsc04, dsc05, dsc06, dsc07, dsc09, dsc08, dsc10, dsc11 Completed.
    11:35:16  Checkpoint Completed:  duration was 0 seconds.
    11:35:16  Checkpoint loguniq 10, logpos 0x267358
    
    11:55:29  Checkpoint Completed:  duration was 0 seconds.
    11:55:29  Checkpoint loguniq 10, logpos 0x276018
    
    12:15:41  Checkpoint Completed:  duration was 0 seconds.
    12:15:41  Checkpoint loguniq 10, logpos 0x277018
    
    
    Thu Jul 15 12:54:29 2004
    
    12:54:29  Checkpoint Completed:  duration was 0 seconds.
    12:54:29  Checkpoint loguniq 10, logpos 0x279018
    Attached Files Attached Files

  10. #10
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Code:
    IBM Informix Dynamic Server Version 9.40.FC3     -- On-Line -- Up 30 days 23:32:13 -- 484656 Kbytes

  11. #11
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Code:
    IBM Informix Dynamic Server Version 11.50.FC9DE -- On-Line (CKPT REQ) -- Up 00:00:16 -- 149744 Kbytes
    Blocked:CKPT
    Code:
    Sun Nov 20 21:39:32 2011
    
    21:39:32  Event alarms enabled.  ALARMPROG = '/opt/IBM/informix/etc/alarmprogram.sh'
    21:39:32  Booting Language <c> from module <>
    21:39:32  Loading Module <CNULL>
    21:39:32  Booting Language <builtin> from module <>
    21:39:32  Loading Module <BUILTINNULL>
    21:39:38  DR: DRAUTO is 0 (Off)
    21:39:38  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
    21:39:38  Warning: shared-memory connection file '/INFORMIXTMP/.inf.centos55x64' is overwritten. This file might
     belong to another instance of IDS server. If the service name of the IDS
     database server is not unique in the environment of the host computer where
     the database server resides, rename the service.
    21:39:38  IBM Informix Dynamic Server Version 11.50.FC9DE Software Serial Number AAA#B000000
    21:39:39  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
    
    21:39:39  Started 1 B-tree scanners.
    21:39:39  B-tree scanner threshold set at 5000.
    21:39:39  B-tree scanner range scan size set to -1.
    21:39:39  B-tree scanner ALICE mode set to 6.
    21:39:39  B-tree scanner index compression level set to med.
    21:39:39  Physical Recovery Started at Page (1:7062).
    21:39:39  Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
    21:39:39  Logical Recovery Started.
    21:39:39  10 recovery worker threads will be started.
    21:39:39  Logical Recovery has reached the transaction cleanup phase.
    21:39:39  Checkpoint Completed:  duration was 0 seconds.
    21:39:39  Sun Nov 20 - loguniq 6, logpos 0xe25018, timestamp: 0x7d0ac Interval: 694
    
    21:39:39  Maximum server connections 0 
    21:39:39  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 1
    
    21:39:39  Logical Recovery Complete.
    	  0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
    
    21:39:40  Dataskip is now OFF for all dbspaces
    21:39:41  Checkpoint Completed:  duration was 0 seconds.
    21:39:41  Sun Nov 20 - loguniq 6, logpos 0xe27018, timestamp: 0x7d0c9 Interval: 695
    
    21:39:41  Maximum server connections 0 
    21:39:41  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2
    
    21:39:41  On-Line Mode
    21:39:42  SCHAPI: Started dbScheduler thread.
    21:39:43  Booting Language <spl> from module <>
    21:39:43  Loading Module <SPLNULL>
    21:39:43  SCHAPI: Started 2 dbWorker threads.
    21:39:44  SCHAPI: [Auto Update Statistics Refresh 19-4] Error -206 The specified table (aus_cmd_info) is not in the database.

  12. #12
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Ok,

    with ontape, the only info you'll have are the lines timestamped 11:30:29 and 11:30:29
    ( archive started and archive completed ).
    If errors occur, you should see them with ERROR and archive in the string

    If you don't have the "Archive.*Completed' regexp, you backed has not finished.

    Regarding the date thing, I have my own msgpath parser that builds the complete timestamp ( yyyy-mm-dd HH:MMS ) :-). It is written in Perl

  13. #13
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Cool,

    Thank you.

  14. #14
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    By the way again,

    did you test the 11.70 Innovator-C Edition ( xC4 latest release ), which
    is a free edition for production environment ?

    You will be limited to 4 CPU VPs and 2Gb of shared memory, but this can help...
    No chunk size limits.

    You can find it here:
    You can even download the Ultimate Edition ( no limits at all, except for a period of 30 days I think).

    Maaaany new functionality, general perf enhancement by 30% or more, a really beautiful product!
    And candidate to install the Informix Warehouse Accelerator too...
    Eric
    Last edited by begooden-it; 12-03-11 at 15:40.

  15. #15
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Yes I have downloaded it, but did not install it yet,

    Is there a simple way to connect via remote client. DB2 client is very easy to use.

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •