select statement volume status

2002-10-14 Thread Joerg Heiken
hi all, i need a select statement, which output shows the status of the volumes like unavailable, read only and so on. thanx for help. regards joe Joerg Heiken Operator BBDO Interactive GmbH Gruenstr. 15 D-40212 Duesseldorf phone: +49-211-93 08-403 fax: +49-211-93 08-360 mailto:[EMAIL PR

Re: select statement volume status

2002-10-14 Thread Robert Ouzen
Hi Joe Here a select command: select volume_name , stgpool_name , access from volumes where access='READONLY' or access='UNAVAILABLE' Regards Robert Ouzen Computing Division Haifa University Israel -Original Message- From: Joerg Heiken [mailto:[EMAIL PROTECTED]] Sent: Monday, O

Re: select statement volume status

2002-10-14 Thread Raghu S
select volume_name,access from volumes Joerg Heiken@BBDO_ITo: [EMAIL PROTECTED] NTERACTIVE cc: Sent by: Subject: select statement volume status Joerg

Re: select statement volume status

2002-10-14 Thread Vazquez Vegas, Sergio
Hi, Joerg: Try this one: select volume_name,status from volumes Sergio Vázquez Vegas [EMAIL PROTECTED] Tlf: 91.213.46.88 -Mensaje original- De: Joerg Heiken [mailto:[EMAIL PROTECTED]] Enviado el: Monday, October 14, 2002 11:03 AM Para: [EMAIL PROTECTED] Asunto: select statemen

Antwort: select statement volume status

2002-10-14 Thread Sascha Braeuning
Hello, use the following: select volume_name,stgpool_name,pct_reclaim,status,access from volumes where access='READONLY' For access you can set: READONLY, READWRITE, UNAVAILABLE, DESTROYED MfG/regards Sascha Bräuning Sparkassen Informatik, Fellbach OrgEinheit: 6322 Wilhelm-Pfitzer Str. 1 70

Re: upgrade from TSM 4.1.3 to TSM 5.1.5

2002-10-14 Thread [EMAIL PROTECTED]
>I'm not too sure about the whole cleanup backupgroups myself. I >understand that Tivoli has re-done the way the database handles >Windows SYSTEM OBJECTS. So if you don't delete them, then the CLEANUP >BACKUPGROUPS, as I understand, cleans that up for you Is this change in system object storage s

Re: NT cilent error message

2002-10-14 Thread Halvorsen Geirr Gulbrand
Hi Mario I had the same problem. Solved it using a newer client (5.1.1.5 patch available from tivoli ftp). In my case the problem occured when the backup reached a system file (as file backup - i.e. not "systemObject"). (can't remember what file...sorry). It happened both from the GUI and the CLI.

Re: upgrade from TSM 4.1.3 to TSM 5.1.5

2002-10-14 Thread Daniel Sparrman
Hi The cleanup backupgroups is intended for one reason only, to fix a bug in prior versions. In version 4.2.2.X, there was a bug that had the effect that system objects wasn't expired. What happens is that when you upgrade from version 4.2.2.X to version 5.1, the installation will be unable to

Re: NT cilent error message

2002-10-14 Thread Mario Behring
2 GB RAM Mario --- Edgardo Moso <[EMAIL PROTECTED]> wrote: > How many mb memory do you have? > > > > > From: Mario Behring <[EMAIL PROTECTED]> on 10/13/2002 01:49 PM > > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > cc: > Subject: Re: NT cilent er

Re: Memory error during backup

2002-10-14 Thread Andrew Raibeck
I didn't see any attachment. Is this the same error you reported in the "NT cilent error message" thread? If so, then please obtain more current Dr. Watson info I emailed you about yesterday, and I will see what I can see (hopefully you received my instructions for configuring Dr. Watson). Regard

Backup error on MS Cluster

2002-10-14 Thread Bruce Kamp
Environment: TSM server: 4.1.4.5 on AIX 4.3.3 ML8 Client: Windows 2000 Server SP2 Cluster TSM client 5.1.1.5 Options file is set for DOMAIN C: SYSTEMOBJECT When I try to backup the C: drive on the cluster nodes I get the following error in the dsmerror.log: 10/13/2002 23:54:59 fioScanDirEntry():

Re: cleanup... (was: upgrade from TSM 4.1.3 to TSM 5.1.5)

2002-10-14 Thread Hans Hedlund
Just to add to the total confusion, you can (will?) experience the same (similar?) problem in a 4.2.2.x server which I don't see properly clearified on ADSM-L. Everyone's talking about this appearing when trying to upgrade to 5.1.x, but I have the problem in a plain 4.2.2 environment too: SYSTEM O

a new atl (for xmas ...)

2002-10-14 Thread Thierry ITTY
Hello all we run tsm since years, currently a 4.2 server on a 2way F50 and 100GB disk pool we have an automated tape library, something custom (a GRAU/ABBA-J with ibm 3590e drives and ca 1000 cartridges), we backup/archieve ca 80 GB every day from our servers and workstations over our lan we eva

Re: upgrade from TSM 4.1.3 to TSM 5.1.5

2002-10-14 Thread Steve Roder
> > The cleanup backupgroups is intended for one reason only, to fix a bug in > prior versions. In version 4.2.2.X, there was a bug that had the effect > that system objects wasn't expired. What happens is that when you upgrade > from version 4.2.2.X to version 5.1, the installation will be unable

Re: cleanup... (was: upgrade from TSM 4.1.3 to TSM 5.1.5)

2002-10-14 Thread Daniel Sparrman
Sorry Hans if I was unclear, but for you that haven't upgraded to version 4.2, this problem doesn't exist. The system object bug was first introduced with version 4.2.2.0. For thoose of you using a lower version, my suggestion is to not upgrade to version 4.2.2, as you will also get this bug.

Re: Script problems

2002-10-14 Thread bbullock
Thanks for all the replies. It looks like the '-outfile' option is the one that will work Thanks, Ben -Original Message- From: Frost, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 4:43 AM To: [EMAIL PROTECTED] Subject: Re: Script problems try adding the

Andre Schwier ist außer Haus / is out of the office from / von 14.10.2002 until / bis 16.10..2002

2002-10-14 Thread Andre Schwier
Ich werde ab 14.10.2002 nicht im Büro sein. Ich kehre zurück am 16.10.2002. In dringenden Fällen erreichen Sie mich unter der Nummer 0172-6619088. Mit freundlichem Gruß Andre Schwier Information Technology

Re: cleanup backupgroups

2002-10-14 Thread Matt Simpson
I'm a newcomer to this list, and a newcomer to TSM. So there's a very good chance that I'm totally confused. I'm catching the tail end of this cleanup backupgroups discussion, and I need some clarification. I think I'm reading that there's a problem in 4.2.2.x versions of TSM which causes SYSTEM

ANR2032E update stgpool command failed

2002-10-14 Thread Michelle DeVault
My update storage pool administrative command schedule failed on Saturday with the following. Any reasons why it failed? The Messages manual was a little vague. It ran ok on Sunday. 10/12/02 03:30:09 ANR2750I Starting scheduled command MIGRATE

Re: ANR2032E update stgpool command failed

2002-10-14 Thread Vazquez Vegas, Sergio
I'm not completely sure, but I think it's caused by a lock. When you are accessing a table with a select statement or any other action affecting one table, you can't perform an action that modifies that same table. Sergio Vázquez Vegas [EMAIL PROTECTED] Tlf: 91.213.46.88 -Mensaje original

TSM BAClient 4.2.1.15 / Win2000 - Installation Error

2002-10-14 Thread David Rigaudiere
Hello all, i get an error at installation starting for TSM BAClient 4.2.1.15, a message box: Title: InstallShield DLL Custom Action Message: Failed to extract file 'Dll_.ini' from the binary table. Buttons: [OK] and the installation stopped. any idea ? -- David Rigaudiere -+- Administratio

Re: TSM BAClient 4.2.1.15 / Win2000 - Installation Error

2002-10-14 Thread David Rigaudiere
argh, it is ok, %TEMP% env variable was on D:\TEMP, which does not exists on this server... sorry -- David Rigaudiere -+- Administration TSM + NT 34, Av. de Friedland -+- 3e étage -+- Bureau 317 [EMAIL PROTECTED] -+- 01.5621.7802 |-+---> | |

Re: cleanup backupgroups

2002-10-14 Thread Zlatko Krastev/ACIT
Matt, you got it right - there is a problem with SystemObject expiration introduced in v4.2.2 and you have to run CLEANUP BACKUPGROUP to prevent enourmous high space usage in DB and storage pool. This applies if you have many W2k nodes backing up to TSM. It would last until you upgrade to a versi

Pinned log

2002-10-14 Thread David E Ehresman
What is the show command to see who has the log pinned? Is it in AIX server 5.1.1.6 level? David

How to determine the number of processors on each platform type

2002-10-14 Thread Kelly J. Lipp
Folks, How, on each supported client platform, does one determine the number of processors? For instance, in Windows 2000 you can use winmsd to find this. If you know how to do this on the various platforms, please respond to me privately and I will consolidate the responses and post them under

Re: cleanup... (was: upgrade from TSM 4.1.3 to TSM 5.1.5)

2002-10-14 Thread Steve Roder
> Sorry Hans if I was unclear, but for you that haven't upgraded to version > 4.2, this problem doesn't exist. > > The system object bug was first introduced with version 4.2.2.0. For > thoose of you using a lower version, my suggestion is to not upgrade to > version 4.2.2, as you will also ge

Re: How to determine the number of processors on each platform ty pe

2002-10-14 Thread PINNI, BALANAND (SBCSI)
Kelly, On most of Unix its sar -P ALL 1 10 Balanand Pinni SBC Services Inc. Work:314-206-5911 Pager:1-800-451-6897 Email ID :[EMAIL PROTECTED] [EMAIL PROTECTED] e.mail pager -Original Message- From: Kelly J. Lipp [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 1:33 PM To:

Re: cleanup backupgroups

2002-10-14 Thread Steve Roder
> Matt, > > you got it right - there is a problem with SystemObject expiration > introduced in v4.2.2 and you have to run CLEANUP BACKUPGROUP to prevent > enourmous high space usage in DB and storage pool. This applies if you > have many W2k nodes backing up to TSM. It would last until you upgrade

cleanup backupgroup

2002-10-14 Thread Steve Roder
> you got it right - there is a problem with SystemObject expiration > introduced in v4.2.2 and you have to run CLEANUP BACKUPGROUP to prevent > enourmous high space usage in DB and storage pool. This applies if you > have many W2k nodes backing up to TSM. It would last until you upgrade to > a ve

Re: cleanup backupgroups

2002-10-14 Thread Joseph Dawes
does that expiration problem with System objects exist on 4.2.1.9? 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

Can't wait for TSM for OS390 4.2.3..........

2002-10-14 Thread Zoltan Forray/AC/VCU
We just jumped for z/OS 1.2 from OS/390 and am starting to have lots of problems with my TSM on OS390 4.1.4. I was hoping to wait for the 4.2.3 update but with the problems I am having, I don't seem to have a choice but to upgrade, ASAP ! Especially since 4.1.x is no longer supported. I have be

cleanup... (was: upgrade from TSM 4.1.3 to TSM 5.1.5)

2002-10-14 Thread Steve Roder
> Sorry Hans if I was unclear, but for you that haven't upgraded to version > 4.2, this problem doesn't exist. > > The system object bug was first introduced with version 4.2.2.0. For > thoose of you using a lower version, my suggestion is to not upgrade to > version 4.2.2, as you will also get th

Different display of output from query

2002-10-14 Thread brian welsh
Hello, AIX 5.1, TSM-server 4.2.2.8 When I execute command 'select * from auditocc' (without quotes) from command-line in Administrator Web-Interface it gives following output: NODE_NAME: CLIENT BACKUP_MB: 1000 BACKUP_COPY_MB: 0 ARCHIVE_MB: 0 ARCHIVE_COPY_MB: 0 SPACEMG_MB: 0 SPACEMG_COPY_MB: 0 TO

Re: Can't wait for TSM for OS390 4.2.3..........

2002-10-14 Thread MC Matt Cooper (2838)
How come you are not going to 5.1.x. I am running 5.1.1.4. It hasn't introduced anything horrible and new. I still see my CPU usage go up (2.5x) and I/O rate go down (to half) while migrations runs. But I saw that happening on 4.1.5 also. Be careful NOT to go to 5.1.0. That was bad.

Re: Can't wait for TSM for OS390 4.2.3..........

2002-10-14 Thread Zoltan Forray/AC/VCU
$ "MC Matt Cooper (2838)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 10/14/2002 02:34 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Can't wait for TSM for OS

E-mail server at MCKINSEY.COM re-routes posts back to ADSM-L

2002-10-14 Thread Zlatko Krastev/ACIT
Hello all, one of the e-mail servers at MCKINSEY.COM resends mailings back to ADSM-L list. That why we are getting (or at least me) nearly all posts to the list twice. I've already dropped a note to but with no answer till now. Hopefully it would be resolved soon. Zlatko Krastev IT Consultant

Re: cleanup backupgroup

2002-10-14 Thread Zlatko Krastev/ACIT
OK, I was proven wrong or unclear. In fact the bug was introduced somewhere in v4.2.2.x and the solution for it (cleanup backupgroup) in v4.2.2.y + v5.1.1.z. For sure bug and fix for it were not in same patch ,-) But even in V4.2.2.0 there were numerous reports to this list for some expiration pro

Re: E-mail server at MCKINSEY.COM re-routes posts back to ADSM-L

2002-10-14 Thread David Longo
I am seeing duplicates of just about everything today too. David Longo >>> [EMAIL PROTECTED] 10/14/02 03:01PM >>> Hello all, one of the e-mail servers at MCKINSEY.COM resends mailings back to ADSM-L list. That why we are getting (or at least me) nearly all posts to the list twice. I've already

Re: Different display of output from query

2002-10-14 Thread Suad Musovich
It's probably adjusting to the narrow frame width of the browser. Redirect to a file (" > filename") and look at the output. Not sure if you can do this with a browser You can also run a commandline script and use the -commadelimited flag. Cheers, Suad -- On Tue, 2002-10-15 at 07:27, brian wel

Re: Different display of output from query

2002-10-14 Thread Andrew Raibeck
Use the -DISPLAYMODE=LIST option when invoking dsmadmc, i.e.: dsmadmc -id=myid -password=xx -displaymode=list etc See the TSM Administrators Reference, Chapter 3. section "Using Administrative Client Options" for more info. Regards, Andy Andy Raibeck IBM Software Group Tivoli Stora

Re: Macros

2002-10-14 Thread Kai Hintze
I push the problem back a level and keep the admin passwords in a reversibly encrypted file. Then I can go and look up the password for the administrator (based on unix id) running the script. - Kai. > -Original Message- > From: Roger Deschner [mailto:[EMAIL PROTECTED]] > Sent: Thursday,

Cleanup Backupgroups question

2002-10-14 Thread Anderson, Michael - HMIS
Is there any special syntax for the cleanup backupgroups question. I upgraded to 4.2.2.12 and tried to run the cleanup command and received the following error: Anrd tb.c(1167) threadid(31) invalid encoded data length Anr0104e imutil.c(8363) Error deleting r

Unable to open file CommandLine$COMClass

2002-10-14 Thread Luciano Ariceto
Hi All I am running TSM Server 4.1.0.0 under NT 4 SP6 and IE6 and the follow message is appearing on console : ANR4706W Unable to open file CommandLine$COMClassObject.class to satisfy web session... After this, the TSM Server simply down. Does anybody know what is this problem ? TIA !!! Lu

What version for NT 3.51

2002-10-14 Thread Michael Moore
We have an NT node that is still on v3.51 of NT. Does anyone know what version of client I should use on the node? Should I go all the way back to V3.7 (if I can find the CD)? Thanks!! Michael Moore VF Services Inc. 121 Smith Street Greensboro, NC 27420-1488 Voice: 336-332-4423 Fax: 336-332

Re: What version for NT 3.51

2002-10-14 Thread Zlatko Krastev/ACIT
No! v3.7 supports only Win9x/NT4/2k. You have to go further and use ADSM v3.1 client!!! ftp://service.boulder.ibm.com/storage/adsm/fixes/v3r1/win32/intel/ Zlatko Krastev IT Consultant Michael Moore <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 14.10.2002 23:48 P

Re: What version for NT 3.51

2002-10-14 Thread Joerg Pohlmann
Michael, NT 3.51 is explicitly mentioned as supported in 3.1.0.8. The client can still be downloaded from ftp://service.boulder.ibm.com/storage/adsm/fixes/v3r1/win32/intel/single/ For the TSM 3.7 client go to ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/client/v3r7/Windo

Re: Cleanup Backupgroups question

2002-10-14 Thread Seay, Paul
If the command as follows does not work, you need to call support: cleanup backupgroups Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Anderson, Michael - HMIS [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 4:08 PM To: [EMAIL PROTE

Re: Pinned log

2002-10-14 Thread Seay, Paul
show logpin I just guessed. It works on 4.2.2.12 as well. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 10:54 AM To: [EMAIL PROTECTED] Subject: Pinned log What is

show logpinned

2002-10-14 Thread Gretchen L. Thiele
>What is the show command to see who has the log pinned? Is it in AIX server >5.1.1.6 level? SHOW LOGPIN is not in v5.1.1.6. It was added back in on the newest maintenance/patch - v5.1.5.1. Gretchen Thiele Princeton University

Monthly backup

2002-10-14 Thread Yahya Ilyas
On one of TSM client I am using two management classes/ copy groups. In include_exclude file I have added new management class name in front of the file system's name and the rest of includes use default management class. Default management group has vere, verd, rete and reto parameters set to 35

Re: cleanup backupgroups

2002-10-14 Thread Seay, Paul
SYSTEM OBJECTS is a windows thing. If you do not have windows clients, you probably do not have the problem. The release you are running 4.2.2.0 is not a good release to be on. I would recommend you get to 4.2.2.12 or higher as soon as possible. I will not say go to 4.2.3.0 because it is not a

Re: a new atl (for xmas ...)

2002-10-14 Thread Seay, Paul
This is one of the best ATLs, most cost effective for sure. The 3590 drive duty cycle is one of the best in the industry. There is no other ATL that supports the 3590 drive except a huge STK silo. A step to LTO or anything else is backwards. The ATL is just a dumb tape mounter. The drives are

Re: Restoring a backupset

2002-10-14 Thread Mark Stapleton
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Ouzen > I generate a backupset of a Novell Client 5 with TSM client 4.2.1.29 and > trying to restore it on a Novell client 6 with TSM client 5.1.0.0. > I run the commands to the new server: >1. load dsmc -virtualnode=

Re: TSM 5.1.5 for Mac OS X; serious issues still remain

2002-10-14 Thread Mark Stapleton
From: Dave Schroeder [mailto:[EMAIL PROTECTED]] > I've recently taken a look at the new TSM 5.1.5 client for Mac OS/Mac > OS X. Some serious issues still remain, and I'd like to know IBM's > official position on these issues: > [snippage] > > I have called in to IBM about this countless times, and

Re: Please help me regarding my query

2002-10-14 Thread Ruksana Siddiqui
I believe it's referring to the Platform I'm not 100% sure though - you can update the node and specify the platform and see if for that node the ? disappears or not. I have done this from GUI not from the command line. -Original Message- From: Sudheer Kumar [mailto:[EMAIL PROTECTED]] Sen

V4.2.3 ODBC supported on Win98?

2002-10-14 Thread Wayne T Smith
The IP22569 ODBC driver readme states The TSM ODBC driver is supported on the following Microsoft operating systems: - Windows 98 - Windows Me - Windows NT 4.0 (SP 4 or higher) - Windows 2000 yet when I try to install it on my Win98SE system, the installer co

Re: cleanup backupgroups

2002-10-14 Thread Tab Trepagnier
The one thing I've missed in this discussion thread is whether the version 4.2.2 that introduced the bug is the server or the client version. I am still running server version 4.1.5.0 on AIX, but my newest file servers are running version 4.2.2.0 clients. Those nodes are Windows 2000 Server mach

Re: cleanup backupgroups

2002-10-14 Thread Seay, Paul
SERVER Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Tab Trepagnier [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 1:33 AM To: [EMAIL PROTECTED] Subject: Re: cleanup backupgroups The one thing I've missed in this discussion thre