Re: Oracle TDP and RMAN
Thanks again, for your input... This is the BEST Support list out there. Regards, Charles -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Andreas Almroth [ MTNCameroon OM - DMSC ] Sent: Saturday, November 20, 2004 3:12 AM To: [EMAIL PROTECTED] Subject: Re: Oracle TDP and RMAN In working with our Oracle DBA's they feel TSM should manage the RMAN Oracle Retentions etc... Is there a Preferred method? If so why? RMAN should normally take care of the retention cleaning. The node should be set up to be allowed to delete backups. In the manual for TDP Oracle it says one should set up verdeleted=0 and retonly=0. That is, when RMAN has deleted the object in the recovery catalog and in TSM, the object should be removed in TSM upon next inventory run. Here's one of our DBA's response when I told them my understanding is that RMAN usually manages the Backup Retentions etc Note on page 85 of the RMAN Backup and Recovery Handbook it says: If you are using a tape management system, it may have its own retention policy. If the tape management system's retention policy is in conflict with the backup retention policy you have defined in RMAN, the tape management system's retention policy will take precedence and your ability to recovery a backup will be in jeopardy. Yes, this is true for some backup systems. That is why one should never set up a retention policy in the backup system for RMAN backups. That is why I was leaving it up to the Tivoli retention policy to be used instead of RMAN retention policies. This seems to be in conflict with the comment about TSM having a dumb repository. I would use RMAN retention, in Oracle 9i it is even easier. The DBA's should have a script that is run regularly to expire backups. This way there will be a minimal risk of ending up with an inconsistency between the recovery catalog and what is stored in TSM. If an inconsistency occurs, you can run tdposync to synchronise recovery catalog and TSM. Regards, Andreas
Re: Roll your own Windows server wizards
Follow this link, http://publib.boulder.ibm.com/infocenter/tivihelp/index.jsp?toc=/com.ibm.itstorage.doc/toc.xml Check out the clients section and look for silent installation stuff. All the directions are there for you. Curtis Steve Harris [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 11/21/2004 08:04 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject Roll your own Windows server wizards Hi all Sorry if this is easy stuff to you windows guys, - my defence is that I'm a unix person :) I'm looking at rolling out a number of TSM servers on windows. I'd like to not use the default setup, but rather my own layout, which will be the same in every case. Is there a way to unravel the wizards that come with the TSM server and bend them to my own ends? Can anyone point out to me where they reside? I haven't even been able to determine which files contain the wizard code. Many thanks Steve. Steve Harris TSM Admin Queensland Health, Brisbane Australia *** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***
Re: Error message Server detected system error
Try looking up the messages ANS1301E. It provides a clue as to where you might start looking for the trouble. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/21/2004 23:16:41: Hi Some users saved their outlook.ps on a Netware client backup by TSM , some forget to close Outlook so when the backup occurred I got this error message: 11/19/2004 23:44:03 ANS1228E Sending of object 'SYM: /Users/BDOTAN/Files/Office/Outlook/outlook.pst' failed 11/19/2004 23:44:03 ANS1301E Server detected system error The backup status finished with: 11/20/2004 00:43:31 ANS1512E Scheduled event 'SCHNOVCOL3' failed. Return code = 12. I changed in the backup group copy the copy serialization to static , no change still this error message .. Did is a way to contour this error My TSM server version is 5.2.3.0 and TSM client Netware 5.2.3.0 Thanks in Advance , Regards Robert Ouzen E-mail: [EMAIL PROTECTED]
Suggestions for file system setup
I just received 2 143 GB internal disk for my AIX 5.1 system and was wondering if anyone knows what the best Logical Volume stripe size to set up as well as what the best File system Block size would be. Hardware 4 GB Ram 4 GB Paging (Never Touched) 2 32GB Scsi Drives for root 2 142 GB SCSI Drives for Storage pool Allocation.- Replacing EMC Disk (To Slow) 7 EMC Fibre attached disk for Database We back up about 1/2 TB a night to these storage pools. And I just need to know the best settings for best performance. Thanks, Andrew This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: TDP SQL - 'set backups' / out of sync TDP backups
David, If you set up your management classes correctly, this is something you can do. Keep in mind that you will need a log backup to go along with the set backup in order for the SQL Server to properly recover the database after a restore. Because of that, you will need to make sure your log and set backups are bound to the same management classes or management classes with similar settings. Both set and log backups are uniquely named and both will be expired upon a new full backup. Because it this, you will need to make sure the management class settings for log and set backups are set to remain for as long as you desire (RETONLY). Thanks, Del ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/19/2004 11:44:53 AM: Guys, To begin, a familiar story for many of you I'm sure - we have a customer who has MSSQL databases, and wants TDP backups going back a month or so. Easy, bread and butter stuff. Happy with this, they want their backups from every Friday to be retained for 4 weeks, and from every 4th Friday to last for 7 years. As the TDP stores the SQL backups in a backup copygroup, we don't have that level of flexibility easily built in to the tool to provide what is essentially more of an 'archive' type request. The normal response at this point is to 'use different node names - ABC123_WEEKLY or ABC123_MONTHLY', and this is indeed what I have done frequently before. However, I can't help feeling this isn't quite perfect, having to make our non TSM savvy client (on a remote site) faff around with different node names and explain to them why TSM has to be handled in this way. It's not that big a deal really, but I'm aiming for simplification here. Now, my question is whether anyone is achieving the fulfilment of such requirements in another way, for example using 'set backups'. According to the docs, 'set backups are intended to be used in unusual one-of-a-kind situations [...] Because set backups are always uniquely named (like log backups), they do not participate in expiration due to version limit [...] The reason for using a set backup is if you do not want the backup to be part of your normal expiration process.' Sounds like a possibility - anyone using these already? We've a similar requirement coming in for Informix backups - again, from what I've seen of ONBAR so far, having out-of-sync weekly/monthly/yearly backups could be a challenge when using the same node name. With Oracle backups, we've managed to overcome this by customising the RMAN backup piece tags, and expiring manually from RMAN based upon these to identify logs, weekly and monthly backup pieces etc - works very smoothly indeed. Your thoughts, especially on a Friday afternoon, are always much appreciated :O)
Management class error in DSM.errorlog
Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance!
Re: Management class error in DSM.errorlog
Hi Tim, Did you check the dsm.opt file for include/exclude options? Probably you are trying to bound files to a management class that no longer exists. Did the SPECIAL management class ever existed? Please include your client dsm.opt for further analisys. HTH, Pablito. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Monday, November 22, 2004 13:23 To: [EMAIL PROTECTED] Subject: Management class error in DSM.errorlog Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance!
Re: Management class error in DSM.errorlog
Timonthy, You need to check a couple of things and then give us some more info so we can help. First of all is the node a member of the PRODUCTION domain. Management classes are only available to the nodes that are defined within the same Domain. Another thing you listed the Policy Set of DAILY, within a domain the only Policy Set that is used is the ACTIVE Policy Set. You should look at it and if Management Class SPECIAL is missing from Domain=PRODUCTION and Policy Set=ACTIVE than you will need to activate the DAILY Policy Set so that it becomes the ACTIVE Policy Set. If all that checks out then re-post with that information and we will go from there, but my bet is that one or two of the things I mentioned above is your problem. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === Timothy Hughes wrote: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance! -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE
Re: Management class error in DSM.errorlog
Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance!
Re: Management class error in DSM.errorlog
I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance! If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: Management class error in DSM.errorlog
I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL Policy Domain Name PRODUCTION Policy Set Name DAILY Mgmt Class Name SPECIAL Default Mgmt Class ? No Description - Space Management Technique NONE Auto-Migrate on Non-Use 0 Migration Requires Backup? YES Migration Destination SPACEMGPOOL Last Update Date/Time 2003-10-04 07:31:24.00 Last Update by (administrator) Managing profile - TSM version 5.2.3.4 TSM AIX client version 5.1.5 Thanks for any help in advance! If you are not an intended
Re: Management class error in DSM.errorlog
This is a typical output of command q mgmt PRODUCTION DAILY SPECIAL f=d issued at server, and certainly not from client QUERY MGMTCLASS output. It is also possible that the node is not in PRODUCTION domain. A QUERY MGMTCLASS output from client will certainly help the troubleshooting. Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:53:53 ANS0348E Operation failed because the copy continue option was set to NO. 11/22/04 00:53:53 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. Management Classes : PRODUCTION DAILY SPECIAL
Re: Management class error in DSM.errorlog
Das, Here is the output from the q mgmtclass as you can see the policy set is activated sm q mgmtclass Node Name: Session established with server TSM: AIX-RS/6000 Server Version 5, Release 2, Level 3.4 Data compression forced off by the server Server date/time: 11/22/04 13:43:24 Last access: 11 Domain Name : PRODUCTION Activated Policy Set Name : DAILY Activation date/time : 10/03/03 17:05:44 Default Mgmt Class Name : DAILY Grace Period Backup Retn. : 30 day(s) Grace Period Archive Retn.: 365 day(s) MgmtClass Name : DAILY Description : Daily Mgmt Class Das, Samiran (IDS ECCS) wrote: This is a typical output of command q mgmt PRODUCTION DAILY SPECIAL f=d issued at server, and certainly not from client QUERY MGMTCLASS output. It is also possible that the node is not in PRODUCTION domain. A QUERY MGMTCLASS output from client will certainly help the troubleshooting. Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL'
Re: Management class error in DSM.errorlog
But there is no SPECIAL management class, which indicates that you may have changed the policy set on the domain, but not activated it. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 11:46:48: Das, Here is the output from the q mgmtclass as you can see the policy set is activated sm q mgmtclass Node Name: Session established with server TSM: AIX-RS/6000 Server Version 5, Release 2, Level 3.4 Data compression forced off by the server Server date/time: 11/22/04 13:43:24 Last access: 11 Domain Name : PRODUCTION Activated Policy Set Name : DAILY Activation date/time : 10/03/03 17:05:44 Default Mgmt Class Name : DAILY Grace Period Backup Retn. : 30 day(s) Grace Period Archive Retn.: 365 day(s) MgmtClass Name : DAILY Description : Daily Mgmt Class Das, Samiran (IDS ECCS) wrote: This is a typical output of command q mgmt PRODUCTION DAILY SPECIAL f=d issued at server, and certainly not from client QUERY MGMTCLASS output. It is also possible that the node is not in PRODUCTION domain. A QUERY MGMTCLASS output from client will certainly help the troubleshooting. Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10
Select Statement Help for Volume Breakdown
How do I combine these two scripts? I want to be able to see a breakdown by stg pools breakdown of scratch/privates in the stgpools. select status, count(*) from libvolumes where library_name = 'LTOLIB' group by status I have this..but, I really want to see the scratch/private breakdown? select stgpool_name, status, scratch, count(*) as Volumes - from volumes - group by status, scratch, stgpool_name STGPOOL_NAME STATUS SCRATCH Volumes -- -- -- --- APIDR1 EMPTY YES 2 BCBSDR2EMPTY YES 1 APIDR1 FILLINGYES13 APIDR2 FILLINGYES12 Background: Operating Sys - AIX 5.2.2.0 TSM- 5.2.3.3 Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Office: (716) 887-7979 Cell: (716) 609-2138 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: Management class error in DSM.errorlog
Andrew, To activate the management class I just use the drop down menu and select activate correct? Do I also have to validate it? Andrew Raibeck wrote: But there is no SPECIAL management class, which indicates that you may have changed the policy set on the domain, but not activated it. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 11:46:48: Das, Here is the output from the q mgmtclass as you can see the policy set is activated sm q mgmtclass Node Name: Session established with server TSM: AIX-RS/6000 Server Version 5, Release 2, Level 3.4 Data compression forced off by the server Server date/time: 11/22/04 13:43:24 Last access: 11 Domain Name : PRODUCTION Activated Policy Set Name : DAILY Activation date/time : 10/03/03 17:05:44 Default Mgmt Class Name : DAILY Grace Period Backup Retn. : 30 day(s) Grace Period Archive Retn.: 365 day(s) MgmtClass Name : DAILY Description : Daily Mgmt Class Das, Samiran (IDS ECCS) wrote: This is a typical output of command q mgmt PRODUCTION DAILY SPECIAL f=d issued at server, and certainly not from client QUERY MGMTCLASS output. It is also possible that the node is not in PRODUCTION domain. A QUERY MGMTCLASS output from client will certainly help the troubleshooting. Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class
Re: Management class error in DSM.errorlog
Here's is the output from q mgmtclass Policy D Policy S Mgmt Cla Default Description omain Na et Name ss Name Mgmt Cla mess ? - - - - ORCBACKUP ACTIVEORCBACKUP Yes mgmt class for oracle b ackups ORCBACKUP ORCBACKUP ORCBACKUP Yes mgmt class for oracle b ackups PRODUCTI ACTIVEDAILY Yes Daily Mgmt Class ON PRODUCTI DAILY DAILY Yes Daily Mgmt Class ON PRODUCTI DAILY SPECIAL NoMgmt Class for open fil ON es STANDARD ACTIVESTANDARD Yes Installed default manag ement class. STANDARD STANDARD STANDARD Yes Installed default manag ement class. Andrew Raibeck wrote: I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/19/04 00:37:43 ANS0348E Operation failed because the copy continue option was set to NO. 11/19/04 00:37:43 ANS1512E Scheduled event 'MIDNIGHT' failed. Return code = 12. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/20/04 00:03:16 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 19 does not exist. 11/21/04 00:07:10 Management class 'SPECIAL' named on include/exclude line 18 does not exist. 11/22/04 00:05:14 Management class 'SPECIAL' named on include/exclude line
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists in a storage pool when it contains client data (and is therefore no longer a scratch tape). -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nancy L Backhaus Sent: Monday, November 22, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Select Statement Help for Volume Breakdown How do I combine these two scripts? I want to be able to see a breakdown by stg pools breakdown of scratch/privates in the stgpools. select status, count(*) from libvolumes where library_name = 'LTOLIB' group by status I have this..but, I really want to see the scratch/private breakdown? select stgpool_name, status, scratch, count(*) as Volumes - from volumes - group by status, scratch, stgpool_name STGPOOL_NAME STATUS SCRATCH Volumes -- -- -- --- APIDR1 EMPTY YES 2 BCBSDR2EMPTY YES 1 APIDR1 FILLINGYES13 APIDR2 FILLINGYES12 Background: Operating Sys - AIX 5.2.2.0 TSM- 5.2.3.3 Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Office: (716) 887-7979 Cell: (716) 609-2138 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: Select Statement Help for Volume Breakdown
There are no scratch tapes in storage pools. A tape volume only exists in a storage pool when it contains client data (and is therefore no longer a scratch tape). Just a footnote on this: Though less commonly seen, an empty tape volume can also exist in a storage pool if it is manually defined to that pool by the administrator (but even then, it is not the same as a scratch tape). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 13:23:37: There are no scratch tapes in storage pools. A tape volume only exists in a storage pool when it contains client data (and is therefore no longer a scratch tape). -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nancy L Backhaus Sent: Monday, November 22, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Select Statement Help for Volume Breakdown How do I combine these two scripts? I want to be able to see a breakdown by stg pools breakdown of scratch/privates in the stgpools. select status, count(*) from libvolumes where library_name = 'LTOLIB' group by status I have this..but, I really want to see the scratch/private breakdown? select stgpool_name, status, scratch, count(*) as Volumes - from volumes - group by status, scratch, stgpool_name STGPOOL_NAME STATUS SCRATCH Volumes -- -- -- --- APIDR1 EMPTY YES 2 BCBSDR2EMPTY YES 1 APIDR1 FILLINGYES13 APIDR2 FILLINGYES12 Background: Operating Sys - AIX 5.2.2.0 TSM- 5.2.3.3 Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Office: (716) 887-7979 Cell: (716) 609-2138 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: Management class error in DSM.errorlog
Yes, you want activate. Regarding your validate question, look up the VALIDATE command in the admin reference and it will explain what that command does. I would *stronlgy* recommend that you read the TSM Admin Guide, and refer to the Admin Reference when the Admin Guide refers to TSM server commands. While the web admin might help facilitate the management of TSM, the reading will give you a good grounding in the product, which will help you administer the server regardless of which interface you choose to use (I think the admin CLI is the best way to learn. :-) Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 12:28:41: Andrew, To activate the management class I just use the drop down menu and select activate correct? Do I also have to validate it? Andrew Raibeck wrote: But there is no SPECIAL management class, which indicates that you may have changed the policy set on the domain, but not activated it. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 11:46:48: Das, Here is the output from the q mgmtclass as you can see the policy set is activated sm q mgmtclass Node Name: Session established with server TSM: AIX-RS/6000 Server Version 5, Release 2, Level 3.4 Data compression forced off by the server Server date/time: 11/22/04 13:43:24 Last access: 11 Domain Name : PRODUCTION Activated Policy Set Name : DAILY Activation date/time : 10/03/03 17:05:44 Default Mgmt Class Name : DAILY Grace Period Backup Retn. : 30 day(s) Grace Period Archive Retn.: 365 day(s) MgmtClass Name : DAILY Description : Daily Mgmt Class Das, Samiran (IDS ECCS) wrote: This is a typical output of command q mgmt PRODUCTION DAILY SPECIAL f=d issued at server, and certainly not from client QUERY MGMTCLASS output. It is also possible that the node is not in PRODUCTION domain. A QUERY MGMTCLASS output from client will certainly help the troubleshooting. Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog I was expecting to see a Policy set name ACTIVE. That could be it... but FYI if this came from client QUERY MGMTCLASS output, then that shows you the activated policy set name, not ACTIVE. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 10:33:10: I was expecting to see a Policy set name ACTIVE. Does your policyset activated? Regards, Samiran Das -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 22, 2004 12:27 PM To: [EMAIL PROTECTED] Subject: Re: Management class error in DSM.errorlog Do you have more than one TSM server? Is it possible that the operation that had the problem with the SPECIAL management class was pointing to a server on which that management class did not exist? Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager [EMAIL PROTECTED] wrote on 11/22/2004 09:22:43: Hello, I am getting the following error in a dsmerror.log. Anyone ever see this before? 11/19/04 00:02:42 Management class 'SPECIAL' named on include/exclude line 20 does not exist. 11/19/04 00:02:42 Management
Re: Oracle TDP and RMAN
Charles, In addition to all the other good answers to this post, you can add this to your argument with the dba's. TSM is NOT a tape management system in the classic sense of that type of product. Classic tape management systems returns a tape to scratch after some policy driven number of days. TSM only returns a tape to scratch when it is logically empty. The rman page 85 note simply doesn't apply to TSM. Hope this helps, Bill Colwell At 05:02 PM 11/19/2004, you wrote: In working with our Oracle DBA's they feel TSM should manage the RMAN Oracle Retentions etc... Is there a Preferred method? If so why? Here's one of our DBA's response when I told them my understanding is that RMAN usually manages the Backup Retentions etc Note on page 85 of the RMAN Backup and Recovery Handbook it says: If you are using a tape management system, it may have its own retention policy. If the tape management system's retention policy is in conflict with the backup retention policy you have defined in RMAN, the tape management system's retention policy will take precedence and your ability to recovery a backup will be in jeopardy. That is why I was leaving it up to the Tivoli retention policy to be used instead of RMAN retention policies. This seems to be in conflict with the comment about TSM having a dumb repository. Thanks for you thoughts... Regards, Charles -- Bill Colwell C. S. Draper Lab Cambridge Ma.
TDP for Oracle Install error
Our network admin was trying to install TDP for Oracle on AIX 5.2. He encountered this error. MISSING REQUISITE: bos.rte v5 when installing TDP Oracle V5.1.5 Has anyone seen this before? We are trying to install TDP 5.2, for AIX 5.2 64 bit on IBM pSeries. I subsequently installed the following packages needed for TDP and re-linked libobk.a and did not have any problems. tivoli.tsm.client.api.64bit 5.2.3.0C FTSM Client - 64bit Application Programming Interface tivoli.tsm.client.oracle.aix51.64bit5.2.0.0C F IBM Tivoli Storage Manager for Databases - Oracle on AIX tivoli.tsm.client.oracle.tools.aix51.64bit5.2.0.0C F IBM Tivoli Storage Manager for Databases - Oracle Tools on AIX tivoli.tsm.loc.client.oracle.aix51.64bit.ela 5.2.0.0C F IBM Tivoli Storage Manager for Databases - Oracle E-Lic I just want to make sure I have installed it right. Thanks, Manjula Krishnan Database Administrator Information Technology Dept. West Jefferson Medical Center 1101 Medical Center Blvd. Marrero, LA - 70072 Phone: (504) 349-1390 image001.gif