3584 checkin/checkout

2006-05-03 Thread Gill, Geoffrey L.
I'm wondering if I'm missing anything in our setup of the 3584 as it relates to incoming and outgoing tapes. Currently the mainframe sends alerts to the operators when the I/O port is full on the 3494 and needs emptying. Once empty the checkout of tapes can continues. I was wondering how others man

Client restores for NFS server backups

2006-05-03 Thread Lance Nakata
Setup: TSM 5.1.5.4 server running on SPARC Solaris 9 TSM 5.2.0.4 client running on SPARC Solaris 9 TSM 5.2.2.0 client running on Intel/AMD RHEL3 Scenario: I'm running TSM backups on a SPARC Solaris 9 NFS server named nfssrv1, backing up the /home partition. /home contains subdirs sm

Fwd: Populating DRM information

2006-05-03 Thread Steven Harris
Hi All I'm installing a new site. TSM is 5.3.3 server and windows2003 clients are Windows2000, Mandrake linux, exchange and MSSQL. I've got everything working and now need to populate the DRM information, something that I've never done before. Does anyone have any scripts they could share for dr

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Timothy Hughes
Thanks Wanda & Brian for your responses! So it is telling us the # of tapes that are full and have reclamable space. We do have multiple storage pools so the number that we are seeing combines both tape pools volumes. Tim "Robinson, Brian D." wrote: > If you check the folder that the TSM Operat

Re: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Jim Bollard
Backup_Copy is your pri tape pool(onsite copy), backup_copy_mb (offsite copy) is your copypool data. Sum will total all data in these pools, handy for making sure your stg pools are in sync for DR as your pri will be destroyed. You could add that SQL statement I gave you to you TSM servers operati

Re: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Vats.Ashok
First of all thanks for the help ...this is good learning for me.I ran the following select commands >select node_name,sum(num_files),sum(physical_mb) from occupancy group by >node_name NODE_NAME Unnamed[2]Unnamed[3] -- -

Re: Backup of MSSQL Databases

2006-05-03 Thread Victoria Ortepio
That's what we current do. But we have been having space issues with the database sizes being backed up. Vicki -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ung Yi Sent: Wednesday, May 03, 2006 12:05 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM

Re: Backup of MSSQL Databases

2006-05-03 Thread Ochs, Duane
We use the native MSSQL backup utility and back them up to a remote archive server and archive all MSSQL dbs from a single location. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ung Yi Sent: Wednesday, May 03, 2006 11:05 AM To: ADSM-L@VM.MARIST.ED

Re: Backup of MSSQL Databases

2006-05-03 Thread Ung Yi
Hello, We backup the databases to local drives then have TSM pick the backup files. Yi -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Victoria Ortepio Sent: Wednesday, May 03, 2006 12:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Backup of MSSQL Databas

Backup of MSSQL Databases

2006-05-03 Thread Victoria Ortepio
We need to back up MSSQL databases, but they need to be closed to the RDMS first. Has anyone done that? We do not have the Tivoli TDP agent, nor any other agents that handle open database files. I am not the best script writer, but I was thinking to build a script somewhat like the following:

Re: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Jim Bollard
select node_name,backup_mb,backup_copy_mb,archive_copy_mb from auditocc Is what you need, this tells you each clients data in MB. Regards, Jim Bollard. Technical Consultant. Unitech Systems Ltd. Mobile: +353 86 353 2761 Office: +353 1 2942300 Office Direct: +353 1 2999356 http://www.unitech-ie

Re: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Bos, Karel
Hi, 'select node_name,sum(num_files),sum(physical_mb) from occupancy group by node_name' Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vats.Ashok Sent: woensdag 3 mei 2006 17:48 To: ADSM-L@VM.MARIST.EDU Subject: TASM 5.3.0.0 on A

Re: TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Jim Bollard
select sum(backup_mb/1024) as "All Primary Data - GB",sum(backup_copy_mb/1024) as "All Copy Data - GB" from auditocc you could include archive data also if needed Regards, Jim Bollard. Technical Consultant. Unitech Systems Ltd. Mobile: +353 86 353 2761 Office: +353 1 2942300 Office Direct: +35

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Robinson, Brian D.
If you check the folder that the TSM Operational Reporting software runs in - usually the C:\Program Files\Tivoli\TSM\Console directory, you should find a file with your daily report name with an ".in" extension. An example is . Edit this file and you will see what and how the report is generated.

TASM 5.3.0.0 on AIX 5.3.0.0 quick question

2006-05-03 Thread Vats.Ashok
Hi All, We need to find how much storage is being used by each TSM client. I get reports which indicate how much data is being backed up by each tsm client but I am not able to find how much data is being stored for each client. Is there any query or select statement I can use to get the info f

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Prather, Wanda
The "volume reclamation warning" is issuing this SQL query: select count(*) as RW from volumes where (status='FULL') AND (pct_utilized<48) Don't ask me why they picked 48. To see this, In the management console, right click on your Daily Report, select PROPERTIES. Click to highlight CUSTOM SUMM

backupsets & TSM TDP products

2006-05-03 Thread John Bremer
All, We made the mistake of creating some backupsets from backups created by Domino API. While backupset generation from these filespaces works fine, you can't restore anything. Querybackupsetcontents shows all the data, but TSM backup client knows nothing about API:DominoData filespace types.

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Timothy Hughes
Thanks Bob! Bob Martoncik wrote: > From what I remember of that, that line is telling you that TSM wanted > to reclaim a tape but for whatever resaon, could not get access to it. > Our problem was that the offsite tapes and onsite where out of sync. > Once we got that problem solved, the reclaima

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Bob Martoncik
>From what I remember of that, that line is telling you that TSM wanted to reclaim a tape but for whatever resaon, could not get access to it. Our problem was that the offsite tapes and onsite where out of sync. Once we got that problem solved, the reclaimation warnings went down from 8 to 0. Hope

Tivoli Storage Manager Operational Reporting item

2006-05-03 Thread Timothy Hughes
Hello, Does anyone who is using Tivoli Storage Manager Operational Reporting know what the Item >> Volume Reclamation warning # <<< means in the Custom Summary selection means? I think it's reporting the # of tape volumes that are reclaimable is that correct? Thanks for any help in advance!

Re: TSM DB backup

2006-05-03 Thread Steven Harris
Hello Jacqueline Just a few thoughts Have you ever run a tape operation in this library before? It may be that the device name of the drive (rmt0, rmt1...) doesn't match the path definitions e.g you have set up drive0 as rmt0, drive1 as rmt1 , but rmt0 might be a local dds drive and not in the