TDP Licensing for an additional node on same server
Hi All, I have TDP for Databases configured to backup MS-SQL databases on a cluster. TDP is installed on the active and passive nodes. The SQL DBA has created another SQL server instance on the same box and wants this backed up using TDP under a different node name. How does the TDP licensing get calculated with this kind of scenario? Also, Does TDP licensing get calculated for the passive node? Your help will be really appreciated. Thanks. regards, Ankur Patel. DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
Re: how can I know an archive finished
Try this: select date(start_time) as start_date, time(start_time) as start_time, date(end_time) as end_date, time(end_time) as end_time, SUBSTR (CAST(entity AS char(17)),1,17) as Node_Name, cast((Bytes/1024) as decimal(15,2)) as KB_Archived, affected, (end_time-start_time)minutes as Mins from summary where activity='ARCHIVE' order by start_date result looks like: START_DATE START_TIME END_DATE END_TIME NODE_NAME KB_ARCHIVED AFFECTED MINS -- -- -- - - -- 2010-03-01 11:50:37 2010-03-01 16:44:35 AUCFDW01_FS 376022498.94 120293 Regards, Ankur Patel Snr Enterprise Mgmt Administrator Sydney. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of William ZHANG Sent: Thursday, 1 April 2010 12:26 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] how can I know an archive finished Hi All, My colleague is archiving some data by gui interface - dsmj , how can I know the finish of this archive if I can not see the gui interface and he does not close gui. Thanks and regards, William DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
Re: TDP MS SQL X32 / X64
Boris, I have recently setup TDP Backups for SQL 64 bit. Not sure about SQL x32 on windows x64. My setup: TSM B/A Client x64 v5.5.1.0 TSM TDP x64 v5.5.0.0 SQL Server 2005 x64 windows Server 2003 R2 Enterprise x64 Edition SP2 Backup Method: Legacy Regards, Ankur Patel TSM Administrator Sydney. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Herrmann, Boris Sent: Wednesday, 10 September 2008 12:24 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP MS SQL X32 / X64 Hello all, we've got a Windows 2003 64 Bit System with a MS SQL Database (32 Bit). We've installed TSM BA Client 5.5.1 (64 Bit). But which version of TDP must we use (32 Bit or 64 Bit?) With kind regards, Boris DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
Re: TSM Copy Services for Exchange 2007 Passive Node.
Thanks Del. I have updated the TDP client from 5.5.0.0 to latest. ~ TSM Server V5.4.3.0 (AIX-RS/6000). TSM B/A Client v5.5.1.0. TSM for Mail v5.5.1.0. TSM for Copy Services v5.5.1.0. Windows Server 2003 R2 Enterprise x64 Edition Service Pack 2. Exchange Server 2007 V8.1.291.1. ~ I have already logged a call with IBM. It has been escalated to level 2. Have submitted trace runs, waiting for their response. Regards, Ankur Patel TSM Administrator Harvey Norman IT* Building A1 Richmond Road Homebush West. NSW. 2140. Australia Email:[EMAIL PROTECTED] Phone: +61295826173 *Yoogalu Pty Limited A.C.N. 002 269 132 / A.B.N. 34 347 009 955 ~~ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Thursday, 4 September 2008 9:56 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. Ankur, You must be running this command from the Exchange Server that owns the replica. I also encourage you to upgrade to Data Protection for Exchange 5.5.1. ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance /tivoli-data-protection/ntexch/v551/x64/ If you are still having problems, place a call with IBM support. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 09/01/2008 04:42:40 AM: [image removed] Re: TSM Copy Services for Exchange 2007 Passive Node. Patel, Ankur to: ADSM-L 09/01/2008 04:43 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Del, Thanks for helping me out with this. I followed those steps you mentioned and now the error (*ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered*) doesn't come up anymore. Below is the output that I get when I now trigger the backup command: Please see if you/someone can comment on that error (ANS1302E (RC2) No objects on server match query). ~~ Running the command to backup the Exchange 2007 replica: C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc backup * full /FROMREPLICA /BACKUPMETHod=VSS /tsmoptfile=G:\tivoli\tsm\api\dsm.opt /logfile=G:\tivoli\tsm\api\excschfull.log /EXCSERVer=AUDCCFOMX005 IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. ACN5057I The G:\tivoli\tsm\api\excschfull.log log file has been pruned successfully. Querying Exchange Server to gather storage group information, please wait... ANS1302E (RC2)No objects on server match query C:\Program Files\Tivoli\TSM\TDPExchange ~~ ** Extract from action log: ANR0406I Session 27079 started for node AUDCCFOMX005_EXCH (TDP MSExchg) tcp/Ip 192.168.128.88(44666)). ANR0406I Session 27080 started for node AUDCCFOMX002_FS (WinNT) (Tcp/Ip 192.168.128.88(44671)). ANR0397I Session 27080 for node AUDCCFOMX002_FS has begun a proxy session for node AUDCCFOMX005_EXCH. ANR0399I Session 27080 for node AUDCCFOMX002_FS has ended a proxy session for node AUDCCFOMX005_EXCH. ANR0403I Session 27080 ended for node AUDCCFOMX002_FS (WinNT). ANR0403I Session 27079 ended for node AUDCCFOMX005_EXCH (TDP MSExchg). ** Regards, Ankur Patel TSM Administrator Sydney. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Saturday, 30 August 2008 1:39 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. This problem is most likely caused because the register node was not done correctly. In order for proxy authority to work, you must have as admin node of Client Owner admin privilege for the DP/Exchange node. This is normally done for you automatically when you issue the REGISTER NODE command. However if something like this was used: REGISTER NODE nodename password USERID=NONE then the admin node is not created. This will cause the exact error you are seeing. The PROXY code uses the Remote Client BA Client service... which requires Client Owner admin privilege. To solve this problem, you can delete the node and register it again correctly. The steps to solve this problem are: 1. On the TSM Server remove the DP/Exchange node: REMOVE NODE USCOL2K3EXVS01 2. On the TSM Server register the DP/Exchange node: REG NODE USCOL2K3EXVS01 password 3. On the TSM Server create the proxy settings: GRANT PROXY TARGET=USCOL2K3EXVS01 agent=USCOL2K3OF01,USCOL2K3EX01 4. On the Exchange Server... to make sure the password is stored... enter this command: TDPEXCC QUERY TSM /TSMPASSWORD=password 5. Retry the query
Re: TSM Copy Services for Exchange 2007 Passive Node.
Del, Thanks for helping me out with this. I followed those steps you mentioned and now the error (*ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered*) doesn't come up anymore. Below is the output that I get when I now trigger the backup command: Please see if you/someone can comment on that error (ANS1302E (RC2) No objects on server match query). ~~ Running the command to backup the Exchange 2007 replica: C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc backup * full /FROMREPLICA /BACKUPMETHod=VSS /tsmoptfile=G:\tivoli\tsm\api\dsm.opt /logfile=G:\tivoli\tsm\api\excschfull.log /EXCSERVer=AUDCCFOMX005 IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. ACN5057I The G:\tivoli\tsm\api\excschfull.log log file has been pruned successfully. Querying Exchange Server to gather storage group information, please wait... ANS1302E (RC2)No objects on server match query C:\Program Files\Tivoli\TSM\TDPExchange ~~ ** Extract from action log: ANR0406I Session 27079 started for node AUDCCFOMX005_EXCH (TDP MSExchg) tcp/Ip 192.168.128.88(44666)). ANR0406I Session 27080 started for node AUDCCFOMX002_FS (WinNT) (Tcp/Ip 192.168.128.88(44671)). ANR0397I Session 27080 for node AUDCCFOMX002_FS has begun a proxy session for node AUDCCFOMX005_EXCH. ANR0399I Session 27080 for node AUDCCFOMX002_FS has ended a proxy session for node AUDCCFOMX005_EXCH. ANR0403I Session 27080 ended for node AUDCCFOMX002_FS (WinNT). ANR0403I Session 27079 ended for node AUDCCFOMX005_EXCH (TDP MSExchg). ** Regards, Ankur Patel TSM Administrator Sydney. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Saturday, 30 August 2008 1:39 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. This problem is most likely caused because the register node was not done correctly. In order for proxy authority to work, you must have as admin node of Client Owner admin privilege for the DP/Exchange node. This is normally done for you automatically when you issue the REGISTER NODE command. However if something like this was used: REGISTER NODE nodename password USERID=NONE then the admin node is not created. This will cause the exact error you are seeing. The PROXY code uses the Remote Client BA Client service... which requires Client Owner admin privilege. To solve this problem, you can delete the node and register it again correctly. The steps to solve this problem are: 1. On the TSM Server remove the DP/Exchange node: REMOVE NODE USCOL2K3EXVS01 2. On the TSM Server register the DP/Exchange node: REG NODE USCOL2K3EXVS01 password 3. On the TSM Server create the proxy settings: GRANT PROXY TARGET=USCOL2K3EXVS01 agent=USCOL2K3OF01,USCOL2K3EX01 4. On the Exchange Server... to make sure the password is stored... enter this command: TDPEXCC QUERY TSM /TSMPASSWORD=password 5. Retry the query exchange operation: TDPEXCC QUERY EXCHANGE Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/28/2008 07:26:36 PM: [image removed] TSM Copy Services for Exchange 2007 Passive Node. Patel, Ankur to: ADSM-L 08/28/2008 07:28 PM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Hi Everybody, I really need help on this. Maybe its something very simple for someone, but i am unable to resolve this Subject: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. Target: To Backup Exchange 2007 Passive Node using TSM Copy Services. Environment: TSM Server v5430 on AIX-RS/6000. Exchange 2007 on Windows 2003 R2 Enterprise x64 Edition SP2. I have Configured the TSM copy services on the Exchange server audccfomx002. System node registered as audccfomx002_fs. Cluster Node registered as audccfomx005_exch. ~ C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc.exe query tsm IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. Tivoli Storage Manager Server Connection Information Nodename ... AUDCCFOMX005_EXCH NetWork Host Name of Server 192.168.128.124 TSM API Version Version 5, Release 5, Level 1.0 Server Name AUCFTSM01_PROD Server Type AIX-RS/6000 Server Version . Version 5, Release 4, Level 3.0 Compression Mode ... ON Domain
TSM Copy Services for Exchange 2007 Passive Node.
Hi Everybody, I really need help on this. Maybe its something very simple for someone, but i am unable to resolve this Subject: [ADSM-L] TSM Copy Services for Exchange 2007 Passive Node. Target: To Backup Exchange 2007 Passive Node using TSM Copy Services. Environment: TSM Server v5430 on AIX-RS/6000. Exchange 2007 on Windows 2003 R2 Enterprise x64 Edition SP2. I have Configured the TSM copy services on the Exchange server audccfomx002. System node registered as audccfomx002_fs. Cluster Node registered as audccfomx005_exch. ~ C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc.exe query tsm IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. Tivoli Storage Manager Server Connection Information Nodename ... AUDCCFOMX005_EXCH NetWork Host Name of Server 192.168.128.124 TSM API Version Version 5, Release 5, Level 1.0 Server Name AUCFTSM01_PROD Server Type AIX-RS/6000 Server Version . Version 5, Release 4, Level 3.0 Compression Mode ... ON Domain Name HN1_PD Active Policy Set .. COPY Default Management Class ... BKUP_FS_MC ~ ~ C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc.exe query tdp IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. Data Protection for Exchange Preferences BACKUPDESTination... TSM BACKUPMETHod VSS BUFFers 3 BUFFERSIze . 1024 DATEformat . 1 LANGuage ... ENU LOCALDSMAgentnode... AUDCCFOMX002_FS LOGFile tdpexc.log LOGPrune ... 60 MOUNTWait .. Yes NUMberformat ... 1 REMOTEDSMAgentnode.. RETRies. 4 TEMPLOGRESTOREPath.. G:\Exchange\Restore TIMEformat . 1 ~ ~ = command used to trigger this backup: C:\Program Files\Tivoli\TSM\TDPExchangetdpexcc backup * full /FROMREPLICA /BACKUPMETHod=VSS /tsmoptfile=G:\tivoli\tsm\api\dsm.opt /logfile=G:\tivoli\tsm\api\excschfull.log /EXCSERVer=AUDCCFOMX005 Errors/output: IBM Tivoli Storage Manager for Mail: Data Protection for Microsoft Exchange Server Version 5, Release 5, Level 0.0 (C) Copyright IBM Corporation 1998, 2007. All rights reserved. ACN5057I The G:\tivoli\tsm\api\excschfull.log log file has been pruned successfully. Querying Exchange Server to gather storage group information, please wait... ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered ~ I cannot resolve this: *ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered*** I have gone through lot of Google search, but Not sure how to get around this. Please someone help me. Let me know if more information is required on this. Thanks. Regards, Ankur Patel. Sydney. DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
Re: TSM database size?
Dinesh, See if this helps. Extract from: http://en.wikipedia.org/wiki/IBM_Tivoli_Storage_Manager ITSM maintains a relational database (limit 534GB through ITSM v5.5) and recovery log (aka transaction log, limit 13.5GB) for logging, configuration, statistical information, and object metadata. DB pages are always 4KB, and partitions every 4MB. Single row inserts only. On average, 20GB of space is consumed for every 25 million objects. Shallow directory structures utilize less TSM DB space than deeper paths. This database may generally be queried via an emulated SQL-98 compliant interface, or through undocumented SHOW, CREATE or DELETE commands. Also, see IBM site: http://www-01.ibm.com/support/docview.wss?rs=0q1=Maximum+TSM+DB+Sizeui d=swg21243509loc=en_AUcs=utf-8cc=aulang=en The Administrator Guide manual specifies that the maximum size of the database is 530GB. This is however a rounded figure.The actual maximum size of the database is 543184 MB, which equates to about 530.5 GB. Regards, Ankur Patel TSM Administrator -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pahari, Dinesh P Sent: Friday, 29 August 2008 11:37 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM database size? Hi All, I have got a TSM server with the 80GB database size. It is already utilized above 80%. Could someone please let me know, what is the exact recommended database size by IBM? Any links with such information would be good. Kind Regards, Dinesh Pahari DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
Re: select statement
Avy, I tried your query on my machine and it has worked fine. See results: ~~ AUCFTSM01_PRODselect vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu. volume_name) as AVG MB/tape from volumeusage vu, auditocc ao where vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4 Session established with server AUCFTSM01_PROD: AIX-RS/6000 Server Version 5, Release 4, Level 3.0 Server date/time: 08/29/08 15:00:01 Last access: 08/29/08 12:46:42 ANR2963W This SQL query may produce a very large result table, or may require a significant amount of time to compute. Do you wish to proceed? (Yes (Y)/No (N)) y NODE_NAME TOTAL_MB TAPES AVG MB/tape -- --- --- --- FLEMTMH2_FS 531344 1543450 FLEMXPS3_FS1122421 1666761 FLEMTDM2_FS 764482 50 15289 FLEMXPS2_FS2865024 172 16657 AUCFTDWH01_FS 4078174 186 21925 AUCFSAV01_FS 3604114 163 22111 AUDCCFOMX006_EXCH70208 3 23402 FLEMXPS0_FS7529458 213 35349 AUCFVSQ1_FS7168357 159 45084 AUCFNIM01_FS 14523030 190 76437 AUCFDW01_FS 48314333 233 207357 . . . . . Regards, Ankur Patel TSM Administrator. SYDNEY. ~~ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Avy Wong Sent: Friday, 29 August 2008 5:36 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] select statement Hello, The following is a select statement to provide a total data stored and tapes used per node in all storage pools. I have broken down the sql and double checked the tables and column names are all there. Can anyone see where the hangs ups are? select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu.volume_name) as AVG MB/tape from volumeusage vu, auditocc ao where vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4 ANR2956E Unable to access SQL base table 'VOLUMEUSAGE'. | ..V me) as AVG MB/tape from volumeusage vu, auditocc ao where vu. ANS8001I Return code 26. thanks, Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860)862-8164 (cell) (860)961-6976 DISCLAIMER Confidential Communication: This email and any attachments are intended for the addressee(s) only and are confidential. They may contain legally privileged or copyright material. If you are not the intended recipient, please contact the sender immediately by reply email and delete this email and any attachments. You must not read, copy, use, distribute or disclose the contents of this email without consent and Harvey Norman Holdings Limited ACN 003 237 545 (and its related subsidiaries) (Harvey Norman) does not accept responsibility for any unauthorised use or reliance on the contents of this email. Harvey Norman does not represent or warrant that the integrity of this email has been maintained or that it is free from errors, viruses, interceptions or interference. Any views expressed by the sender do not necessarily represent the views of Harvey Norman. This notice should not be removed from this email.
