Determining which side of an optical platter a file is on?

2005-10-14 Thread Justin Derrick
Hi TSMers... I'm working on a project to extract archived data from almost 2000 optical platters. The data needs to come out of TSM temporarily, be reprocessed, and eventually, loaded back into TSM. The problem is, I want to do this in the most efficient way possible, and I'm having a little tr

select on events table question

2005-10-14 Thread TSM_User
I know that per APAR IC28825 if you try running select * from events you will only get the events for today. That APAR lists a work around where running select count(*) from events where scheduled_start between '2005-10-01 18:00:00' and '2005-10-15 06:00:00' will actually give you the events

Re: Include and sub-dirs

2005-10-14 Thread Laurent Bendavid
Zoltan Forray/AC/VCU wrote: I want to code an include statement that applies a management class to a specific directory/filesystem and all subdirs/filesystems beneath it. Do I need to have one include statement for each sub-filesystem ? We tried:INCLUDE /oracle_backups/* ORACLE_BACKUPS bu

Re: Query for schedule and node

2005-10-14 Thread Andrew Raibeck
Well, my query gives you pretty much what you expressed in your original post (except I swapped the order of platform and node). It would also help if you could clarify *exactly* what it is you are looking for, to avoid the problem of VIVO ("Vague In, Vague Out") :-))) You can rearrange the c

Re: Query for schedule and node

2005-10-14 Thread Gill, Geoffrey L.
Seems to be ok but unless I can run it on production I won't know for sure. The question now is how to get this to read in columns by nodename instead. Sorry if this is simple to others but I have no experience with these. DOMAIN_NAME: NT_DOM SCHEDULE_NAME: CLIENT2_M-F ACTION: INCREMENTAL

Re: Fw: Configuring JBB

2005-10-14 Thread Tab Trepagnier
Charles, For years we operated TSM with very little disk space. The trick is to use small disk pools of 5-10 GB with several volume files, and set a fairly low migration threshold - say 10-20% or so. In our case one of our disk pools was 4 GB as 20 x 200 MB volumes. We ran with HI=10, LO=0, so

Re: TSM 5.3 Doc

2005-10-14 Thread fred johanson
As you open each publication, there is an option for PDF Version. At 11:42 AM 10/14/2005 -0400, you wrote: Is the InfoCenter html view the only documentation available for TSM 5.3? Is there no way to print the 5.3 doc? David Fred Johanson ITSM Administrator University of Chicago 773-702-8464

Re: Query for schedule and node

2005-10-14 Thread Andrew Raibeck
This *might* do what you need. Initial testing suggests it works. Caveats: I guarantee nothing :-) and it will probaby take a while to run (mine took about 15 minutes). Try it and see; look at the tables separately and make sure the output you get looks correct. My main concern is that this still m

Re: TSM 5.3 Doc

2005-10-14 Thread Uwe Schreiber
Within each tree you can find a .pdf version. [EMAIL PROTECTED] Sent by: ADSM-L@VM.MARIST.EDU 14.10.2005 17:42 Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TSM 5.3 Doc Is the InfoCenter html view the only documentation available for TSM 5.3? Is there no w

Re: AW: [ADSM-L] TSM 5.3 Doc

2005-10-14 Thread David E Ehresman
Thank you SO much. What a clever place to hide it. David >>> [EMAIL PROTECTED] 10/14/05 11:51 AM >>> If you open a document in the InfoCenter the first entry on the left side for each document is the "PDF version". You can download and print the document form there. Thomas -Ursprünglich

AW: [ADSM-L] TSM 5.3 Doc

2005-10-14 Thread Thomas Rupp
If you open a document in the InfoCenter the first entry on the left side for each document is the "PDF version". You can download and print the document form there. Thomas -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von David E Ehresman

TSM 5.3 Doc

2005-10-14 Thread David E Ehresman
Is the InfoCenter html view the only documentation available for TSM 5.3? Is there no way to print the 5.3 doc? David

Re: Antwort: Errors restoring the SystemObject

2005-10-14 Thread Andrew Raibeck
The 5.1 client, starting at 5.1.6, includes support for Windows 2003. System object support uses the "legacy" APIs (same APIs as used by Windows 2000 and XP). This is documented in the client README file. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Int

Re: expiration Oracle backups

2005-10-14 Thread Allen S. Rout
==> On Fri, 14 Oct 2005 09:41:34 +0200, Rainer Holzinger <[EMAIL PROTECTED]> said: > In general this works fine in our installation. But in the meantime there is > one Oracle system where we have found 'old' TDPO objects in TSM storage but > no entries in the RMAN recovery catalog. Even a 'TDPOS

Re: Group collocation

2005-10-14 Thread fred johanson
I agree. It's just another instance of eternal vigilance forced on us by TSM. I have a group adding a dozen or more new clients a day. If I don't get them assigned to groups and they push so much to disk to force a migration, I wind up with a dozen or so 3592 cartridges with less than 1% used

Re: Include and sub-dirs

2005-10-14 Thread Eric Bourgi
INCLUDE /oracle_backups/.../* mgmt_class -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, October 13, 2005 9:46 PM To: ADSM-L@VM.MARIST.EDU Subject: Include and sub-dirs I want to code an include statement that

Re: Query for schedule and node

2005-10-14 Thread Leigh Reed
Geoff, I'm not 100% sure, but I think that what you're asking for is the classic SQL union of 2 select statements. As I understand it, this is possible in a traditional DB2, but the union & intersect operations are not available in the TSM SQL subset. The closest I can manage is the following sel

Antwort: Errors restoring the SystemObject

2005-10-14 Thread TSM
hi patricia, i think that tsm client version 5.1.7.3 is not able to backup w2003 at all, because w2003 backups for system objects and system state depends on vss and tsm 5.1 does not know these api! with best regards stefan savoric

Re: expiration Oracle backups

2005-10-14 Thread Rainer Holzinger
Hello, I'm running 18 Oracle systems on HP-UX which are backed up by TDP for Oracle. The TDP for Oracle version is 5.2.1.0, the TSM servers 5.2.4.1 on AIX 5.2 ML05. Oracle serves are at level 9i and 10g. Our Oracle administrators have written a RMAN script that deletes obsolete backups. I was moni

Re: expiration Oracle backups

2005-10-14 Thread Jurjen Oskam
On Thu, Oct 13, 2005 at 07:38:18AM -0700, Neil Rasmussen wrote: > When deleting Rman objects on the TSM Server, TDP Oracle uses the delete > function on objectsthe objects do not move to inactive they are just > simply deleted from the TSM Server. While the manual says to create nodes for RMA