SQL Select statement

2004-01-21 Thread John Stephens
I have a select statement that will display part of what I want but I cant seem to make it completely work. Here is the statement and the output, select node_name as Node,count(distinct volume_name) as "Tape Pool Media",count(distinct volume_name) as "Copy Pool Media" from volumeusage where stgpoo

Re: Schedules not running

2004-01-21 Thread Graham Trigge
Roger, That would do it! Last line of the dsmserv.opt - "DISABLESHEDS YES". Thanks for the help. Regards, -- Graham Trigge IT Technical Specialist Server Support Telstra Australia Office: (02) 8272 8657 Mobile: 040

Re: Stop an AUDITDB

2004-01-21 Thread Fred Johanson
You can cancel it. If you have a problem that you need to audit, I don't think there's any more damage you can cause. At 03:51 PM 1/21/2004 -0600, you wrote: How do I stop an auditdb on windows? I can't wait for it to finish TIA Fred Johanson ITSM Administration NSIT/DCS University of Chicago 77

Stop an AUDITDB

2004-01-21 Thread Redell, Greg S.
How do I stop an auditdb on windows? I can't wait for it to finish TIA

Re: Open File Support for Windows 2003 (Was Userprofile Backup wi t h Windows2003 and TSM 5.2)

2004-01-21 Thread Prather, Wanda
Yes, that is true, at least on W2K pro and server, the profiles are not locked for inactive users and will back up OK. However, if you have any services running under accounts other than "system" (which you must do if you want the service to be able to access network resources), then they are alwa

NDMP Backups : How do I do directory level backups

2004-01-21 Thread Matthew Edwards-Winser
Hi all, I am a little new to TSM, but learning fast. Anyway I want to be able to split up the NDMP backups on the NetApp filer we have into smaller chunks. My aim is to do backups at the qtree level eg /vol/vol1/qtree1. This way I can reduce the impact on re-running a failed backup if something

Re: New drive in TSM 3583 library - set SCSI ID (NOT)

2004-01-21 Thread Terry McColgan
To the best of my knowledge the scsi id is set by the slot position. When we boot our TSM server (win2k) with 2 2940 adapters I see the following sign on: The first adapter shows the Library as scsid 6 and the first (bottom) drive as scsid 0. The second adapter shows the second drive (which is in e

Re: Open File Support for Windows 2003 (Was Userprofile Backup wi t h Windows2003 and TSM 5.2)

2004-01-21 Thread Stapleton, Mark
From: Prather, Wanda [mailto:[EMAIL PROTECTED] >THANK YOU for this information, it is very important to us. It seems Tivoli has never been interested in marketing TSM for backing up workstations (which REQUIRES the ability to recover user profiles).< Good point, Wanda. Most customers don't giv

Re: Win Client on W2003 Server CAD Error

2004-01-21 Thread Stapleton, Mark
From: Charlie Hurtubise [mailto:[EMAIL PROTECTED] Getting CAD Service start-up errors on a Win 2003 Server for Client data Backup only. Anyone else have experience here or IBM? Details... > I have installed TMS Client 5.2.2 on a new Win2003 server to backup non C: > disk data. All is fine except

Win Client on W2003 Server CAD Error

2004-01-21 Thread Charlie Hurtubise
> Hello. > Getting CAD Service start-up errors on a Win 2003 Server for Client data Backup only. Anyone else have experience here or IBM? Details... > I have installed TMS Client 5.2.2 on a new Win2003 server to backup non C: > disk data. All is fine except when I try to use the CAD daemon (servic

Re: Open File Support for Windows 2003 (Was Userprofile Backup wi t h Windows2003 and TSM 5.2)

2004-01-21 Thread Prather, Wanda
Stefan, THANK YOU for this information, it is very important to us. It seems Tivoli has never been interested in marketing TSM for backing up workstations (which REQUIRES the ability to recover user profiles). Wanda -Original Message- From: Stefan Holzwarth [mailto:[EMAIL PROTECTED] Sen

Re: Expiration of SQL BackTrack Filespaces

2004-01-21 Thread James R Owen
Rob, Like David said, etc... During SQL-BT setup, you should have created a MC for SQL-BT backups w/ Backup CopyGroup w/ VerExists=1 VerDeleted=0 RetExtra=0 RetOnly=0. SQL-BT incorporates datime values in its TSM backup filenames so that each backup filename is unique; if you setup SQL-BT to keep 1

Re: NTUSER.DAT/LOG getting failed during backup!

2004-01-21 Thread Andrew Raibeck
I can see from the dsmsched.log extracts that the backup on 1/15 ran OK, but the one on 1/16 did not. However, it is not possible to identify the problem since (a) you did not provide complete dsmsched.log info, and (b) the dsmerror.log data you provided are for the wrong dates. You need to examine

Re: help ?

2004-01-21 Thread Sam Rudland
Upgrade AIX I believe - I don't think 5.2 is supported on 4.3.3 Cheers, Sam -Original Message- From: goran [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 11:38 To: [EMAIL PROTECTED] Subject: help ? hi all, what should i do first ? upgrade AIX from 4.3.3 ml10 to 5.2 or, upgrade TSM 5

Re: Schedules not running

2004-01-21 Thread Kent Monthei
'query opt' shows 'Maximum Sessions' 'query status' shows 'Maximum Sessions' (number of sessions) and 'Maximum Scheduled Sessions' (also as number of sessions) - the latter is based on the percentage specified in 'set opt MaxSchedSessions ' "Roger Deschner" <[EMAIL PROTECTED]> Sent by: "

LAN-Free backups - minimum file size recommendation?

2004-01-21 Thread Ted Byrne
Does anyone know what the recommended minimum size for sending backups across the SAN is? I'm trying to come up with a solution to integrate the backup of DB and non-DB files on two AIX servers. Currently, the DB files are backed up after the db is shut down, using one node name, and the remainde

Re: Expiration of SQL BackTrack Filespaces

2004-01-21 Thread David Longo
It handles expiration like Oracle RMAN (in general). The expiration is done by the client, not the normal "versioning" of TSM. The SQL-BT setup and config should have info on setting up Management Class on TSM for this. I have SQL-BT version 4.2 on AIX Sybase Client. The config on SQL-BT allows

Re: Schedules not running

2004-01-21 Thread Roger Deschner
Check your dsmserv.opt file to make sure that you do NOT have DISABLESCHEDS YES Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] On Tue, 20 Jan 2004, Graham Trigge wrote: >All, > >I am running TSM 5.1.8.0 on Solaris 8. My client is a Windows 2K server >(client versio

Re: Idle Waits

2004-01-21 Thread Prather, Wanda
We see that all the time, and I don't think it's necessarily a problem... The "idle wait" you see from Q session is the state of things from the SERVERS point of view. It just means the client hasn't started another transaction yet. The client may be noodling through the filesystem looking for th

Re: Antw: Upgrade db

2004-01-21 Thread Roger Deschner
It can't hurt! If you don't need to run it, it will complete fairly quickly without doing anything. If you do need it, it will toil away and do its job. I was surprised at how much it cleaned up - my database went from 92% full to 79% full. Run it on a weekend - it is fairly compute intensive if it

Re: Idle Waits

2004-01-21 Thread Richard Sims
>What are some of the more common Idle Wait problems? We have a few >(about 5) nodes that back up into the daytime. Either they have long >idle wait times, or they have numerous short idle waits (like say 10 >seconds or so). I am told the NIC cards have been checked. Thanks for >any information

Idle Waits

2004-01-21 Thread Andy Carlson
What are some of the more common Idle Wait problems? We have a few (about 5) nodes that back up into the daytime. Either they have long idle wait times, or they have numerous short idle waits (like say 10 seconds or so). I am told the NIC cards have been checked. Thanks for any information. Oh

Expiration of SQL BackTrack Filespaces

2004-01-21 Thread Rob Hefty
Hello all, How does TSM handle the expiration of SQL Backtrack filespaces if the data was originally written directly to tape, thus never existing on hard disk? We have a situation where these filespaces are not expiring and are not even being marked as inactive yet they are in a MC that is se

Re: TDP for SQL copygroup

2004-01-21 Thread Del Hoobler
You could create a new domain or you could just create separate management classes to meet your needs and use the INCLUDE option to bind those objects to the specific management class. In general, take a look at the book where it discusses policy recommendations: Because log and set objects are

Antwort: Re: Antwort: cross platform library sharing aix w2k

2004-01-21 Thread Markus Veit
Hi, there is another thing, do not share w2k and aix uplinks from a SAN switch to a SAN gateway, because on one connection you can define only one HOSTTYPE, i.e. autosense/NT or AIX. Aix sometimes uses longer SCSI commands for HOSTTYPE autosense/NT Best Regards Markus Veit

Re: TSM 5.2 upgrade - is driver upgrade required also?

2004-01-21 Thread Charlie Hurtubise
Hi. I'm running a 3582 with two LTO2 drives with 5.2.2 server on Linux ES 2.1-27. I've seen macrocode comments before, but I'm running macrocode level 35N2 on the IBM LTO2 drives and all works great. Charlie H Tecsys Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PRO

Re: Antwort: cross platform library sharing aix w2k

2004-01-21 Thread Koen Willems
Thnx Markus, You gave me the right answer in the right time ...boy I love this list... Best Regards, Koen. From: Markus Veit <[EMAIL PROTECTED]> Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Antwort: cross platform library sharing aix w2k Date: Wed, 21 J

TSM Journal Based Backup KB Article

2004-01-21 Thread Pete Tanenhaus
An IBM Knowledge Base article addressing many common Journal Based Backup questions has recently been published and is available at the following link (search for Journal Based Backup): http://www-306.ibm.com/software/sysmgmt/products/support/ This article also contains links to unsupported Journ

Antwort: cross platform library sharing aix w2k

2004-01-21 Thread Markus Veit
Hi, yes it is, just make sure the path/devices match, i.e. /dev/rmt0 --> mt0.1.0.1 Best Regards Markus Veit An: [EMAIL PROTECTED] Kopie: Thema: c

DB2 - JFS2

2004-01-21 Thread Crawford, Lindy
Hi TSMers, This question is not really about tsm but please could some assist me... If I create my filesystems as JFS2 are there any implications to DB2 or SAP R/3 Thanks you for all your assistance. Lindy Crawford Information Technology Nedbank Corporate - Property and Asset Finance Tel

Consulting Belgium

2004-01-21 Thread Geert De Pecker
Hi, We are using (or trying to use) TSM for a couple of months now and still have quite a list of questions. I'm looking for companies or people in Belgium who would be available for some consulting/jobs on TSM. I guess 1 or 2 days would suffice for somebody who is familiar with TSM. If you know p

cross platform library sharing aix w2k

2004-01-21 Thread Koen Willems
Dear Listers, Does anybody knows if it is possible to share a library between AIX and w2k. Using the sharing functionality in TSM. THNX, Koen _ Talk with your online friends with MSN Messenger http://messenger.msn.nl/

Re: help ?

2004-01-21 Thread Richard van Denzel
Upgrade to AIX 5.2 ML2 first, because TSM 5.2.x is not supported on AIX 4.3.3. Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. _

help ?

2004-01-21 Thread goran
hi all, what should i do first ? upgrade AIX from 4.3.3 ml10 to 5.2 or, upgrade TSM 5.1.8.0 to 5.2.2.0 ? pSeries640 LTO 3584 FC conn thanks, goran

Re: TSM Journaling on a cluster

2004-01-21 Thread Barth, Terry (MBS)
Thanks David - I did see the document and have been reading over it. I just have a few more questions, if you would not mind. :) How is the utilization on your cluster for this? Also, how many objects are on your cluster total? How many changes are made? Thanks again -- Terry -Origin

Re: TSM Journaling on a cluster

2004-01-21 Thread David McClelland
Terry, Yes, we use TSM JBB's on an MSCS Win2K AS server - it's a production system, and since we've got the JBB's up and running properly (a few probs to begin with) we haven't experienced a failover to the 'B' system to see how the JBB's respond. Since 5.1 client there is a PreserveDBonexit setti

TSM Journaling on a cluster

2004-01-21 Thread Barth, Terry (MBS)
Hi - Has anyone used journaling on a cluster? If so, any information, problems, etc, would be helpful. I do know how to set it up, but just am curious about your experience with it. We have a cluster that takes 16 hours to inspect 9million files, but it only backs up maybe 30k to 50k of these.

Re: TSM Journaling

2004-01-21 Thread David McClelland
Hi Sam, A few things to look out for when running TSM journaling: O - You'll need to complete a normal incremental backup after having enabled journaling (i.e. the tsmjbbd.exe process is running all the time). Subsequent backups should then be journaled. O - In your next incremental backup, you'

TSM Journaling

2004-01-21 Thread Sam Rudland
I have enabled journaling on a client which has a lot of timeouts and overruns it's sessions due to a large number of files in the are being backed. However I could not find documentation on it and wanted to confirm it's working - am I right in thinking that once enabled the next window runs as no