Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Kilchenmann Timo
Dear all, I have looked through the adsm.org archives. The answers I got from the archives are not consistent. I would vary much appreciate an answer to the question: Does TSM use all DB volumes for I/O (like round-robin) or does it fill a volume and then goes to the next one? What about LOG

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Dan Foster
Hot Diggety! Kilchenmann Timo was rumored to have written: I would vary much appreciate an answer to the question: Does TSM use all DB volumes for I/O (like round-robin) or does it fill a volume and then goes to the next one? I do not know for sure, because I don't know of a TSM way to report

how to run a file with MACRO

2002-10-02 Thread Abdulaziz Almuammar
Hello guys, First of all, I would like to thank all the pepole who work in this group becaus the email that i get every day are like a rsource for me. I am in the proccess of implementting the DRM. I have a small issue to check in the offsite tapes after i run this command: MOVE DRMEDIA *

Re: can't extend db

2002-10-02 Thread Karel Bos
I had something what sounds the same. TSM db on raid 5 (not anymore). Extend started, server seems to hang. Went home and came back next morning. All went well. -Oorspronkelijk bericht- Van: Karla Ross [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 2 oktober 2002 1:00 Aan: [EMAIL

Re: Calculating amount of data being backed up every 24 hours.

2002-10-02 Thread Karel Bos
Or /* */ /* Query TSM to make a daily summary*/ /* */ set sqldatetimeformat i set sqldisplaymode w set sqlmathmode r commit select count(*) as Count, - case - when sum(bytes) 1073741824

AW: Calculating amount of data being backed up every 24 hours.

2002-10-02 Thread Stefan Holzwarth
All schedules that run over midnight are counted twice: So your results are not correct. Regards Stefan Holzwarth -Ursprüngliche Nachricht- Von: Karel Bos [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 2. Oktober 2002 12:52 An: [EMAIL PROTECTED] Betreff: Re: Calculating amount of data

FW: Important Update on the Tivoli Support Web Site Migration to IBM

2002-10-02 Thread Cook, Dwight E
If you use the Tivoli web site, it is changing. Here is some info. I received Monday. just passing it along, later, Dwight -Original Message- From: Customer Support WEB Registration [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 8:56 PM To: [EMAIL PROTECTED] Subject:

Re: Help! Problems restoring files of a dead AIX client on another system (adsm 3.1 2.90)

2002-10-02 Thread Cook, Dwight E
What client level was Barney ? (and what level is Fred ?) If Barney was higher than the code on Fred then yes, natrually Fred can't see anything for Barney (from Barney)... Also ADSM isn't rated for AIX 4.3.3... (have to get in the standard IBM answer there ;-) ) I would try going into the

TSM 4.2.3 clients available for download

2002-10-02 Thread Loon, E.J. van - SPLXM
Hi *SM-ers! Maybe you already noticed it, but IBM made the 4.2.3 clients available for download. Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site:

Re: Help! Problems restoring files of a dead AIX client onanother system (adsm 3.1 2.90)

2002-10-02 Thread Ramnarayan, Sean A [EDS]
Hi We currently using ADSM 3.1.20.90 on AIX 4.3.3 If I understand FRED is your ADSM server and Barney is your client. If you have authentication set on, you must use the option of set access. Once you have done this you can change the NODENAME in your dsm.sys file to Barney on the FRED server

Re: Calculating amount of data being backed up every 24 hours.

2002-10-02 Thread Karel Bos
Sure, and the table is not that accurate. Keep in mind, its for free. -Oorspronkelijk bericht- Van: Stefan Holzwarth [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 2 oktober 2002 13:09 Aan: [EMAIL PROTECTED] Onderwerp: AW: Calculating amount of data being backed up every 24 hours. All

Re: can't extend db

2002-10-02 Thread Karla Ross
Your right, it took about 40 minutes, never had it take so long. Thanks for the response. Karla Ross IBM Global Services 314-232-9964 [EMAIL PROTECTED] Karel Bos [EMAIL PROTECTED]@VM.MARIST.EDU on 10/02/2002 05:31:27 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Sent by:

Re: DB2 +INFORMIX--------TSM

2002-10-02 Thread MUSTAFA BAYTAR
Hi Muthyam , 1.For db2 backups you don't need any special configuration for sys opt files but you must define DSMI_DIR , DSMI_CONFIG and DSMI_LOG parametes in db2 environment profile.For example like this. DSMI_DIR=/usr/tivoli/tsm/client/api/bin

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Michael Moore
We are having a similar problem with our server (v4.2.2.12, on OS/390 v2.10). Here is my problem: The reclaim runs, and ends, but the tapes are not being updated as empty. If I run an audit of the tape volume, it will then go to empty, and be deleted during our next MOVEDRMEDIA command. Here

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread John Naylor
Michael, Why has your tape got a status of filling ? That would be a reason why it would not return to scratch Are all your problem tapes like that? Michael Moore [EMAIL PROTECTED] on 10/02/2002 01:34:26 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Michael Moore
Yes.. I now have approximately 200 tapes in this status, and so far the only fix is to audit each volume. IBM/Tivoli is looking into how they are getting in this state. I am waiting on some trace parms from them. Michael Moore VF Services Inc. 121 Smith Street Greensboro, NC 27420-1488

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread David Longo
Basically it uses DB and LOG volumes by filling up the first then moving to the next one. Of course as things progress, some of the first volumes can be less than 100% full, this is more so on DB Volumes. The LOG is a sequentially written device. This is most easily observered when a new

Re: Off site copy with one drive???

2002-10-02 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of GUILLAUMONT Etienne I hope you will excuse me to be so direct but I think that you last answer is stupid, Actually, I won't excuse you, and there's no need to be insulting. did you ever look at the price of a single drive

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Burton, Robert
There is a known problem opened with IBM on this... We were told to upgrade to tsm 4.2.2.4 or higher...this seemed to clean up most but not all these problems... If you q content on the tape it is empty, yet if you try to do reclamation or delete it you are informed that there is still data on

select statement for disk pools

2002-10-02 Thread Joseph Dawes
Does anyone have a select statement to draw a correlation between which cleints go to which disk pools? Joseph Dawes I/T Infrasctructure - Unix Technical Support Chubb Son, a Division of Federal Insurance Company 15 MountainView Road Warren,New Jersey 07059 Office:908.903.3890

Question about database fragmentation

2002-10-02 Thread Farren Minns
Hi All I wonder who can help me with this. Does the database become very fragmented over time? If so, is there any way of telling how much? Also, is the only fix for this to do a dump and reload of the database? If the answer to the final question is yes, how easy are dump/reloads? We recently

Re: Off site copy with one drive???

2002-10-02 Thread Christian Bagard
Hello Mark, One-drive libraries are pretty much worthless False With our add-on SOS-MB (sorry only french) we use this technology. and it works fine (SOS-MB is promoted in France by IBM/Tivoli) We guarantee a day - 1 recovery of the backup server (the worst case) and without the DRM of TSM If

Re: Off site copy with one drive???

2002-10-02 Thread GUILLAUMONT Etienne
The only small things I would need to be able to use TSM with a single drive library is to have the ability of having a next storage pool on a copy pool, I must be possible to do as it is already done on a backup storage pool. And the ability of using a disk reclaim storage pool for offsite copy

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Bill Boyer
If a tape is EMPTY, but the access is OFFSITE, TSM won't delete the tape until the access if change to READWRITE, or the MOVE DRMEDIA to bring the tape back onsite. Until then, the tape will remain EMPTY and won't go scratch. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Seay, Paul
My experience is the database volumes fill sequentially, no load balancing. This is why I recommend striping on the database to improve backup performance. But, that can be suicide if your bufferpool is not large enough to get 98.5%+ hits. So, there are tradeoffs. Keep in mind I have ESS

Re: Off site copy with one drive???

2002-10-02 Thread Karel Bos
Yes, you CAN DO off site reclaimation with one drive. The way it should be set up is in the tsm books (online version) or one of the redbooks. I set it ones up, and it work. Slowly but it work. The compagny I work for has divert libraries with 6 to 10 drives (and still growing), but some of the

Expiring Files on a Copy Storage pool

2002-10-02 Thread Gerhard Rentschler
Hi, using the new move nodedata command I moved a number of files from one sequential stgpool to another. The source stgpool is backed up to a copy storagepool, the target stgpool is not. Using q occupancy I can see that the moved files are still on the copy storagepool. Are they going to be

Re: dsmc Manual

2002-10-02 Thread Yury Us
If you install windows server on your pc it will install documentation for both client and server. It is a nice documentation with cross links and search engine. -Original Message- From: Tani [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 6:00 AM To: [EMAIL PROTECTED]

Re: Off site copy with one drive???

2002-10-02 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Karel Bos Yes, you CAN DO off site reclaimation with one drive. The way it should be set up is in the tsm books (online version) or one of the redbooks. I set it ones up, and it work. Slowly but it work. The compagny I work

Question about Microsoft Data Engine

2002-10-02 Thread Heinz, Greg
Hello all Dose anyone know how to backup a MSDE database??? Can you use TDP for SQL ??? Any help would be great. Thanks Greg Greg Heinz - Infrastructure Analyst EDS, Goodrich - Sensor Systems Account 14300 Judicial Rd. Burnsville, MN 55306 Ph: (952) 892-4636 Fax:(952) 892-4700

Re: tdpo.opt for Release 2 Version 2 for Sun solaris

2002-10-02 Thread Prabhat Ghosh
Hi, Can any body tell me where can i get a STANDARD tdpo.opt file for Release 2 Version 2 for Sun solaris. Thanks, Prabhat K Ghosh The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the

5.1.1.6 Upgrade

2002-10-02 Thread Maria Ragan
Last week we moved the TSM server from an IBM H70 running AIX 4.3.3 and TSM 4.2.2.4 to an IBM 6H1 running AIX 5.1.0.2 then upgraded to TSM 5.1.1.6. My database is about 51 gigs in size. Tivoli support told me to run cleanup backupgroup to cleanup orphaned records when I ran into problems with

Orphan backupset tape

2002-10-02 Thread Werner Kliewer
We have an NSM still running TSM 4.1.3. In it we have an LTO cartridge in the library that is marked in the libvols and volhist tables as being part of a backupset. The backupset has been deleted - actually, it expired - at some point in the past, but I cannot reclaim the cartridge for the

Re: Question about Microsoft Data Engine

2002-10-02 Thread Large, Matthew
Greg, I found this page http://www.lyris.com/lm_help/6.0/Backing_Up_MSDE.html which talks about copying two files out while the SQL server service manager is offline. Copy the ListManager.mdf and ListManager_log.ldf files to your backup location and back them up with the standard B/A client?

Re: Calculating amount of data being backed up every 24 hours.

2002-10-02 Thread Wells, William
select sum(bytes) from summary William Wells AIX Systems Administrator Atos Origin Work# +1-817-264-8560 Cell# +1-817-233-9479 Pager# +1-817-432-2062 -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 10:38 AM To: [EMAIL PROTECTED]

What stripe size to use for TSM DB, LOG

2002-10-02 Thread Kilchenmann Timo
Dear all, From a previous threat I learned, that TSM fills a DB volume an than goes to the next one. Same is true for the LOG volumes - no load balancing like on STG Volumes via client sessions. In this case (DB LOG) I plan to use AIX LVM to stripe the logical volumes over the available

Question about Microsoft Data Engine

2002-10-02 Thread Heinz, Greg
Hello all Dose anyone know how to backup a MSDE database??? Can you use TDP for SQL ??? Any help would be great. Thanks Greg

Re: Off site copy with one drive???

2002-10-02 Thread Christian Bagard
Hi, Sorry. An error in my last post ! It's not : 4 - You clear the disk storage pool and delete the same in the database but of course : 4 - You clear the copy storage pool and delete the same in the database in other words the knowledge that TSM has about the offsite tapes. Sorry again

Now that TSM on OS390 V4.1 is no longer supported...........

2002-10-02 Thread Zoltan Forray/AC/VCU
When can we expect a finalization of the 4.2.2.?? PTF's..not patches, which are up to 4.2.2.13 ! I have outstanding issues on my current, now unsupported V4.1 server (for which I have posted messages here and received absolutely no responses) and I can no longer call IBM/Tivoli about

Re: Orphan backupset tape

2002-10-02 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Werner Kliewer We have an NSM still running TSM 4.1.3. In it we have an LTO cartridge in the library that is marked in the libvols and volhist tables as being part of a backupset. The backupset has been deleted - actually,

NFS backup

2002-10-02 Thread PINNI, BALANAND (SBCSI)
All- I have a dought to be cleared .Please help! What I understand is that nfs File system can not be backed up by default and the same was seen in mails that dsm.sys or .opt need to be updated accordingly. Recently I converted AIX Server on NAS i.e NFS.I did clone the server first and

TSM on NT 4.0 w/Norton

2002-10-02 Thread Schwartz, Paul E.
I am looking for help using TSM 4.2.1.20 with Norton Anti-Virus Corporate Edition v7.6. I have recieving Event Viewer Error Messages: ID 4099 ANS4987E Error processing server name: the object is in use by another process. This in turn reports a Failed Backup. Can anyone tell me what to do

Re: Off site copy with one drive???

2002-10-02 Thread Alex Paschal
I have to agree with Mark in this case. Unless there is some critical functionality that TSM has that nothing else does, using TSM with a single drive library is kind of a square-peg/round-hole solution. There are better solutions for environments of this scale, specifically solutions that

Re: Does TSM use all DB Volumes for I/O?

2002-10-02 Thread Gianluca Mariani1
Placing TSM DB volumes over multiple physical volumes can improve performances because the DB is read-oriented, the LVM will spread the load over the various volumes. if the number of volumes is too high, though, your performance will be hit by the overhead on the Logical Volume Manager. the

Re: TSM on NT 4.0 w/Norton

2002-10-02 Thread Mertens, Chris
What does you dsmerror.log file say. It could have nothing to do with Norton and simply be unable to back up files that NT normally has a hold of. You may need to insert some exclude statements into your .opt file to remedy this issue. -Original Message- From: Schwartz, Paul E.

Re: select statement for disk pools

2002-10-02 Thread Alex Paschal
Joseph, Each client can back up files to multiple disk pools depending on which management classes/copygroups it's binding files to in the include/exclude list. So to do this, you would have to select against your backups and mgmtclass tables or your contents and volumes tables, both of which

Re: TSM on NT 4.0 w/Norton

2002-10-02 Thread Schwartz, Paul E.
The error in the dsmsched.log is as follows: ANS4987E Error processing '\\oltfs020\e$ ': the object is in use by another process Now we are not seeing this when Norton is turned off. Any ideas? -Original Message- From: Mertens, Chris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October

bad tapes

2002-10-02 Thread Alexander Lazarevich
I've got a pretty simple question: some of my tapes are automatically turning to READ ONLY state. That's cool I assume the server detects a read/write error, then sets the tape to READ ONLY. 1) is there any scenareo where a tape is still good, yet the server sets it to READ ONLY? 2) where is

Re: bad tapes

2002-10-02 Thread David Longo
1. Not that I know of. However you can do it manually with the Update Volume Command. 2. One way I do is to use the actlog: q actlog begind=-1 search=i/o This will show any I/O errors in last day. You can search on other specific message numbers of other patterns/words. David Longo [EMAIL

Re: bad tapes

2002-10-02 Thread Dan Foster
Hot Diggety! Alexander Lazarevich was rumored to have written: 1) is there any scenareo where a tape is still good, yet the server sets it to READ ONLY? Yes, there is. It can happen if you have a drive whose element ID mapping to rmt device name has gotten out of sync with each other. More

Re: bad tapes

2002-10-02 Thread Pearson, Dave
Hello, If you do a q volume nn f=d (nn=volume name) this will tell you the Number of Write Errors: and Number of Read Errors: amoung with other good information. Dave Pearson IS PRoduction Support Analyst System and Network Service Snohomish County PUD # 1 425.347.4420 Number of Write

Re: What stripe size to use for TSM DB, LOG

2002-10-02 Thread Andrew Carlson
I played with this at one time, with 6 36GB SSA disks. I found the smallest stripe size (4K) worked the best. I cut 50% of my DB backup time going from 128K to 4k stripe size. I saw little or no observable difference for my client backups, but that machine has other resource issues that may

Re: bad tapes

2002-10-02 Thread Orin Rehorst
In a manual tape drive arrangement, if TSM calls for a tape and you don't mount it within the timeout period, TSM will mark it read only. Regards, Orin Orin Rehorst Port of Houston Authority (Largest U.S. port in foreign tonnage) e-mail: [EMAIL PROTECTED] Phone: (713)670-2443 Fax:

Help setting up a MS cluster

2002-10-02 Thread Bruce Kamp
Server AIX 4.3.3 TSM 4.1.4.5 Client Win 2k SP2 TSM Client 5.1.1.5 When I try to start the scheduler service I get the following errors in the dsmerror.log 10/02/2002 14:15:56 ReadPswdFromRegistry(): getRegValue(): Win32 RC=2 . 10/02/2002 14:15:56 ReadPswdFromRegistry(): getRegValue(): Win32

Re: bad tapes

2002-10-02 Thread Nancy Reeves
Actually, ours get marked unavailable. Nancy Reeves Technical Support, Wichita State University [EMAIL PROTECTED] 316-978-3860 - Orin Rehorst wrote: In a manual tape drive arrangement, if TSM calls for a tape and you don't mount it within the timeout period, TSM will mark

Re: Help setting up a MS cluster

2002-10-02 Thread Alan Davenport
Bruce, I just went through this. You have to have two separate schedulers on the box. One for the non-clustered data and one for the clustered drives. I went through the same thing trying to figure out what was wrong with authority. There isn't anything. Once you set up two schedulers as I

expiration errors

2002-10-02 Thread Alexander Lazarevich
when the server is running some expirations, it runs as a process and i can see that process: 70 Expiration Examined 83933 objects, deleting 1024 backup objects, 0 archive objects, 0 DB backup volumes, 0 recovery plan files; 6 errors encountered. where is the log for the errors encountered so i

Re: expiration errors

2002-10-02 Thread David Longo
It's in the server's actlog. q actlog for the time expiration was running and you will most likely see the errors. Essentially any error on the server is logged in the actlog, which is stored in the DB. David Longo [EMAIL PROTECTED] 10/02/02 05:38PM when the server is running some

Re: 5.1.1.6 Upgrade (cleanup backupgroups)

2002-10-02 Thread Seay, Paul
OK, I ran cleanup backupgroups for a week and it returned 1.5M pages to my database. However, that was not continuous time. I would run it for several hours and cancel it as needed to prevent conflicts with other stuff. My experience was it literally shuts down backup stg and database backups.

Re: select statement for disk pools

2002-10-02 Thread Seay, Paul
Clients are connected to policy domains which contain management classes that have copygroups that specify a storage primary pool. There is now way to perform a select to definitively find out what you want. The BACKUPS table has the management classes of the backups for a node. But, it can be

Re: Question about database fragmentation

2002-10-02 Thread Seay, Paul
The only way to reorganize the database is an UNLOADDB, LOADFORMAT, LOADDB. Nothing else accomplishes this. If your database has had lots of filespace deletions the tree can get severly unbalanced and negatively affect performance. Paul D. Seay, Jr. Technical Specialist Naptheon Inc.

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Seay, Paul
My recommendations is for people to get to 4.2.2.12 or higher for those of us on 4.2 and get the backupgroups cleaned up before attempting a 5.1.1.6 migration. This probably includes running an auditdb before starting the ugprade as well. Paul D. Seay, Jr. Technical Specialist Naptheon Inc.

4.2.3 Server Soon.

2002-10-02 Thread Seay, Paul
4.2.3 is very near release, probably less than a week. The client was released last night. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:07 PM To: [EMAIL

Re: Expiring Files on a Copy Storage pool

2002-10-02 Thread Seay, Paul
There is no direct relationship between a copy storage pool and a primary storage pool. When you move data from one primary pool to another the copy storage pool is managed just as before, the expiration criteria of the primary objects. Remember TSM manages the objects not tapes. I recently

Re: TSM on NT 4.0 w/Norton

2002-10-02 Thread Seay, Paul
This is probably a Norton configuration issue. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Schwartz, Paul E. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: TSM on NT 4.0 w/Norton I am

Re: Space reclamation runs, but tapes don't free up

2002-10-02 Thread Johnn D. Tan
Paul: What is the exact syntax for auditdb? I've seen you mention it twice now. I'm on 4.1.3 server (migrating to 5.1.1.6 tomorrow!) and don't see this mentioned anywhere. This is part of 4.2 and later? johnn My recommendations is for people to get to 4.2.2.12 or higher for those of us on 4.2

Re: What stripe size to use for TSM DB, LOG

2002-10-02 Thread Seay, Paul
Stripe size is very hardware dependent. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Kilchenmann Timo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: What stripe size to use for TSM DB,

Re: What stripe size to use for TSM DB, LOG

2002-10-02 Thread Roger Deschner
Im my experience, it is better NOT to stripe the TSM database. Fragmentation is a way of life for the ITSM Database. This insures that I/O seek locations will be randomly spread across the entire database. If you stripe, you increase the number of heads that must move for each I/O operation. This

Re: bad tapes

2002-10-02 Thread Seay, Paul
It is in the activity log. I run the following select daily to kick out what to consider. /* This select scans the activity log for the last 23 hours and 55 minutes */ select substr(cast(date_time as char(26)),1,16) as date time, message as Message