Threshold on Copypool relcamation

2005-06-08 Thread Debbie Bassler
A couple of weeks ago I was given the opportunity to take on the TSM admin role :-) I was wondering if anyone reclaims copy storage pools. Currently, we execute a schedule to reclaim space from our copy storage pool using the upd stgp copypool recl=80 command, this is scheduled for 15:00. Then we

Re: Threshold on Copypool relcamation

2005-06-08 Thread Debbie Bassler
Thanks to allI had a brain block...I was thinking our copy storage pool was collocated, as are our primary pools,,boy, it's hard to get back in the saddle (and stay on) :-) Lawrence Clark <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 06/08/2005 04:13 PM Please respond to

Faster Restore

2005-06-14 Thread Debbie Bassler
I started a gui restore, of the C drive, on an NT server about an hour ago. The server has only restored 1.2G and I'm told contains about 8G of data. Is there something I can do to restore faster? The TSM server version is 5.1.1 and the client version is 5.2.0. Also, if I cancel the current restore

Server Locked Up

2005-06-17 Thread Debbie Bassler
It seems our server has locked up. We are copying our storage pools to our copypool and nothing seems to be moving, no counts are increasing. Our server level is 5.1.1. We have 10 tape drives, all online. 8 are in use and 2 are reserved. Has anyone had this problem before? The dsmserv.err log doesn

Re: Server Locked Up

2005-06-17 Thread Debbie Bassler
Actually, I'm thinking it was a tape conflict. We had a node backup waiting 7 hrs for media. However, the node backup started 3 hours before the copy pool backups. Once I cancelled the node backup everything started running again. I will go through the activity log again, more thoroughly this time

Backup Information

2005-06-21 Thread Debbie Bassler
I was looking at the database tables and trying to find a way to get the node names, backup start and end times and the amount of data backed up, into an excel spread sheet. We backup over 100 servers a night and the operations people manually go throught the activity log to find, and record, thi

Re: Backup Information

2005-06-22 Thread Debbie Bassler
to the server ... It work great (also with pre-5.2.2 servers) and no additional costs. It's to check everydays work. If you want the tool let me know and I'll mail it (approx 17 MB). Jop de Graaf Interaccess -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECT

Re: Backup Information

2005-06-22 Thread Debbie Bassler
19) as End_Time, (end_time - start_time) minutes as Duration, examined as Examined, affected as Backed_Up, failed as Failed, cast(bytes/1024/1024 as integer) as MB, successful from summary where start_time !< (current_timestamp - 1 day) and upper(activity)='BACKUP' [EMAIL PROTECTED] Debb

CAD Question

2005-06-23 Thread Debbie Bassler
We had a Windows 2003 box which had to have the C drive rebuilt a couple of weeks ago. The TSM software was on the D drive and was not disturbed. However, we just noticed the backup has not run since 6/13. The dsmsched.log has a next start date of 6/14. I believe I need to load dsmcad, the dsm.opt

Re: Can't write log file on remote disk

2005-06-24 Thread Debbie Bassler
Richard, How do you restart the scheduler process on a Window 2000 machine. Also, if I decide to use CAD, how do I implement it? Thanks, Debbie Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 06/24/2005 07:27 AM Please respond to "ADSM: Dist Stor Manager" To:

MS SQL Database Backup

2005-07-07 Thread Debbie Bassler
Does anyone know if it's possible to use TSM to backup a MS SQL Database while it's up and running?? Thanks, Debbie

Backup/Restore Questions

2005-07-15 Thread Debbie Bassler
I have 2 questions I hope someone can help me with., How does TSM gather data to do a backup? I thought when a backup started, TSM made a list of files to backup and backed up only those files. However, we started a backup, yesterday at 2:00 PM, and there was only 38G of data to be backed up on t

Version Control Question

2005-07-21 Thread Debbie Bassler
We have reduced the number of file versions to keep from 14 to 7 on one of our clients, the primary storage pool is the tape pool. When we display the number of versions in TSM we can see there are 7, as expected. Is there a way to see if we have reclaimed tapes in our primary tape pool? Our TSM

Tape Question

2005-07-27 Thread Debbie Bassler
Currently, we have a 3494 tape library and 3590 tape drives and 3590 tapes. We are planning to get a couple of 3592 tape drives. My question is, will we be able to use the 3590 tapes in the 3592 tape drives? I would think since the capacity of the 3590 tapes is only 20G/40G it would not be a good i

Re: Tape Question

2005-07-27 Thread Debbie Bassler
:34 AM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: [ADSM-L] Tape Question On Jul 27, 2005, at 8:17 AM, Debbie Bassler wrote: > Currently, we have a 3494 tape library and 3590 tape drives and > 3590 tap

Re: Scripts for summary

2005-08-01 Thread Debbie Bassler
I'm just starting to learn the value of scripts,,, The attached email provoked me to send this email before diving into the script arena,,,in hopes someone may already have a script similiar to the one I'm in need of,,, I'm looking for a script containing the following backup information,,, sche

Re: Scripts for summary

2005-08-01 Thread Debbie Bassler
: ADSM-L@VM.MARIST.EDU cc: Subject:Re: [ADSM-L] Scripts for summary Debbie, try select SCHEDULE_NAME, START_TIME, END_TIME, BYTES, LastSess_Duration, FAILED, SUCCESSFUL from summary, nodes where entity = node_name and end_time > date(

Cancel Session

2005-08-02 Thread Debbie Bassler
I executed a script, yesterday, and it is still executing. The session won't cancel it because it's in a run status. Is there a way to force a session to cancel? Thanks, Debbie

Re: Cancel Session

2005-08-02 Thread Debbie Bassler
This is the script which is executing; set sqldatetimeformat usa set sqldisplaymode wide select a.entity,a.successful,b.msgno,substr(b.message,posstr(b.message,'transferred:')+14,8)as Bytes_Backedup, substr(cast(min(a.start_time)as varchar(10)),1,10) as Start_Date, substr(cast(min(a.start_time)as

Re: Cancel Session

2005-08-02 Thread Debbie Bassler
Thanks, Andy,, I ran the script as a server script. I was not able to cancel the session, we had to bounce the server. Is there any information on how to code scripts for TSM? If I remember correctly, it's a btrieve database. Currently, I've only dealt with Oracle databases and know PL/SQL code.

Restore request

2005-08-03 Thread Debbie Bassler
I'm trying to perform a restore between two Novell servers. I need to know the command line entry to restore pjihelp\vol1\support to pjinwapps01\restore. I am doing the restore on pjinwapps01 and my dsm.opt file has a virtualnodename pjihelp. Can anyone help? Thanks, Debbie

Technote 1200328

2005-08-03 Thread Debbie Bassler
This doc offers alot of information about improving performance. I'm especially interested in this because it took 56 minutes to restore 6.24G of data, from Novell server to Novell server, over a 100MB pipe. Our TSM version is 5.1.1 ( I know,,,we need to upgrade)...and the client version is 5.2.

Re: Technote 1200328

2005-08-03 Thread Debbie Bassler
Oops, I meant to include that in the email. The bottom of this doc shows the transfer rates..   Lawrence Clark <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/03/2005 04:10 PM Please respond to "ADSM: Dist Stor Manager"                 To:        ADSM-L@VM.MARIST.EDU         c

Re: Technote 1200328

2005-08-04 Thread Debbie Bassler
Our storage pool is colloated,,,there are only 3 volumes used for this server's backed up data. Also, there were no tape drive contention problmes when I ran the restore...that's why this is so puzzling. Debbie Troy Frank <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/03/2005 05:2

Re: Technote 1200328

2005-08-08 Thread Debbie Bassler
pe, this is also a big winner when restoring "slow" FS's as Netware and NTFS. Regards, Maurice - Original Message - From: Debbie Bassler To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, August 03, 2005 10:19 PM Subject: Re: [ADSM-L] Technote 1200328 Oops, I meant to include that

ODBC Driver Connection

2005-08-11 Thread Debbie Bassler
I have downloaded the TSM ODBC driver. I tried using Access and extracting the table data, but that takes a long time. Does anyone else use the ODBC driver connection, and if so, how do you connect to it to easily select data from the tables? Thanks, Debbie

Resourceutilization & Backup Question

2005-08-17 Thread Debbie Bassler
Is there any benefit to having the resourceutilization parameter set to 5 when the backup is collocated? The other sessions go into media wait status, waiting on a tape that one of the other sessions is using. Does this cause contention, slowing the server down? Also, I have another question. I'm

Re: SUSPECT: (MSW) Resourceutilization & Backup Question

2005-08-17 Thread Debbie Bassler
** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Debbie Bassler Sent: Wednesday, 17 August, 2005 16:32 To: ADSM-L@VM.MARIST.EDU Subject: SUSPECT: (MSW) Resourceutilization & Backup Question Is there any benefit to having the res

Re: Resourceutilization & Backup Question

2005-08-17 Thread Debbie Bassler
on on the disks as many reads and writes could be happening on the same diskpool volumes. Those are my meandering thoughts on what may be happening. Ben -Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Debbie Bassler Sent: Wednesday, August 17, 2005

Query for Summary Table

2005-08-23 Thread Debbie Bassler
I'm trying to query the summary table, but, I don't want any information for schedules with 0 bytes. I've tried <>, !=, and ^=. None of these work. This is the error I receive: ANR2916E The SQL data types DECIMAL(18,0) and CHAR(1) are incompatible for operator '<>'.

Re: Query for Summary Table

2005-08-23 Thread Debbie Bassler
I did see the decimal field, with a (p,s) of (18,0). However, I didn't realize the quotes were not needed,,, I'll also check out the redbook that Wanda suggested Thanks to all, Debbie Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 08/23/2005 02:11 PM Please r

DB Query

2005-08-24 Thread Debbie Bassler
I'm having a problem executing a query. Here is the query I'm executing as the root user on the TSM server machine: dsmadmc -id=admin -pa= -commadelimited "select a.volume_name, a.filespace_n ame, b.access from volumeusage a, volumes b where a.volume_name=b.volume_name or der by b.access, a.vo

Log Containing Tape Drive Info

2005-08-29 Thread Debbie Bassler
Our TSM server, 5.1, is on an AIX OS, 4.3.3. Does anyone know of a log containing information about the tape drives? One of our drives has been inaccessible since 3:20 this morning. I'd like to write a script to page me when this happens, but, I don't know if there is a log available to pull the in

Re: Log Containing Tape Drive Info

2005-08-29 Thread Debbie Bassler
dvanced Deployment Professional Tivoli Storage Management Solutions 2005 IBM Certified Advanced Technical Expert (CATE) AIX Office 262.521.5627 >-Original Message- >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On >Behalf Of Debbie Bassler >Sent: Monday, August 29, 20

Re: Log Containing Tape Drive Info

2005-08-29 Thread Debbie Bassler
torage Management Solutions 2005 IBM Certified Advanced Technical Expert (CATE) AIX Office 262.521.5627 >-Original Message- >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On >Behalf Of Debbie Bassler >Sent: Monday, August 29, 2005 11:27 AM >To: ADSM-L@VM.MARI

Re: Log Containing Tape Drive Info

2005-08-29 Thread Debbie Bassler
%s' and '%s' - Search for paths offline. I think the can'd report only does drives. Alert if NPO>0 select count(*) as NPO from paths where online='NO' Bill Boyer "Some days you're the bug, some days you're the windshield" - ?? -Original

Re: Log Containing Tape Drive Info

2005-08-29 Thread Debbie Bassler
easily left to the student. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 IBM Certified Advanced Technical Expert (CATE) AIX Office 262.521.5627 >-Original Message- >From: ADSM: Dist Stor Manager [mailto: