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: TSM>select count (*) from volumes where devclass_name='stk9710'
>
> Un
*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 addressee.
The ARCHIVES and BACKUPS tables have a column CLASS_NAME. So you could do
"SELECT * FROM ARCHIVES WHERE CLASS_NAME=''"
"SELECT * FROM BACKUPS WHERE CLASS_NAME=''"
these queries may run for some time so it might be better to include a WHERE
clause for NODE_NAME such as WHERE NODE_NAME IN ('xxx',
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 TD
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 (S
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 individua
>Is there any way to modify the priority of CHECKIN to be higher than
>CHECKOUT in the background process queue?
Tom - I'm not aware of a means yet available in the product to allow for
selective prioritization. One thing you might try is to use the
NOPREEMPT server option and see if that
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
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 PROTECT
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 a
Yes you won the bet , but i am having 400tapes in STK,and the query shows 47?
^^^
tsm: TSM>select count(*) from volumes where devclass_name='STK9710'
Unnamed[1]
---
47
"[EMAIL PROTECTED]/P=Internet/A= /C=us" on 09/20/2000 03:33:17 AM
Please respon
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
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
Geoff,
If you do a "query session format=detail" it will show you which tapes are
mounted for which client session.
Nick Cassimatis
[EMAIL PROTECTED]
"I'm one cookie away from happy." - Snoopy (Charles Schulz)
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
Please remove my e-mail address from ADSM-Serv
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 privelege
I received an error the first time I sent this so I'm sending it again.
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 stat
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]
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.
>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
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 find
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
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 pro
Where can I find a good Oracle DBA mailing list
Thanks
Chris
Hello fellow *SM. I'm hoping someone can help me determine the amount of
available space on the tapes currently in the library.
I'm running aix4.3.3 and 3.7.0 TSM.
Also I ran out of space on one of my storage pools the other day and had to
increase the amount of tapes from 80 to 100. Is there
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: dri
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
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 the
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 St
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 y
yes. do a q stg from the command line and look under the pct util column.
larry clark
nys thruway authority
>>> [EMAIL PROTECTED] 09/20/00 12:32PM >>>
Hello fellow *SM. I'm hoping someone can help me determine the amount of
available space on the tapes currently in the library.
I'm running aix
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.
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 info
Dave,
Hmmm... We haven't seen this before.
Did you happen to install anything from the base client at
or about the same time (like maybe ODBC)?
I am not sure how this is related..
What happens when you uninstall TDP for SQL. Does it still fail?
TDP for SQL does install the following things int
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 PROTE
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 syn
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 t
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]
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
-Original
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 to
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, c
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
week,
Check that the client scheduler is running.
> -Original Message-
> From: Georgia Blair [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 12:30 PM
> To: [EMAIL PROTECTED]
> Subject: Server unable to contact client
>
> Has anyone seen this error trying to backup NT clien
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 [SMT
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,
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
f
Daniel,
Absolutely no offence taken...
Looking at the second command it seems to be trying to do something slightly
different, something clever which my command doesnt !!!
Can someone please explain !!
Many thanks,
Brian Johnson
> -Original Message-
> From: Daniel Swan/TM [SMTP:[E
We have same problems. It took 6 hrs to restore 220MB with 300,000 small
files without DIRMC, with disk DIRMC it reduce to 3 hrs. However it is
still too slow. I did test for multi-session--multi drive, it dose not
improve much. As long as we use tape, multi session will be limited. Only
thing m
How so??
George
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 configuration
> 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
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]
www.
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
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 WordPerf
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 t
From: Vanderlei Pelizer Pereira@NOTESDSV on 09/20/2000 05:38 PM
Please remove my e-mail address from ADSM-Serv
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
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
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 are
Please remove my e-mail address from ADSM-Serv
Tivoli Storage Manager Server Development
[EMAIL PROTECTED]
Tel: (520) 799-5485 -*- T/L: 321-5485
What is the reusedelay parameter set to on that pool? That's the number of
days a volume will stay empty before being deleted from a pool. For primary
pools, typically 0 is good number of days. For DR pools, perhaps longer to
allow for volume movement from on-site to off-site.
Kelly J. Lipp
St
Could someone with experience doing large restores with ArcServe or
BackupExec provide some performance numbers? I've been in shops where the
backups were taking a very long time. Longer than my TSM backup took. I
never witnessed a restore but how can it be better.
I want the facts. I'm tired
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: D
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
the
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
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]
Not today. But I have heard it is coming.
Also MS is adding a native NTFS image backup to NT 6.0 (aka Whistler).
That will definitely be nice...
--
Joshua S. Bassi
Senior Technical Consultant
Symatrix Technology, Inc.
[EMAIL PROTECTED]
-Original Message-
From: ADSM: Dist Stor Manager
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 PROTECTED
> 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 [mailto:[EMAI
I can't comment on ARCserve or BackupExec's performance numbers, but
I can comment on their robustness. In the past 3 months I have
assisted several customers off of ARCserve onto a TSM based solution.
Before that I have migrated other customers off BackupExec as well.
Once an ARCserve customers
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
f
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
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
-Ori
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
backup
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
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 E
Help!
TSM Server: TSM 3.7.2 for NT
Clients effected:Novell 4.X and 5.00 Servers using TSM 3.7.1 client
Issue:
I'm encountering major problems backup up these Novell servers with these
clients It's just 2 out of 20+ Novell servers, but they are highly
visible. What's happening is that it w
Hi there,
1 node exported from ADSM server 3.1.2.50 (MVS) - filedata=all
During import to TSM server 3.7.3(MVS) i get this error..
ANRD IMBKINS(795): Multiple active versions of the same file found during
import.
ANRD SMINV(1945): Duplicate object encountered during import or rename.
AN
Rating: 8
I have found TSM to be an excellent product.
We are running >700 Nodes, and upgrading to a SAN architecture so we can
keep growing/take advantage of the LAN free approach.
The only reasons it doesn't get a 10 are;
- It is quite complicated when you first look in. I think it's roots
in
80 matches
Mail list logo
