Yes Arty,

I have the same problem, i solved it wit a select macro scripts, i bind
toether in one executable file,

I have a example of the output attacment, in a file called log.txt

I alsow am workin on a new version, where i will show when the backup
compleded, and how the sessions where.

If anyone wants to have it, your more than welcome to contact me and i can
give it you yah,

Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

[EMAIL PROTECTED]

 Nyherji Hf              Simi TEL: +354-569-7700
 Borgartun 37            105 Iceland
 URL:                    http://www.nyherji.is


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Arty Ecock
Sent: 16. september 2002 13:30
To: [EMAIL PROTECTED]
Subject: Backup reporting


Hi,

   We're trying to put together some TSM backup reports for our
Help Desk staff.  We're using something like

   SELECT * FROM EVENTS ...

and things like

   SELECT NODE_NAME, LASTACC_TIME FROM NODES

and

   SELECT NODE_NAME, FILESPACE_NAME, (CURRENT_TIMESTAMP-BACKUP_END) DAYS
   AS "Days_Since_Backup" FROM FILESPACES WHERE
   CAST((CURRENT_TIMESTAMP-BACKUP_END) DAYS AS DECIMAL) >= 30 ORDER BY
   "Days_Since_Backup"

   What we need is a single, consolidated report that lists all our
client nodes and the (real) status of the morning's backup run.
"Query Events" (and the Select * from Events ...) will tell us
if the scheduled backup was "Completed", "Missed", or "Failed".
>From our experience, "Completed" only means that the scheduled
command actually completed, not that it was truly successful.
By way of exmple, we use a scheduled command script to drive our
Domino TDP backups.  The script invokes the DOMDSMC command to
actually perform the backup.  DOMDSMC may fail miserably, but as
long as the invoking (scheduled) script completes, the status of
the backup shows "Complete".  (We now pass a bad RC from the script
if DOMDSMC returns a bad RC).

   For our Oracle TDP backups, I believe there is a way to issue
a SELECT against the Oracle (RMAN?) instance to determine the state
of the most recent backup.

   Our Help Desk needs to determine if a backup for a given node
actually completed successfully, and if it failed, they need to
determine the cause (all without having exceptional knowledge of
TSM).

   I'm sure this problem has been addressed by many sites in many
ways.  Our ideal solution would be a number of SELECTs, which we
could drop in a CGI script on some Web Server.

   Any words of advice?

Arty Ecock
CUNY/CIS - (212) 541-0956
╔═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘ TSM Backup Log                                                                     
                               β•‘
╠═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╣

β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚  The following information is taken from Tivoli Storage Manager to help you 
with daly administration            β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘ 1 β”‚   The Backup log last 24 hours                                               
                                       β•‘
β•‘ 2 β”‚   Data sent over to the TSM System the last 24 hours                         
                               β•‘
β•‘ 3 β”‚   The Backup log last 24 hours (administrative schedules)                    
                                       β•‘
β•‘ 4 β”‚       Are there any drives Unavlible or offline?                             
                                       β•‘
β•‘ 5 β”‚       Shows you the tapes that have Read or Write errors and how many it has 
                                       β•‘         
β•‘ 6 β”‚       shows you if there are any tapes that are Unavailable or Read-Only but 
are in the library                     β•‘
β•‘ 7 β”‚   Shows files that where locked while backup was running                     
                                       β•‘
β•‘ 8 β”‚       Have there been any Hardware errors the last 24 hours                  
                                       β•‘
β•‘ 9 β”‚   Shows you when the last successful database backup was made                
                               β•‘
β•‘ 10β”‚   Total TSM data on your Backup System (GB)                                  
                               β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•

ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 1.β”‚ TSM Backup Log the last 24 hours                                             
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




Scheduled Start          Actual Start             Schedule Name     Node Name         
Status   
--------------------     --------------------     -------------     -------------     
---------
04/22/2002 08:30:00      04/22/2002 08:33:49      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/22/2002 11:00:00      04/22/2002 11:18:33      ARCH_DOM          LYF_DOM           
Completed
04/22/2002 11:00:00                               ARCH_DOM          SS_DOM            
Missed   
04/22/2002 12:30:00      04/22/2002 12:31:59      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/22/2002 15:00:00      04/22/2002 15:25:52      ARCH_DOM          LYF_DOM           
Completed
04/22/2002 15:00:00                               ARCH_DOM          SS_DOM            
Missed   
04/22/2002 16:30:00      04/22/2002 16:42:13      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/22/2002 19:00:00      04/22/2002 20:38:49      DAGLEGT           NOTES1            
Completed
04/22/2002 19:00:00      04/22/2002 20:14:14      DAGLEGT           SOL               
Completed
04/22/2002 19:00:00      04/22/2002 21:58:35      DAGLEGT           MARS              
Completed
04/22/2002 19:00:00      04/22/2002 21:15:28      DAGLEGT           ORION             
Completed
04/22/2002 19:00:00                               DAGLEGT           DEMON             
Missed   
04/22/2002 19:00:00      04/22/2002 21:14:24      DAGLEGT           SIMASERVER1       
Completed
04/22/2002 19:00:00      04/22/2002 20:40:39      DAGLEGT           PLUTO             
Completed
04/22/2002 19:00:00      04/22/2002 19:48:04      DAGLEGT           ITS1              
Completed
04/22/2002 19:00:00      04/22/2002 20:34:23      DAGLEGT           CTISERVER-01      
Completed
04/22/2002 19:00:00      04/22/2002 19:54:03      DAGLEGT           NEPTUNUS          
Completed
04/22/2002 19:00:00      04/22/2002 19:41:54      DAGLEGT           AXEL              
Completed
04/22/2002 19:00:00      04/22/2002 19:11:45      DAGLEGT           REKILL            
Completed
04/22/2002 19:00:00      04/22/2002 20:23:48      DAGLEGT           DIRECTOR          
Completed
04/22/2002 19:00:00      04/22/2002 20:34:07      DAGLEGT           IDES2             
Completed
04/22/2002 19:00:00      04/22/2002 21:17:18      DAGLEGT           GYLFI             
Completed
04/22/2002 19:00:00      04/22/2002 20:22:45      DAGLEGT           SAPNSD            
Completed
04/22/2002 19:00:00      04/22/2002 20:53:34      DAGLEGT           ETOP              
Completed
04/22/2002 19:00:00      04/22/2002 19:29:51      DAGLEGT           JONAS             
Completed
04/22/2002 19:00:00      04/22/2002 19:03:23      ARCH_DOM          LYF_DOM           
Completed
04/22/2002 19:00:00      04/22/2002 19:35:33      ARCH_DOM          SS_DOM            
Completed
04/22/2002 20:00:00      04/22/2002 21:46:46      DAGLEGT           AFRITARI          
Completed
04/22/2002 20:00:00      04/22/2002 20:43:10      DAGLEGT           SURTUR            
Completed
04/22/2002 20:00:00      04/22/2002 20:26:40      DAGLEGT           HEIM.IS           
Completed
04/22/2002 20:00:00                               DAGLEGT           VEFUR1            
Missed   
04/22/2002 20:00:00      04/22/2002 21:40:06      DAGLEGT           BAUG_EPLI         
Completed
04/22/2002 20:00:00      04/22/2002 21:18:08      DAGLEGT           BAUG_BANANI       
Completed
04/22/2002 20:00:00      04/22/2002 20:10:29      DAGLEGT           BAUG_CDB2         
Completed
04/22/2002 20:00:00      04/22/2002 21:52:42      DAGLEGT           BAUG_CWEBC        
Completed
04/22/2002 20:00:00      04/22/2002 20:14:21      DAGLEGT           ISLENSKT          
Completed
04/22/2002 20:00:00      04/22/2002 20:21:22      DAGLEGT           SAPRNP            
Completed
04/22/2002 20:00:00      04/22/2002 21:41:01      DAGLEGT           SS1ADAL           
Completed
04/22/2002 20:00:00      04/22/2002 21:56:08      DAGLEGT           SS_NOTES          
Completed
04/22/2002 20:00:00      04/22/2002 23:02:12      DAGLEGT           SS_PDC            
Completed
04/22/2002 20:00:00      04/22/2002 20:00:46      DAGLEGT           SS_TSE1           
Completed
04/22/2002 20:00:00      04/22/2002 20:03:10      DAGLEGT           SS_TSE2           
Completed
04/22/2002 20:00:00      04/22/2002 20:48:20      DAGLEGT           TIMASKRANING      
Completed
04/22/2002 20:00:00      04/22/2002 20:45:37      DAGLEGT           DOMINO_LYF        
Completed
04/22/2002 20:00:00      04/22/2002 20:35:19      DAGLEGT           NTLYF1            
Completed
04/22/2002 20:00:00      04/22/2002 20:48:28      DAGLEGT           VEFUR3            
Completed
04/22/2002 20:00:00      04/22/2002 20:01:44      DAGLEGT           VEFUR2            
Completed
04/22/2002 20:00:00      04/22/2002 22:27:45      DAGLEGT           VEFUR2_NOTES      
Completed
04/22/2002 20:00:00                               DAGLEGT           UMSJA09           
Missed   
04/22/2002 20:00:00      04/22/2002 21:50:14      DAGLEGT           EXMAIL1           
Completed
04/22/2002 20:00:00      04/22/2002 22:14:02      DAGLEGT           LUMUR             
Completed
04/22/2002 20:00:00      04/22/2002 21:10:11      DAGLEGT           MENNT             
Completed
04/22/2002 20:00:00      04/22/2002 22:30:18      DAGLEGT           GLYRNIR           
Completed
04/22/2002 20:00:00      04/22/2002 20:44:14      DAGLEGT           DC1               
Failed   
04/22/2002 20:00:00      04/22/2002 21:42:09      DAGLEGT           GRANDIS01         
Completed
04/22/2002 20:00:00      04/22/2002 20:48:13      DAGLEGT           ISA1              
Completed
04/22/2002 20:00:00      04/22/2002 20:49:51      DAGLEGT           TS1               
Completed
04/22/2002 20:00:00                               DAGLEGT           STRUMPUR          
Missed   
04/22/2002 20:30:00      04/22/2002 20:40:30      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/22/2002 22:30:00      04/22/2002 22:51:08      NAVISION          LUMUR_NAVISI-     
Completed
                                                                     ON                
        
04/22/2002 22:30:00      04/22/2002 22:48:10      NAVISION          FINGRANDI         
Completed
04/22/2002 23:00:00      04/22/2002 23:24:55      ARCH_DOM          LYF_DOM           
Completed
04/22/2002 23:00:00      04/22/2002 23:11:32      ARCH_DOM          SS_DOM            
Completed
04/23/2002 00:30:00      04/23/2002 00:39:48      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/23/2002 02:00:00      04/23/2002 02:31:45      DAGLEGT           LOKI              
Completed
04/23/2002 02:00:00                               DAGLEGT           SLEIPNIR          
Missed   
04/23/2002 02:00:00      04/23/2002 03:59:02      DAGLEGT           ODINN             
Completed
04/23/2002 02:00:00      04/23/2002 03:58:38      DAGLEGT           VIT               
Completed
04/23/2002 02:00:00      04/23/2002 03:10:37      DAGLEGT           NEO               
Completed
04/23/2002 02:00:00      04/23/2002 02:15:49      DAGLEGT           CNEO              
Completed
04/23/2002 02:00:00                               DAGLEGT           TRINITY           
Missed   
04/23/2002 02:00:00      04/23/2002 03:12:46      DAGLEGT           CTRINITY          
Completed
04/23/2002 02:00:00                               DAGLEGT           MORPHEUS          
Missed   
04/23/2002 02:00:00      04/23/2002 02:35:40      DAGLEGT           NETV              
Completed
04/23/2002 02:00:00      04/23/2002 02:16:08      DAGLEGT           FP                
Failed   
04/23/2002 02:00:00      04/23/2002 04:30:29      DAGLEGT           ORACLE            
Completed
04/23/2002 02:00:00      04/23/2002 03:17:51      DAGLEGT           CODINN            
Completed
04/23/2002 02:00:00                               DAGLEGT           VSCAN             
Missed   
04/23/2002 02:00:00                               DAGLEGT           TYR               
Missed   
04/23/2002 02:00:00                               DAGLEGT           GRIC1RAD          
Missed   
04/23/2002 02:00:00      04/23/2002 04:03:02      DAGLEGT           GRIC2RAD          
Completed
04/23/2002 02:00:00      04/23/2002 04:02:33      DAGLEGT           TONLIST           
Completed
04/23/2002 03:00:00      04/23/2002 03:21:16      ARCH_DOM          LYF_DOM           
Completed
04/23/2002 03:00:00      04/23/2002 03:18:33      ARCH_DOM          SS_DOM            
Completed
04/23/2002 03:00:00      04/23/2002 03:34:15      DAGLEGT_DB2       SURTUR            
Completed
04/23/2002 03:00:00      04/23/2002 03:00:13      DAGLEGT_DB2       BAUG_CDB2         
Completed
04/23/2002 03:00:00      04/23/2002 03:46:29      DAGLEGT_DB2       ISLENSKT          
Completed
04/23/2002 04:30:00      04/23/2002 04:44:58      EXCHANGE_INC      EXMAIL1_EXCH-     
Completed
                                                                     ANGE              
        
04/23/2002 07:00:00      04/23/2002 07:13:33      ARCH_DOM          LYF_DOM           
Completed
04/23/2002 07:00:00      04/23/2002 07:23:41      ARCH_DOM          SS_DOM            
Completed
ο»Ώ

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”

β”‚                                        β”‚
β”‚ Where there any failures, Missed backups β”‚
β”‚                                        β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜




Scheduled Start          Actual Start             Schedule Name     Node Name         
Status   
--------------------     --------------------     -------------     -------------     
---------
04/22/2002 11:00:00                               ARCH_DOM          SS_DOM            
Missed   
04/22/2002 15:00:00                               ARCH_DOM          SS_DOM            
Missed   
04/22/2002 19:00:00                               DAGLEGT           DEMON             
Missed   
04/22/2002 20:00:00                               DAGLEGT           VEFUR1            
Missed   
04/22/2002 20:00:00                               DAGLEGT           UMSJA09           
Missed   
04/22/2002 20:00:00      04/22/2002 20:44:14      DAGLEGT           DC1               
Failed   
04/22/2002 20:00:00                               DAGLEGT           STRUMPUR          
Missed   
04/23/2002 02:00:00                               DAGLEGT           SLEIPNIR          
Missed   
04/23/2002 02:00:00                               DAGLEGT           TRINITY           
Missed   
04/23/2002 02:00:00                               DAGLEGT           MORPHEUS          
Missed   
04/23/2002 02:00:00      04/23/2002 02:16:08      DAGLEGT           FP                
Failed   
04/23/2002 02:00:00                               DAGLEGT           VSCAN             
Missed   
04/23/2002 02:00:00                               DAGLEGT           TYR               
Missed   
04/23/2002 02:00:00                               DAGLEGT           GRIC1RAD          
Missed   
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 2.β”‚ TSM Backup Log the last 24 hours                                             
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚   The following ifromation tells you how mutch data was sent over to TSM the 
last 24 hours.                 β•‘
β•‘   β”‚       The reason for this is for you to see if there is anything unusual 
with the data transfer to the TSM Server.  β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Pay special attention to TDP product because they can say completed in 
schedules but dont send anything over  β•‘
β•‘   β”‚       to TSM, because of some unknown error.                                 
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       This information alsow tells you how mutch data is sent over total to 
the system                              β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•





NODE NAME              DOMAIN                 PLATFORM                   MBYTES      
CONECTIONS
------------------     ------------------     ----------------     ------------     
-----------
BAUG_CDB2              REKSTRAR               DB2                      12360.93        
       4
FINGRANDI              REKSTRAR               WinNT                     8789.06        
       1
VEFUR2_NOTES           REKSTRAR               WinNT                     8674.47        
       2
PLUTO                  NYHERJI                WinNT                     6730.55        
       2
VIT                    TITAN                  DB2/6000                  5929.64        
       1
CODINN                 TITAN                  AIX                       4771.42        
       1
NETV                   TITAN                  AIX                       3395.24        
       1
AIXNOTES1              NYHERJI                TDP Domino AIX            3072.04        
      24
BAUG_CWEBC             REKSTRAR               AIX                       2437.61        
       2
TONLIST                TITAN                  Linux86                   1448.93        
       1
SS_PDC                 REKSTRAR               WinNT                     1369.52        
       3
ISLENSKT               REKSTRAR               AIX                       1297.98        
       3
QBRMS                  REKSTRAR               OS400                     1170.43        
       9
EXMAIL1                REKSTRAR               WinNT                      823.17        
       2
SS_DOM                 REKSTRAR               WinNT                      768.01        
       5
ORION                  NYHERJI                WinNT                      729.68        
       2
FP                     TITAN                  WinNT                      702.99        
       2
LUMUR_NAVISION         REKSTRAR               WinNT                      683.59        
       1
ODINN                  TITAN                  AIX                        676.75        
       1
AXEL                   NYHERJI                WinNT                      668.59        
       2
ISA1                   REKSTRAR               WinNT                      654.20        
       1
VEFUR2                 REKSTRAR               WinNT                      614.36        
       2
LYF_DOM                REKSTRAR               WinNT                      576.00        
       6
AFRITARI               REKSTRAR               AIX                        551.97        
       2
MENNT                  REKSTRAR               WinNT                      481.82        
       2
NTLYF1                 REKSTRAR               WinNT                      480.53        
       2
GRANDIS01              REKSTRAR               WinNT                      473.74        
       1
REKILL                 NYHERJI                WinNT                      434.84        
       1
CNEO                   TITAN                  AIX                        421.29        
       1
VEFUR3                 REKSTRAR               WinNT                      414.94        
       2
SS_NOTES               REKSTRAR               WinNT                      402.67        
       2
SURTUR                 REKSTRAR               DB2/6000                   387.13        
       3
CTRINITY               TITAN                  AIX                        337.09        
       1
DC1                    REKSTRAR               WinNT                      330.57        
       2
TIMASKRANING           REKSTRAR               WinNT                      307.26        
       1
HEIM.IS                REKSTRAR               Linux86                    254.30        
       2
TS1                    REKSTRAR               WinNT                      249.79        
       1
MAGNADUR               TITAN                  SCO                        243.97        
       1
GLYRNIR                REKSTRAR               WinNT                      227.74        
       1
SOL                    NYHERJI                WinNT                      211.18        
       2
EXMAIL1_EXCHANGE       REKSTRAR               WinNT                      190.00        
       6
GRIC2RAD               TITAN                  Linux86                    186.99        
       1
MARS                   NYHERJI                WinNT                      180.61        
       2
SAPNSD                 NYHERJI                WinNT                      175.80        
       2
NOTES1                 NYHERJI                AIX                        154.95        
       1
GYLFI                  NYHERJI                WinNT                      150.00        
       2
LOKI                   TITAN                  AIX                        144.20        
       1
ETOP                   NYHERJI                WinNT                      135.68        
       2
NEPTUNUS               NYHERJI                WinNT                      134.43        
       2
BAUG_EPLI              REKSTRAR               AIX                        110.31        
       1
ITS1                   NYHERJI                WinNT                       94.29        
       2
IDES2                  NYHERJI                WinNT                       94.25        
       2
JONAS                  NYHERJI                WinNT                       93.40        
       2
MIKILL                 TITAN                  SCO                         85.81        
       1
DIRECTOR               NYHERJI                WinNT                       80.36        
       2
SIMASERVER1            NYHERJI                WinNT                       72.17        
       2
SAPRNP                 REKSTRAR               WinNT                       68.36        
       2
CTISERVER-01           NYHERJI                WinNT                       54.54        
       2
NEO                    TITAN                  AIX                         54.51        
       1
SS_TSE2                REKSTRAR               WinNT                       51.74        
       2
SS_TSE1                REKSTRAR               WinNT                       40.26        
       2
ORACLE                 TITAN                  AIX                         19.39        
       1
LUMUR                  REKSTRAR               WinNT                        8.91        
       1
SS1ADAL                REKSTRAR               WinNT                        8.24        
       1
BAUG_BANANI            REKSTRAR               AIX                          3.09        
       1
ο»Ώ

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”

β”‚                                        β”‚
β”‚ Total data sent to TSM the last 24 hours β”‚
β”‚                                        β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜



      DATE           MBYTES     CONNECTIONS
----------     ------------     -----------
2002-04-22         76948.59             149
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 3.β”‚ TSM Administrative Schedules  the last 24 hours                              
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here you can see if your administrative schedules, database, space 
reclimation and so forth.                  β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




Scheduled Start          Actual Start             Schedule Name     Status   
--------------------     --------------------     -------------     ---------
04/22/2002 08:00:00      04/22/2002 08:00:15      LEYFIR_RECLA-     Completed
                                                   IM                        
04/22/2002 11:30:00      04/22/2002 11:30:15      BACKUPDB          Completed
04/22/2002 18:00:00      04/22/2002 18:00:22      BANNAR_RECLA-     Completed
                                                   IM                        
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 4.β”‚ Are there any drives Unavlible or offline?                                   
                               β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for any drives that are not 
avalible                                    β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




LIBRARY                DRIVE                  TYPE                 DEVICE              
   ONLINE            
------------------     ------------------     ----------------     ------------------  
   ------------------
DLTLIB1                DLTDRV1                DLT                  /dev/mt0            
   NO                
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 5.β”‚ Shows you the tapes that have Read or Write errors and how many it has       
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for any Tapes that have errors   
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




VOLUME NAME            STORAGE POOL           WRITE ERRORS     READ ERRORS
------------------     ------------------     ------------     -----------
000023                 DLT_TITAN_TEMP                    1               0
000031                 DLT_ARCH_REK                      1               0
602ABP                 LTO_NYH_POOL                      1               0
603ABP                 LTO_NYH_POOL                      1               0
604ABP                 LTO_NYH_POOL                      1               0
607ABP                 LTO_NYH_POOL                      1               1
620ABP                 LTO_REK_POOL                      1               1
624ABP                 LTO_REK_POOL                      0               1
625ABP                 LTO_REK_POOL                      1               0
626ABP                 LTO_REK_POOL                      1               0
635AAX                 LTO_REK_POOL                      3               0
636AAX                 LTO_REK_POOL                      1               0
637AAX                 LTO_REK_POOL                      1               1
638AAX                 LTO_REK_POOL                      2               0
640ABP                 LTO_NYH_POOL                      1               0
880ABQ                 LTO_TITAN_POOL                    1               3
881ABQ                 LTO_TITAN_POOL                    0               1
882ABQ                 LTO_TITAN_POOL                    1               0
883ABQ                 LTO_TITAN_POOL                    0               6
889ABQ                 LTO_TITAN_POOL                    0              67
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 6.β”‚ Shows you if there are any tapes Unavalible or Read-Only but are in the 
library                                     β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for any Tapes that are 
unavalible or Read-Only but in your library      β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•



         No tapes where unavailable or Read-Only in the library  
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 7 β”‚   Shows files that where locked while backup was running                     
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for any files that where 
Unavalible, Read-Only but in the library       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




                      DATE     NODE NAME                                               
             FILE NAME                                                                 
                                                                                       
                                                                                       
  
--------------------------     
----------------------------------------------------------------     
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

2002-04-22 19:30:04.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$ \pagefile.sys': the object is in 
use by another process                                                                 
                                                                                       
     
2002-04-22 19:31:30.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\Documents and Settings\db2admin 
\NTUSER.DAT': the object is in use by another process                                  
                                                                                       
      
2002-04-22 19:31:30.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\Documents and Settings\db2admin 
\ntuser.dat.LOG': the object is in use by another process                              
                                                                                       
      
2002-04-22 19:31:31.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\Documents and 
Settings\db2admin\Local Settings\Application Data\Microsoft\Windows \UsrClass.dat': 
the object is in use by another process                                                
                           
2002-04-22 19:31:31.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\Documents and 
Settings\db2admin\Local Settings\Application Data\Microsoft\Windows 
\UsrClass.dat.LOG': the object is in use by another process                            
                                           
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config \default': 
the object is in use by another process                                                
                                                                                       
     
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config 
\default.LOG': the object is in use by another process                                 
                                                                                       
                
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config \SAM': the 
object is in use by another process                                                    
                                                                                       
     
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config \SAM.LOG': 
the object is in use by another process                                                
                                                                                       
     
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config \SECURITY': 
the object is in use by another process                                                
                                                                                       
    
2002-04-22 19:35:22.000000     JONAS                                                   
             ANE4987E Error processing '\\jonas\c$\WINNT\system32\config 
\SECURITY.LOG': the object is in use by another process                                
                                                                                       
                                                                                       
                      
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 8 β”‚   Have there been any Hadware errors the last 24 hours                       
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for any kind of sense error that 
may have happend                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




Date/Time                Message                                                   
--------------------     ----------------------------------------------------------
04/22/2002 08:00:37      ANR8300E I/O error on library LTOLIB1 (OP=00006C03,       
                          CC=207, KEY=05, ASC=83, ASCQ=02,                         
                          SENSE=70.00.05.00.00.00.00.0A.00.00.00.00.83.02.E2.00.00-
                          .00., Description=Device is not in a state capable of    
                          performing request).  Refer to Appendix D in the         
                          'Messages' manual for recommended action.                
04/22/2002 08:25:05      ANR8300E I/O error on library LTOLIB1 (OP=00006C03,       
                          CC=207, KEY=05, ASC=83, ASCQ=02,                         
                          SENSE=70.00.05.00.00.00.00.0A.00.00.00.00.83.02.E2.00.00-
                          .00., Description=Device is not in a state capable of    
                          performing request).  Refer to Appendix D in the         
                          'Messages' manual for recommended action.                
                          begind=-30 search=SENSE                                  
                          begind=-30 search=SENSE                                  ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 8 β”‚   Shows you when the last successful database backup was made                
                               β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server when the last successful 
database backup was made of the TSM DB         β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




Last Database Backup
--------------------
2002-04-23 11:30:24 
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘ 9 β”‚   Shows you the total data on your TSM backup System                         
                               β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚       Here the script querys the TSM server for the total data on the server 
                                       β•‘
β•‘   β”‚                                                                              
                                       β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•




    TOTAL GB    
----------------
        2341.696
ο»Ώ


╔═══╀═════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗

β•‘   β”‚                                                                              
                                       β•‘
β•‘   β”‚   This is the end of this log                                                
       β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β•’
β•‘   β”‚                                                                              
               β”‚       Created by:           β•‘
β•‘   β”‚                                                                              
               β”‚       Petur Eythorsson      β•‘
β•‘   β”‚                                                                              
               β”‚       22 april 2002         β•‘
β•šβ•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•§β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•β•



Reply via email to