Re: Re: command to query how much data is stored

Kelly Lipp wrote: > > Now the big dogs will weigh in with the perfect 300 character SQL > select statement with it summarized, etc, but this will get you > started. It sounded more to me like Richard is looking for "query stgpool"... :) Well, if he doesn't want to do the math by hand, something

Re: reclamation

. Richard - it is not reclaiming anything, because you don't have any tapes to reclaim. The script you are using that shows tapes awaiting reclamation at 99% utilized is misleading you. That is showing you how many tapes you could reclaim if you set the threshold to 1. The basic prioblem is that %

Re: Re: command to query how much data is stored

How about 'select sum(physical_mb) from occupancy where stgpool_name='TAPEPOOL'? On Tue, Nov 11, 2008 at 3:01 AM, David Bronder <[EMAIL PROTECTED]>wrote: > Kelly Lipp wrote: > > > > Now the big dogs will weigh in with the perfect 300 character SQL > > select statement with it summarized, etc,

Include/Exclude tester?

Has someone created an include/exclude tester to show me the errors of my ways (besides from the client side)? I have this statement in my CLOPTSET: INCLEXCL EXCLUDE *:\...\Sophos\* and FORCE=YES Yet I still see boxes that have this cloptset assigned to them backing up files like: \PROG

Re: Include/Exclude tester?

I think that only excludes files with the immediate parent directory named "sophos" Keep that and add: *:\...\sophos\...\* Regards, Shawn Shawn Drew Internet [EMAIL PROTECTED] Sent by: ADSM-L@VM.MARIST.EDU 11/11/2008 01:42 PM Please respond t

Recovery Log Query

Hi TSM Server version 5.3.3.1 I have a query regarding some unusual activity a couple of nights ago. Our recovery log is 12gb and is in NORNAL mode I ran a full database backup at 16:00 Saturday - that should clear the log down During the night, the log appears to go to 80%. Or so the followi

Re: NDMP restore

Once again the answer was read the fantastic manual. Thank you for pointing me to the correct one. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Michael Green Sent: Tuesday, November 11, 2008 1:51 AM To: ADSM-L@VM.MARIST.EDU Subject

CBRM - Centera and my TSM server.

Can someone give me a clue ? I've been tasked to back up our Centera... I have no working knowledge of CBRM and have not been through any previous exercises to define NDMP operations on TSM. What I have: TSM server EE 5.4.3 on AIX. CBRM version 2.2. T950 library with 10 LTO4 drives. I have th

Re: command to query how much data is stored

I see it's been about a day, and I'd hate for you to be disappointed, Kelly, so here goes. select stgpool_name, sum(est_capacity_mb*pct_utilized/100) from volumes group by stgpool_name OK, so it's short by about 200 characters -- I'll just have to try harder next time. :o) disclaimer: I didn't

Re: Recovery Log Query

You likely have a backup session that is "pinning" the log in place until the backup completes. Create a TSM script that runs QUERY LOG >> every minute or so. Examine the file every day to see if the same sort of thing happens regularly. Note the timestamps, and discover what clients are backing

Re: CBRM - Centera and my TSM server.

For the Celerra, the NDMP manuals is at powerlink.emc.com, requires powerlink account Under support, technical documentation and Advisories, Hardware/platforms Documentation, Celerra network server, installation/configuration scroll down for NDMP -Original Message- From: ADSM: Dist Stor

Re: CBRM - Centera and my TSM server.

There are 2 webcast which may be helpful Tivoli Storage Manager (TSM) Backup Considerations with Nseries http://www-01.ibm.com/support/docview.wss?rs=2077&context=SSGSG7&dc=DA41 0&dc=DA450&dc=DA430&dc=DA440&dc=D600&dc=D700&dc=DB510&dc=DB520&dc=D800&d c=D900&dc=DA900&dc=DA800&dc=DB540&dc=DB400&dc=D