start maintenance script after backups
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='Backup' if(rc_ok) goto reschedule /* Start maintenance if backups are finished */ ... exit /* Reschedule the script if the backups are not yet finished */ reschedule: delete schedule maitenance t=a define schedule maintenance t=a cmd='run maintenance' startt=now+0:15 dur=15 duru=m per=1 peru=h active=yes One night, a large backup took place (a few TB) over the SAN and the maintenance script started however. So the sql query did not detect the running backups. What sql query should be used to verify that no backups (LAN or SAN) are currently running? Is there a better query on another table (sessions, ...)? Thanks in advance for any suggestions! best regards, Kurt
SYSSTATE\SYSFILES [Assigned]
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> ba systemstate Backup System State using shadow copy... Backup System State: 'System Files'. Backup System State: 'COM+ Database'. Backup System State: 'Registry'. Backup System State: 'Active Directory'. Backup System State: 'Certificate Server'. Backup System State: 'System Volume'. ANS1898I * Processed 500 files * ANS1898I * Processed 1,000 files * ANS1898I * Processed 1,500 files * ANS1898I * Processed 2,000 files * ANS1898I * Processed 2,500 files * ANS1898I * Processed 3,000 files * Normal File--> 0 \SYSSTATE\SYSFILES [Assigned] < 660.67 MB> [- ] --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
Re: start maintenance script after backups
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 Efim * Kurt Beyers <[EMAIL PROTECTED]> [Mon, 28 Aug 2006 09:31:23 +0200]: 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='Backup' if(rc_ok) goto reschedule /* Start maintenance if backups are finished */ ... exit /* Reschedule the script if the backups are not yet finished */ reschedule: delete schedule maitenance t=a define schedule maintenance t=a cmd='run maintenance' startt=now+0:15 dur=15 duru=m per=1 peru=h active=yes One night, a large backup took place (a few TB) over the SAN and the maintenance script started however. So the sql query did not detect the running backups. What sql query should be used to verify that no backups (LAN or SAN) are currently running? Is there a better query on another table (sessions, ...)? Thanks in advance for any suggestions! best regards, Kurt --
Copy storage pool volume in limbo
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 12601 Email: [EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255
Re: Copy storage pool volume in limbo
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 Audit Volume Fix=yes usually treats. Richard Sims
Re: Encryption in API
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 TDP for ORACLE and MSSQL use the API, I should be able to encrypt > some or all of DB backups we do. Since SQL generates the directory name > for the backup, how do we determine which is which to include or exclude > selected DBs on a particular client? We have one client with about 75 DBs > on it and not all should be encrypted.
Re: Upgrade IBM 3584 LTO-1 to LTO-3 drives
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 Glasshouse Technologies, Inc. From: ADSM: Dist Stor Manager on behalf of Zosimo Noriega Sent: Sun 8/27/2006 03:00 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Upgrade IBM 3584 LTO-1 to LTO-3 drives Hi Sir, Please help me regarding my inquiries. Is it possible to upgrade IBM 3584 with existing 6 LTO-1 tape drives into 6 LTO-3 tape drives? What consideration may required? We have AIX 5.1 (p610 server) with TSM 5.1 server. Tape Library: IBM 3584 UltraScalable Tape Library with 6 FC drives & 254 slots. Thanks for your help in advance. Best Regards, Zosimo B. Noriega Systems Analyst, Data Storage ADNOC - IS&T P.O. Box 898, Abu Dhabi, United Arab Emirates Tel: 971-2-6024987/971-50-5914267/Fax: 971-2-6665587 Email: [EMAIL PROTECTED]; [EMAIL PROTECTED] This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e- mail. - CONFIDENTIALITY NOTICE: This message is confidential, intended only for the named recipient(s) and may contain information that is privileged, or exempt from disclosure under applicable law. If you are not the intended recipient(s), you are notified that the dissemination, distribution or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender by reply e-mail, delete this e-mail from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege. This message and all contents may be reviewed by authorized parties of the Catholic Health System other than those named in the message header. The contents of this message do not bind the Catholic Health System to any contract, position, or course of action unless the sender is specifically authorized to enter into contracts on behalf of the Catholic Health System. The contents of this message do not necessarily constitute an official representation of the Catholic Health System.
Re: Copy storage pool volume in limbo
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: Monday, August 28, 2006 8:21 AM Subject: Re: Copy storage pool volume in limbo 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 Audit Volume Fix=yes usually treats. Richard Sims
Re: Copy storage pool volume in limbo
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 Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: maandag 28 augustus 2006 14:53 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Copy storage pool volume in limbo 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: Monday, August 28, 2006 8:21 AM Subject: Re: Copy storage pool volume in limbo > 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 Audit Volume Fix=yes > usually treats. > >Richard Sims >
Re: start maintenance script after backups
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 Behalf Of Sent: maandag 28 augustus 2006 12:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] start maintenance script after backups Hello, try this: select * from sessions where upper(session_type)='NODE' if (rc_ok) goto reschedule ...
Re: start maintenance script after backups
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 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 Behalf Of Sent: maandag 28 augustus 2006 12:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] start maintenance script after backups Hello, try this: select * from sessions where upper(session_type)='NODE' if (rc_ok) goto reschedule ... -- Efim.
Re: Encryption in API
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 quotes around the "Search for" text) Del "ADSM: Dist Stor Manager" wrote on 08/25/2006 01:07:23 PM: > Since TDP for ORACLE and MSSQL use the API, I should be able to encrypt > some or all of DB backups we do. Since SQL generates the directory name > for the backup, how do we determine which is which to include or exclude > selected DBs on a particular client? We have one client with about 75 DBs > on it and not all should be encrypted. Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Encryption in API
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' statement allows you to prepend/append characters (strings) to each backup piece. For instance, you may have an RMAN script for each database, say DB1 and DB2, then prepend these strings to each 'format' statement in your RMAN script. Then you can use these identifiers in your include.encrypt statements in your dsm.opt file. I can give you explicit examples if you need them. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] fred johanson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/28/2006 07:00 AM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: Encryption in API 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 quotes around the "Search for" text) > >Del > > > >"ADSM: Dist Stor Manager" wrote on 08/25/2006 >01:07:23 PM: > > > Since TDP for ORACLE and MSSQL use the API, I should be able to encrypt > > some or all of DB backups we do. Since SQL generates the directory name > > for the backup, how do we determine which is which to include or exclude > > selected DBs on a particular client? We have one client with about 75 >DBs > > on it and not all should be encrypted. Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Encryption in API
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 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' statement allows you to prepend/append characters (strings) to each backup piece. For instance, you may have an RMAN script for each database, say DB1 and DB2, then prepend these strings to each 'format' statement in your RMAN script. Then you can use these identifiers in your include.encrypt statements in your dsm.opt file. I can give you explicit examples if you need them. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] fred johanson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/28/2006 07:00 AM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: Encryption in API 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 quotes around the "Search for" text) > >Del > > > >"ADSM: Dist Stor Manager" wrote on 08/25/2006 >01:07:23 PM: > > > Since TDP for ORACLE and MSSQL use the API, I should be able to encrypt > > some or all of DB backups we do. Since SQL generates the directory name > > for the backup, how do we determine which is which to include or exclude > > selected DBs on a particular client? We have one client with about 75 >DBs > > on it and not all should be encrypted. Fred Johanson ITSM Administrator University of Chicago 773-702-8464 Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: TDP for Mail question
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 "ADSM: Dist Stor Manager" wrote on 08/24/2006 10:19:46 AM: > Hello List, > TSM-Server AIX 5.2 > TDP for Mail TDP-Domino-5.3.0-2 > > - Backing up selective on Saturday > - After selective --> domina (inactivation of archive logs) > - Doing Archivelog-Backup until Saturday > - Backing up selective on Saturday and so on ... > > Our copygroup for Notes: > tsm: server>q copyg notes > > PolicyPolicyMgmt Copy Versions Versions Retain Retain > DomainSet Name Class Group Data DataExtra Only > NameName NameExists Deleted Versions Version > - - - - --- > NOTES ACTIVENOTESMC STANDARD No Limit No Limit 90 90 > > My question: > - Doing sel-Backup on 05.08.2006 > - Doing arc-Backup on 06.08-11.08.2006 > - Doing sel-Backup on 12.08.2006 > - Doing inactivate archivelogs on 12.08.2006 after backup > > Is is possible to restore all from week 05.08-12.08.2006, for example restore > 09.08.2006 12:00, if the inactivate process has run on 12.08.2006? > As you can see from the copyg-output has "No Limit" for Versions Data > Exists/Deleted! > > Cheers, > ku
Re: TDP for Mail question
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 there a problem? No Problem. Only newbie to TDP for Mail. Tested to restore old Database and applying Archivelogs to that DB. It worked well. Thanx to all that answered. Cheers, ku -- Yoda: When nine hundred years old you reach, look as good you will not. Hmm?
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 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.. From: ADSM: Dist Stor Manager on behalf of Tim Brown Sent: Mon 8/28/2006 8:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Copy storage pool volume in limbo 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: Monday, August 28, 2006 8:21 AM Subject: Re: Copy storage pool volume in limbo > 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 Audit Volume Fix=yes > usually treats. > >Richard Sims >
TSM loses tape drives (again and again and again...)
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: 08/28/2006 12:28:02 ANR8779E Unable to open drive /dev/IBMtape1, error number=22.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:02 ANR8945W Scratch volume mount failed 04WK1. (SESSION: 1, PROCESS: 2) 08/28/2006 12:28:02 ANR1792W HBAAPI vendor library failed to load or is missing.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:02 ANR8963E Unable to find path to match the serial number defined for drive TAPMLB011 in library TAPMLB01.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:02 ANR8779E Unable to open drive /dev/IBMtape1, error number=21.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:38 ANR8381E LTO volume 04WK1 could not be mounted in drive TAPMLB011 (/dev/IBMtape1).(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:38 ANR1404W Scratch volume mount request denied - mount failed.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:38 ANR4578E Database backup/restore terminated - required volume was not mounted.(SESSION: 1, PROCESS: 2) 08/28/2006 12:28:38 ANR0985I Process 2 for DATABASE BACKUP running in the BACKGROUND completed with completion state FAILURE at 12:28:38 PM. (SESSION: 1, PROCESS: 2) In Linux I tried: IBMtapeutil 1. Open a Device /dev/IBMtape1 for read/write 3. Inquiry Inquiry Data: Peripheral Qualifier---0x00 Peripheral Device Type0x01 Removal Medium Bit1 Device Type Modifier--0x00 ISO version---0x00 ECMA version--0x00 ANSI version--0x03 Asynchronous Event Notification Bit---0 Terminate I/O Process Message Bit-0 Response Data Format--0x02 Additional Length-0x35 Medium Changer Mode---0x00 Relative Addressing Bit---0 32 Bit Wide Data Transfers Bit0 16 Bit Wide Data Transfers Bit0 Synchronous Data Transfers Bit0 Linked Commands Bit---0 Command Queueing Bit--0 Soft Reset Bit0 Vendor ID-IBM Product IDULT3580-TD2 Product Revision Level4772 vendor1, Length 20 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF - [] 0010 - [] vendor2, Length 31 0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF - [] 0010 - 00[... ] I do NOT see the serial number. Am I looking in the wrong spot? Rob Berendt -- Group Dekko Services, LLC Dept 01.073 PO Box 2000 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com
Problem deleting disk pool volume.
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 appreciated. Thanks, Larry McNutt The Timken Company tsm: FSPHTSM2>q vol stg=workstn Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /tsm1stg1/tsm2disk03.dsm WORKSTN DISK 25,600.00.5 On-Line /tsm1stg2/tsm2disk02.dsm WORKSTN DISK 25,600.06.4 On-Line /tsm1stg2/tsm2disk05.dsm WORKSTN DISK 25,000.05.5 On-Line /tsm1stg3/tsm2disk05.dsm WORKSTN DISK 12,500.06.7 On-Line /tsm1stg4/tsm2disk05.dsm WORKSTN DISK 12,500.0 16.1 On-Line /tsm2stg1/tsm2disk03.dsm WORKSTN DISK 10,240.01.9 On-Line /tsm2stg2/tsm2disk03.dsm WORKSTN DISK 10,240.00.7 On-Line /tsm5stg1/tsm2disk03.dsm WORKSTN DISK 50,000.01.8 On-Line /tsmstg2/disk01.dsm WORKSTN DISK 50,000.0 -1.1 On-Line <= This is the volume tsm: FSPHTSM2>q vol /tsmstg2/disk01.dsm f=d Volume Name: /tsmstg2/disk01.dsm Storage Pool Name: WORKSTN Device Class Name: DISK Estimated Capacity: 50,000.0 Scaled Capacity Applied: Pct Util: -1.1 Volume Status: On-Line Access: Read-Only Pct. Reclaimable Space: Scratch Volume?: In Error State?: Number of Writable Sides: Number of Times Mounted: Write Pass Number: Approx. Date Last Written: Approx. Date Last Read: Date Became Pending: Number of Write Errors: Number of Read Errors: Volume Location: Volume is MVS Lanfree Capable : Last Update by (administrator): MCNUTT Last Update Date/Time: 08/22/06 17:31:36 Begin Reclaim Period: End Reclaim Period: tsm: FSPHTSM2>audit volume /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. Do you wish to proceed? (Yes (Y)/No (N)) y ANR2209W Volume /tsmstg2/disk01.dsm contains no data. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANRD dsaudit.c(1097): ThreadId<80> Erroneous information for volume /tsmstg2/disk01.dsm was removed from the database. ANRD ThreadId<80> issued message from: <-0x00010001c240 outDiagf <-0x000100414b98 DsAuditEmptyVol <-0x0001004108d8 ssAuditEmptyVol <-0x00010075aa48 DoAuditVolume <-0x00010075f218 AdmAuditVolume <-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand <-0x000100507694 SmAdminCommandThread <-0x0001e9dc StartThread <-0x093f52f8 _pthread_body ANR2209W Volume /tsmstg2/disk01.dsm contains no data. tsm: FSPHTSM2>delete volume /tsmstg2/disk01.dsm ANR2220W This command will delete volume /tsmstg2/disk01.dsm from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) y ANS8001I Return code 13. ANR2017I Administrator MCNUTT issued command: DELETE VOLUME /tsmstg2/disk01.dsm ANR2406E DELETE VOLUME: Volume /tsmstg2/disk01.dsm still contains data. ANR2017I Administrator MCNUTT issued command: ROLLBACK Date/TimeMessage -- 08/28/06 09:48:43 ANR2017I Administrator MCNUTT issued command: QUERY VOLUME /tsmstg2/disk01.dsm f=d (SESSION: 346448) 08/28/06 09:49:38 ANR2017I Administrator MCNUTT issued com
Re: Encryption in API
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
/adsmorc here is what it might look like:
RMAN script for DB1:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB1_%d_%t_%s_%p'
(database);
}
RMAN script for DB2:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB2_%d_%t_%s_%p'
(database);
}
RMAN script for DB3:
run
{
allocate channel t1 type 'sbt_tape';
backup
format 'DB3_%d_%t_%s_%p'
(database);
}
**
dsm.opt
include.encrypt /adsmorc/.../DB2_*
include.encrypt /adsmorc/.../DB3_*
Regards,
Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]
fred johanson <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
08/28/2006 07:54 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Encryption in API
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
>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'
>statement allows you to prepend/append characters (strings) to each
backup
>piece. For instance, you may have an RMAN script for each database, say
>DB1 and DB2, then prepend these strings to each 'format' statement in
your
>RMAN script. Then you can use these identifiers in your include.encrypt
>statements in your dsm.opt file.
>
>I can give you explicit examples if you need them.
>
>
>Regards,
>
>Neil Rasmussen
>Software Development
>Data Protection for Oracle
>[EMAIL PROTECTED]
>
>
>
>
>fred johanson <[EMAIL PROTECTED]>
>Sent by: "ADSM: Dist Stor Manager"
>08/28/2006 07:00 AM
>Please respond to
>"ADSM: Dist Stor Manager"
>
>
>To
>ADSM-L@VM.MARIST.EDU
>cc
>
>Subject
>Re: Encryption in API
>
>
>
>
>
>
>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 quotes around the "Search for" text)
> >
> >Del
> >
> >
> >
> >"ADSM: Dist Stor Manager" wrote on 08/25/2006
> >01:07:23 PM:
> >
> > > Since TDP for ORACLE and MSSQL use the API, I should be able to
>encrypt
> > > some or all of DB backups we do. Since SQL generates the directory
>name
> > > for the backup, how do we determine which is which to include or
>exclude
> > > selected DBs on a particular client? We have one client with about
75
> >DBs
> > > on it and not all should be encrypted.
>
>Fred Johanson
>ITSM Administrator
>University of Chicago
>773-702-8464
Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464
Re: Copy storage pool volume in limbo
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 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.. From: ADSM: Dist Stor Manager on behalf of Tim Brown Sent: Mon 8/28/2006 8:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Copy storage pool volume in limbo 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: Monday, August 28, 2006 8:21 AM Subject: Re: Copy storage pool volume in limbo 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 Audit Volume Fix=yes usually treats. Richard Sims
FW: Problem deleting disk pool volume.
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. -Original Message- From: Mcnutt, Larry E. Sent: Monday, August 28, 2006 1:32 PM To: 'ADSM: Dist Stor Manager' Subject: Problem deleting disk pool volume. 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 appreciated. Thanks, Larry McNutt The Timken Company tsm: FSPHTSM2>q vol stg=workstn Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /tsm1stg1/tsm2disk03.dsm WORKSTN DISK 25,600.00.5 On-Line /tsm1stg2/tsm2disk02.dsm WORKSTN DISK 25,600.06.4 On-Line /tsm1stg2/tsm2disk05.dsm WORKSTN DISK 25,000.05.5 On-Line /tsm1stg3/tsm2disk05.dsm WORKSTN DISK 12,500.06.7 On-Line /tsm1stg4/tsm2disk05.dsm WORKSTN DISK 12,500.0 16.1 On-Line /tsm2stg1/tsm2disk03.dsm WORKSTN DISK 10,240.01.9 On-Line /tsm2stg2/tsm2disk03.dsm WORKSTN DISK 10,240.00.7 On-Line /tsm5stg1/tsm2disk03.dsm WORKSTN DISK 50,000.01.8 On-Line /tsmstg2/disk01.dsm WORKSTN DISK 50,000.0 -1.1 On-Line <= This is the volume tsm: FSPHTSM2>q vol /tsmstg2/disk01.dsm f=d Volume Name: /tsmstg2/disk01.dsm Storage Pool Name: WORKSTN Device Class Name: DISK Estimated Capacity: 50,000.0 Scaled Capacity Applied: Pct Util: -1.1 Volume Status: On-Line Access: Read-Only Pct. Reclaimable Space: Scratch Volume?: In Error State?: Number of Writable Sides: Number of Times Mounted: Write Pass Number: Approx. Date Last Written: Approx. Date Last Read: Date Became Pending: Number of Write Errors: Number of Read Errors: Volume Location: Volume is MVS Lanfree Capable : Last Update by (administrator): MCNUTT Last Update Date/Time: 08/22/06 17:31:36 Begin Reclaim Period: End Reclaim Period: tsm: FSPHTSM2>audit volume /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. Do you wish to proceed? (Yes (Y)/No (N)) y ANR2209W Volume /tsmstg2/disk01.dsm contains no data. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANRD dsaudit.c(1097): ThreadId<80> Erroneous information for volume /tsmstg2/disk01.dsm was removed from the database. ANRD ThreadId<80> issued message from: <-0x00010001c240 outDiagf <-0x000100414b98 DsAuditEmptyVol <-0x0001004108d8 ssAuditEmptyVol <-0x00010075aa48 DoAuditVolume <-0x00010075f218 AdmAuditVolume <-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand <-0x000100507694 SmAdminCommandThread <-0x0001e9dc StartThread <-0x093f52f8 _pthread_body ANR2209W Volume /tsmstg2/disk01.dsm contains no data. tsm: FSPHTSM2>delete volume /tsmstg2/disk01.dsm ANR2220W This command will delete volume /tsmstg2/disk01.dsm from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) y ANS8001I Return code 13. ANR2017I Administrator MCNUTT issued command: DELETE VOLUME /tsms
Problem deleting disk pool volume.
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 communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company / The Timken Corporation --- Begin Message --- 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 appreciated. Thanks, Larry McNutt The Timken Company tsm: FSPHTSM2>q vol stg=workstn Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /tsm1stg1/tsm2disk03.dsm WORKSTN DISK 25,600.00.5 On-Line /tsm1stg2/tsm2disk02.dsm WORKSTN DISK 25,600.06.4 On-Line /tsm1stg2/tsm2disk05.dsm WORKSTN DISK 25,000.05.5 On-Line /tsm1stg3/tsm2disk05.dsm WORKSTN DISK 12,500.06.7 On-Line /tsm1stg4/tsm2disk05.dsm WORKSTN DISK 12,500.0 16.1 On-Line /tsm2stg1/tsm2disk03.dsm WORKSTN DISK 10,240.01.9 On-Line /tsm2stg2/tsm2disk03.dsm WORKSTN DISK 10,240.00.7 On-Line /tsm5stg1/tsm2disk03.dsm WORKSTN DISK 50,000.01.8 On-Line /tsmstg2/disk01.dsm WORKSTN DISK 50,000.0 -1.1 On-Line <= This is the volume tsm: FSPHTSM2>q vol /tsmstg2/disk01.dsm f=d Volume Name: /tsmstg2/disk01.dsm Storage Pool Name: WORKSTN Device Class Name: DISK Estimated Capacity: 50,000.0 Scaled Capacity Applied: Pct Util: -1.1 Volume Status: On-Line Access: Read-Only Pct. Reclaimable Space: Scratch Volume?: In Error State?: Number of Writable Sides: Number of Times Mounted: Write Pass Number: Approx. Date Last Written: Approx. Date Last Read: Date Became Pending: Number of Write Errors: Number of Read Errors: Volume Location: Volume is MVS Lanfree Capable : Last Update by (administrator): MCNUTT Last Update Date/Time: 08/22/06 17:31:36 Begin Reclaim Period: End Reclaim Period: tsm: FSPHTSM2>audit volume /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. Do you wish to proceed? (Yes (Y)/No (N)) y ANR2209W Volume /tsmstg2/disk01.dsm contains no data. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANR2311W This command will discard any inventory references to volume /tsmstg2/disk01.dsm associated with missing or inconsistent stored data, thereby rendering the data unrecoverable; the valid data on the volume will be inaccessible to users until the operation completes. ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME /tsmstg2/disk01.dsm fix=yes ANRD dsaudit.c(1097): ThreadId<80> Erroneous information for volume /tsmstg2/disk01.dsm was removed from the database. ANRD ThreadId<80> issued message from: <-0x00010001c240 outDiagf <-0x000100414b98 DsAuditEmptyVol <-0x0001004108d8 ssAuditEmptyVol <-0x00010075aa48 DoAuditVolume <-0x00010075f218 AdmAuditVolume <-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand <-0x000100507694 SmAdminCommandThread <-0x0001e9dc StartThread <-0x093f52f8 _pthread_body ANR2209W Volume /tsmstg2/disk01.dsm contains no data. tsm: FSPHTSM2>delete volume /tsmstg2/disk01.dsm ANR2220W This command will delete volume /tsmstg2/disk01.dsm from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) y ANS8001I Return code 13. ANR2017I Administrator MCNUTT issued comm
Identifying nodes per MgmtClass
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 are using a particular management class? I'd like to clean up unused ones and perhaps move some stuff around. If you have any ideas please let me know :) Currently runing TSM 5.2.6 (soon to be 5.3.x) Thanks much!! -Douglas Fox TSM Admin Dematic Corp
Re: Identifying nodes per MgmtClass
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 PROTECTED] On Behalf Of
Doug Fox
Sent: Monday, August 28, 2006 2:35 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Identifying nodes per MgmtClass
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 are using a particular
management class? I'd like to clean up unused ones and perhaps move some
stuff around. If you have any ideas please let me know :)
Currently runing TSM 5.2.6 (soon to be 5.3.x)
Thanks much!!
-Douglas Fox
TSM Admin
Dematic Corp
-Message Disclaimer-
This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to [EMAIL PROTECTED] and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.
Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.
While this communication may be used to promote or market a transaction
or an idea that is discussed in the publication, it is intended to provide
general information about the subject matter covered and is provided with
the understanding that The Principal is not rendering legal, accounting,
or tax advice. It is not a marketed opinion and may not be used to avoid
penalties under the Internal Revenue Code. You should consult with
appropriate counsel or other advisors on all matters pertaining to legal,
tax, or accounting obligations and requirements.
Re: FW: Problem deleting disk pool volume.
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 you're really anxious about it, restart the server, but I wouldn't bother, since this is a problem that actually can be solved by going for lunch. Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] === Therapy is expensive. Popping bubble wrap is cheap. You choose. On Mon, 28 Aug 2006, Mcnutt, Larry E. wrote: >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. > > > >-Original Message- >From: Mcnutt, Larry E. >Sent: Monday, August 28, 2006 1:32 PM >To: 'ADSM: Dist Stor Manager' >Subject: Problem deleting disk pool volume. > >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 appreciated. > >Thanks, >Larry McNutt >The Timken Company > > >tsm: FSPHTSM2>q vol stg=workstn > > > >Volume Name Storage Device EstimatedPct >Volume > Pool NameClass Name Capacity Util >Status > --- -- - - > >/tsm1stg1/tsm2disk03.dsm WORKSTN DISK 25,600.00.5 >On-Line >/tsm1stg2/tsm2disk02.dsm WORKSTN DISK 25,600.06.4 >On-Line >/tsm1stg2/tsm2disk05.dsm WORKSTN DISK 25,000.05.5 >On-Line >/tsm1stg3/tsm2disk05.dsm WORKSTN DISK 12,500.06.7 >On-Line >/tsm1stg4/tsm2disk05.dsm WORKSTN DISK 12,500.0 16.1 >On-Line >/tsm2stg1/tsm2disk03.dsm WORKSTN DISK 10,240.01.9 >On-Line >/tsm2stg2/tsm2disk03.dsm WORKSTN DISK 10,240.00.7 >On-Line >/tsm5stg1/tsm2disk03.dsm WORKSTN DISK 50,000.01.8 >On-Line >/tsmstg2/disk01.dsm WORKSTN DISK 50,000.0 -1.1 >On-Line <= This is the volume > > >tsm: FSPHTSM2>q vol /tsmstg2/disk01.dsm f=d > > Volume Name: /tsmstg2/disk01.dsm > Storage Pool Name: WORKSTN > Device Class Name: DISK >Estimated Capacity: 50,000.0 > Scaled Capacity Applied: > Pct Util: -1.1 > Volume Status: On-Line >Access: Read-Only >Pct. Reclaimable Space: > Scratch Volume?: > In Error State?: > Number of Writable Sides: > Number of Times Mounted: > Write Pass Number: > Approx. Date Last Written: >Approx. Date Last Read: > Date Became Pending: >Number of Write Errors: > Number of Read Errors: > Volume Location: >Volume is MVS Lanfree Capable : >Last Update by (administrator): MCNUTT > Last Update Date/Time: 08/22/06 17:31:36 > Begin Reclaim Period: >End Reclaim Period: > >tsm: FSPHTSM2>audit volume /tsmstg2/disk01.dsm fix=yes > >ANR2311W This command will discard any inventory references to volume > >/tsmstg2/disk01.dsm associated with missing or inconsistent stored data, > >thereby rendering the data unrecoverable; the valid data on the volume >will be >inaccessible to users until the operation completes. > > > >Do you wish to proceed? (Yes (Y)/No (N)) y > >ANR2209W Volume /tsmstg2/disk01.dsm contains no data. > > > > >ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME >/tsmstg2/disk01.dsm >fix=yes >ANR2311W This command will discard any inventory references to volume >/tsmstg2/disk01.dsm associated with missing or inconsistent stored data, >thereby rendering the data unrecoverable; the valid data on the volume >will be >inaccessible to users until the operation completes. >ANR2017I Administrator MCNUTT issued command: AUDIT VOLUME >/tsmstg2/disk01.dsm >fix=yes >ANRD dsaudit.c(1097): ThreadId<80> Erroneous information for volume >/tsmstg2/disk01.dsm was removed from the database. >ANRD ThreadId<80> issued message from: <-0x00010001c240 >outDiagf ><-0x000100414b98 DsAuditEmptyVol <-0x0001004108d8 >ssAuditEmptyVol ><-0x00010075aa48 DoAuditVolume <-0x00010075f218 AdmAuditVolume ><-0x0001001e9e58 AdmCommandLocal <-0x0001001ead98 admCommand ><-0x000100507694 SmAdminCommandThread <-0x0001e9dc >StartThread ><-0x093f52f8 _pthread_body >ANR2209W Volume /tsmstg2/disk01.dsm contains no data. > >tsm: FSPHTSM2>delete volume /
TDP for exchange error
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 following error: Sunday Monday Tuesday Full (23:00) OK I (09:00) OK I (09:00) Error I (15:00)OK I (15:00) Error I (20:00) OK I (20:00)Error >From the actlog: ANE4993E (Session: 145219, Node: EXCHSRV01_DB) TDP MSExchg ACN3502 Data Protection for Exchange: incr backup of First Storage Group from server EXCHSRV01 failed, rc = 425. (SESSION: 145219) >From the excincr.log: Beginning incr backup of First Storage Group, 1 of 2. Backup of storage group First Storage Group failed. ACN5798E MS Exchange API HRESEBACKUPSETUP() failed with HRESULT: 0xc8000230 - The database missed a previous full backup before the incremental backup. My backup copy group are: Full backup nolimit nolimit 8 8 Incr backup nolimit nolimit 15 15 The Exchange administrator told me that is not running any defrag on the database . Any clue ? Regards Robert Ouzen
