start maintenance script after backups

2006-08-28 Thread Kurt Beyers
Hello, I was starting my TSM maintenance script (TSM server 5.3.2 on AIX 5.3) with the following sql query to make sure that the backups were finished. If the backups are still running, the script is rescheduled 15 minutes later. /* Maintenance script*/ select * from processes where process=

SYSSTATE\SYSFILES [Assigned]

2006-08-28 Thread Henrik Wahlstedt
Hi, W2k3 client , 5.3.3.0. Normally in dsmsched.log you see [Change/Sent] after files are submitted to TSM. I guess "SYSSTATE\SYSFILES [Assigned]" are normal.. but what is sysfiles assigned to?? There are no includes to other management classes in dsm.opt/clopset´s. //Henrik tsm> b

Re: start maintenance script after backups

2006-08-28 Thread Аккерман Ефим
Hello, try this: select * from sessions where upper(session_type)='NODE' if (rc_ok) goto reschedule ... ... ... ... exit reschedule: delete schedule BACKUP_SCRIPT_RETRY type=admin define schedule BACKUP_SCRIPT_RETRY type=admin cmd="run BACKUP_SCRIPT" active=yes starttime=NOW+0:20 peru=onetime

Copy storage pool volume in limbo

2006-08-28 Thread Tim Brown
Have a storage pool volume that displays as 0.3 full, I run q content against the volume and it TSM says it has no data. I try and delete the volume and nothing happens. How can I remove the volume from TSM Tim Brown Systems Specialist Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY

Re: Copy storage pool volume in limbo

2006-08-28 Thread Richard Sims
On Aug 28, 2006, at 7:34 AM, Tim Brown wrote: Have a storage pool volume that displays as 0.3 full, I run q content against the volume and it TSM says it has no data. I try and delete the volume and nothing happens. How can I remove the volume from TSM Tim - An often encountered problem, which

Re: Encryption in API

2006-08-28 Thread Del Hoobler
Fred, Go to: http://www.ibm.com/us/ Search for: "Encrypting Data Protection for SQL Backups" (include the double quotes around the "Search for" text) Del "ADSM: Dist Stor Manager" wrote on 08/25/2006 01:07:23 PM: > Since T

Re: Upgrade IBM 3584 LTO-1 to LTO-3 drives

2006-08-28 Thread Aaron Durkee
We did this. One thing is the lto-3 drives will only be able to read your lto-1 media, but not write to it. It could cost quite a bit to do a complete converstion over. >>> [EMAIL PROTECTED] 08/27/06 09:20PM >>> Yes. See your IBM Business Partner for the details and costs. Orville L. Lantto Gl

Re: Copy storage pool volume in limbo

2006-08-28 Thread Tim Brown
Does the volume have to be physically available to audit it The partricular tape I am dealing with is an offsite tape. ANR2425E AUDIT VOLUME: Unable to access volume A01758 - access mode is set to "offsite". Tim - Original Message - From: "Richard Sims" <[EMAIL PROTECTED]> To: Sent: M

Re: Copy storage pool volume in limbo

2006-08-28 Thread Kurt Beyers
Tim, The audit does indeed require that the volume is in the library. If it is a copy storage pool volume, you just can delete it with the option discarddata=yes. The files that were on the volume will be included in the next backup of the primary storage pools. Regards, Kurt -Original Mess

Re: start maintenance script after backups

2006-08-28 Thread Kurt Beyers
Efim, Thanks for the suggestion, I will give it a go but can't test it right now. A session openend by a storage agent will be of the 'SERVER' type and thus not be detected by the sql query? Best regards, Kurt -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On

Re: start maintenance script after backups

2006-08-28 Thread Efim
Kurt, When you use Storage Agent they open min 2 session, one for data (SERVER) and one for control (NODE). I can't test this now. Efim * Kurt Beyers <[EMAIL PROTECTED]> [Mon, 28 Aug 2006 15:00:48 +0200]: Efim, Thanks for the suggestion, I will give it a go but can't test it right now. A

Re: Encryption in API

2006-08-28 Thread fred johanson
Thanks Del. I suspected that is the way it works for SQL. I can't surmise how to limit how much ORACLE is encrypted. At 08:44 AM 8/28/2006 -0400, you wrote: Fred, Go to: http://www.ibm.com/us/ Search for: "Encrypting Data Protection for SQL Backups" (include the double quot

Re: Encryption in API

2006-08-28 Thread Neil Rasmussen
Fred, Encrypting Oracle databases with DP Oracle is accomplished in very much the same fashion. The twist? In order to exploit the include.encrypt statements you will have to rely on the 'format' statement in the RMAN scripts that you use to backup your Oracle database. Using the 'format' statemen

Re: Encryption in API

2006-08-28 Thread fred johanson
Thanks Neil, explicit examples would mean I don't lose anything in transmission to the ORACLE DBAs. At 07:40 AM 8/28/2006 -0700, you wrote: Fred, Encrypting Oracle databases with DP Oracle is accomplished in very much the same fashion. The twist? In order to exploit the include.encrypt stateme

Re: TDP for Mail question

2006-08-28 Thread Del Hoobler
Ku, Yes... if all of the backups are correctly bound to the "NOTESMC" management class as you have it defined below, then all backup objects (logs and databases) will be kept on the TSM Server for 90 days. Did you try it? Is there a problem? Thanks, Del -

Re: TDP for Mail question

2006-08-28 Thread Hans-Dieter Kutz
On Mon, Aug 28, 2006 at 11:01:46AM -0400, Del Hoobler wrote: > Ku, > > Yes... if all of the backups are correctly bound to the "NOTESMC" > management class as you have it defined below, then all backup objects > (logs and databases) will be kept on the TSM Server for 90 days. > Did you try it? Is t

Re: Copy storage pool volume in limbo

2006-08-28 Thread Prather, Wanda
When I have run into this issue, it was sufficient to do UPDATE VOL x access=readonly. Didn't have to actually check the tape into the library. TSM never called for a mount, because it finally detected there was really no data on the volume. Won't hurt to try..

TSM loses tape drives (again and again and again...)

2006-08-28 Thread Rob Berendt
Seems pretty consistent that when we IPL our Linux partition on our iSeries TSM will no longer talk to the tape drives. q system Storage Management Server for Linux/ppc64 - Version 5, Release 3, Level 3.1 Suse Linux on iSeries. backup db devclass=lto_class type=full scratch=yes wait=no results in:

Problem deleting disk pool volume.

2006-08-28 Thread Mcnutt, Larry E.
TSM Server 5.3.3.0 AIX 5.3 ML4 Hello list, I have a disk pool volume that I cannot seem to delete. I have used "move data" to empty the volume, but when I try a "delete volume", it says the volume contains data. However, "audit volume fix=yes" says there is no data in the volume. Any help is a

Re: Encryption in API

2006-08-28 Thread Neil Rasmussen
Fred, Here is the basic idea: Let's say that you have 3 databases, DB1 and DB2 and DB3, and you only want to encrypt data for DB2 and DB3. You would need to have an RMAN script for each database. Data Proctection for Oracle can share the same dsm.opt among these databases. Assuming your TDPO_FS is

Re: Copy storage pool volume in limbo

2006-08-28 Thread Tim Brown
Thanks, that Worked !! Tim - Original Message - From: "Prather, Wanda" <[EMAIL PROTECTED]> To: Sent: Monday, August 28, 2006 12:38 PM Subject: Re: Copy storage pool volume in limbo When I have run into this issue, it was sufficient to do UPDATE VOL x access=readonly. Didn't have to

FW: Problem deleting disk pool volume.

2006-08-28 Thread Mcnutt, Larry E.
Sorry, but I have no clue as to what caused the format of my original post to be so trashed. I hope this is better. Thanks, Larry -Original Message- From: Mcnutt, Larry E. Sent: Monday, August 28, 2006 2:59 PM To: Mcnutt, Larry E. Subject: FW: Problem deleting disk pool volume.

Problem deleting disk pool volume.

2006-08-28 Thread Mcnutt, Larry E.
Well maybe this method will work. Larry McNutt The Timken Company - This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not forward, copy, print, use or disclose this com

Identifying nodes per MgmtClass

2006-08-28 Thread Doug Fox
Hello guys and gals, I'm trying to do some maintenance and cleaning on our TSM environment. Part of this includes cleaning up old policies and nodes. What I would like to do is be able to identify what (if any) nodes are using a management class. Is there a way to search and find out which noeds

Re: Identifying nodes per MgmtClass

2006-08-28 Thread Miller, Ryan
You can run this query to get that info for backups: Select distinct node_name,class_name from backups For archives, just change backups to archives Ryan Miller Tivoli Certified Consultant Principal Financial Group -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTE

Re: FW: Problem deleting disk pool volume.

2006-08-28 Thread Roger Deschner
Usually, I simply wait an hour or two, and this resolves itself. Some process has something here pinned, and that process has to finish. Could be a backup, a restore, expiration, reclamation, or who knows what internal machination. Patience has usually worked for me on problems of this nature. If

TDP for exchange error

2006-08-28 Thread Robert Ouzen Ouzen
Hi to all I have an exchange server Windows2003 (not in cluster) with TDP version 5.2.1 I backup it at Sunday Tuesday Thursday full (at 23:00) and between 3 times a day incremental (at 9 , 15 , 20). The 3 incrementals after the full are running correctly but the second day I got the followin