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 like

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, but this

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:

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 to

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

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

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

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

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 filename 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

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

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=2077context=SSGSG7dc=DA41 0dc=DA450dc=DA430dc=DA440dc=D600dc=D700dc=DB510dc=DB520dc=D800d