Re: Determining Capacity on ADSM?

Shekhar, are the cases o.k.? I bet, it should look like select count (*) from volumes where devclass_name='STK9710' ^^^ Regards, Reinhard Shekhar Dhotre writes: tsm: TSMselect count (*) from volumes where devclass_name='stk9710'

Upgrade TSM 3730 to 4110

*SM, Is it possible to upgrade from TSM 3.7.3.0 directly to TSM 4.1.1.0. Thanks in advance Patrick. - ATTENTION: The information in this electronic mail message is private and confidential, and only intended for the

Re: Any way to see which files are associated to a certain Mgt class? ?

The ARCHIVES and BACKUPS tables have a column CLASS_NAME. So you could do "SELECT * FROM ARCHIVES WHERE CLASS_NAME='your class'" "SELECT * FROM BACKUPS WHERE CLASS_NAME='your class'" these queries may run for some time so it might be better to include a WHERE clause for NODE_NAME such as WHERE

Urgent info required for TSM,Solaris7 and Informix 64bit

Hi all We need to backup our Informix databse running on Solaris 7. However the TSM 3.7 client does not have 64bit API. So i upgraded client to TSM 4.1.1 which is 64 bit enabled, hoowever the readme.api file says that this API does not support Informix onbar backups native anymore and that

Re: Tape Mounts and Disk Pools

Hello, I usually start a Q CONTENT on the volume name of the mounted tapes. Listing the first 20 files will give you an idea of the client which have been backed up or migrated (pool full) to the tape. Regards, René Lambelet Nestec S.A. / Informatique du Centre 55, av. Nestlé CH-1800 Vevey

Checkout/Checkin Priority

I am using a 3494 ATL and ADSM 3.1.2.55. When we remove tapes from ADSM to the bulk door of the 3494 we issue 90 CHECKOUT commands to ADSM. These background commands take a little while to complete. We have the 3494 set to give priority to the convienience door vs the bulk door so that

NT Permissions and Restore

I am trying to figure out if there is any way to allow a non-administrator account to restore files from ADSM to an NT server. I am the network administrator and have previously handled this. Our Operations group is going to take this over, and I have added them to the Backup Operators group in

Re: Checkout/Checkin Priority

Richard - from what I read about that, it seems that it would have no effect on this. This has nothing to do with the "same" volume usages by two processes, but just choosing to have one process run before another. Hopefully someone from Tivoly/IBM will see and respond. -Tom [EMAIL

Re: NT Permissions and Restore

Try this: grant auth (someadmin) cl=node auth=acc node=(somenode) -Original Message- From: Mayo, Bill [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 8:22 AM To: [EMAIL PROTECTED] Subject: NT Permissions and Restore I am trying to figure out if there is any way to allow

sql agent causing user32.dll error

hi all has anybody seen this problem: NT Server 4 running MSSQL7. Before TDP was installed, user used use an MSSQL7 function called LINK SERVER. This allowed them to connect to an AS400 database. Since TDP was installed the function now gives user32.dll error 3 initialization failure

DB2 Error

Hi! Does anyone have an idea what the meaning of this error is? When doing a db2 backup for node 1 (f1s9c) on f1s11c I get the following error: SQL2025N An I/O error "2302" occurred on media "". Here is the command I'm using from f1s11c: db2wbq db2_all "-0 db2 backup database wbq use adsm

Re: Tape Mounts and Disk Pools

Gill, Is it possible that reclamation has kicked off and you specified the archive tape pool as reclamation storage pool. Just a thought. Arturo -Original Message- From: Gill, Geoffrey L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 10:02 PM

unsubscribe

Please remove my e-mail address from ADSM-Serv

Re: NT Permissions and Restore

Take a look at the Web client. It's designed for this case - to let someone at a help desk (or operations) run restores remotely. You can give your operators an ADSM admin id with the ADSM authority of "CLIENT OWNER", just for specific machines. That gives them NO ADSM server management

Re: Determining Capacity on ADSM?

Shekhar, "select count(*) from volumes ..." counts the volumes already attached to storagepools not the tapes in the tape library if you have 400 tapes in the STK - Library named 'STK-LIB' try a "select count(*) from libvolumes where LIBRARY_NAME='STK-LIB'" and yu will get Unnamed[1]

Another ADSM capacity question

How do I find out the total storage used by a node, and what are the best ways to break that down into useful information as to what is making up that total? I've got a node that appears to be taking up more space than it should, and need to find out why.

Re: Another ADSM capacity question

How do I find out the total storage used by a node Do 'Audit License', then 'Query Auditoccupancy'. Break down with 'Query Occupancy'. Richard Sims, BU

Re: Another ADSM capacity question

Issue command q license. This updates the information. Then issue q auditoccupancy to display it. -Original Message- From: Daniel Swan/TM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 11:08 AM To: [EMAIL PROTECTED] Subject: Another ADSM capacity question How do I

Re: Another ADSM capacity question

You could try, select node_name, sum(physical_mb), as DATA_IN_MB, sum(num_files) from occupancy group by node_name order by node_name Brian Johnson Merrill Lynch 212-647 3557 -Original Message- From: Richard Sims [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 12:16

Slow restore for large NT client outcome.. appeal to Tivoli Development/Support

I posted the memo below to this listserv last week when we were having trouble with the performance restoring a large NT drive. This memo is for the people who wanted to know how we made out in the end. I am also writing to bring to the attention of TSM development what I feel is a pretty big

Oracle mailing list

Where can I find a good Oracle DBA mailing list Thanks Chris

Exclude.FS(?) on NT cluster

I haven't found the answer in the archives. Server: ADSM 3.1.2.58 on AIX 4.3.2 Client: 3.1.0.8 on NT 4.0 Cluster Server Two physical cluster nodes with 3 local drives each Six shared drives hosting six virtual servers In the next few days, we are transfering all data from our NT cluster's G:

Re: Oracle mailing list

metalink.oracle.com Chris Welsh - Finance [EMAIL PROTECTED]@VM.MARIST.EDU on 09/20/2000 11:09:37 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Oracle mailing list Where can I

Inactive Versions

I am trying to list the number of inactive versions of a file if more than ten exist. Here is what I have so far: select FILESPACE_NAME,HL_NAME,LL_NAME,count(*) as Inactive_Files from backups where node_name='NODEX' and state='INACTIVE_VERSION' group by HL_NAME,LL_NAME,FILESPACE_NAME Here is

Re: Upgrade TSM 3730 to 4110

No, you must first upgrade to 4.1.0.0 (or whatever is sent to you on CD) so that you will install your license fileset. Then install 4.1.1.0 on top of that. -- Joshua S. Bassi Senior Technical Consultant Symatrix Technology, Inc. [EMAIL PROTECTED] -Original Message- From: ADSM: Dist

Re: Slow restore for large NT client outcome.. appeal to Tivoli Development/Support

Jeff, One thing to show your NT Admins is just how much overhead NTFS has. The way I've done this before is to copy a drive, either locally or over the network. If you take one of the drives with a lot of small files, can copy it, the performance will drop as the copy goes on. The more files

Re: Slow restore for large NT client outcome.. appeal to Tivoli Development/Support

Can TSM do an image backup on NT? (If it can)That will dramatically decrease the amount of time it takes to do backups/restores for file systems that have tons of small files.

TSM Image problems

I am doing testing on AIX 4.3 for TSM 3.7 and 4.1 clients. Every thing works fine with the exception of Images(logical volumes). The error I get when I try any command with "image" in it(query image, backup image) I get Unknown system error Please Check the TSM Error Log for any additional

Re: Inactive Versions

Adam, add having count(*) 10 after the group by clause. Hope this helps, -- -- Bill Colwell C. S. Draper Lab Cambridge, Ma. [EMAIL PROTECTED] -- In [EMAIL PROTECTED], on 09/20/00 at 01:25 PM, "Crump, Adam (CC-MIS Open Sys)" [EMAIL

Re: Another ADSM capacity question

Brian, my ADSM server choked on your SQL statement... it didn't like the "as". However, I did work this out on my own: select node_name, sum(capacity * (PCT_UTIL/100)) from filespaces group by node_name It works the way I want it to, but I'd like to round the result... I tried a few obvious

Re: Available Space In Library

There isn't really any way to do this since it is impossible to know, generally, how much data can fit on each tape. You can make some calculations based on tape utilization of full tapes in the library to determine average capacity of a tape and apply this to all other tapes. TSM sort of does

Server unable to contact client

Has anyone seen this error trying to backup NT client? The schedlog looks fine, it shows the next date and time for backup to start. ANR2716E Schedule prompter was not able to contact client NodeName using type 1 (165.4.121.2 1501) Thanks, [EMAIL PROTECTED]

Re: Exclude.FS(?) on NT cluster

Just fooled with this, but on the latest 3.7.2 client. The syntax there is exclude.dir c:\* Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (719) 260-5991 Email: [EMAIL PROTECTED] www.storsol.com www.storserver.com

Re: Another ADSM capacity question

On Wed, 20 Sep 2000, Daniel Swan/TM wrote: // Brian, my ADSM server choked on your SQL statement... it didn't like the // "as". However, I did work this out on my own: // // select node_name, sum(capacity * (PCT_UTIL/100)) from filespaces group by // node_name // // It works the way I want it

Re: Another ADSM capacity question

Brian, your SQL statement worked like a charm, however, I am having trouble reconciling the difference between the following outputs, which I think should be the same: adsm select total_MB from auditocc where node_name='U1_APPS' TOTAL_MB --- 7396917 ---AND--- adsm select node_name,

Re: Slow restore for large NT client outcome.. appeal to Tivoli D evelopment/Support

Just a thought - Take a look at the new TSM Implementation Redbook. They set up separate storage pools for NT, one for directory info and one for files. According to the Redbook restoring the directory structure first allows for faster restore times. I happened to be in a TSM session last

Re: Another ADSM capacity question

Daniel, My command only sums up the number of files backed up and the total MB per client. It doesnt do any percentages and so on - so just for a set of totals my command works ok and the figures are ok Regards, Brian Johnson 212 647 3557 -Original Message- From: Daniel Swan/TM

Re: Slow restore for large NT client outcome.. appeal to Tivoli Development/Support

Would other backup tools suffer the same problem then? If this is a filesystem problem I would expect so. To the original poster: how long does it take Barfserve to restore a 60 GB filesystem with 10M files? As you can tell, I'm no fan of Arcserve. Kelly J. Lipp Storage Solutions Specialists,

Re: Another ADSM capacity question

Brian, in no way did I mean to imply your statement was faulty... I guess what I was hoping for is a better understanding of the output it generates. From my limited understanding, the two commands below should generate identical #'s. Ie, Total occupancy of a client should equal the sum of all

Re: Slow restore for large NT client outcome.. appeal to Tivoli Development/Support

How so?? George

Re: Slow restore for large NT client outcome

Jeff - I more than sympathize with your predicament as a storage administrator dealing with NT systems and their administrators. But be careful about going after a vendor to fix a problem you perceive to be with their product without first establishing baseline values for your

Re: Server unable to contact client

Has anyone seen this error trying to backup NT client? The schedlog looks fine, it shows the next date and time for backup to start. ANR2716E Schedule prompter was not able to contact client NodeName using type 1 (165.4.121.2 1501) I have seen it more often with Unix clients, but I think

Re: Server unable to contact client

This will also happen if there is a firewall between the server and the client. Perhaps the port is not being passed backward or forward. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (719) 260-5991 Email: [EMAIL PROTECTED]

Unknown Exchange API error

Hi TSMers, I'm running the TDP for Exchange Version 1 Release 1 Level 1.0 (IP21909) and suddenly get the following messages. 09/14/2000 23:01:38,COMMAND LINE : C:\ADMIN\ADSM\agentexc\excdsmc /backup:dir,full /adsmoptfile:C:\ADMIN\ADSM\agentexc\dsm.opt /logfile:C:\ADMIN\ADSM\agentexc\excdsm.log

Re: Slow restore for large NT client outcome.. appeal to Tivo

Jeff, we too have a problem with small files. At first I thought it was a Netware thing because the servers we have the greatest amount of files on reside on the Netware servers. But reading emails from several users I see that I may have a future problem on the NT side. We store Word and

3570 Volumes status=empty. Why?

This has not happened in the last 1 1/2 years of our ADSM system. Some of our 3570 volumes are being reclaimed OK, except instead of being deleted out of the library, some of them go to an "empty" status. Do any of you know why this is happening?? Yet other volumes reclaim to their end and

Re: ADSM 3.1.2.50 for SUN Solaris 2.5.1

Good afternoon, May be you note that Solaris 8 is freeware for less than 8 processors. You can confirm this in Sun's Website Cordially Diego Garcma System Manager Pontificia Universidad Javeriana Bogota , Colombia Gerrit van Zyl wrote: Hi **SM'ers Is there anybody out there still using

Re: 3570 Volumes status=empty. Why?

Ken, Issue a q vo on the volume that is empty with format=detail and see if the Scratch Volume field is no. If it is no then you will have to delete the volume from the storage pool. Bill Sherrill Analyst International

Re: 3570 Volumes status=empty. Why?

Does the activity log indicate that there was some type of problem during the reclaim process. I have seen a similar problem where an error occured with our gardware and the tape was not made scratch (in our case). I realize I am running an exabyte library, and there may be several things that

Unsubscribe

Please remove my e-mail address from ADSM-Serv Tivoli Storage Manager Server Development [EMAIL PROTECTED] Tel: (520) 799-5485 -*- T/L: 321-5485

Re: ADSM 3.1.2.50 for SUN Solaris 2.5.1

You mean and not have the license police jump down their throats? Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (719) 260-5991 Email: [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM:

Re: Slow restore for large NT client outcome.. appeal to Tivoli D evelopment/Support

Jeff, I have the same concerns. My company is in the process of server consolidation. I have concerns that when the time comes to consolidate these servers into cluster servers I (TSM) will not be able to restore 1.2 TB of data to a cluster server in a timely manner. I am quickly loosing

Re: 3570 Volumes status=empty. Why?

Ken, "Some of our 3570 volumes are being reclaimed OK, except instead of being deleted out of the library, some of them go to an "empty" status. Do any of you know why this is happening?? Yet other volumes reclaim to their end and then get deleted from the library, as they should." We've seen

Re: Slow restore for large NT client outcome.. appeal to Tivoli D evelopment/Support

That may be because from what I have seen in TSM 3.7, directories are actually kept in the TSM database and not on tape. (That is just what I have seen in the field, but haven't seen documented anywhere). -- Joshua S. Bassi Senior Technical Consultant Symatrix Technology, Inc. [EMAIL PROTECTED]

Re: 3570 Volumes status=empty. Why?

If there was a write error when TSM attempted to use that volume, then TSM would update the volume to being private so that it could track the error it had on the volume (scratch volumes do not allow that). -- Joshua S. Bassi Senior Technical Consultant Symatrix Technology, Inc. [EMAIL

Re: Slow restore for large NT client outcome.. appeal to Tivoli D evelopment/Support

My NT admin's are moving toward hardware mirroring. That should be the first feature added for any highly available configuration. -- Joshua S. Bassi Senior Technical Consultant Symatrix Technology, Inc. [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager

Multiple companies using the same TSM server

Our TSM server running on a OS/390 serves multiple customers. For each customer I have a separate policy domain separate archive backup disk storage pools and when they migrate they migrate to a common 9840 cartridge storage pool. For those who are backing up more than one customer

Re: Another ADSM capacity question

Hi, Daniel, Brian. The second select statement is selecting from filespaces. If you have a 2GB client drive with 1GB of data on it, and if that counts as a filespace on your OS, then your filespaces table will show that filespace as having a 2GB capacity and 50% utilization. That's data on the

Re: Would you buy TSM again.

It would be interesting to see the answers from customers of other products. Lynn: if you get answers elsewhere about other products, post them here. Dan Kronstadt Warner Bros. "Who the hell wants to hear actors talk?" - H. M. Warner (1881-1958), founder of Warner Bros., in 1927

Re: Slow restore for large NT client outcome

I think we need the answers to Kelly Lipp's question - how fast is Arcserve really? But IF it is better, then I dont think we can get away with saying - its too many files, its NTFS that slows down TSM, etc. Those are the realities of our servers, and we need a RESTORE (notice I did not say

Re: DLT TAPE CLEANING PROBLEMS WITH ADSM

In article 000d01c02215$bfc0e000$86a97099@tn91665ws, Johan Moreels [EMAIL PROTECTED] says: Johan Moreels Hello Johan You might want to check if any others have been manually using the cleaning tape on the drives. len

SAP Backups

I was wondering if someone with experience with the SAP way of communicating with ADSM could contact me. I've got some questions and concerns I'd like to discuss. I don't know I've seen many posts about it so I'm just hoping someone has some knowledge. Thanks, Geoff Gill NT Systems Support