Exporting TDP backups
Does anyone have experience with exporting and importing a node that uses Oracle or Sql TDP for its backups with TSM 5.2.3? Have you had success restoring the imported data? Is there anything special you had to do? Karla Ross
Need help with select command
I am trying to find the tapes needed to recover only the active backups of a client. I used the following select command and it gives me a list of all tapes for all backups of that client. How can I narrow the search to just active backups? select volume_name,filespace_name from volumeusage where - node_name='CLIENT NAME' and stgpool_name='STGPOOL'
stopping active backup sessions at a specified time
We have several applications that due to some performance issues have there backups running longer than normal on some nights. Does anyone have a good automated method to monitor backup sessions for a client and either stop them at a given time if they are still running or notify someone that they are still running? Karla Ross
Performing Full Client Backups with TSM
I read this process on the IBM web page, my question is, my customer wants different retentions on weekly full backups, monthly full, and daily incrementals. Whats the recommended way to do this with TSM? Karla Ross
TSM V5.2.2
We are getting ready to install a new TSM server running on AIX 5. I wanted to install TSM V5.2.2. Is anyone running this version, and if so do you have any comments, issues or tips?
Re: Unable to remove node!
You can't remove a node if there are backupsets for it. Do a q volh t=backupset Karla Ross Alan Davenport [EMAIL PROTECTED]@VM.MARIST.EDU on 12/19/2003 07:37:54 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: Unable to remove node! Query filespaces for that node. Delete filespaces, then you will be able to delete the node. Take care, Al Alan Davenport Senior Storage Administrator Selective Insurance Co. of America [EMAIL PROTECTED] (973) 948-1306 -Original Message- From: Niklas Lundstrom [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 3:17 AM To: [EMAIL PROTECTED] Subject: Unable to remove node! Hello I am trying to remove a node. tsm: SPADAB-PRODrem node tremfk Do you wish to proceed? (Yes (Y)/No (N)) y ANR2152E REMOVE NODE: Inventory references still exist for node TREMFK. ANS8001I Return code 13. tsm: SPADAB-PRODq occu tremfk ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. So the q occu tells me that the node has no files, but the rem node says it has??! Any ideas?? Mvh Niklas Lundström Föreningssparbanken IT 08-5859 5164
TDP for oracle on linux
Does anyone know if there is a TDP for oracle that will run on Linux redhat interprize AS 2.1? Karla Ross
Need select command to show how much is backed up
I need a select command the will show me how much data is being backed up by my tsm server, can anyone help? Karla Ross
Re: Need select command to show how much is backed up
Thanks this worked great. Karla Ross Lawrence Clark [EMAIL PROTECTED]@VM.MARIST.EDU on 05/30/2003 12:01:50 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: Need select command to show how much is backed up By client: select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files from occupancy group by node_name order by node_name asc [EMAIL PROTECTED] 05/30/03 12:34PM I need a select command the will show me how much data is being backed up by my tsm server, can anyone help? Karla Ross
Re: can't extend db
Your right, it took about 40 minutes, never had it take so long. Thanks for the response. Karla Ross IBM Global Services 314-232-9964 [EMAIL PROTECTED] Karel Bos [EMAIL PROTECTED]@VM.MARIST.EDU on 10/02/2002 05:31:27 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: can't extend db I had something what sounds the same. TSM db on raid 5 (not anymore). Extend started, server seems to hang. Went home and came back next morning. All went well. -Oorspronkelijk bericht- Van: Karla Ross [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 2 oktober 2002 1:00 Aan: [EMAIL PROTECTED] Onderwerp: can't extend db Urgentie: Hoog Has anyone ever seen this, my tsm database is 100% full, I formated and defined more volumes, and when you q dbv volume you see the new volumes, but the extend db never works. When I enter q db I have 4052MB to extend to but when I issue the command 'extend db 4052' it just hangs, no response ever. I am running TSM v5.1.1 on a solaris. Any help would be great! Karla Ross IBM Global Services 314-232-9964 [EMAIL PROTECTED]
can't extend db
Has anyone ever seen this, my tsm database is 100% full, I formated and defined more volumes, and when you q dbv volume you see the new volumes, but the extend db never works. When I enter q db I have 4052MB to extend to but when I issue the command 'extend db 4052' it just hangs, no response ever. I am running TSM v5.1.1 on a solaris. Any help would be great! Karla Ross IBM Global Services 314-232-9964 [EMAIL PROTECTED]
Select command to q client name and version
Does anyone have a select command that will show me the clients and what version of TSM they are running? My TSM servers are running TSM v4.1, 4.2, and 5.1. Karla Ross
Re: Select command to q client name and version
This worked great! Thanks for all the replys. Karla Ross -- Forwarded by Karla Ross/St Louis/IBM on 09/19/2002 01:26 PM --- Hussein Abdirahman [EMAIL PROTECTED]@VM.MARIST.EDU on 09/19/2002 08:34:10 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: Select command to q client name and version Hi Carla; Try this. I got this from group. It will also display the OS versions. select platform_name as OS, - client_os_level as OS_VER, - node_name as Node, - cast(cast(client_version as char(2)) || '.' - || cast(client_release as char(2)) || '.' - || cast(client_level as char(2)) || '.' - || cast(client_sublevel as char(2)) - as char(15)) as Client - from nodes - order by platform_name, Client, Node regrds; Hussein M. Abdirahman UNIX Administrator -Original Message- From: Karla Ross [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:08 AM To: [EMAIL PROTECTED] Subject: Select command to q client name and version Does anyone have a select command that will show me the clients and what version of TSM they are running? My TSM servers are running TSM v4.1, 4.2, and 5.1. Karla Ross
Re: Select command to q client name and version
This works great, thanks for all the replays. Karla Ross Hussein Abdirahman [EMAIL PROTECTED]@VM.MARIST.EDU on 09/19/2002 08:34:10 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:Re: Select command to q client name and version Hi Carla; Try this. I got this from group. It will also display the OS versions. select platform_name as OS, - client_os_level as OS_VER, - node_name as Node, - cast(cast(client_version as char(2)) || '.' - || cast(client_release as char(2)) || '.' - || cast(client_level as char(2)) || '.' - || cast(client_sublevel as char(2)) - as char(15)) as Client - from nodes - order by platform_name, Client, Node regrds; Hussein M. Abdirahman UNIX Administrator -Original Message- From: Karla Ross [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 9:08 AM To: [EMAIL PROTECTED] Subject: Select command to q client name and version Does anyone have a select command that will show me the clients and what version of TSM they are running? My TSM servers are running TSM v4.1, 4.2, and 5.1. Karla Ross
Re: TSM 5.1
I have one server upgraded, AIX 4.3 running TSM 5.1.0.2. The issue I am having is with copy storage pool. It will not use any tape unless the tape has been previously used by the backup pool. I am working with TSM level 2. They are trying to duplicate this. I am getting the same results on a new install Aix 4.3 running TSM 5.1.0.2. The tape library on the upgraded server is a 3494 and on the new install its a 3584. Is anyone else seeing this? Karla Ross IBM Global Services 314-232-9964 [EMAIL PROTECTED] Hart, Charles [EMAIL PROTECTED]@VM.MARIST.EDU on 06/04/2002 12:23:02 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: Subject:TSM 5.1 Has anyone yet upgraded to version 5.1 on AIX 4.3.3? If so please let us know your experiences. We are considering going to 5.1 to utilize NDMP for a EMC Celerra. Regards, Charles