Can't unload the DB

2002-07-22 Thread Max Kwong
Hi all, I need to optimize the TSM db so i unload the db but it failed. I've tried to audit the db and then unload it again but it also can fix the problem. Does anyone have a idea to solve this problem. The following is the error statement of dsmserv unloaddb devclass=dltclass4 vol=adsm02.

Re: Antwort: Client error

2002-07-22 Thread Loon, E.J. van - SPLXM
Hi Markus! The latest client level is 4.2.2.0. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Markus Veit [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 15:30 To: [EMAIL PROTECTED] Subject: Antwort: Client error Hi, yes we've had that problem

Re: Server partitioning using TSM library sharing

2002-07-22 Thread Zlatko Krastev/ACIT
Scott, you hit the bullseye - the main problem would be volumes. But not only ones used by single (deleted) node. The ones used by two nodes might be bigger problem. Let say volume CBA321 hold the data for both nodeA and nodeB, who will be the owner of the libvolume? Collocation is the key - so

Re: TSM and MS Exchange (MailBox Restore and Exchange 2000 Improvements)

2002-07-22 Thread Zlatko Krastev/ACIT
Tony, could you explain a bit more. I am somewhat confused. You (instead of CA?) fought to fix Arcserve agent for 8 months??? Was it so broken? What means 95% operational, what are the rest 5%, what was the percentage before those 8 months? And what on the end is tolerable, something you still

Re: TSM DB design (was Re: TSM 5.1 Performance Tuning Guide - Where?)

2002-07-22 Thread Reinhard Mersch
Besides the more academic question, whether a B-tree plus SQL interface is a relational DB, the more interesting point for me is the fact, that this SQL interface is incomplete. It e.g. does not tell me, on which volume a specific backup copy of a file is lying. (It tells me all the volumes that

Re: Another TDP for Lotus Domino question

2002-07-22 Thread Del Hoobler
Mike, thanks for the reply. You said that when I backup the 6th time the 1st backup will go away. Can you explain how the incrementals fit in the equation? I understand that a backup copy group is using versions to retain files. What if 1 DB(file) changes daily and is daily backed up

Re: query what you've set with set command

2002-07-22 Thread Andy Raibeck
You can issue either: QUERY STATUS or SELECT * FROM STATUS To get *only* the licenseauditperiod, you can issue: SELECT LICENSEAUDITPERIOD FROM STATUS Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew

Re: General TSM Q's

2002-07-22 Thread Garrison, Tony
what kind of problem did you have with the backupset? we recovered 2 Aix 4.3.3 filespaces with backupsets this weekend. The filespaces have approx 3.5 million files and was taking about 40hrs per filespace to perform a normal restore. the problem is running node collocation, it really

Re: Server partitioning using TSM library sharing

2002-07-22 Thread Cook, Dwight E
Whew, being mighty bold but you ~might~ be able to get it to work... I'd do everything with the library NOT available to the system, this MIGHT allow you to clean out references to volumes not used on each system without causing them to roll scratch. Even if you do this you will still need to go

question about Netware 6 and Groupwise TSA/GWTSA

2002-07-22 Thread Peter Pijpelink - P.L.C.S. BV Storage Consultants
hi, Does anyone know anything about the backup and specially the recovery of Netware 6 Groupwise? Does TSM support the TSA and GWTSA modules to backup the Groupwise databases online? Downtime is not an option in this case. We also thinking about using st Bernard OFM to backup Groupwise, anyone

Re: TSM DB design (Was covered at Share in Long Beach, February 2001)

2002-07-22 Thread Peter Pijpelink - P.L.C.S. BV Storage Consultants
Maybe allready said and done, but at Oxford there was also a presentation about the internal database design. Look at the oxford symposium website. http://tsm-symposium.oucs.ox.ac.uk/ Dave Cannon explained very good how it all works with verbs and other little animals :) (no bugs!) greetings

Re: query what you've set with set command

2002-07-22 Thread Bill Dourado
Michelle query status ORquery system Bill Dourado Michelle DeVault To: [EMAIL PROTECTED] adsmigmo@YAHcc: OO.COM Subject: query what you've set with set command

Re: General TSM Q's

2002-07-22 Thread Mark Bertrand
I restored one 220kb Excel file this weekend from a backupset with approx 270,000 files from a W2K client at 4.2.2.0 with a server at W2K, TSM 4.2.2.2. with an IBM 3584. One 220kb file, it took 92 hours. Does anyone know what math formula is used to determine the amount of time that this should

LANFREE on WINDOWS

2002-07-22 Thread David Gratton
Can anyone help me out what the dsm.opt file and dsmsta.opt file should look like for the LANFREE setup in a Windows Environment? Also, is namedpipes better then TCPIP in this situation and if so how do you set this up in the options files? Thanks. David Gratton IBM Global Services

Re: AW: AIX Upgrade with TSM

2002-07-22 Thread Gill, Geoffrey L.
I would certainly say that you are increasing your chances for problems by upgrading two things at once. It is so much simpler to diagnose problems if you only upgrade one at a time - do TSM separately from AIX. Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] Believe

Re: General TSM Q's

2002-07-22 Thread Bratlie, Allen
Mark, I am unaware of any formula to figure this out, but in my experience this is very odd. In some recent testing of Windows 2000 nodes restored from TSM on MVS I was able to restore 1.9 Million files (45GB) in 18 Hours over 100 Mb Ethernet. Usually when I have seen restore times like you are

Occupancy comparison script

2002-07-22 Thread Jolliff, Dale
I know someone has already invented this wheel... I need to create a script to compare occupancy of primary sequential pools to copypools to verify a complete stgpool backup. Anyone got one handy that won't bring a server to it's knees?

TSM 4.1.2 upgrade to 5.1.1

2002-07-22 Thread Mills, John
All, I am looking at upgrading my TSM server from: Version 4, Release 1, Level 2.0 to the latest greatest at 5.1.1. I've found in-depth directions for jumping from 4.1 to 4.2 to 5.1, but I was wondering if there are any major pitfalls I should have to avoid. Thanks, John T. Mills

LanFree not working with Scheduler

2002-07-22 Thread David Gratton
This was brought up about a week ago and I didn't see if it was resolved or notI am having the same problem, my LanFree backup (TSM 5.1.0) will only work when I invoke the backup through the command line and wont work when invoked by the scheduler? Any help would be appreciated... Dave

pre and post sched on NT TSM 5.1.1

2002-07-22 Thread Lawrence Clark
We noticed after upgradeing the TSM client on NT that those servers with pre and post sched commands were not backing up. Anyone else experience this? DSM.OPT entries: preschedulecmd e:\adsmbackup\cinfoadsmprebackup.bat postschedulecmd e:\adsmbackup\cinfoadsmpostbackup.bat ERROR LOG ENTRIES:

Re: command file execution

2002-07-22 Thread Wholey, Joseph (TGA\\MLOL)
Don, I agree with all that you state below... and that is how I thought it worked as well. Here's what's really happening in my case though. I execute a command schedule to recycle Backup Exec services on NT servers (we use Backup Exec to backup 100s of Exchange servers to TSM). We have Backup

sbtio error 959 and ANS1192E symbolic link not allowed

2002-07-22 Thread chris rees
Hi all Hoping you can help me out with a problem that is really bugging me... Trying to backup an Oracle 8.0.5 database using rman. TSM client is 4.1.3, TSM server is 4.1.5. Everything is running on AIX 4.3.3 No matter what I set in /usr/tivoli/tsm/client/api/bin/dsm.sys I always get the

Re: TSM DB design (Was covered at Share in Long Beach, February 2001)

2002-07-22 Thread Doug Thorneycroft
I don't know if it is available online, but Mike Kaczmarski gave a presentation titled Everything You Always Wanted to Know about the Tivoli Storage Manager Database at Share in Long Beach February 2001. (According to the presentation, it's a B-Tree Database.) Maybe someone with access to the

Re: Dr. Watson Error in drive C:\

2002-07-22 Thread Rushforth, Tim
This sounds like it might be APAR IC33023. If you do an archive to a copy group that does not have a corresponding backup copy group and the files are opened with an exclusive lock you will fail with Dr. Watson. Bypass is to exclude those files that are open, or create a corresponding backup

Re: pre and post sched on NT TSM 5.1.1

2002-07-22 Thread Rushforth, Tim
The first error message below tells you what is happening - the pre command failed - the schedule is not executed. This is new with 5.11 - if the preschedulecmd fails, the schedule doesn't run. Tim Rushforth City of Winnipeg -Original Message- From: Lawrence Clark [mailto:[EMAIL

Need help on Report/Script

2002-07-22 Thread Vikash Gupta
Hi All, I am new to this TSM. I need to know the daily status of the my TSM backup which includes schedule name , start/end time, amount of data is being backed up against each client and may be no of file also. How do I get this type of report from query ? Please help. Vikash

How to code a select?

2002-07-22 Thread Coats, Jack
I am trying to come up with a select I could code that will give the results similar to a q libv command. Eventually I want to get it to indicate volume volume storage percent Libraryname status pool utilized This is really a combination of q vol and q

Re: Region size for TSM

2002-07-22 Thread William F. Colwell
Matt, I had a similar problem and called support; level 2 explained why region=0M is bad. TSM takes the JCL region size and getmains a small fraction of that to use for a cellpool. The object of the cellpool is to avoid doing getmains and freemains. When it sees 0M a too small default cellpool

Re: pre and post sched on NT TSM 5.1.1

2002-07-22 Thread Andy Raibeck
This is the correct behavior starting with the 5.1 client. Have you looked up message ANS1902E? It explains what you are seeing. Also, check out the client manual, chapter 7 Automating Tasks, section Return Codes from the Command Line Interface. This information applies to the scheduler as well.

Re: command file execution

2002-07-22 Thread Don France
Joe, Are you using Win2K's RSM (rather than TSM driver) for library manager? (How did you connect the BackupExec service to TSM library manager?) The output from the show session looks strange -- it indicates the last event was restore, and that it ended, but Platform ID should be WinNT; rather

Re: How to code a select?

2002-07-22 Thread Coats, Jack
I am trying to know more about what is in my library. I have a small (18 tape) library with 2 drives and it is easily overloaded, so this will help me do some day to day monitoring. -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:37 PM To:

RH Linux 7.3

2002-07-22 Thread John Bremer
*SMers, Anyone out there tried our TSM 5.1.1 Linux client on the latest RedHat release (with success)? We are getting an install error: rpmdb: Item 212 on page 1116 hashes incorrectly error: db4 error(-30979) from db-verify: DB_VERIFY_BAD: Database verification failed then DSMC fails with

Re: Tape questions

2002-07-22 Thread Mark D. Rodriguez
Rob Hefty wrote: Hello, We recently removed a damaged 3584 library tape from our primary tape pool. We were unable to complete the move data command and the data was unavailable. We removed the tape and deleted it from the database. Luckily we still have the copy pool tape. What if we need

Re: How to code a select?

2002-07-22 Thread Coats, Jack
Great... I appreciate it! ... not knowing sql well makes doing some of these kind of things a steep learning curve. ... Jack

[no subject]

2002-07-22 Thread Steve Green
I will be out of the office from 23/07/2002 until 29/07/2002. If you require assistance please contact the helpdesk on 444. Regards - Steve

Re: query what you've set with set command

2002-07-22 Thread Cook, Dwight E
HA ! I didn't remember the query system command so I gave it a run on my test environment and after a while got ** *** --- select stgpool_name,devclass_name,count(*) as VOLUMES from volumes group by stgpool_name,devclass_name

TDP R/3

2002-07-22 Thread Gill, Geoffrey L.
Should these tape pools have collocation NO? I see these 8 sessions all waiting for the same tape and I wonder if this is one of my problems with the SAP backups taking so long. Sess Number: 146,103 Comm. Method: Tcp/Ip Sess State: IdleW

Dr. Watson Error in drive C:\

2002-07-22 Thread Christian Astuni
Hi ... I have a client with TSM Client 4.2 Level 1.20 under NT 4 sp6a. And when I want to perform an archive backup of drive C:\ the backup crash with Dr. Watson error as this dsmcsvc.exe Exception: access violation (0xc005), Address: 0x0047b3b2 and in the dsmsched.log and dsierror.log there

tape mount priority

2002-07-22 Thread Gill, Geoffrey L.
Can anyone help me with what takes priority as it relates to tape drives? If all are in use for TSM's daily processes what can bump them? If all are in use for a backup session what can bump them? Is this posted anywhere? Thanks, Geoff Gill TSM Administrator NT Systems Support Engineer SAIC

Re: Tape questions

2002-07-22 Thread Don France
Yes, but You may want to ensure the copy pool version gets restored before you need it; restore volume is designed with this in mind -- refer to the admin guide or reference, as it's dependent on the database info to find the copy pool data. If you truly wiped out all references to the

Re: How to code a select?

2002-07-22 Thread Greg Garrison
Jack... Is this what you're looking for? select a.library_name, b.volume_name, b.status, b.stgpool_name, b.pct_utilized from libvolumes a, volumes b where a.volume_name = b.volume_name Greg A. Garrison Account Storage Manager IBM Global Services, Service Delivery Center - West 9022 S. Rita

Re: Tape questions

2002-07-22 Thread Seay, Paul
Did you do a DELETE VOLUME vv DISCARDDATA=YES? If so, the data is gone. You should be able to perform a RESTORE STGPOOL command, otherwise, and it will get the data from the copy pool. The correct way to recover the data on a destroyed primary volume is to issue: RESTORE VOLUME vv

Re: Server partitioning using TSM library sharing

2002-07-22 Thread Seay, Paul
If you are using 2 different NICs on the same physical server or two physically different servers you can define your machine to the 3494 twice. In this way, I would think the owner thing would be not required. Just CHECKOUT LIBVOLUME REMOVE=NO the ones from server A. Do a checkout libvolume of

Re: tape mount priority

2002-07-22 Thread Seay, Paul
This is the response we just got from Development on this question: 2) When the TSM Server is performing various processes, there is a priority for the mount point requests as to what will take precedence. The Tivoli Storage Manager for AIX Administrator 's Guide lists the preemption order that

Re: Server partitioning using TSM library sharing

2002-07-22 Thread Roger Deschner
Oooh! This gives me the heebie-jeebies! I think you really need to sit down and think about whether you want to pursue this strategy at all. It just sounds very dangerous, with a downside risk that you might not even be warned when data is destroyed. These are too many risks to take with other