Re: Gig utilization during backups
Geoff, Check these settings, they apply to 1Gig Ether. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 rfc1323=0 The following settings have been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 no -o rfc1323=1 no -r -o rfc1323=1 Hope this help... Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Friday, September 08, 2006 6:50 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Gig utilization during backups I'd like to get some input on what others see on their port utilization during heavy network traffic. With 350+ systems backing up to a single TSM server I'm curious as to why we see only about 50% utilization on the GIG port with max scheduled sessions set to 95. Sessions run extremely long compared to when they were on the old system. What have others seen their systems and what do you have set for max scheduled sessions? I still feel like this system, which has 4 CPU's is not nearly as fast at moving data than my 2 CPU system was and the setup is very similar. AIX 5.3 - TSM 5.3.3.0 - 4 CPU's - 4GB memory - Gig interface Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: TDP for Oracle
On Sun, Sep 10, 2006 at 11:47:57PM +0700, Wira Chinwong wrote: perform daily backup. But I don't have an idea to setup monthly yearly backup policy. The expiration on daily monthly yearly are conflicted. Anybody who have an experience please advise. You shouldn't use TSM expiration parameters like Versions Exists, Versions Deleted, etc. Those settings should be configured according to the TDP installation manual. You must use RMAN to configure your database backup retention policy. You can do this using the RMAN CONFIGURE command, and you can always use the KEEP option for individual backups. See the RMAN documentation for this, it's not complicated. -- Jurjen Oskam Savage's Law of Expediency: You want it bad, you'll get it bad.
Re: ANS0101E NLInit error after installation of TDPO 5.3 .2 on Solaris and RMAN backup attempt to SBT_TAPE
Hi Damion,
We have seen this problem where the maximum number of mount points is set to
1. We got around this problem by increasing it to 5.
Freundliche Grüße / Kind regards
Stuart Pitt,
IBM Certified Deployment Professional TSM 5.2
IBM Certified Storage Administrator TSM 5
Data Management and Implementation
RWE npower
Trigonos Building
Swindon
Tel Int 7 322 3253
Tel Ext 01793 893253
[EMAIL PROTECTED]
-Original Message-
From: Reeves, Damion [mailto:[EMAIL PROTECTED]
Sent: 11 September 2006 00:17
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3.2 on
Solaris and RMAN backup attempt to SBT_TAPE
Hi,
I'm fairly new to TDPO so would be grateful for any assistance or advice
from more experienced TDPO Guru's !
Our UNIX Sys Admin staff and I have just installed and configured TDPO 5.3.2
on Sun Solaris 5.8.
We've followed the IBM TDPO instructions and have setup the tdpo.opt file
and the symbolic link from our Oracle 8.1.7.2 ORACLE_HOME/lib/libobk.so as
follows:
lrwxrwxrwx 1 oracle dba 18 Sep 7 11:13 libobk.so -
/usr/lib/libobk.so*
I've performed the RMAN setup/configuration using an Oracle 10.2.0.2
Recovery Catalog on the same Solaris 5.8 system.
I can successfully backup an Oracle 8.1.7.2 database to disk (via the Oracle
10.2.0.2 Recovery Catalog), but when I attempt to perform a backup of the
same database via RMAN to SBT_TAPE I receive the ANS0101E error below:
RMAN run {
allocate channel t1 type 'sbt_tape'
parms=ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup
incremental level = 0
format = 'level0_%d_%s_%p.bus'
(database include current controlfile);
release channel t1;
}
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error
ORA-06512: at SYS.X$DBMS_BACKUP_RESTORE, line 141
ORA-06512: at line 23
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry
possible
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error
ORA-06512: at SYS.X$DBMS_BACKUP_RESTORE, line 141
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE
When I attempt to run the tdpoconf binary I receive the following
error:
tdpoconf showenv
ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.
ANS1087E (RC106) Access to the specified file or directory is denied
This appears to be an issue with the TDPO installation, but exactly what
issue I'm not sure.
Any assistance would be much appreciated !
Regards,
Damion Reeves
Oracle Database Administrator
IT Services
Shared Business Services
SANTOS Ltd.
Santos House
91 King William St
Adelaide S.A. 5000
Email: [EMAIL PROTECTED]
Santos Ltd A.B.N. 80 007 550 923
Disclaimer: The information contained in this email is intended only for the
use of the
person(s) to whom it is addressed and may be confidential or contain
privileged information. If you are not the intended recipient you are hereby
notified that any perusal, use, distribution, copying or disclosure is
strictly prohibited. If you have received this email in error please
immediately advise us by return email and delete the email without making a
copy.
The information contained in this email is intended only for the use of the
intended recipient
Re: ANS0101E NLInit error after installation of TDPO 5.3 .2 on Solaris and RMAN backup attempt to SBT_TAPE
Does this file physically exist:
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
It looks like an Australian English message file??? Were the required language
packs installed?
_
Ian Smith
SAN/TSM Specialist
Hitachi Data Systems Certified Professional
IBM Tivoli Storage Manager Certified Consultant
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pitt,
Stuart
Sent: 11 September 2006 09:32
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3 .2
on Solaris and RMAN backup attempt to SBT_TAPE
Hi Damion,
We have seen this problem where the maximum number of mount points is set to 1.
We got around this problem by increasing it to 5.
Freundliche Grüße / Kind regards
Stuart Pitt,
IBM Certified Deployment Professional TSM 5.2 IBM Certified Storage
Administrator TSM 5
Data Management and Implementation
RWE npower
Trigonos Building
Swindon
Tel Int 7 322 3253
Tel Ext 01793 893253
[EMAIL PROTECTED]
-Original Message-
From: Reeves, Damion [mailto:[EMAIL PROTECTED]
Sent: 11 September 2006 00:17
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3.2 on
Solaris and RMAN backup attempt to SBT_TAPE
Hi,
I'm fairly new to TDPO so would be grateful for any assistance or advice
from more experienced TDPO Guru's !
Our UNIX Sys Admin staff and I have just installed and configured TDPO 5.3.2
on Sun Solaris 5.8.
We've followed the IBM TDPO instructions and have setup the tdpo.opt file
and the symbolic link from our Oracle 8.1.7.2 ORACLE_HOME/lib/libobk.so as
follows:
lrwxrwxrwx 1 oracle dba 18 Sep 7 11:13 libobk.so -
/usr/lib/libobk.so*
I've performed the RMAN setup/configuration using an Oracle 10.2.0.2
Recovery Catalog on the same Solaris 5.8 system.
I can successfully backup an Oracle 8.1.7.2 database to disk (via the Oracle
10.2.0.2 Recovery Catalog), but when I attempt to perform a backup of the
same database via RMAN to SBT_TAPE I receive the ANS0101E error below:
RMAN run {
allocate channel t1 type 'sbt_tape'
parms=ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup
incremental level = 0
format = 'level0_%d_%s_%p.bus'
(database include current controlfile);
release channel t1;
}
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error
ORA-06512: at SYS.X$DBMS_BACKUP_RESTORE, line 141
ORA-06512: at line 23
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry
possible
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error
ORA-06512: at SYS.X$DBMS_BACKUP_RESTORE, line 141
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE
When I attempt to run the tdpoconf binary I receive the following
error:
tdpoconf showenv
ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.
ANS1087E (RC106) Access to the specified file or directory is denied
This appears to be an issue with the TDPO installation, but exactly what
issue I'm not sure.
Any assistance would be much appreciated !
Regards,
Damion Reeves
Oracle Database Administrator
IT Services
Shared Business Services
SANTOS Ltd.
Santos House
91 King William St
Adelaide S.A. 5000
Email: [EMAIL PROTECTED]
Santos Ltd A.B.N. 80 007 550 923
Re: client session stopps with 'no space available in storage... and all successor pools'
Hi all, since changing some things as pointed out (thanks again to all hints) the error now has luckily disappeared :-) . Although it may happen again I just want to give a short feedback on what we've changed: - increased the mountlimit from default 20 - 200 on the devclass of the file-pool - increased the random-acces backuppool - decreased the migration thresholds for both random-access ( 90/50 - 60/20 ) and the sequential file-pool ( 90/70 - 90/50 ) - moving from 'random migration by thresholds' to 'schedulded migration by time' with the 'duration=xx' option, running through admin-schedules at times with not much activity. So until now everything is fine and the overall throughput-rate is much better now; things wanted to do anyway to not weigh down the nightly backups with migrations. the stages now appear something like ... StorageDevice Estimated Pct PctHighLow Next Stora- Pool Name Class Name Capacity Util Migr MigMigge Pool PctPct ------------ --- BACKUPPOOL2DISK 200 G 19.4 19.4 60 20 FILEPOOL2 FILEPOOL2 FILE2 502 G 48.0 53.2 90 50 TAPEPOOL2 TAPEPOOL2 359224,620 G 8.0 25.0 100 70 Cheers Rainer
TSM recovery failure
Hi all, We did a test on our remote site to restore our primary TSM server on a second DR server. On the DR site we've got two servers, one for normal backups and the other for DR purposes. When TSM is restored we would like to use the DR server to act as a library client to the first TSM server. Some details: TSM version = 5.2.* AIX = 5.3.* Procedure: - Shutdown primary TSM server - Restore TSM on DR server - Startup primary TSM server - Remove paths, library and drives from DR server - Configure library client on DR server - Put all tapes in library - Checkin tapes as private in primary TSM server - Audit library on DR server Only two tapes are changing ownership to DR server instead of the 180 off-site tapes. The diff with the q vol command on the DR server is : Tape which change ownership: Volume Name: RG0166 Storage Pool Name: CR_TAPEPOOL_COPY Device Class Name: ULTRIUM3 Estimated Capacity (MB): 228,029.4 Scaled Capacity Applied: Pct Util: 74.7 Volume Status: Full Access: Read-Only Pct. Reclaimable Space: 25.6 Scratch Volume?: Yes In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 1 Write Pass Number: 1 Approx. Date Last Written: 08/11/2006 17:13:23 Approx. Date Last Read: 08/11/2006 14:06:48 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: VAULT Volume is MVS Lanfree Capable : No Last Update by (administrator): ADMIN Last Update Date/Time: 09/09/2006 15:37:51 Example tape which isn't changing ownership: Volume Name: RAR010 Storage Pool Name: ARCHIVECOPY_1YEAR Device Class Name: ULTRIUM3 Estimated Capacity (MB): 569,254.7 Scaled Capacity Applied: Pct Util: 89.2 Volume Status: Full Access: Read-Only Pct. Reclaimable Space: 10.8 Scratch Volume?: No In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 4 Write Pass Number: 1 Approx. Date Last Written: 08/08/2006 17:02:58 Approx. Date Last Read: 06/20/2006 10:27:31 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: VAULT Volume is MVS Lanfree Capable : No Last Update by (administrator): ADMIN Last Update Date/Time: 09/09/2006 15:37:45 The only diff I can see is the output on the Scratch Volume question. If I look in the Volume History file on the primary server this RAR010 tape has ownership of the DR server. Why isn't this changing then ??? Any help is appreciated... Best regards, Oscar Kolsteren UNIX / TSM Administrator | ING Direct 410 Thames Valley Park Drive, Reading, Berkshire, RG6 1RH Tel: 0118 938 1990 l Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]@ingdirect.co.uk - ATTENTION: The information in this electronic mail message is private and confidential, and only intended for the addressee. Should you receive this message by mistake, you are hereby notified that any disclosure, reproduction, distribution or use of this message is strictly prohibited. Please inform the sender by reply transmission and delete the message without copying or opening it. Messages and attachments are scanned for all viruses known. If this message contains password-protected attachments, the files have NOT been scanned for viruses by the ING mail domain. Always scan attachments before opening them. -
Re: ANS0101E NLInit error after installation of TDPO 5.3 .2 on Solaris and RMAN backup attempt to SBT_TAPE
Hello All,
Thanks for those who responded to my initial question.
We have solved the issue.
The error we were receiving (ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat') appears to have been caused
because the Solaris system did not have the English (Australian)
Language/Locale packages installed (we performed a pkginfo to find this).
To get around the problem we simply created a symbolic link:
cd /opt/tivoli/tsm/client/oracle/bin/
mkdir en_AU
cd en_AU
ln -s ../en_US/tdpo.cat .
We are now able to run successful RMAN backups to SBT_TAPE.
Regards,
Damion Reeves
Oracle Database Administrator
IT Services
Shared Business Services
SANTOS Ltd.
Santos House
91 King William St
Adelaide S.A. 5000
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Smith, I
(Ian)
Sent: Monday, 11 September 2006 18:09
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3 .2
on Solaris and RMAN backup attempt to SBT_TAPE
Does this file physically exist:
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
It looks like an Australian English message file??? Were the required language
packs installed?
_
Ian Smith
SAN/TSM Specialist
Hitachi Data Systems Certified Professional
IBM Tivoli Storage Manager Certified Consultant
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pitt,
Stuart
Sent: 11 September 2006 09:32
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3 .2
on Solaris and RMAN backup attempt to SBT_TAPE
Hi Damion,
We have seen this problem where the maximum number of mount points is set to 1.
We got around this problem by increasing it to 5.
Freundliche Grüße / Kind regards
Stuart Pitt,
IBM Certified Deployment Professional TSM 5.2 IBM Certified Storage
Administrator TSM 5
Data Management and Implementation
RWE npower
Trigonos Building
Swindon
Tel Int 7 322 3253
Tel Ext 01793 893253
[EMAIL PROTECTED]
-Original Message-
From: Reeves, Damion [mailto:[EMAIL PROTECTED]
Sent: 11 September 2006 00:17
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] ANS0101E NLInit error after installation of TDPO 5.3.2 on
Solaris and RMAN backup attempt to SBT_TAPE
Hi,
I'm fairly new to TDPO so would be grateful for any assistance or advice
from more experienced TDPO Guru's !
Our UNIX Sys Admin staff and I have just installed and configured TDPO 5.3.2
on Sun Solaris 5.8.
We've followed the IBM TDPO instructions and have setup the tdpo.opt file
and the symbolic link from our Oracle 8.1.7.2 ORACLE_HOME/lib/libobk.so as
follows:
lrwxrwxrwx 1 oracle dba 18 Sep 7 11:13 libobk.so -
/usr/lib/libobk.so*
I've performed the RMAN setup/configuration using an Oracle 10.2.0.2
Recovery Catalog on the same Solaris 5.8 system.
I can successfully backup an Oracle 8.1.7.2 database to disk (via the Oracle
10.2.0.2 Recovery Catalog), but when I attempt to perform a backup of the
same database via RMAN to SBT_TAPE I receive the ANS0101E error below:
RMAN run {
allocate channel t1 type 'sbt_tape'
parms=ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt);
backup
incremental level = 0
format = 'level0_%d_%s_%p.bus'
(database include current controlfile);
release channel t1;
}
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
ANS0101E NLInit: Unable to open message repository
'/opt/tivoli/tsm/client/oracle/bin/en_AU/tdpo.cat'.
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error
ORA-06512: at SYS.X$DBMS_BACKUP_RESTORE, line 141
ORA-06512: at line 23
RMAN-10035: exception raised in RPC: ORA-19624:
OFS/LVSA for x64 windows server 2003
Hi, does anybody know when TSM Client X.y.z.a will have open file support (lvsa engine) for backing up files in use? Thanks, Egon ..-- Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus protection.
FW: TSM Client Active and Passive setting
Yes. Look the Client Manual for Windows. There is a section in the book explaining how to configure the client to work in a Clustered environment. Here is a link to the manuals: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp On the left side, click the line Tivoli Storage Manager Clients Then click the + next to Backup Archive Clients You can download the PDF version of the Windows client manual. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, September 10, 2006 10:29 PM To: ADSM-L@VM.MARIST.EDU Subject: TSM Client Active and Passive setting Hi all, I would like to know whether TSM5.3.2 have feature in automatically connecting to the client that is active in cluster environment. Currently in my customer environment they have active and passive servers. When the active servers become passive and vise versa, the system admin have to restart the scheduler services manually on the passive server that has become active. Really appreciate if anybody could give me any opinion how to configure this kind of environment. The Server run on AIX and clients on Windows. Thanks Regards Zareyna mail2web - Check your email from the web at http://mail2web.com/ .
Re: Splitting TSM database and library sharing
Hi William, You can try EXPORT commands. With them, you can selectively export objects from one instance to other. On 9/6/06, William Boyer [EMAIL PROTECTED] wrote: I have a client using library sharing of a 3584 with LTO3 drives. Right now their one main instance is so large it needs to be split. The client does daily incremental as well as monthly backups. The daily backups are domain STANDARD using stgpools 3584POOL and 3584CPPOOL. The monthly backups use domain LONGTERM and stgpools LONGTERM_3584 and LONGTERM_VAULT. I would like to create another instance and initially restore the database to it. Then rename it and establish server-2-server for the library sharing. Then from the main instance LOCK all the monthly nodenames and start deleting them. And from the new monthly instance, lock all the daily nodes and start deleting them. (DELETE FILESPACE). How can I change ownership of the volumes?? Right now the main instance TSM owns the volumes with the library manager. I want to change the ownership of all the LONGTERM* tapes to the TSM2 instance. If I run an AUDIT LIBR from TSM2, then ALL volumes that are currently in the library are changed to TSM2, including the daily tapes. If I try to do an UPDATE LIBV on the library manager to change the ownership, I get error ANR8969E. It also appears that all the volumes belonging to a library client are in the library manager volume history file as TYPE=REMOTE. Maybe there's a better (or easier??) way of splitting the database and use library sharing for the resources...any help will be appreciated. TSM Server 5.3.2.1 on AIX. Bill Boyer Select * from USERS where CLUE0 0 rows returned -- Helder Garcia
Re: delete virtual volumes
Mark Stapleton wrote: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/08/2006 07:19:25 AM: we backup a storage pool to a copy pool on a target server (virtual volumes). Yesterday I deleted 10 virtual volumes from the copypool DELETE VOL ... DISCARD=YES The virtual volumes are seen as archive data on the target server, the target server should delete these archive files. So I expect that the target server deletes these archive files during the next EXPIRE INVENTORY. But the final message ANR0812I of EXPIRE INVENTORY says: that 0 archive objects have been deleted. Look at HELP RECONCILE VOLUMES. See if that helps. first, look at delete volhist -- Mark Stapleton ([EMAIL PROTECTED]) US Bank MR Backup and Recovery Management -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint: 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end. -- Douglas Adams
How does EXPIRE INVENTORY work ?
Hi *SMers, i've come across some behaviour of the EXPIRE IVENTORY command which i don't understand. We have a daily job that executes EXPIRE EIVENTORY. Results are shown in the Activity Log and read as follows: 09/02/06 07:49:48 ANR0812I Inventory file expiration process 301 completed: examined 9604 objects, deleting 1929 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recoveryplan files. 0 errors were encountered. 09/04/06 05:15:35 ANR0812I Inventory file expiration process 313 completed: examined 40052 objects, deleting 1162 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recovery plan files. 0 errors were encountered. Two things really upset me: - The numbers of objects examined are significant different, but i am sure the database grows very slowly - A rough estimate for the total number of objects gives a value somewhere between 200,000 and 300,000 objects. Can someone shade a light on this? Thanks in advance regards Guenther -- Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany Guenther_Bergmann at gbergmann dot de http://www.gbergmann.de
Re: How does EXPIRE INVENTORY work ?
Each time it is basicly expiring files that no longer are required to meet the definitions in the mangement group. Perhaps a client deleted a file system and the number of days for inactive file retention was passed. [EMAIL PROTECTED] 09/11/06 1:07 PM Hi *SMers, i've come across some behaviour of the EXPIRE IVENTORY command which i don't understand. We have a daily job that executes EXPIRE EIVENTORY. Results are shown in the Activity Log and read as follows: 09/02/06 07:49:48 ANR0812I Inventory file expiration process 301 completed: examined 9604 objects, deleting 1929 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recoveryplan files. 0 errors were encountered. 09/04/06 05:15:35 ANR0812I Inventory file expiration process 313 completed: examined 40052 objects, deleting 1162 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recovery plan files. 0 errors were encountered. Two things really upset me: - The numbers of objects examined are significant different, but i am sure the database grows very slowly - A rough estimate for the total number of objects gives a value somewhere between 200,000 and 300,000 objects. Can someone shade a light on this? Thanks in advance regards Guenther -- Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany Guenther_Bergmann at gbergmann dot de http://www.gbergmann.de The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: Gig utilization during backups
On Fri, 8 Sep 2006 09:49:56 -0700, Gill, Geoffrey L. [EMAIL PROTECTED] said: I'd like to get some input on what others see on their port utilization during heavy network traffic. With 350+ systems backing up to a single TSM server I'm curious as to why we see only about 50% utilization on the GIG port with max scheduled sessions set to 95. Sessions run extremely long compared to when they were on the old system. You've gotten several data points about GigE utilization; but they mostly told you what you already knew: your network can go faster than that. What are _all_ the changes you made between the old system and the new? What is the disk topology underneath? What is the database topology? In a nutshell, where do you see the bottleneck being now? CPUs approach irrelevance when your big job is I/O. What are the two hardware platforms? How many adapters, attached to how many disks? Different types? Same? My knee-jerk suggestion is Database commit contention. When folks move up in hardware, they often optimize their database on newer bigger disk, which can lead to too few DB volumes to keep up with the transaction rates to which they're accustomed. But that's a wild-ass guess, because we don't know much about your system. - Allen S. Rout
Re: How does EXPIRE INVENTORY work ?
Don't worry about it. According to a talk I heard from L2 support, the expire inventory process is optimized and clever. It looks at the objects belonging to a filespace, expires those that are ready to expire, but can tell by the dates when it doesn't need to look further through the filespace for things that have expired. So it doesn't have to look at every object in the DB, and objects examined is not an indicator of how many objects you have in the data base. Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Monday, September 11, 2006 1:14 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: How does EXPIRE INVENTORY work ? Each time it is basicly expiring files that no longer are required to meet the definitions in the mangement group. Perhaps a client deleted a file system and the number of days for inactive file retention was passed. [EMAIL PROTECTED] 09/11/06 1:07 PM Hi *SMers, i've come across some behaviour of the EXPIRE IVENTORY command which i don't understand. We have a daily job that executes EXPIRE EIVENTORY. Results are shown in the Activity Log and read as follows: 09/02/06 07:49:48 ANR0812I Inventory file expiration process 301 completed: examined 9604 objects, deleting 1929 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recoveryplan files. 0 errors were encountered. 09/04/06 05:15:35 ANR0812I Inventory file expiration process 313 completed: examined 40052 objects, deleting 1162 backup objects, 0 archive objects, 0 DB backup volumes, and 0 recovery plan files. 0 errors were encountered. Two things really upset me: - The numbers of objects examined are significant different, but i am sure the database grows very slowly - A rough estimate for the total number of objects gives a value somewhere between 200,000 and 300,000 objects. Can someone shade a light on this? Thanks in advance regards Guenther -- Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany Guenther_Bergmann at gbergmann dot de http://www.gbergmann.de The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments.
Re: How does EXPIRE INVENTORY work ?
...09/02/06 07:49:48 ANR0812I Inventory file expiration process 301 ... See that message number in http://people.bu.edu/rbs/ADSM.QuickFacts for collected factoids. All behaviors are subject to change with product evolution. Richard Sims
Re: Gig utilization during backups
A lot of discussion around the problem is also the subject of a separate email. In those I have mentioned hardware information. As of this time I have changed nothing on this new system as I want to gather as much information as possible before making a decision on what I should do. Most everything I have compared on these systems has revealed nothing as they are almost identical. The basic hardware on both of these systems is the same. The real difference lies in a few minor things. Physical memory on the old box was 5GB this new one 4GB. Two more CPU's on the new system. The underlying disk infrastructure is the same on both systems. The new system has more disks, but according to what I've read not even close to the recommended limit. The real difference is, and I see you mentioned it below, is the number of db volumes per disk on the new system. This is something I've been looking at changing as I feel it is more than likely part of the problem. I know there aren't many specifics here but I guarantee that if I ever get this worked out I will detail what I have and what I did. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Monday, September 11, 2006 10:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Gig utilization during backups On Fri, 8 Sep 2006 09:49:56 -0700, Gill, Geoffrey L. [EMAIL PROTECTED] said: I'd like to get some input on what others see on their port utilization during heavy network traffic. With 350+ systems backing up to a single TSM server I'm curious as to why we see only about 50% utilization on the GIG port with max scheduled sessions set to 95. Sessions run extremely long compared to when they were on the old system. You've gotten several data points about GigE utilization; but they mostly told you what you already knew: your network can go faster than that. What are _all_ the changes you made between the old system and the new? What is the disk topology underneath? What is the database topology? In a nutshell, where do you see the bottleneck being now? CPUs approach irrelevance when your big job is I/O. What are the two hardware platforms? How many adapters, attached to how many disks? Different types? Same? My knee-jerk suggestion is Database commit contention. When folks move up in hardware, they often optimize their database on newer bigger disk, which can lead to too few DB volumes to keep up with the transaction rates to which they're accustomed. But that's a wild-ass guess, because we don't know much about your system. - Allen S. Rout
SQL TDP Encryption
Folks, A quick perusal of the archive suggests that API Clients/TDPs are unable to offer encryption services. The entries from Del (thanks) were all older. Has anything changed in this regard? Is encryption supported now in the TDP for SQL? If not we're thinking of going the Export the DB and use the BA client route. Thoughts on that approach while I'm bothering al of you! Thanks, Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED]
Re: SQL TDP Encryption
Kelly, Check the archive for the last month. Del and Neil pointed me in the right direction for encryption in SQL and ORACLE respectively. At 01:24 PM 9/11/2006 -0600, you wrote: Folks, A quick perusal of the archive suggests that API Clients/TDPs are unable to offer encryption services. The entries from Del (thanks) were all older. Has anything changed in this regard? Is encryption supported now in the TDP for SQL? If not we're thinking of going the Export the DB and use the BA client route. Thoughts on that approach while I'm bothering al of you! Thanks, Kelly J. Lipp VP Manufacturing CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Best Practices JigSaw Puzzle
Hi all, Did anyone has a best practice, blueprint, or white paper to partition database, recovery log, and storage pools over big/large disks volumes ¿? for example 14 disks drives with 400 GB each one... Thanks in Advance, Regards, Ibán Bernaldo de Quirós Márquez Technical Specialist cell: + 34 659 01 91 12 Sun Microsystems Iberia
Re: Deleting a tape that doesn't exist
We have about 800 volumes that are Remote Type. We only need to delete the ones with a specific device class. Is there a way to accomplish this? If we delete all of the remote types from the volhist, will the in use volumes generate new history if we delete their old history? Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis, Melburn W IT743 Sent: Thursday, June 29, 2006 11:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Deleting a tape that doesn't exist I had a similar problem once and TSM gave me this nifty command: delete volhist todate=today type=remote volume=volumename force=yes Works well if somehow a tape's status has been lost between server to server communications, where your library manager shows the tape as type remote (meaning that it has been given control over to another server), and the server that is supposed to be using it shows either no info in the volhist or the last entry shows it as being stgdelete. Hope this helps. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deleting a tape that doesn't exist I have this problem tape. The library manager server says the tape is owned/used by a remote system/server. When I check the remote system, it says it knows nothing about the tape. How can I convince the library manager server that the tape is gone/deleted/kaput so I can relabel the tape and reuse it ? DELETE VOLUME ... DISCARDDATA=YES does nothing. Is there some kind of hidden force=yes IreallyMeanIt=yes option I can use ? This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: Best Practices JigSaw Puzzle
These disk drives sounds like SATA drives. I don't believe it is wise to place database and recovery logs on these drives. Behalf Of Bernaldo de Quiros, Iban 1 Sent: Monday, September 11, 2006 2:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Best Practices JigSaw Puzzle Hi all, Did anyone has a best practice, blueprint, or white paper to partition database, recovery log, and storage pools over big/large disks volumes ¿? for example 14 disks drives with 400 GB each one... Thanks in Advance, Regards, Ibán Bernaldo de Quirós Márquez Technical Specialist cell: + 34 659 01 91 12 Sun Microsystems Iberia
Re: Best Practices JigSaw Puzzle
On Sep 11, 2006, at 5:37 PM, Bernaldo de Quiros, Iban 1 wrote: Hi all, Did anyone has a best practice, blueprint, or white paper to partition database, recovery log, and storage pools over big/large disks volumes ¿? for example 14 disks drives with 400 GB each one... Redbooks Technote TIPS0301 IBM Tivoli Storage Manager Using Multiple Disk Volumes for the Database and the Recovery Log Files addresses this, as does the TSM Performance Tuning Guide. RAID 1+0 is excellent for the database. You can find logs of good information via simple search terms at the TSM Support Page, http://www.ibm.com/software/sysmgmt/products/ support/IBMTivoliStorageManager.html . Richard Sims
Re: TDP for Oracle
Hi Jurjen, As your suggestion, currently instead rman database, I'm using controlfile to keep the catalog. Can I still follow by your recommendation? Best Regards, Wira Chinwong Engineering Service Manager Enterprise Division SCSI Co., Ltd. 976/22 Rimklongsamsen Rd., Bangkapi, Huaykwang, Bangkok 10320 Tel. 66 (2) 641 4003-4 Fax. 66 (2) 641 4002 E-mail: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jurjen Oskam Sent: Monday, September 11, 2006 3:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle On Sun, Sep 10, 2006 at 11:47:57PM +0700, Wira Chinwong wrote: perform daily backup. But I don't have an idea to setup monthly yearly backup policy. The expiration on daily monthly yearly are conflicted. Anybody who have an experience please advise. You shouldn't use TSM expiration parameters like Versions Exists, Versions Deleted, etc. Those settings should be configured according to the TDP installation manual. You must use RMAN to configure your database backup retention policy. You can do this using the RMAN CONFIGURE command, and you can always use the KEEP option for individual backups. See the RMAN documentation for this, it's not complicated. -- Jurjen Oskam Savage's Law of Expediency: You want it bad, you'll get it bad.
