Tape Volume usage
Hello I have several Tape Archive Pools defined on TSM. The Archive's tapes are removed periodically from TSM library to a safe. During normal TSM usage there are some Nodes that made archives to those storage pools. Regarding that some of the tapes are offsite TSM Library, TSM use new scratch volumes for archive. Now I have several archives tapes with low PCT_UTILIZED how are using many tapes like the example bellow. Example: VOLUME_NAME EST_CAPACITY PCT_UTILIZED PCT_RECLAIM -- - --- A00015L4 832845.5 88.7 11.2 A00018L4 160.0 2.1 0.0 A00122L4 160.0 2.3 0.0 A00142L4 160.0 9.9 0.0 A00145L4 160.0 36.2 0.0 A00158L4 160.0 5.7 0.0 A00243L4 160.0 5.5 0.0 A00311L4 160.0 5.6 0.0 AE0055L4 160.0 2.4 0.0 AE0077L4 160.0 2.4 0.0 AE0080L4 160.0 14.8 0.0 Note: Collocation are not used in Storage Pool. Now all tapes are in the library My question is: There are any way to configure storage pool to use the minimal number of tapes (use tape maximum capacity on storage pool)? There are any way to reduce the number of tapes using the maximum tape capacity or I have to do it manually with command (MOVE DATA)? Thank you
Tape Volume usage
Hello I have several Tape Archive Pools defined on TSM. The Archive's tapes are removed periodically from TSM library to a safe. During normal TSM usage there are some Nodes that made archives to those storage pools. Regarding that some of the tapes are offsite TSM Library, TSM use new scratch volumes for archive. Now I have several archives tapes with low PCT_UTILIZED how are using many tapes like the example bellow. Example: VOLUME_NAME EST_CAPACITY PCT_UTILIZED PCT_RECLAIM -- - --- A00015L4 832845.5 88.7 11.2 A00018L4 160.0 2.1 0.0 A00122L4 160.0 2.3 0.0 A00142L4 160.0 9.9 0.0 A00145L4 160.0 36.2 0.0 A00158L4 160.0 5.7 0.0 A00243L4 160.0 5.5 0.0 A00311L4 160.0 5.6 0.0 AE0055L4 160.0 2.4 0.0 AE0077L4 160.0 2.4 0.0 AE0080L4 160.0 14.8 0.0 Note: Collocation are not used in Storage Pool My question is: There are any way to configure storage pool to use the minimal number of tapes (use tape maximum capacity on storage pool)? There are any way to reduce the number of tapes using the maximum tape capacity or I have to do it manually with command (MOVE DATA)? Thank you
Re: LTO4 Tape Volumes with diferent Estimated Capacity
Hello all Thank you for your all answers. Regarding to your experience what is more efficiency regarding to tape usage capacity (increase tape amount of data stored)? Compression on client or compression on Drive(HW)? Cumprimentos / Best regards Tiago Botelho -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Botelho, Tiago (External) Sent: quarta-feira, 18 de Janeiro de 2012 15:27 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] LTO4 Tape Volumes with diferent Estimated Capacity Hello I have several tape volumes (LTO4) with different Estimated Capacity. What can cause this situation? Ex: A00035L4 WIN_SRV_T TS3310 629.5 G 95.4 Full A00039L4 WIN_SRV_T TS3310 1.1 T 98.2 Full A00101L4 WIN_SRV_T TS3310 884.8 G 84.4 Full A00113L4 WIN_SRV_T TS3310 1.0 T 93.7 Full A00118L4 WIN_SRV_T TS3310 1.0 T 73.6 Full A00128L4 WIN_SRV_T TS3310 1.0 T 99.2 Full A00129L4 WIN_SRV_T TS3310 969.1 G 93.7 Full A00133L4 WIN_SRV_T TS3310 934.8 G 96.1 Full All tapes and Drives are LTO4, TSM Server 553 for AIX. The devc are configured as: Device Class Name: TS3310 Device Access Strategy: Sequential Storage Pool Count: 16 Device Type: LTO Format: ULTRIUM4C Est/Max Capacity (MB): Mount Limit: DRIVES Mount Wait (min): 60 Mount Retention (min): 60 Label Prefix: ADSM Library: TS3310 Directory: Server Name: Retry Period: Retry Interval: Shared: High-level Address: Minimum Capacity: WORM: No Drive Encryption: Off Scaled Capacity: Last Update by (administrator): ADM Last Update Date/Time: 07/27/09 17:32:05 Cumprimentos / Best regards Tiago Botelho
LTO4 Tape Volumes with diferent Estimated Capacity
Hello I have several tape volumes (LTO4) with different Estimated Capacity. What can cause this situation? Ex: A00035L4 WIN_SRV_T TS3310 629.5 G 95.4 Full A00039L4 WIN_SRV_T TS3310 1.1 T 98.2 Full A00101L4 WIN_SRV_T TS3310 884.8 G 84.4 Full A00113L4 WIN_SRV_T TS3310 1.0 T 93.7 Full A00118L4 WIN_SRV_T TS3310 1.0 T 73.6 Full A00128L4 WIN_SRV_T TS3310 1.0 T 99.2 Full A00129L4 WIN_SRV_T TS3310 969.1 G 93.7 Full A00133L4 WIN_SRV_T TS3310 934.8 G 96.1 Full All tapes and Drives are LTO4, TSM Server 553 for AIX. The devc are configured as: Device Class Name: TS3310 Device Access Strategy: Sequential Storage Pool Count: 16 Device Type: LTO Format: ULTRIUM4C Est/Max Capacity (MB): Mount Limit: DRIVES Mount Wait (min): 60 Mount Retention (min): 60 Label Prefix: ADSM Library: TS3310 Directory: Server Name: Retry Period: Retry Interval: Shared: High-level Address: Minimum Capacity: WORM: No Drive Encryption: Off Scaled Capacity: Last Update by (administrator): ADM Last Update Date/Time: 07/27/09 17:32:05 Cumprimentos / Best regards Tiago Botelho
TSM Client Return Codes - Failed or partial failed
Hello, I have a 160 (daily backup) environment and I need to perform a daily report. Several Client Nodes report Status: Failed Result: Errors. In those cases I have to login in the TSM Node and check dsmsched.log and dsmerror.log to check if it fails completed or not. In some situations, the client Backup fails completed. Others the errorlog.log / dsmsched.log report open files or files not found ( but in the report send by TSM Management console I cannot see the difference). I'm looking a solution that can see the difference between a complete failure and a partial failure (like open files or files not found) to use on TSM Management console (SQL statements). There are any SQL query that can show me the difference? Any event that can be disable on the TSM Server to prevent this. Any ideas? Thank you for your delp Cumprimentos / Best regards Tiago Botelho T_Systems at Volkswagen
Software Sources
Hello, Can you provide link to SW resources for TSM environment? I'm implementing LAN-free and I need to Download several SW including SANergy. The only I have is: index.storsys.ibm.com Thank you Best regards
Re: Exluded file do not work - Can't understand why
C:\WINDOWS\System32\CatRoot2\...\* Operating System
Exclude All C:\WINDOWS\SoftwareDistribution\...\* Operating System
Exclude All C:\WINDOWS\repair\asr.log Operating System
Exclude All C:\WINDOWS\repair\asr.err Operating System
Exclude All C:\WINDOWS\Registration\*.clb Operating System
Exclude All c:\windows\ntfrs\jet\...\* Operating System
Exclude All C:\WINDOWS\netlogon.chgOperating System
Exclude All C:\WINDOWS\debug\NtFrs\NtFrs* Operating System
Exclude All C:\WINDOWS\debug\* Operating System
Exclude All C:\WINDOWS\csc\...\* Operating System
Exclude All C:\DOCUME~1\ADMBOT~1\LOCALS~1\Temp\1\...\* Operating System
Exclude All C:\Documents and Settings\All Users\DRM\...\* Operating System
Exclude All C:\Documents and Settings\All Users\Application Data\Microsoft
\Network\Downloader\* Operating System
Exclude All C:\Documents and Settings\admbotelho\...\index.dat Operating S
ystem
Exclude All *\System Volume Information\MountPointManagerRemoteDatabase Op
erating System
Exclude All *\System Volume Information\...\*{3808876B-C176-4e48-B7AE-0404
6E6CC752} Operating System
Exclude All *\System Volume Information\*.{7cc467ef-6865-4831-853f-2a4817f
d1bca}DB Operating System
Exclude All *\System Volume Information\*.{7cc467ef-6865-4831-853f-2a4817f
d1bca}ALT Operating System
Exclude All *\Pagefile.sys Operating System
Exclude All *\hiberfil.sys Operating System
Exclude All *\...\*.crmlog Operating System
Exclude File D:\NTDS\ntds.dit dsm.opt
Include Archive *\...\system32\dns\backup\...\* dsm.opt
Exclude Archive *\...\system32\dns\...\* dsm.opt
Include Archive *\...\system32\dhcp\backup\...\* dsm.opt
Exclude Archive *\...\system32\dhcp\...\* dsm.opt
Exclude Archive *\...\system32\Perflib*.datdsm.opt
Exclude Archive *\...\system32\config\...\*dsm.opt
Exclude Archive *\IO.SYS dsm.opt
Exclude Archive *\IBMDOS.COM dsm.opt
Exclude Archive *\IBMBIO.COM dsm.opt
Exclude Archive *\...\EA DATA. SF dsm.opt
Exclude Archive *\microsoft uam volume\...\*.* dsm.opt
Exclude Archive *\microsoft uam volume\...\* dsm.opt
Include Backup*\...\system32\dns\backup\...\* dsm.opt
Exclude Backup*\...\system32\dns\...\* dsm.opt
Include Backup*\...\system32\dhcp\backup\...\* dsm.opt
Exclude Backup*\...\system32\dhcp\...\* dsm.opt
Exclude Backup*\...\system32\Perflib*.datdsm.opt
Exclude Backup*\...\system32\config\...\*dsm.opt
Exclude Backup*\IO.SYS dsm.opt
Exclude Backup*\IBMDOS.COM dsm.opt
Exclude Backup*\IBMBIO.COM dsm.opt
Exclude Backup*\...\EA DATA. SF dsm.opt
Exclude Backup*\microsoft uam volume\...\*.* dsm.opt
Exclude Backup*\microsoft uam volume\...\* dsm.opt
No DFS include/exclude statements defined.
tsm>
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Dwight
Cook
Sent: terça-feira, 21 de Setembro de 2010 12:39
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Exluded file do not work - Can't understand why
>From a dsmc session, see what "q inclexcl" reveals.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Botelho, Tiago (External)
Sent: Tuesday, September 21, 2010 4:56 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Exluded file do not work - Can't understand why
Hello all,
I have a situation on a TSM Node that I don't understand.
I received a daily Failed Status from this node regarding to this file:
09/21/2010 01:11:40 ANS1228E Sending of object
'\\vwaepasd00081\d$\NTDS\ntds.dit' failed
09/21/2010 01:11:40 ANS8010E An attempt to backup or archive a file has
exceed the maximum number of retries.
Dsm.opt (part):
SNAPSHOTCACHELOCATION C:\TSM_VSS
SNAPSHOTPROVIDERFS VSS
SNAPSHOTPROVIDERIMAGE VSS
SNAPSHOTCACHESIZE 3
NODENAME VWAEPASD00081
EXCLUDE.FILE "D:\NTDS\ntds.dit"
EXCLUDE.DIR "D:\NTDS"
CHANGINGRETRIES 0
On TSM GUI I see the directory d:\NTDS excluded when I do a manual
backup.
On TSM Server:
Cloptset:
INCLEXCL 7 No exclude
*:\...\NTDS\ntds.dit
Management classes: Backup the file (no retries)
TSM Node:
Windows 2003 R2 SP2 Standard Edition
TSM Client Version 6.2.0
TSM Server:
AIX 6.1
TSM Server 5.5.2
Any ideia for this issue?
Thanks
TB
Re: Several TSM Clients with files that retries has exceed the maximum number of retries
Hello Richard, I want to backup the file in the first attempt even if the file is changing during backup. Regards -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: terça-feira, 21 de Setembro de 2010 12:10 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Several TSM Clients with files that retries has exceed the maximum number of retries On Sep 21, 2010, at 6:48 AM, Botelho, Tiago (External) wrote: > ... > Some dsm.opt files have the parameter: > > changingretries 0 > > Any ideas with the clients are send the "ANS8010E" messages ? Review the TSM documentation regarding the Changingretries option. If a file changes as TSM is trying to back it up, and you tell it not to retry, then... Richard Sims
Re: Several TSM Clients with files that retries has exceed the maximum number of retries
Option Set it's forced to YES All those nodes are using a server cloptset with the following entry: CHANGINGRETRIES 0 Yes 0 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Guido Martínez Sent: terça-feira, 21 de Setembro de 2010 11:56 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Several TSM Clients with files that retries has exceed the maximum number of retries Update the Option Set. Instead of Force=NO use Force=YES. Regards. El sep 21, 2010 7:50 a.m., "Botelho, Tiago (External)" < tiago.bote...@volkswagen.pt> escribió: Hello, I have several TSM clients reporting error "ANS8010E An attempt to backup or archive a file has exceed the maximum number of retries." All those nodes are using Management Classes / copy groups with the bellow configuration: Policy Domain Name: WIN_SERVERS Policy Set Name: STANDARD Mgmt Class Name: WIN_SRV_DATA Copy Group Name: STANDARD Copy Group Type: Backup Versions Data Exists: 5 Versions Data Deleted: 2 Retain Extra Versions: 30 Retain Only Version: No Limit Copy Mode: Modified Copy Serialization: Dynamic Copy Frequency: 0 Copy Destination: WIN_SRV_D Table of Contents (TOC) Destination: Last Update by (administrator): TMB Last Update Date/Time: 08/31/10 09:19:55 Managing profile: Changes Pending: No All those nodes are using a server cloptset with the following entry: CHANGINGRETRIES 0 Yes 0 Examples: 09/21/2010 01:09:25 ANS1228E Sending of object '\\ptvwaepas00068\c$\QuirlNT10\logfiles\import.log' failed 09/21/2010 01:09:25 ANS8010E An attempt to backup or archive a file has exceed the maximum number of retries. Some dsm.opt files have the parameter: changingretries 0 Any ideas with the clients are send the "ANS8010E" messages ? Thank you
Re: Exluded file do not work - Can't understand why
Hello, I restarted TSM Scheduler several times. I already upgrade TSM Client to a new version yesterday. Thank you -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Jason Zerdin Sent: terça-feira, 21 de Setembro de 2010 11:49 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Exluded file do not work - Can't understand why Hello, Has the TSM scheduler service been restarted since the exclude rules were added? If not then it won't have picked up the additions to dsm.opt, which would explain the discrepancy between manual and scheduled backups. Best wishes, Jason -- Dr Jason Zerdin Systems and Storage Administrator HFS OUCS http://www.oucs.ox.ac.uk/hfs/ On 21/09/2010 10:56, Botelho, Tiago (External) wrote: > > > Hello all, > > > > I have a situation on a TSM Node that I don't understand. > > > > I received a daily Failed Status from this node regarding to this file: > > > > 09/21/2010 01:11:40 ANS1228E Sending of object > '\\vwaepasd00081\d$\NTDS\ntds.dit' failed > > 09/21/2010 01:11:40 ANS8010E An attempt to backup or archive a file has > exceed the maximum number of retries. > > > > > > Dsm.opt (part): > > > > SNAPSHOTCACHELOCATION C:\TSM_VSS > > SNAPSHOTPROVIDERFS VSS > > SNAPSHOTPROVIDERIMAGE VSS > > SNAPSHOTCACHESIZE 3 > > > > NODENAME VWAEPASD00081 > > > > EXCLUDE.FILE "D:\NTDS\ntds.dit" > > EXCLUDE.DIR "D:\NTDS" > > > > CHANGINGRETRIES 0 > > > > > > On TSM GUI I see the directory d:\NTDS excluded when I do a manual > backup. > > > > On TSM Server: > > Cloptset: > > INCLEXCL 7 No exclude > *:\...\NTDS\ntds.dit > > > > Management classes: Backup the file (no retries) > > > > > > TSM Node: > > Windows 2003 R2 SP2 Standard Edition > > TSM Client Version 6.2.0 > > > > TSM Server: > > AIX 6.1 > > TSM Server 5.5.2 > > > > > > Any ideia for this issue? > > > > Thanks > > TB -- Dr Jason Zerdin Systems and Storage Administrator HFS OUCS http://www.oucs.ox.ac.uk/hfs/
Several TSM Clients with files that retries has exceed the maximum number of retries
Hello, I have several TSM clients reporting error "ANS8010E An attempt to backup or archive a file has exceed the maximum number of retries." All those nodes are using Management Classes / copy groups with the bellow configuration: Policy Domain Name: WIN_SERVERS Policy Set Name: STANDARD Mgmt Class Name: WIN_SRV_DATA Copy Group Name: STANDARD Copy Group Type: Backup Versions Data Exists: 5 Versions Data Deleted: 2 Retain Extra Versions: 30 Retain Only Version: No Limit Copy Mode: Modified Copy Serialization: Dynamic Copy Frequency: 0 Copy Destination: WIN_SRV_D Table of Contents (TOC) Destination: Last Update by (administrator): TMB Last Update Date/Time: 08/31/10 09:19:55 Managing profile: Changes Pending: No All those nodes are using a server cloptset with the following entry: CHANGINGRETRIES 0 Yes 0 Examples: 09/21/2010 01:09:25 ANS1228E Sending of object '\\ptvwaepas00068\c$\QuirlNT10\logfiles\import.log' failed 09/21/2010 01:09:25 ANS8010E An attempt to backup or archive a file has exceed the maximum number of retries. Some dsm.opt files have the parameter: changingretries 0 Any ideas with the clients are send the "ANS8010E" messages ? Thank you
Exluded file do not work - Can't understand why
Hello all, I have a situation on a TSM Node that I don't understand. I received a daily Failed Status from this node regarding to this file: 09/21/2010 01:11:40 ANS1228E Sending of object '\\vwaepasd00081\d$\NTDS\ntds.dit' failed 09/21/2010 01:11:40 ANS8010E An attempt to backup or archive a file has exceed the maximum number of retries. Dsm.opt (part): SNAPSHOTCACHELOCATION C:\TSM_VSS SNAPSHOTPROVIDERFS VSS SNAPSHOTPROVIDERIMAGE VSS SNAPSHOTCACHESIZE 3 NODENAME VWAEPASD00081 EXCLUDE.FILE "D:\NTDS\ntds.dit" EXCLUDE.DIR "D:\NTDS" CHANGINGRETRIES 0 On TSM GUI I see the directory d:\NTDS excluded when I do a manual backup. On TSM Server: Cloptset: INCLEXCL 7 No exclude *:\...\NTDS\ntds.dit Management classes: Backup the file (no retries) TSM Node: Windows 2003 R2 SP2 Standard Edition TSM Client Version 6.2.0 TSM Server: AIX 6.1 TSM Server 5.5.2 Any ideia for this issue? Thanks TB
Implementing LANFree data Movement - WIN Storage Agent Server Requirements
Hello, I'm planning to configure LANFree data movement. I take a look on IBM for System Requirements for Storage Agent Server. http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp I do not find a concrete answer regarding to the need of Fibre Channel Adapter Cards on a Windows Storage Agent Server. Its mandatory for Storage Agent Server FC cards? Thank you
Implementing LANFree data Movement - WIN Storage Agent Server Requirements
Hello, I'm planning to configure LANFree data movement. I take a look on IBM for System Requirements for Storage Agent Server. http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp I do not find a concrete answer regarding to the need of Fibre Channel Adapter Cards on a Windows Storage Agent Server. Its mandatory for Storage Agent Server FC cards? Thank you
Re: Urgent: dsmj omn AIX does not open GUI
I take a look now. Thank you. But ... How Can I archive ALL filesystem from a AIX Server using CLI?? -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: quarta-feira, 30 de Dezembro de 2009 12:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Urgent: dsmj omn AIX does not open GUI If you have not already, take a look at IBM Technote 1389435. In any case, given the number of clients you intend to work with, it would seem that the CLI would be the best, fastest vehicle for accomplishing the work. Richard Sims
Urgent: dsmj omn AIX does not open GUI
Hello, I'm trying to make and archive from my AIX clients using GUI. I only have today for Downtime on my 12 AIX Servers. Dsmj do not start client GUI, and I cannot know why. Anyone can help? Thank you. I connect remotely on each servers and do the following: #Export DISPLAY=[MY_IP:0.0] #cd /usr/tivoli/tsm/client/ba/bin #dsmj Here it open a BA GUI interface (temporary) and then I received the following box message: ANS2609S TCP/IP communications failure between the browser and the client machine. On AIX side: # dsmj Exception in thread "main" # # cat dsmj.log *** commOpen: java.net.SocketException: Connection timed out:could be due to invalid address java.lang.NullPointerException at COM.ibm.storage.adsm.cadmin.comgui.DcgApplicationController.cgInitialize Controller(DcgApplicationController.java:2773) at COM.ibm.storage.adsm.cadmin.clientgui.DDsmApplication.StartUp(DDsmApplic ation.java:646) at COM.ibm.storage.adsm.cadmin.clientgui.DDsmApplet.start(DDsmApplet.java:7 47) at COM.ibm.storage.adsm.cadmin.clientgui.DDsmApplet.main(DDsmApplet.java:96 8) # cat dsmwebcl.log 12/30/09 11:57:11 (dsmagent) IBM Tivoli Storage Manager 12/30/09 11:57:11 (dsmagent) Remote Client Agent - Built Mar 13 2009 19:05:49 12/30/09 11:57:11 (dsmagent) Version 5, Release 5, Level 2.0 12/30/09 12:04:02 (dsmagent) IBM Tivoli Storage Manager 12/30/09 12:04:02 (dsmagent) Remote Client Agent - Built Mar 13 2009 19:05:49 12/30/09 12:04:02 (dsmagent) Version 5, Release 5, Level 2.0 12/30/09 12:05:35 (dsmagent) IBM Tivoli Storage Manager 12/30/09 12:05:35 (dsmagent) Remote Client Agent - Built Mar 13 2009 19:05:49 12/30/09 12:05:35 (dsmagent) Version 5, Release 5, Level 2.0 l43fis23:/usr/tivoli/tsm/client/ba/bin # dsmc IBM Tivoli Storage Manager Command Line Backup/Archive Client Interface Client Version 5, Release 5, Level 2.0 Client date/time: 12/30/09 12:06:42 (c) Copyright by IBM Corporation and other(s) 1990, 2009. All Rights Reserved. Node Name: L43FIS23 Session established with server TSMSERVER: AIX-RS/6000 Server Version 5, Release 5, Level 3.0 Server date/time: 12/30/09 12:04:04 Last access: 12/30/09 11:50:15 tsm> dsm.sys: SErvername tsmserver COMMMethod TCPip TCPPort1500 TCPServeraddress tsmserver nodename l43fis23 passwordaccess generate domain all-local ## java -version java version "1.4.2" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20080122 (SR10) (JIT enabled: jitc)) l43fis23:/usr/tivoli/tsm/client/ba/bin #
Can I archive SQL DB using TSM DP for SQL?
Hello, Can I archive SQL DB using TSM DP for SQL? Thank you
Create a Archive Scheduler for several platform servers
Hello, I need to create a scheduler to archive all data from my servers. The Servers are severalf Windows, Linix, AIX, ... servers. How can I create a Scheduler to perform a complete archive? TSM Server: 5.5.2 Thank you
Re: TSM DP for SQL - Some backups failed due to Session reject - TCPIP connection failure
[Botelho, Tiago (External)] Its a new TSM DP SQL Node. The node has multiple instances running. Only some DB fail. The current date is: 13-10-2009 Enter the new date: (dd-mm-yy) The current time is: 15:35:34,47 Enter the new time: IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 5, Level 1.0 (C) Copyright IBM Corporation 1997, 2008. All rights reserved. ACO5057I The C:\Progra~1\Tivoli\TSM\TDPSql\maximo\sqldiff.log log file was pruned successfully. Connecting to SQL Server, please wait... Starting SQL database backup... Connecting to TSM Server as node 'SQL_VWAEPASS00093_MAXIMO'... Beginning difffull backup for database MaximoD, 1 of 4. Full: 0 Read: 11781120 Written: 11781120 Rate: 11,159.07 Kb/Sec Full: 0 Read: 11784576 Written: 11784576 Rate: 7,482.69 Kb/Sec Backup of MaximoD completed successfully. Beginning difffull backup for database MaximoP, 2 of 4. Full: 0 Read: 89088 Written: 0 Rate: 0.00 Kb/Sec Full: 30 Read: 102760448 Written: 71303168 Rate: 34,150.07 Kb/Sec Full: 30 Read: 186646528 Written: 155189248 Rate: 49,607.86 Kb/Sec Full: 29 Read: 272906752 Written: 242221056 Rate: 58,104.64 Kb/Sec Full: 30 Read: 358612992 Written: 327155712 Rate: 62,767.78 Kb/Sec Full: 7 Read: 395719680 Written: 387973120 Rate: 62,050.44 Kb/Sec Full: 6 Read: 449304576 Written: 441450496 Rate: 60,446.44 Kb/Sec Full: 6 Read: 449304576 Written: 441450496 Rate: 52,909.18 Kb/Sec Full: 6 Read: 451401728 Written: 443547648 Rate: 47,271.85 Kb/Sec Full: 3 Read: 453512704 Written: 448790528 Rate: 43,056.49 Kb/Sec Full: 3 Read: 453512704 Written: 448790528 Rate: 39,148.91 Kb/Sec Full: 3 Read: 453512704 Written: 448790528 Rate: 35,894.51 Kb/Sec Full: 3 Read: 453512704 Written: 448790528 Rate: 33,137.15 Kb/Sec Waiting for TSM server. Full: 2 Read: 453533696 Written: 448790528 Rate: 17,234.45 Kb/Sec Full: 4 Read: 462653440 Written: 458227712 Rate: 16,920.18 Kb/Sec Full: 13 Read: 462653440 Written: 458227712 Rate: 16,823.49 Kb/Sec Backup of MaximoP failed. ANS1017E (RC-50) Session rejected: TCP/IP connection failure Beginning difffull backup for database model, 3 of 4. Full: 0 Read: 11133184 Written: 11133184 Rate: 15,248.60 Kb/Sec Backup of model completed successfully. Beginning difffull backup for database msdb, 4 of 4. Full: 0 Read: 10774784 Written: 10774784 Rate: 14,737.04 Kb/Sec Backup of msdb completed successfully. Total SQL backups selected: 5 Total SQL backups attempted: 4 Total SQL backups completed: 3 Total SQL backups excluded: 1 Throughput rate: 16,239.85 Kb/Sec Total bytes transferred: 491,920,256 Elapsed processing time: 29.58 Secs ACO0151E Errors occurred while processing the request. Errors: 10/13/2009 15:35:35 == Log file pruned using log retention period of 60 day(s) 10/13/2009 15:35:35 == No log entries pruned 10/13/2009 15:35:35 = 10/13/2009 15:35:36 = 10/13/2009 15:35:36 Request : DIFF BACKUP 10/13/2009 15:35:36 Database Input List : * 10/13/2009 15:35:36 Group Input List : - 10/13/2009 15:35:36 File Input List : - 10/13/2009 15:35:36 Number of Buffers : 3 10/13/2009 15:35:36 Buffer Size : 1024 10/13/2009 15:35:36 Number of SQL Buffers : 0 10/13/2009 15:35:36 SQL Buffer Size : 1024 10/13/2009 15:35:36 Number of Stripes specified : 10 10/13/2009 15:35:36 Estimate : 20 10/13/2009 15:35:36 Truncate Log? : - 10/13/2009 15:35:36 Wait for Tape Mounts? : Yes 10/13/2009 15:35:36 TSM Options File : C:\Progra~1\Tivoli\TSM\TDPSql\maximo\dsm.opt 10/13/2009 15:35:36 TSM Nodename Override : - 10/13/2009 15:35:36 Sqlserver : VWAEPASH00095\MAXIMO 10/13/2009 15:35:36 10/13/2009 15:36:04 ACO5436E A failure occurred on stripe number (8), rc = 418 10/13/2009 15:36:04 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 10/13/2009 15:36:05 Backup of MaximoP failed. 10/13/2009 15:36:05 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 10/13/2009 15:36:07 Total SQL backups selected: 5 10/13/2009 15:36:07 Total SQL backups attempted: 4 10/13/2009 15:36:07 Total SQL backups completed: 3 10/13/2009 15:36:07 Total SQL backups excluded: 1 10/13/2009 15:36:07 Throughput rate: 16,239.85 Kb/Sec 10/13/2009 15:36:07 Total bytes transferred: 491,920,256 10/13/2009 15:36:07 Elapsed processing time: 29.58 Secs 10/13/2009 15:36:07 ACO01
TSM DP for SQL - Some backups failed due to Session reject - TCPIP connection failure
Hello I need some help to resolve the following problem. Some of my Databases are failing to perform the backups. TSM Server: 5.5.2 Server Option Option Setting Server Option Option Setting - - CommTimeOut 3,600IdleTimeOut 30 TSM DP SQL: 5.5.1 I receive the foolwing information: Tdpsql.log: 10/13/2009 10:40:22 = 10/13/2009 10:40:22 Request : FULL BACKUP 10/13/2009 10:40:22 Database Input List : a...@db_avaya_bi,BI_DW,BI_SA,BOE,BOE_Audit,BOE_PM,master,model,msdb 10/13/2009 10:40:22 Group Input List : 10/13/2009 10:40:22 File Input List : 10/13/2009 10:40:22 Number of Buffers : 3 10/13/2009 10:40:22 Buffer Size : 1024 10/13/2009 10:40:22 Number of SQL Buffers : 0 10/13/2009 10:40:22 SQL Buffer Size : 1024 10/13/2009 10:40:22 Number of Stripes specified : 1 10/13/2009 10:40:22 Estimate : - 10/13/2009 10:40:22 Truncate Log? : - 10/13/2009 10:40:22 Wait for Tape Mounts? : Yes 10/13/2009 10:40:22 TSM Options File : c:\progra~1\Tivoli\TSM\TDPSql\BI\dsm.opt 10/13/2009 10:40:22 TSM Nodename Override : - 10/13/2009 10:40:22 Sqlserver : VWAEPASH00098\BI 10/13/2009 10:42:03 ACO5436E A failure occurred on stripe number (0), rc = 418 10/13/2009 10:42:03 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 10/13/2009 10:42:03 Backup of BI_SA failed. 10/13/2009 10:42:03 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 10/13/2009 10:42:37 Total SQL backups selected: 9 10/13/2009 10:42:37 Total SQL backups attempted: 9 10/13/2009 10:42:37 Total SQL backups completed: 8 10/13/2009 10:42:37 Total SQL backups excluded: 0 10/13/2009 10:42:37 Total SQL backups inactivated:0 10/13/2009 10:42:37 Throughput rate: 5,993.74 Kb/Sec 10/13/2009 10:42:37 Total bytes transferred: 827,678,720 10/13/2009 10:42:37 Elapsed processing time: 134.85 Secs 10/13/2009 10:42:37 ACO0151E Errors occurred while processing the request. 10/13/2009 10:43:27 == Log file pruned using log retention period of 60 day(s) 10/13/2009 10:43:27 == No log entries pruned Dsierror.log 10/13/2009 11:04:59 sessSendVerb: Error sending Verb, rc: -50 10/13/2009 11:04:59 ANS1017E Session rejected: TCP/IP connection failure
TSM DP for Oracle (Windows) error
Hello, Anyone had this problem? IBM Tivoli Storage Manager for Databases: Data Protection for Oracle Version 5, Release 5, Level 1.0 (C) Copyright IBM Corporation 1997, 2008. All rights reserved. Data Protection for Oracle Information Version: 5 Release: 5 Level:1 Sublevel: 0 Platform: 32bit DP Oracle Win32 Tivoli Storage Manager Server Information Server Name: DSMSERV Server Address: 10.81.35.29 Communication Method: TCP/IP Session Information Node Name:ORACLE_GRID_HLS DSMI_DIR: C:\Program Files\Common Files\Tivoli\TSM\api DSMI_ORC_CONFIG: c:\Program Files\tivoli\tsm\agentoba\dsm_hls.opt TDPO_OPTFILE: tdpo_hls.opt Compression: TRUE License Information: License file exists and contains valid license data. ANS0237E (RC2033) On dsmInit, the node is not allowed when PASSWORDACCESS=genera te. Dsm_hls.opt: * * Tivoli Storage Manager * * Sample dsm.opt for the Microsoft Windows Backup-Archive Client * * * TCP/IP * commmethod tcpip tcpport 1500 TCPServeraddress 10.81.35.29 nodename ORACLE_GRID_HLS *tracefile "c:\program files\tivoli\tsm\agentoba\tdpo.trc" *traceflag service passworddir c:\progra~1\tivoli\tsm\agentoba\ COMPression ON PASSWORDACCESS GENERATE Tdpo_hsl.opt: * * IBM Tivoli Storage Manager for Databases * Data Protection for Oracle * * Sample tdpo.opt for the Data Protection for Oracle on Win32 * * * TSM API configuration * DSMI_ORC_CONFIGc:\Progra~1\tivoli\tsm\agentoba\dsm_hls.opt DSMI_LOG c:\Progra~1\tivoli\tsm\agentoba TDPO_NODE ORACLE_GRID_HLS TDPO_PSWDPATH c:\Progra~1\tivoli\tsm\agentoba TDPO_DATE_FMT 1 TDPO_NUM_FMT 1 TDPO_TIME_FMT 1 *TDPO_TRACE_FLAGSorclevel0 orclevel1 orclevel2 *TDPO_TRACE_FILE "c:\Program Files\tivoli\tsm\agentoba\tdpo.out" * * TSM Server - filespace name * * TDPO_FS default: adsmorc * * TDPO_FSGRID_DB
Re: TSM Dp for Oracle - rman command error
Hello,
The problem was related to file permission for Oracle user.
The problem was solved.
Thank you for your help.
Best regards
Tiago
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Grigori Solonovitch
Sent: quarta-feira, 16 de Setembro de 2009 10:28
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TSM Dp for Oracle - rman command error
Please try to add next lines in opt file
TDPO_TRACE_FLAGS ORCLEVEL0
TDPO_TRACE_FILE /usr/tivoli/tsm/client/oracle/bin64/tdpo.trc
to have trace file. It is better to touch trace file before backup and
check write permissions for Oracle HOME owner.
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East
http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail:
g.solonovi...@bkme.com
Please consider the environment before printing this Email
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Botelho, Tiago (External)
Sent: Wednesday, September 16, 2009 12:06 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TSM Dp for Oracle - rman command error
Hello,
I have a problem backing up the Oracle DB (Oracle 10g).
I received the following rman error log:
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 16 09:55:35
2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: HLSUTF (DBID=478657477)
RMAN> run {
2> allocate channel 'ch1' type 'SBT_TAPE' parms
3>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4>
5>
6> allocate channel 'ch2' type 'SBT_TAPE' parms
7>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8>
9> backup incremental level 0
10> format 'ORACLE_BCK_L0_ENL_%s_%t_%p_%u.dbf'
11> database;
12>
13> sql 'alter system archive log current';
14>
15> backup
16> format 'ORACLE_ARC_ENL_%s_%t_%p_%u.dbf'
17> archivelog all
18> delete input;
19>
20> backup
21> format 'ORACLE_CFILE_ENL_%s_%t_%p_%u.dbf'
22> current controlfile;
23>
24> release channel ch1;
25> release channel ch2;
26> }
27>
using target database control file instead of recovery catalog
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03009: failure of allocate command on ch1 channel at 09/16/2009
09:55:39
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error
Additional info:
1.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 5
Level:2
Sublevel: 0
Platform: 64bit TDP Oracle AIX
Tivoli Storage Manager Server Information
Server Name: ORACLE_GRID
Server Address: 10.81.35.29
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name:ORACLE_GRID_34
Node Type:TDP Oracle AIX
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /usr/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license
data
2.
lrwxrwxrwx1 oracle dba 19 15 Set 17:04 libobk.a ->
/usr/lib/libobk64.a
3.
cat tdpo.opt
DSMI_ORC_CONFIG/usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /usr/tivoli/tsm/client/oracle/bin64/oracle_tsm.log
TDPO_FSoracle_grid
TDPO_NODE ORACLE_GRID_34
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1
TDPO_NUM_FMT 1
TDPO_TIME_FMT 1
Any help?
Thank you
Best regards
Tiago
Please consider the environment before printing this Email.
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are
n
TSM Dp for Oracle - rman command error
Hello,
I have a problem backing up the Oracle DB (Oracle 10g).
I received the following rman error log:
Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 16 09:55:35
2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: HLSUTF (DBID=478657477)
RMAN> run {
2> allocate channel 'ch1' type 'SBT_TAPE' parms
3>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4>
5>
6> allocate channel 'ch2' type 'SBT_TAPE' parms
7>
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8>
9> backup incremental level 0
10> format 'ORACLE_BCK_L0_ENL_%s_%t_%p_%u.dbf'
11> database;
12>
13> sql 'alter system archive log current';
14>
15> backup
16> format 'ORACLE_ARC_ENL_%s_%t_%p_%u.dbf'
17> archivelog all
18> delete input;
19>
20> backup
21> format 'ORACLE_CFILE_ENL_%s_%t_%p_%u.dbf'
22> current controlfile;
23>
24> release channel ch1;
25> release channel ch2;
26> }
27>
using target database control file instead of recovery catalog
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03009: failure of allocate command on ch1 channel at 09/16/2009
09:55:39
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: Reserved errno was encountered
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error
Additional info:
1.
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 2.0
(C) Copyright IBM Corporation 1997, 2009. All rights reserved.
Data Protection for Oracle Information
Version: 5
Release: 5
Level:2
Sublevel: 0
Platform: 64bit TDP Oracle AIX
Tivoli Storage Manager Server Information
Server Name: ORACLE_GRID
Server Address: 10.81.35.29
Server Type: AIX-RS/6000
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name:ORACLE_GRID_34
Node Type:TDP Oracle AIX
DSMI_DIR: /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
TDPO_OPTFILE: /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /usr/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license
data
2.
lrwxrwxrwx1 oracle dba 19 15 Set 17:04 libobk.a ->
/usr/lib/libobk64.a
3.
cat tdpo.opt
DSMI_ORC_CONFIG/usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /usr/tivoli/tsm/client/oracle/bin64/oracle_tsm.log
TDPO_FSoracle_grid
TDPO_NODE ORACLE_GRID_34
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64
TDPO_DATE_FMT 1
TDPO_NUM_FMT 1
TDPO_TIME_FMT 1
Any help?
Thank you
Best regards
Tiago
TSM Data Protection for SQL - Scheduler
Hello, I'm new to TSM Data Protection for Databases. I configured the TSM DP for SQL and I'm able to perform manual backups for my SQL DB. How can I Scheduler a Backup to a SQL Database (like TSM Scheduler in a TSM BA Client) to perform daily backups? TSM Server (AIX 6.1.3) Server Version 5, Release 5, Level 3.0 TSM Data protection for SQL 5.5.1.0 Tdpsql.cfg LASTPRUNEDate 21-08-2009 10:17:50 SQLAUTHentication SQLuserid SQLSERVer VWAEPASV000127 FROMSQLserver VWAEPASV000127 MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20 BUFFers 3 BUFFERSIze 1024 STRIPes 1 SQLBUFFers 0 SQLBUFFERSIze 1024 LOGPrune 60 DATEformat 2 TARGETNode 1 LANGuage PTG NUMBERformat 5 Dsm.opt LASTPRUNEDate 21-08-2009 10:17:50 SQLAUTHentication SQLuserid SQLSERVer VWAEPASV000127 FROMSQLserver VWAEPASV000127 MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20 BUFFers 3 BUFFERSIze 1024 STRIPes 1 SQLBUFFers 0 SQLBUFFERSIze 1024 LOGPrune 60 DATEformat 2 TARGETNode 1 LANGuage PTG NUMBERformat 5 Thank you Best regards Tiago
Re: volumes in a collocation group?
Hi Larry, I thing that my TSM Server do not have this DB record (version 5.2) , but I will try to help you or give you some ideas. Try sommething similarlike this: select volume_name from volumeusage where stgpool_name='STORAGEPOOL' group by volume_name try to find where COLLOCG record are (maybe in nodedata table) See on TSM Server commnd line all the tables from db: h select select * from tables select * from columns ... Useful scripts can be made with TSm DB Best regards Tiago -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: sábado, 14 de Março de 2009 22:13 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] volumes in a collocation group? Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)?
Re: Client Data Lost after client re-installation
Unicode? --- --- - - - / 1 IRIX XFS No 13,262.1 34.1 /usr2 2 IRIX XFS No 17,359.9 68.3 /usr3 3 IRIX XFS No 139,995. 76.7 4 tsm: TSM01> From: Botelho, Tiago (External) Sent: quarta-feira, 18 de Março de 2009 14:23 To: 'ADSM-L@VM.MARIST.EDU' Subject: Client Data Lost after client re-installation Hello all, After client node system disk failure the system administrator change the failure disk, install the OS and makes a manual backup of the client (same node name and IP as before). Now, I search for old data (before disk failure), and no data were found. An expire inventory were made after the backup ... I think that the inactive files should be shown. Backup copy Group for backup: Version Data Deleted =3 ; Retain only Version = 360 days. I try the option "show active and inactive files" and point in time" options on the client, but no old data were found (only the data of the manual backup made after node disk failure) Any idea what can be the problem? TSM Node ID? Any suggestion to solve this problem and return the old files? Thank you for your help Best Regards Tiago
Client Data Lost after client re-installation
Hello all, After client node system disk failure the system administrator change the failure disk, install the OS and makes a manual backup of the client (same node name and IP as before). Now, I search for old data (before disk failure), and no data were found. An expire inventory were made after the backup ... I think that the inactive files should be shown. Backup copy Group for backup: Version Data Deleted =3 ; Retain only Version = 360 days. I try the option "show active and inactive files" and point in time" options on the client, but no old data were found (only the data of the manual backup made after node disk failure) Any idea what can be the problem? TSM Node ID? Any suggestion to solve this problem and return the old files? Thank you for your help Best Regards Tiago
