Re: copy storage pools

2002-05-01 Thread Seay, Paul
My name got mentioned in this dual thread so I guess I should say a few things to see if I can help. I have decided to attach to Tom's response because I think his first statement is the most important issue. A PLAN! We are deep into developing a comprehensive recovery plan and progressing to

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Seay, Paul
We do not because it is too cumbersome. The answer is what were Backupsets really created for? When Tivoli Sales comes in they sell backupsets as a way to send a remote user/site (laptop users are the main ones) a place to start a recovery from so that the transmission of the entire system over

Re: TDP for R/3 setup errors

2002-05-01 Thread Hooft, Jeroen
I think you will need a symbolic link from /usr/tivoli/tsm/client/api/bin/dsm.opt to the option file that is ised by TDP. (same for dsm.sys). -Original Message- From: Eugene Awyong - Singapore [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:01 PM To: [EMAIL PROTECTED]

Re: TSM Server Console

2002-05-01 Thread TSM
Hello, no, you do not need another license for the dsmadmc. Bye Rainer Tammer On Tue, 30 Apr 2002 11:15:41 -0700, Fred Zhang wrote: Does that mean I need another license for a client in order to install dsmadmc on the server? Thanks Fred Zhang -Original Message- From: Gerald

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Joe Cascanette
I have 6 key servers that I create backupsets for (Tuesday and Thursday). Depending on your media (mine is DLT 40/80) and your DR site hardware (availability of drives to use), I would suggest the more servers you can put on a backupset the better. These sets are great to have running while

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread John Naylor
Michael, At last, something I do not entirely agree with from Paul. I would not use backupsets for everything, but they are excellent for speading up the restore of large data servers. Provided you take them regularly and I think twice weekly is overkill, then the fromdate overhead to bring in

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Rejean Larivee/Quebec/IBM
Hello Ken, I believe you are suffering from a known defect identified by IC32636. This apar describes a problem with the client having problems backing system files if the root drive is other than C:. Per your note below, it appears the boot drive is M:. This is why the client works fine if you

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Bruce Kamp
Join the club. I have been working with Tivoli for a couple of months on this (even though they don't support Citrix). They had me upgrade to 4.2.1.30. There thinking is that it has to do with the CAD starting scheduler. When I stopped using managed services it stopped hitting my TSM

Select odd behaviour

2002-05-01 Thread Warren, Matthew James
(Apologies. Re-Send with correct subject line) In addition to what I said below, the following statement generates a return code 3 from TSM; select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where access='READONLY'),(select count(*) from volumes where

Re: Logmode rollforward and incr/full dbbackups

2002-05-01 Thread Warren, Matthew James
Hello TSM'ers I am trying to run the following simple SQL query select db.pct_utilized,log.pct_utilized,(select count(*) from volumes where access='READONLY'),(select count(*) from volumes where access='UNAVAILABLE') from db,log The above works fine, but if I add 'as' into it like so;

Re: Recovering from a disaster ....

2002-05-01 Thread Zlatko Krastev
All you need to recover from a disaster is: 1. At least one copy of the database 2. At least one copy of the objects (files for B/A client and backups for TDPs) known to the database restored in step 1. Will the copy of the database ordinary full backup, a full+incrementals or DB snapshot - it

Strange Novell Backup Behavior

2002-05-01 Thread Kelli Jones
We have a Novell 4.11 client running TSM 3.7 client..TSM server running 4.1.5. The Novell server houses part of our GroupWise email system.a session starts but the server activity log reports ANR0481W Session xxx for node XXX (Netware) terminated - client did not respond within 600

Re: Backing up to WORM

2002-05-01 Thread Prather, Wanda
Don't know what your server/client mix is; but a possible solution is to keep doing your incrementals to WORM, but buy a CD burner for the server and create BACKUPSETs for the clients periodically (for the clients that support backupsets)... A storage pool for each client is a nightmare to

Re: Migration from DLT to LTO Tape Drive

2002-05-01 Thread bbullock
Um... Am I missing something here... This seems to have nothing to do with TSM... Why is it being posted here? Ben -Original Message- From: Monit Kapoor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 8:10 AM To: [EMAIL PROTECTED] Subject: Migration from DLT to

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Ken Long
Bruce, lower the duration of the startup window to reduce the amount of retries for these failed backups. Mine is set to 1 hour, so it isn't retrying all day. Bruce Kamp [EMAIL PROTECTED]To: [EMAIL PROTECTED] T

Re: Migration from DLT to LTO Tape Drive (competitive analysis curiosity)

2002-05-01 Thread Zlatko Krastev
Just of curiosity - aren't you satisfied by TSM? Why not to migrate those servers to TSM instead of Legato? Maybe you can point some points in favor of Legato against TSM. Or this is just a management decision, not technical? From time to time competitive analysis questions are popping on the

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Ken Long
I haven't looked into the 5.x clients yet, as my server is still at 4.1.4 and will be for awhile until some old clients go away. Does the 5.1 client work with a 4.1 server? Also, can I assume the fix will be applied to the 4.2 client as well? Thanks... Ken Rejean

Re: copy storage pools

2002-05-01 Thread Kauffman, Tom
Rob -- Another suggestion. Take a look at http://search.adsm.org/ and search under 'D/R' or 'recovery'; there's been a lot covered (I've babbled on about it enough :-) that may help as well. If all you've got so far is a demand from the auditors . . . that's nice, but not enough. I've been

Re: Select odd behaviour

2002-05-01 Thread Zlatko Krastev
Direct answer - it's you. Details below: 1. use double quotes in AS statement - Unavailable instead of 'Unavailable' 2. use AS outside the brackets - (select ...) AS Read-only, (select ...) AS Unavailable. Example: select db.pct_utilized,log.pct_utilized,(select count(*) as READONLY from volumes

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Seay, Paul
My situation is very different from many TSM sites. I have no tape drives in my servers so I have no way to create backupsets that can be read by the client because 3590 is not supported based on what I know. And, anyway, it would not be feasible. Sorry, I did not fully explain why they are

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Steven Bridge
I believe you are suffering from a known defect identified by IC32636. This apar describes a problem with the client having problems backing system files if the root drive is other than C:. Per your note below, it appears the boot drive is M:. This is why the client works fine if you don't

Help on Include Exclude process

2002-05-01 Thread Robert Ouzen
Hi folks I need your advice on configuring include exclude statement. Let say I have C ,D and E disk (on my C I have a lot of directories) I need to backup only from C directories F G R and subdirectories. I did ... exclude ?:\...\...\*.* include f:\...\...\*.* include g:\...\...\*.* include

Re: Migration from DLT to LTO Tape Drive

2002-05-01 Thread Zlatko Krastev
You're right. There is nothing related to TSM except we can argue and convince such people that TSM is better :-) OTOH some people are having experience with non-TSM products and maybe can help even more than competitive company's support !?! For example I am keeping Paul Seay's posts

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Michael Moore
John, To answer your questions.: Yes, MPThreading is turned on. Yes, it is getting plenty of processor. Region is set at 512M. I have sent to IBM dumps that were taken during the hung periods. What I have been told, is that there is a large number of locks being generated during that period,

Re: Help on Include Exclude process

2002-05-01 Thread Remeta, Mark
try using the domain statement in your option file. domain C: Mark -Original Message- From: Robert Ouzen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 1:29 PM To: [EMAIL PROTECTED] Subject: Help on Include Exclude process Hi folks I need your advice on configuring

TSM and Windows 2000 AD disaster recovery

2002-05-01 Thread Consiglio, Tony
Hello, Has anyone ever done a disaster recovery/restore of their Win2000 AD database? 1.) Is it supported by TSM 4.2? 2.) If not...What Backup software did you do it with? 2.) How did you do it? 3.) Was it successful? 4.) What steps did you use/take? I can not seem to find any specific

Re: Logmode rollforward and incr/full dbbackups

2002-05-01 Thread Alex Paschal
Matthew, Your as should be outside the parentheses because you want it as part of the final query, not as part of the subquery. The renaming won't carry outside the subquery if you put it inside the parentheses. Also, try using double quotes instead of single quotes. The following worked for

Re: Recovery Log almost 100%

2002-05-01 Thread Malbrough, Demetrius
Brian, For starters to prevent this from happening in the future you can define a space trigger for your recovery log to automatically extend it when it reaches a certain percentage! See the admin reference guide under DEFINE SPACETRIGGER! Regards, Demetrius Malbrough UNIX/TSM Administrator

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Adams, Matt (US - Hermitage)
Michael, We successfully perform DR on NT4.0 and W2K clients successfully without using backupsets and others on this list do as well. We use them on a couple of larger nodes once a month for snapshots of file data, but that's about it. So if you are worried about being able to do a disaster

Re: Recovery Log almost 100%

2002-05-01 Thread Fought,Tom
Brian, When this happens to us even with a Space Trigger in place it is necessary to: 1. define a new log volume with dsmfmt 2. extend the log using dsmserv 3. then restart your TSM server Once it is running you can remove and delete the log vol you added. Tom Fought Sr System Engineer/TSM

Recovery Log almost 100%

2002-05-01 Thread brian welsh
Hello, AIX 4.3.3 and server 4.1.1.0. Last night two archive-schedules had a problem. On the clients there were files in a kind of loop and TSM tried to archive them. Result, recovery log almost 100%. This was the first time our log is that high. Problem on the client solved, but now I have the

Re: Recovery Log almost 100%

2002-05-01 Thread Sung Y Lee
When log reaches 100%, just pray that TSM server process will not crash. I say the key is prevention. Whatever you can do to prevent that from happening is the best answer. There are many things you can do to prevent from growing to 100%. One that works for me is I have LogMode set to Roll

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread Othonas Xixis
Mike, backupsets... back in version 3.7... where mainly designed for server/network less restores, if these restores are part of the everyday workload/design then fine, they will do the job, if they are part of the DR scheme/design then again is fine, it all depends on yr overall design.

Re: Recovery Log almost 100%

2002-05-01 Thread Gerald Wichmann
For starters most people will define spacetriggers to automatically expand their DB and recovery log before it reaches 100% (do a help define spacetrigger on dsmadmc cmdline). What this does is let you set a threshold (say 80%) at which a process gets kicked off to create a new volume for your DB

Re: Help on Include Exclude process

2002-05-01 Thread Zlatko Krastev
you want to say Domain c: f: g: r: Aren't you? Zlatko Krastev IT Consultant Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject:Re: Help on Include Exclude process try using the

Re: AIX JFS Striping vs Multiple DB Extents

2002-05-01 Thread Zlatko Krastev
Use TSM mirroring and evaluate usage of MIRRORWRITE DB Sequential. There were several posts on this list regarding TSM self-recovery when one of the mirror copies get broken. There are few possible (rare but possible) occasions when DB mirror copy may get corrupt. AIX will write corrupt data to

Re: Strange Novell Backup Behavior

2002-05-01 Thread Zlatko Krastev
What is the value of IDLETimeout option in dsmserv.opt? If it is not defined it would default to 10 minutes (600 seconds). Try to increase it to 120-720 (2-6 hours) to prevent control session be closed by the server. You are having many files and it may take long time while TSM is skipping not

Re: Recovery Log almost 100%

2002-05-01 Thread Thomas A. La Porte
Given that this is one of the more comman FAQ style questions on this listserv, I wonder if it's not time for someone to submit a TSM requirement that the server behave better in a recovery log full situation. This happens in other databases w/o causing a SIGSEGV. Oracle, for example, simply

Re: 4.2.1.32 problem with systemobject on Citrix

2002-05-01 Thread Joel Fuhrman
I do _not_ run Citrix. However, I had the same problem on a server whose systemdisk was D:. One of the 4 start up files (boot.ini, ntldr, etc.) was missing. Installing the missing file allows the backup of the systemobjects. I think the missing file is displayed by NT's backup utility. On

TSM 4.2.1 client scheduler problems

2002-05-01 Thread Bob Booth - UIUC
We have just upgrade our AIX TSM server to 4.2.1.13. Some of our users have upgraded the clients (AIX and Solaris) to 4.2.1.X (whatever is LATEST). A strange thing is happening, for clients using the scheduler, that have a pre and post schedule command defined. When the scheduler fires off, it

backup stgpool

2002-05-01 Thread Gerald Wichmann
Given an environment where you pretty much have constant backups occurring to your TSM server 24x7 (say every 2 hours) and thus to your primary pools, how does this affect copying the data to a copypool? i.e. if my TSM server is currently accepting backups from one or more clients and that data

Re: SQL to do q auditoccupancy?

2002-05-01 Thread Alex Paschal
Auditocc = select node_name, sum(physical_mb) from occupancy group by node_name occupancy = select * from occupancy where .. = select node_ame, filespace_name, sum(physical_mb) from occupancy group by node_name, filespace_name Alex Paschal Storage Administrator Freightliner, LLC

Re: backup stgpool

2002-05-01 Thread Mire, Nona
We start all of our backups between 9PM and Midnight - we have 39 clients - our backups finish up before midnight. Our primary storage pool is a diskpool. We then do a backup of our diskpool to the copypool. (around 3AM) Then do a migration from our diskpool to the tapepool. 5AM Then a backup

SQL to do q auditoccupancy?

2002-05-01 Thread Coats, Jack
Someone have a guess as to how to do an SQL query to mostly duplicate the query auditoccupancy command or even query occupancy? ... TIA ... JC

Re: backup stgpool

2002-05-01 Thread Gerald Wichmann
It's a theoretical question.. I am purposefully avoiding going into the details of why and I'm well aware of a more typical implementation like you outlined. Even in your situation though it's possible (though unlikely) some sysadmin might do an adhoc backup at 3:15AM causing the situation I'm

Re: backup stgpool

2002-05-01 Thread David Longo
I have a similar environment, running about 18 hours a day or so. It works. Yes, you will have extra hits on disks etc. May need to do some adjusting of schedules or disks if becomes a problem. I have TSM server 4.2.1.10 on AIX 4.3.3, also have old server 3.7.4.0 on AIX 4.3.3 (separate server

Re: SQL to do q auditoccupancy?

2002-05-01 Thread Sung Y Lee
Is this what you are looking for? q auditoccup = select node_name,backup_mb,archive_mb, spacemg_mb,total_mb from auditocc q occup= select node_name,type,filespace_name,stgpool_name,num_files,physical_mb,logical_mb from occupancy Sung Y. Lee E-mail [EMAIL PROTECTED]

Re: SQL to do q auditoccupancy?

2002-05-01 Thread Coats, Jack
Yes, you and Alex came up with just what I needed. Is there somewhere the selects from the query commands are in the data base? ... Just learning SQL ... JC -Original Message- From: Sung Y Lee [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:25 PM To: [EMAIL PROTECTED]

Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread asr
= On Wed, 1 May 2002 04:20:13 -0400, Seay, Paul [EMAIL PROTECTED] said: It can be used for servers, but that was not the backupsets' original mission in life. I've got one other use for backupsets: for the big restores. We've got a ~400 GB server (mail store for central IMAP service at UF)

asr@ufl.edu: Re: Using Backupsets for Disaster Recovery

2002-05-01 Thread asr
Fumble-fingered. Here's the rest. = On Wed, 1 May 2002 04:20:13 -0400, Seay, Paul [EMAIL PROTECTED] said: It can be used for servers, but that was not the backupsets' original mission in life. I've got one other use for backupsets: for the big restores. We've got a ~400 GB server (mail

migration (diskpool) --- copypool then onsite pool (issues)

2002-05-01 Thread Pothula S Paparao
We are going to implement offsite storage management for ruby. . As I know , we are planned to backup primary storage pool to copy storage pool before migrating the data to onsite tapepool from diskpool ( BACKUP STGPOOL PRIMARYPOOL COPYPOOL) . But we have small problem , few of the db2 / domino

Re: Help on Include Exclude process

2002-05-01 Thread Robert Ouzen
I want to say that the domain will be c: d: e: ( I will change to only c:) The include statements are from subdir under C: I need to see only c: and just the subdir from the include statement Thanks Robert -Original Message- From: Zlatko Krastev [mailto:[EMAIL PROTECTED]] Sent:

Re: Recovery Log almost 100%

2002-05-01 Thread Seay, Paul
Actually, this was significantly discussed at Share and the basic requirement is TSM, take action whatever necessary to keep the server up. Start by cancelling expiration. Then nail the client that has the log pinned. There were also a number of issues discussed. Apparently, there are a lot of