TSM Storage Pool Hierarchy Question

2003-10-20 Thread Curt Watts
Alright, time to ask the experts! Essentially, I'm trying to have our remote TSM servers (satellite locations) utilize the main TSM server as the next storage pool in it's hierarchy. The hierarchy will eventually look like this: Remote Server (RS) Disk Cache -Main Server (MS) Disk Cache -

Re: SQL to determine what offsite volumes are needed for move data

2003-10-20 Thread Zlatko Krastev
--> This list of tapes is used by the operators to go and fetch the tapes to be brought onsite. I cannot figure it out! For what a reason you prefer to add more risk to your offsite copies by bringing them onsite? Before new copies reach the vault you are having *no* offsite copies (or your copies

SQL select problems

2003-10-20 Thread Simeon Johnston
I'm trying to run some select statements and get a summary of the bytes transferred during a backup. No matter what I use, the bytes transferred always = 0. In the msi GUI it all looks good, but the dsmadmc select queries come up w/ 0. Is this a known problem or am I doing something wrong? Why d

Re: Database fragmentation formula (was Re: Online DB Reorg)

2003-10-20 Thread Wayne T. Smith
Hi Zlatko, If I plug into your formula, I get ... 1492.648 0.81294 14396.6095.29128 (clearly under utilized). But (ADSM V3.1(ancient)) shows ... Available Assigned Maximum MaximumPage Total Used Pct Max. Space Capacity Extension Reduction

Re: Move data

2003-10-20 Thread David E Ehresman
>There are no errors showing in the logs for any of >the tapes. Sometimes when I come in in the morning reclamation is still >running on the offsite pool This sounds like you are setting the reclaim level too low. Start by setting it higher, e.g. 90. If reclaim is able to process that in your ti

Re: Move data

2003-10-20 Thread David Longo
Try running you reclamation at say 90% and see if that doesn't free a bunch up. You may have so many that it is trying to reclaim say 100 tapes ansd will take forever as more tapes are added each day. Try 90% for a couple of days. David B. Longo System Administrator Health First, Inc. 3300 Fi

Re: Database fragmentation formula (was Re: Online DB Reorg)

2003-10-20 Thread Wheelock, Michael D
Hi, First off, let me say that this a wonderfully explained set of formulas and analysis. Isn't this getting a little off the mark though? Last I checked, almost every database on the planet (yes even pervasive sql) when allocating pages/extents, left an amount of space unutilized at the end. I

Re: Move data

2003-10-20 Thread Gill, Geoffrey L.
>I have used the MOVE DATA without any problems. Usually it is >because of a percieved problem with the offsite tape. But it should work >for what you want to do. >WHy doesn't Reclaimation get this done for you? >Matt That is a good question. There are no errors showing in the lo

Database fragmentation formula (was Re: Online DB Reorg)

2003-10-20 Thread Zlatko Krastev
* ATTENTION * Those who do not like the mathematics, skip to the end (search for word "select"). * >From my mathematical background this query is not showing very good results. The formula looks like ( MAX_REDUCTION_MB * 256 ) 100 - -

Re: Move data

2003-10-20 Thread MC Matt Cooper (2838)
Gill, I have used the MOVE DATA without any problems. Usually it is because of a percieved problem with the offsite tape. But it should work for what you want to do. WHy doesn't Reclaimation get this done for you? Matt -Original Message- From: Gill, Geoffrey L. [mailto:[E

Re: Win2K Device Support SAIT drives

2003-10-20 Thread Himanshu A Madhani
SONY SAIT drives will be supported in TSM 5.2.2 which is scheduled to be released end of this year. Himanshu Madhani Tivoli Storage Manager Development

Re: Very slow backups of Exchange 5.5 with tpdexcc

2003-10-20 Thread Del Hoobler
David, The underlying backup code is identical for the command-line and GUI for Data Protection for Exchange. I agree something doesn't sound right. I would take a closer look at the logs for both Data Protection for Exchange and the TSM Server to make sure the same data and same amount of data w

Re: Online DB Reorg

2003-10-20 Thread Robin Sharpe
Mine came back as 0.02 does that mean it is not very fragmented? Our database is 112GB, 78.8% used, was "new" in October 2001 and has never been reorganized. Robin Sharpe Berlex Labs |-+---> | | "Prather, Wanda"| | | <[EMAI

Move data

2003-10-20 Thread Gill, Geoffrey L.
Have any of you used the move data command to try and consolidate data from filling tapes that have been sent offsite to tapes within the library that will be sent offsite? At the moment we have over 180 tapes in filling status offsite, anywhere from 0.1% to 100% filling. I'd like to at least see i

Re: Export server

2003-10-20 Thread MC Matt Cooper (2838)
Dave, I have just completed moving 300 desktops and servers from 1 TSM server to another. I do not know how many clients you are dealing with but the things I can tell you are... 1) the TCPSERVERADDRESS and the TCPPORT on the clients DSM.OPT dictate where they are backed up to, not the TSM

Very slow backups of Exchange 5.5 with tpdexcc

2003-10-20 Thread Tyree, David
We are running Exchange 5.5 on a box running Win2k Sp2, 1.1 GHz x2 with 2.6 gig ram, TSM version 5.1.5.2, and TDP version 5.1.5.0. It's talking a TSM server running 5.1.6. The backups are normally ran via a batch file using the command line program with the switches we wan

Re: Online DB Reorg

2003-10-20 Thread Prather, Wanda
That query (taken here from ADSM.QuickFacts) confuses me entirely - can someone please explain? SELECT CAST((100 - ( CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) / (CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS

Win2K Device Support SAIT drives

2003-10-20 Thread Dean Winger
Help Please I am in the market for a new tape library. I have been watching the developments with Sony's SAIT technology. Not many libraries on the market yet but I have managed to find a few. So, will TSM support SAIT, and if so what is the timeline? Thanks Dean Winger Network Administrator

Re: Export server

2003-10-20 Thread Clark, Rodney
I would take the last option anyday. -Original Message- From: Dave Adams [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 1:48 PM To: [EMAIL PROTECTED] Subject: Export server We are planning to reinstall our Windows 2000-based TSM server with Linux. We only use DASD for storage.

History of ITSM/TSM/ADSM/...

2003-10-20 Thread asr
Howdy, all. I've only been around TSM since ADSM 2.1; I recall hearing bits and pieces of the earlier versions and the roots of the product. Could someone who was there synopsize, and perhaps someone who FAQs capture it? I rooted around in the archives and Mr. Sims' fine quickfacts, but didn't s

Re: Online DB Reorg

2003-10-20 Thread Wayne T. Smith
John Naylor wrote, in part: OK I ran Remco's sql and it reports my database is 53% fragmented. Maybe this makes you feel better? My result is 99.80, but then my database isn't what it used to be :-)cheers, wayne

Re: vault to vaultretrieve

2003-10-20 Thread Richard van Denzel
It's a two-way procedure: MOVE DRMEDIA WHERESTATE=VAULT TOSTATE=COURIERRETRIEVE MOVE DRMEDIA WHERESTATE=COURIERRETRIEVE TOSTATE=VAULTRETRIEVE Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant

vault to vaultretrieve

2003-10-20 Thread Alegra Fernandez
Is there anyway to manually set a volume from vault to vaultretrieve? If not, how does one recall offsite volumes in a vault state? I have a problem with my expiration, and I'm running VERY low on scratches. So I'm trying to retrieve some of my offsite tapes. And since expiration isn't automatic

Re: Online DB Reorg

2003-10-20 Thread John Naylor
OK I ran Remco's sql and it reports my database is 53% fragmented. I know that a fragmented database is the natural state, but is there any level of fragmentation that you should start to get worried at ? Not being a database expert I would say only worry if TSM cache hits start slipping badly, bu

Re: Online DB Reorg

2003-10-20 Thread Loon, E.J. van - SPLXM
Hi Guys! The SQL statement can also be found at Richard's quickfacts page: http://people.bu.edu/rbs/ADSM.QuickFacts Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Remco Post [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:30 To: [EMAIL PROTECT

Re: Online DB Reorg

2003-10-20 Thread Remco Post
On Sat, 18 Oct 2003 14:35:09 -0400 "Talafous, John G." <[EMAIL PROTECTED]> wrote: > Remco, > Would you be willing to share your SQL query that reports on DB > fragmentation? > I was allready looking at Eric (he probably saved my thingy somewhere usefull, I just saved it in my sent-mail folder)

need help tsm san manger on w2k

2003-10-20 Thread TSM
hello, environment: windows nt 4.0 tsm server 4.2.x tsm client 4.2.x tsm san manager 4.2.x lto 3584, 4 drives i need some help upgrading nt4 .0 san agent to w2k. the problem is, that the registry parameter maximumsglist is false (too small), but under nt4.0 everything (also restore) is working