ADSM-L

Re: Query Event for Previous day shows status In Progress

2003-11-05 11:05:46
Subject: Re: Query Event for Previous day shows status In Progress
From: James Choate <jchoate AT SOURCE1INC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 5 Nov 2003 09:05:01 -0700
I guess I should rephrase the question.
 
Can someone tell me what the when I query an event what in-progress in the 
status column means?  
 
This isn't making much sense to me.  For example, today I queried the events 
for my nt_backups.  I queried my events for the past 3 days.  The output seem 
to indicate that the event is still in progress.  I have attached the schedule 
and the output from the query events, but I still don't understand what 
in-progress means from 2 days ago??
 
 
tsm: TSM>q event * nt_backups begind=today-3  begint=00:00  endd=today
 
Scheduled Start      Actual Start         Schedule Name Node Name     Status   
-------------------- -------------------- ------------- ------------- ---------
11/02/03   22:30:00  11/02/03   23:14:38  NT_BACKUPS    IBS           Completed
11/02/03   22:30:00  11/02/03   22:30:17  NT_BACKUPS    FS_VSI        Completed
11/02/03   22:30:00  11/02/03   22:30:18  NT_BACKUPS    PLUS_2000     Completed
11/02/03   22:30:00  11/02/03   22:30:22  NT_BACKUPS    ID_CARD       Completed
11/02/03   22:30:00  11/02/03   22:30:26  NT_BACKUPS    FS_DEVII      Completed
11/02/03   22:30:00                       NT_BACKUPS    FIRSTPLACE    Missed   
11/02/03   22:30:00  11/02/03   22:40:30  NT_BACKUPS    POWERFAIDS    Completed
11/02/03   22:30:00  11/02/03   22:30:16  NT_BACKUPS    TPG           Completed
11/02/03   22:30:00  11/02/03   22:30:14  NT_BACKUPS    FS_VSJ        Completed
11/02/03   22:30:00  11/02/03   22:30:15  NT_BACKUPS    FS-HEAT       Completed
11/02/03   22:30:00  11/02/03   22:30:11  NT_BACKUPS    FS-LIB        Completed
11/02/03   22:30:00  11/02/03   22:30:12  NT_BACKUPS    TNVOICE       Completed
11/02/03   22:30:00  11/02/03   22:30:08  NT_BACKUPS    FS_ACT        Completed
11/02/03   22:30:00  11/02/03   23:02:55  NT_BACKUPS    MERLIN2       Completed
11/02/03   22:30:00  11/02/03   22:30:07  NT_BACKUPS    MERCYWEBSRV   Completed
11/02/03   22:30:00  11/02/03   22:43:10  NT_BACKUPS    W2KDC         Completed
11/02/03   22:30:00                       NT_BACKUPS    W2K-GC1       Missed   
11/02/03   22:30:00  11/02/03   22:30:02  NT_BACKUPS    FS-XTD        Completed
11/03/03   22:30:00  11/03/03   22:45:00  NT_BACKUPS    IBS           In Progr-
                                                                      ess     
11/03/03   22:30:00  11/04/03   00:18:12  NT_BACKUPS    FS_VSI        Completed
11/03/03   22:30:00  11/03/03   22:30:41  NT_BACKUPS    PLUS_2000     In Progr-
                                                                       ess     
11/03/03   22:30:00  11/04/03   00:15:34  NT_BACKUPS    ID_CARD       Completed
11/03/03   22:30:00  11/04/03   00:16:36  NT_BACKUPS    FS_DEVII      Completed
11/03/03   22:30:00                       NT_BACKUPS    FIRSTPLACE    Missed   
11/03/03   22:30:00  11/04/03   00:15:41  NT_BACKUPS    POWERFAIDS    Completed
11/03/03   22:30:00  11/04/03   00:15:44  NT_BACKUPS    TPG           Completed
11/03/03   22:30:00  11/04/03   00:17:13  NT_BACKUPS    FS_VSJ        Completed
11/03/03   22:30:00  11/04/03   00:16:42  NT_BACKUPS    FS-HEAT       Completed
11/03/03   22:30:00  11/03/03   22:30:33  NT_BACKUPS    FS-LIB        In Progr-
                                                                       ess     
11/03/03   22:30:00  11/04/03   00:07:09  NT_BACKUPS    TNVOICE       Completed
11/03/03   22:30:00  11/04/03   00:16:34  NT_BACKUPS    FS_ACT        Completed
11/03/03   22:30:00  11/03/03   23:16:54  NT_BACKUPS    MERLIN2       In Progr-
                                                                       ess     
11/03/03   22:30:00  11/03/03   22:40:38  NT_BACKUPS    MERCYWEBSRV   In Progr-
                                                                       ess     
11/03/03   22:30:00  11/04/03   00:28:27  NT_BACKUPS    W2KDC         Completed
11/03/03   22:30:00                       NT_BACKUPS    W2K-GC1       Missed   
11/03/03   22:30:00  11/04/03   00:15:36  NT_BACKUPS    FS-XTD        Completed
11/04/03   22:30:00                       NT_BACKUPS    IBS           Missed   
11/04/03   22:30:00  11/04/03   22:30:37  NT_BACKUPS    FS_VSI        Completed
11/04/03   22:30:00                       NT_BACKUPS    PLUS_2000     Missed   
11/04/03   22:30:00  11/04/03   22:30:38  NT_BACKUPS    ID_CARD       Completed
11/04/03   22:30:00  11/04/03   22:30:39  NT_BACKUPS    FS_DEVII      Completed
11/04/03   22:30:00                       NT_BACKUPS    FIRSTPLACE    Missed   
11/04/03   22:30:00  11/04/03   22:30:34  NT_BACKUPS    POWERFAIDS    Completed
11/04/03   22:30:00  11/04/03   22:30:32  NT_BACKUPS    TPG           Completed
11/04/03   22:30:00  11/04/03   22:40:44  NT_BACKUPS    FS_VSJ        Completed
11/04/03   22:30:00  11/04/03   22:30:30  NT_BACKUPS    FS-HEAT       Completed
11/04/03   22:30:00                       NT_BACKUPS    FS-LIB        Missed   
11/04/03   22:30:00  11/04/03   22:30:34  NT_BACKUPS    TNVOICE       Completed
11/04/03   22:30:00  11/04/03   22:30:31  NT_BACKUPS    FS_ACT        Completed
11/04/03   22:30:00                       NT_BACKUPS    MERLIN2       Missed   
11/04/03   22:30:00                       NT_BACKUPS    MERCYWEBSRV   Missed   
11/04/03   22:30:00  11/04/03   22:30:27  NT_BACKUPS    W2KDC         Completed
11/04/03   22:30:00                       NT_BACKUPS    W2K-GC1       Missed   
11/04/03   22:30:00  11/04/03   22:30:20  NT_BACKUPS    FS-XTD        Completed
11/05/03   22:30:00                       NT_BACKUPS    IBS           Future   
11/05/03   22:30:00                       NT_BACKUPS    FS_VSI        Future   
11/05/03   22:30:00                       NT_BACKUPS    PLUS_2000     Future   
11/05/03   22:30:00                       NT_BACKUPS    ID_CARD       Future   
11/05/03   22:30:00                       NT_BACKUPS    FS_DEVII      Future   
11/05/03   22:30:00                       NT_BACKUPS    FIRSTPLACE    Future   
11/05/03   22:30:00                       NT_BACKUPS    POWERFAIDS    Future   
11/05/03   22:30:00                       NT_BACKUPS    TPG           Future   
11/05/03   22:30:00                       NT_BACKUPS    FS_VSJ        Future   
11/05/03   22:30:00                       NT_BACKUPS    FS-HEAT       Future   
11/05/03   22:30:00                       NT_BACKUPS    FS-LIB        Future   
11/05/03   22:30:00                       NT_BACKUPS    TNVOICE       Future   
11/05/03   22:30:00                       NT_BACKUPS    FS_ACT        Future   
11/05/03   22:30:00                       NT_BACKUPS    MERLIN2       Future   
11/05/03   22:30:00                       NT_BACKUPS    MERCYWEBSRV   Future   
11/05/03   22:30:00                       NT_BACKUPS    W2KDC         Future   
11/05/03   22:30:00                       NT_BACKUPS    W2K-GC1       Future   
11/05/03   22:30:00                       NT_BACKUPS    FS-XTD        Future   
tsm: TSM>q sched nt_backups
 ANR2034E QUERY SCHEDULE: No match found using this criteria.
ANS8001I Return code 11.
tsm: TSM>q sched * nt_backups
 
Domain       * Schedule Name    Action Start Date/Time      Duration Period Day
------------ - ---------------- ------ -------------------- -------- ------ ---
NT_SERVERS     NT_BACKUPS       Inc Bk 04/30/02   22:30:00      4 H    1 D  Any
tsm: TSM>q sched * nt_backups f=d
 
            Policy Domain Name: NT_SERVERS
                 Schedule Name: NT_BACKUPS
                   Description: Backup ALL NT Servers
                        Action: Incremental
                       Options: 
                       Objects: 
                      Priority: 3
               Start Date/Time: 04/30/02   22:30:00
                      Duration: 4 Hour(s)
                        Period: 1 Day(s)
                   Day of Week: Any
                    Expiration: 
Last Update by (administrator): EMUSONGE
         Last Update Date/Time: 06/07/02   15:38:06
              Managing profile: 

tsm: TSM>

 

        -----Original Message----- 
        From: Mr. Lindsay Morris [mailto:lmorris AT SERVERGRAPH DOT COM] 
        Sent: Wed 11/5/2003 7:00 AM 
        To: ADSM-L AT VM.MARIST DOT EDU 
        Cc: 
        Subject: Re: Query Event for Previous day shows status In Progress
        
        
Am I off base in suggesting that query events is not a
reliable way to check backup status?
We've found that you can have:

--events that say Missed, but you DO have a good backup
   (it started late, or was run manually, etc, but it WAS done)

--events that say Completed, but you DON'T have a good backup
   (it Completed the kickoff of a TDP agent;
    the agent failed an hour later)

--NO events at all for some nodes
   (your DBA may want to control the timing with crontab,
    rather than the TSM scheduler do it)

--skipped files, and events doesn't help you there.
   (outlook.pst, for example, usually stays open/locked, so
    TSM misses it. The event status is Completed, because it's
    "only" one file...!!)

This is old news to some people, but maybe useful for others.
-----------------------------
Mr. Lindsay Morris
Lead Architect
www.servergraph.com
512-482-6138 ext 105

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> James Choate
> Sent: Wednesday, November 05, 2003 8:23 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Query Event for Previous day shows status In Progress
>
>
> Can someone tell me what is going on with a client(s) that has a
> status of In Progress when I query the event?  When I query the
> event for the previous day, the status indicates that the event
> is in progress.  When I query the event for the current day, the
> event status shows future.  When I query the session and the
> process on the tsm server, I do not see anything going on with
> respect to this event.  I have attached the output.  Any
> help/guidance is appreciated.
> 
>
> tsm: TSM>q event nt_servers nt_backups begint=00:00 begind=11/03/2003
> 
> Scheduled Start          Actual Start             Schedule Name  
>   Node Name         Status  
> --------------------     --------------------     -------------  
>   -------------     ---------
> 11/03/03   22:30:00      11/03/03   22:45:00      NT_BACKUPS     
>   IBS               In Progr-
>                                                                  
>                      ess    
> 11/03/03   22:30:00      11/04/03   00:18:12      NT_BACKUPS     
>   FS_VSI            Completed
> 11/03/03   22:30:00      11/03/03   22:30:41      NT_BACKUPS     
>   PLUS_2000         In Progr-
>                                                                  
>                      ess    
> 11/03/03   22:30:00      11/04/03   00:15:34      NT_BACKUPS     
>   ID_CARD           Completed
> 11/03/03   22:30:00      11/04/03   00:16:36      NT_BACKUPS     
>   FS_DEVII          Completed
> 11/03/03   22:30:00      11/04/03   00:15:41      NT_BACKUPS     
>   POWERFAIDS        Completed
> 11/03/03   22:30:00      11/04/03   00:15:44      NT_BACKUPS     
>   TPG               Completed
> 11/03/03   22:30:00      11/04/03   00:17:13      NT_BACKUPS     
>   FS_VSJ            Completed
> 11/03/03   22:30:00      11/04/03   00:16:42      NT_BACKUPS     
>   FS-HEAT           Completed
> 11/03/03   22:30:00      11/03/03   22:30:33      NT_BACKUPS     
>   FS-LIB            In Progr-
>                                                                  
>                      ess    
> 11/03/03   22:30:00      11/04/03   00:07:09      NT_BACKUPS     
>   TNVOICE           Completed
> 11/03/03   22:30:00      11/04/03   00:16:34      NT_BACKUPS     
>   FS_ACT            Completed
> 11/03/03   22:30:00      11/03/03   23:16:54      NT_BACKUPS     
>   MERLIN2           In Progr-
>                                                                  
>                      ess    
> 11/03/03   22:30:00      11/03/03   22:40:38      NT_BACKUPS     
>   MERCYWEBSRV       In Progr-
>                                                                  
>                      ess    
> 11/03/03   22:30:00      11/04/03   00:28:27      NT_BACKUPS     
>   W2KDC             Completed
> 11/03/03   22:30:00      11/04/03   00:15:36      NT_BACKUPS     
>   FS-XTD            Completed
> tsm: TSM>q sess
>   Sess     Comm.      Sess         Wait       Bytes       Bytes  
>   Sess      Platform     Client Name        
> Number     Method     State        Time        Sent       Recvd  
>   Type                  
> ------     ------     ------     ------     -------     -------  
>   -----     --------     --------------------
>      1     ShMem      Run          0 S      112.8 K         139  
>   Admin     AIX          ADMIN              
> 17,411     ShMem      Run          0 S       45.9 M         139  
>   Admin     AIX          ADMIN              
> 19,029     ShMem      Run          0 S        1.0 M       1,018  
>   Admin     AIX          UHO           
> 
>
> tsm: TSM>q pr                                                  
> 
>  Process     Process Description      Status                     
>                     
>   Number                             
> --------     --------------------    
> -------------------------------------------------
>    2,917     Space Reclamation        Offsite Volume(s) (storage
> pool AIX_OFFSITE_1), 
>                                        Moved Files: 52400, Moved
> Bytes: 21,509,772,447,
>                                        Unreadable Files: 3476,
> Unreadable Bytes: 0.   
>                                        Current Physical File
> (bytes): 20,597,841
>      
>                                        Current input volume: OP0303.
>                  
>                                        Current output volume: OP0287.
>                 
> tsm: TSM>q event nt_servers nt_backups begint=00:00 begind=11/04/2003
> 
> Scheduled Start          Actual Start             Schedule Name  
>   Node Name         Status  
> --------------------     --------------------     -------------  
>   -------------     ---------
> 11/04/03   22:30:00                               NT_BACKUPS     
>   IBS               Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS_VSI            Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   PLUS_2000         Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   ID_CARD           Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS_DEVII          Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FIRSTPLACE        Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   POWERFAIDS        Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   TPG               Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS_VSJ            Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS-HEAT           Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS-LIB            Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   TNVOICE           Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS_ACT            Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   MERLIN2           Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   MERCYWEBSRV       Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   W2KDC             Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   W2K-GC1           Future  
> 11/04/03   22:30:00                               NT_BACKUPS     
>   FS-XTD            Future  
> tsm: TSM>
>
> 
>
> 
> 
>