Re: DB2/Oracle backup reporting and scheduling

2015-03-11 Thread Steven Harris
ined in hopes others find it helpful. > > ~Rick > > > -Original Message- From: ADSM: Dist Stor Manager > [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: > Sunday, March 08, 2015 5:19 PM To: ADSM-L@VM.MARIST.EDU Subject: > Re: [ADSM-L] DB2/Oracle backup repor

Re: DB2/Oracle backup reporting and scheduling

2015-03-09 Thread Rick Adamson
, 2015 5:19 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2/Oracle backup reporting and scheduling Rick, It's a problem, everywhere, no matter how you do it. * The simplistic answer to your question is yes; the external scheduler is running a list of tasks; after the last ta

Re: DB2/Oracle backup reporting and scheduling

2015-03-08 Thread Prather, Wanda
DSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Adamson Sent: Friday, March 06, 2015 12:12 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2/Oracle backup reporting and scheduling I assume someone has dealt with this I would like to hear how they handled it. The issue: DB2 and

Re: DB2/Oracle backup reporting and scheduling

2015-03-07 Thread Steven Langdale
lto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Rick Adamson > Sent: Friday, March 06, 2015 1:38 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: DB2/Oracle backup reporting and scheduling > > Rick, > This all began after a recent audit revealed many systems either had > missed backup sch

Re: DB2/Oracle backup reporting and scheduling

2015-03-07 Thread Rhodes, Richard L.
:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Adamson Sent: Friday, March 06, 2015 1:38 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: DB2/Oracle backup reporting and scheduling Rick, This all began after a recent audit revealed many systems either had missed backup schedules, excessive retention, or no bac

Re: DB2/Oracle backup reporting and scheduling

2015-03-06 Thread Rick Adamson
: Friday, March 06, 2015 12:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2/Oracle backup reporting and scheduling Our Oracle backups have three scenarios. 1) Home grown scripts are scheduled via cron on the Oracle server, copy/compress the db to local disk, then pushed the db backup to

Re: DB2/Oracle backup reporting and scheduling

2015-03-06 Thread Rhodes, Richard L.
Behalf Of Rick Adamson Sent: Friday, March 06, 2015 12:12 PM To: ADSM-L@VM.MARIST.EDU Subject: DB2/Oracle backup reporting and scheduling I assume someone has dealt with this I would like to hear how they handled it. The issue: DB2 and/or Oracle database backups that are dependent on completion of

DB2/Oracle backup reporting and scheduling

2015-03-06 Thread Rick Adamson
I assume someone has dealt with this I would like to hear how they handled it. The issue: DB2 and/or Oracle database backups that are dependent on completion of external processes. Currently our DBA's utilize a variety of methods to initiate DB2 and Oracle database backups (CRON, external sched

Re: NDMP backup reporting.

2005-04-29 Thread Ben Bullock
there. I'll keep working at it. Thanks, Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Iain Barnetson Sent: Friday, April 29, 2005 1:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: NDMP backup reporting. Ben, This si

Re: NDMP backup reporting.

2005-04-29 Thread Iain Barnetson
KUP' or activity='NAS Backup') - order by start, node_name Regards, Iain Barnetson IT Systems Administrator UKN Infrastructure Operations -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben Bullock Sent: 28 April 2005 23:27 T

NDMP backup reporting.

2005-04-28 Thread Ben Bullock
I know that many of us in TSM land have started to jump on the NDMP bandwagon, me included. I have a few questions that I'm hoping someone else has already figured out. I'm not finding it in the archives, so I will ask. Basically it has to do with the scheduling and reporting of th

ANN: New Mailing List for Backup Reporting

2003-11-04 Thread Peter L. Buschman
[ This is a one-time announcement that is being sent to lists where the topic of backup reporting has come up in the past. Apologies to any who consider it to be off-topic. ] A new list has been created specifically for the discussion of backup-reporting issues: http://www.openbackup.org

Backup reporting strange status after upgrade

2002-10-24 Thread Gill, Geoffrey L.
After upgrading to 5.1.5.1 I now find a strange status in the backup report. I'd also like to mention that we had an unusually high amount of failures and missed backups last night too. Query is this: q event * * begindate=today-1 begintime=16:00 enddate=today endtime=now Output is this: 10/23/20

RE: Réf. : Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-10-15 Thread Seay, Paul
-688-8180 -Original Message- From: Guillaume Gilbert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:59 AM To: [EMAIL PROTECTED] Subject: Réf. : Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND Just got word from Tivoli that APAR IC34462: BYTES FIELD IN SUMMARY TABLE SHOWS

Réf. : Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-10-15 Thread Guillaume Gilbert
t;@VM.MARIST.EDU> on 2002-09-20 10:36:12 Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Envoyé par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-29 Thread Zlatko Krastev/ACIT
t; <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 28.09.2002 03:12 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND I get

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-27 Thread Chetan H. Ravnikar
select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) Total GB == On Fri, 20 Sep 2002, Seay, Paul wrote: > Date: Fri, 20 Sep 2002 09:57:53 -0400 > From: "Seay, Paul" <[EMAIL PROTECTED]> > Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> >

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Williams, Tim P {PBSG}
is [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND For the record, Servergraph/TSM doesn't use the summary table, so problems there won't make it give incorrect results. It uses the accou

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Mr. Lindsay Morris
8-8478 fax > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Bill Boyer > Sent: Friday, September 20, 2002 10:17 AM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND > > > Yeah, but

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Williams, Tim P {PBSG}
The fix for this is at these levels (per apar doc): Apply patch 4.2.2.5, 5.1.1.1 or higher, available through Tivoli Web Page to resolve this problem, or fixing PTF when available. Here's a blerb from my etr/pmr (problem ticket): The APAR you are referring to is IC34462. This issue is spec

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Bill Boyer
. Bill -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Joel Fuhrman Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To me is seems as though the worker sessions should be in

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Seay, Paul
They are working on a fix. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Joel Fuhrman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 5:13 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND To

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-20 Thread Joel Fuhrman
t > Naptheon Inc. > 757-688-8180 > > > -Original Message- > From: Mark Bertrand [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 2:39 PM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting > > > Paul and all, > > When I attempt

Réf. : RE: Réf. : Re: Backup reporting

2002-09-19 Thread Guillaume Gilbert
r : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour :[EMAIL PROTECTED] cc : Objet : RE: Réf. : Re: Backup reporting I believe that this only affects the summary table data, not the accounting records. The accounting records are correct in the byte counts. I know you can'

Re: Backup reporting

2002-09-19 Thread Rainer Wolf
iginal Message- > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > > Bill Boyer > > Sent: Wednesday, September 18, 2002 3:10 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Backup reporting > > > > > > There was a problem where

Re: Backup reporting

2002-09-18 Thread Rushforth, Tim
f > Bill Boyer > Sent: Wednesday, September 18, 2002 3:10 PM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting > > > There was a problem where the bytes transferred in the summary table as > zero. It has been fixed in later patch levels. I'm not sure what the APAR >

Re: Backup reporting

2002-09-18 Thread Mr. Lindsay Morris
y, September 18, 2002 3:10 PM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting > > > There was a problem where the bytes transferred in the summary table as > zero. It has been fixed in later patch levels. I'm not sure what the APAR > number is or the level where it was

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

2002-09-18 Thread Seay, Paul
Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Paul and all, When I attempt to use any of the following select statements my "Total MB" returned is always 0. I get my list of nodes but there is never any numbers for size. Since this is my firs

Re: Réf. : Re: Backup reporting

2002-09-18 Thread Rejean Larivee
: Sent by: "ADSM: Dist Subject: Réf. : Re: Backup reporting Stor Ma

RE: Réf. : Re: Backup reporting

2002-09-18 Thread Bill Boyer
er [mailto:[EMAIL PROTECTED]]On Behalf Of Guillaume Gilbert Sent: Wednesday, September 18, 2002 3:27 PM To: [EMAIL PROTECTED] Subject: Rif. : Re: Backup reporting I'm at level 4.2.2.12 of the server on AIX and the summary table problems are still there. I am currently writing a PMR on this. Guilla

Réf. : Re: Backup reporting

2002-09-18 Thread Guillaume Gilbert
" <[EMAIL PROTECTED]> Envoyé par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : Re: Backup reporting There was a problem where the bytes transferred in the summary table as zero. It has been fixed in later patch levels. I&#

Re: Backup reporting

2002-09-18 Thread Bill Boyer
nsmitted field. Something for me to add to my Honey-Do list..:-) Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Bertrand Sent: Wednesday, September 18, 2002 2:39 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Pa

Re: Backup reporting

2002-09-18 Thread Mark Bertrand
mmand line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help:

Re: Backup reporting

2002-09-17 Thread Bill Boyer
er [mailto:[EMAIL PROTECTED]]On Behalf Of Halvorsen Geirr Gulbrand Sent: Monday, September 16, 2002 10:10 AM To: [EMAIL PROTECTED] Subject: Re: Backup reporting Hi, I have a suggestion on how to achieve one consolidated report for TSM. Unfortunately, I don't have the scripts (anymore), but one

Re: Backup reporting

2002-09-17 Thread Justin Case
PROTECTED]> To: [EMAIL PROTECTED] cc: Subject:Re: Backup reporting (See attached file: log.txt) =?iso-8859-1?Q?log.txt?= Description: Binary data

Re: Backup reporting

2002-09-17 Thread Pétur Eyþórsson
Simi TEL: +354-569-7700 Borgartun 37105 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

Re: Backup reporting

2002-09-16 Thread Seay, Paul
ve not formed */ /* a session in the last 24 hours to 30 days */ select node_name as "Node Name", substr(cast(lastacc_time as char(26)),1,16) as "Last Access" from nodes where upper(contact) not in ('*SUSPENDED*', '*RETIRED*') and upper(contact) not like