Need a select command

Hi To select guru I need one for calculate the amount of data store in my site. I run q auditocc but I need the total of each domain. T.I.A Robert Ouzen [EMAIL PROTECTED]

Re: Can you explain: Maxnump and keepmp

Keep Mount Point Select whether the node should retain the tape mount point for the entire session. Yes Specifies that the node must retain the tape mount point during the entire session

occupancy

Hi, Although I can see the backup data of the 2. node why is it seemed as not using any space? What can be the problem? I am using 4.2.1.10. Best Regards, Burak tsm: TSM01.MBT>q auditocc                                     Used (MB) Used (MB)          (MB) Used (MB)

Re: Need a select command

Robert try this. /* how much data in the pools */ select node_name,backup_mb,backup_copy_mb,archive_mb,archive_copy_mb from auditocc Robert Ouzen <[EMAIL PROTECTED] To: [EMAIL PROTECTED] IFA.AC.IL> cc: (bc

Re: How do you secure the passwd in a TSM admin command run a via batch script

Hello, it would solve a few more security problems if there were a dsmadm.rc file which would allow to specify some options for the dsmadmc command including id and password. This way dsmadmc itself would read the file with the password and it would not occur on the command line. Best regards Gerh

Re: Need a select command

Hi Mustafa Thanks Can I got too from this select the total of all. Robert -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Re: Need a select command Robert try this. /* how much data in

Re: How do you secure the passwd in a TSM admin command run a via batch script

Hello, this would not solve all security problems. If a user does a "ps -elf" command on a unix system he can see the whole command line including the password. Best regards Gerhard Gerhard Rentschler email: [EMAIL PROTECTED] Manager Central Servers & Services Regional Compu

Re: occupancy

Hi burak, Before to do a "q auditocc" you need to do an "audit licences", that is going to update to auditocc values ! Cheers. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerl

Re: TSM Sendmail and AIX

> I know this is not a TSM topic but what the hey. > We currently use AIX sendmail to mail copies of our vault list generated > from TSM to our off-site tape handler. > With the recent rash of viruses being sent by email, this company will not > accept email from a sender they can not do a "revers

Antwort: Re: How do you secure the passwd in a TSM admin command run a via batch script

I wrote a very small Rexx File on S390 to secure the password. I guess this way would work on all platforms => 1) There is a textfile, which only the specific user can read/write. Inside is the user and the password 2) There is a rexx, which first reads the user specific textfile and afterwards ca

TSM Software ftp server layout

Hello, I have problems with the layout of the ftp server ftp://service.boulder.ibm.com/storage/tivoli-storage-managent. As an example: to find the current Windows client I have to go from rom the top level to the directory maintenance/client/v4r2/Windows. To figure out whether there is a patch f

IBM 3995 Optical Library with TSM for OS/390.

Hi, We would like to use IBM 3995 Optical Library with our TSM 4.1.3 for OS/390. My question is: where can I find any documentation about using this device (or any other optical device) with this TSM for OS/390 (for example device type). Thanks in advance. Best regards, Andrási Péter [EMAI

Re: PC Magazine Enterprise Backup Article - NO MENTION OF

Kelly, Let's change "would" to "should" and you'll be dead on! Nick Cassimatis [EMAIL PROTECTED] Today is the tomorrow of yesterday. Kelly Lipp <[EMAIL PROTECTED]To: [EMAIL PROTECTED] >c

TDP for SAP

Hi all I have a problem with TDP for SAP I have set a BRBACKUPMGTCLASS xxx and a BRARCHIVEMGTCLASS yyy in my initSID.utl. When I start the save of the redo log files the first file is saved with BRARCHIVEMGTCLASS yyy (this is true) but all the others are saved with BRBACKUPMGTCLASS xxx. Why a

Re: add drives in IBM 3583 library

Kurt, You just have to license the feature once... This is becaus the license goes per library Greetz,   Koen Willems "Every brilliant plan, can be ruined by a few well placed idiots" =

Re: Can you explain: Maxnump and keepmp

If you have a node set to have 1 mount point, and the library drives are all inuse, does the data goto the storage pool, or just keeps trying to mount a tape until it does? Joe -Original Message- From: MUSTAFA BAYTAR [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:24 AM

server to server session refused

Hi, I have TSM 4.2.1.9 release. I'm working in a Tape Library Sharing enviroment, Tagsm01 is the primary manager and Tagsm02 is the library client. Today I received on tagsm01 the following error: 14/02/02 15:24:56 ANR0408I Session 3738 started for server TAGSM02-PD (Solaris 7/8 ) (Tcp/Ip) for li

Upgradeing 3494 drives

We are upgradeing the drives in our 3494 library to: -double the storage capacity of the J cartridges -convert from SCSI to fibre There seems to be a question of if we need to convert just one drive and move the data to the newly defined lib / drive or can we simply convert both drives, as long

Re: Need a select command

For total data being managed by TSM I use: select sum(physical_mb) from occupancy Or if you want to know the total MB for nodes in schedules only you can use: select sum(physical_mb) from occupancy where node_name in (select node_name from associations) Regards, Denis L. L'Huiller 973-360-773

Re: Upgrading 3494 drives

Hi, We upgraded one drive from a 3590B to 3590E and added upgrades on both to read the K tapes... you need to move all earlier tapes to read-only - move the data at your leisure if you have enough tapes - and then the tapes will read and write from all.. we had a terrible time at first understand

Anyone have bare metal restore instructions for SGI's???

Does anyone have some good bare metal restore instructions for SGI? Seems like you used to be able to boot off the install cd's and then ftp over dsmc to recover. BUT now it seems that the dsmc module requires lib's that aren't on the CD boot Any ideas? Keith

Re: Upgrading 3494 drives

Hi Jane: I'm not clear on your responce. Can both drives in a library be upgraded, then the data converted via a move data? >>> [EMAIL PROTECTED] 02/14/02 09:58AM >>> Hi, We upgraded one drive from a 3590B to 3590E and added upgrades on both to read the K tapes... you need to move all earlier ta

Re: Upgradeing 3494 drives

Lawrence, I guess you are talking about 3590 drives in a 3494 library? For that there are some good info in the README file for the server (see below). We upgraded all the drives to E drives at the same, if you only got 2 then it makes sense to do both at the same time. Just remember to put all ex

Re: TSM Sendmail and AIX

I use the AIX mhmail command as follows: mhmail $ADDRESS -from $FROM -subject $SUBJECT -cc $CC >> [EMAIL PROTECTED] 02/14/02 06:04AM >>> > I know this is not a TSM topic but what the hey. > We currently use AIX sendmail to mail copies of our vault list generated > from TSM to our off-site tape ha

Export/Import process

We had a TSM region setup for testing and we are moving servers from one TSM started task to another one. So far we've just pointed the servers to the new TSM. We'd like to export all data for each node to import into the new TSM. If we do this, would we overwrite data in the new environment, o

Re: PC Magazine Enterprise Backup Article - NO MENTION OF

Yes, but we need the big Tivoli guns saying it in the press, not us rambling about it here. Since their big guns are saying it, we have to defend why we don't one at a time. Makes it very hard to sell. And let's remember: we are all selling. If we already have TSM, we're selling to keep it. T

List of tapes in vault

Does anyone have a easy way to find out which tapes are supposed to be in the vault? I need to check every so often to make sure the operator is bringing back the tapes correctly. I'm not sure if the following is correct: select volume_name as "Tape Number" from drmedia where state='VAULT

Re: Can you explain: Maxnump and keepmp

Depends on the management class. If the data is bound to a management class that points to a disk pool, but the disk pool has a NEXTSTGPOOL pointing to tape (i.e., the disk pool migrates to tape after it fills): The data goes to the disk pool. If the disk pool is too full to hold the incoming d

Re: TSM Sendmail and AIX

I use mail -s "" [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: Re: TSM Sendmail and AIX I use the AIX mhmail command as follows: mhmail $ADDRESS -from $FROM -subject $SUBJECT -cc $CC >> [EMAIL PROTECTED] 02/14/02 06:

Re: List of tapes in vault

Yes, but check your spellingVAULTRETRIEVE, COURIERRETRIEVE ALso, it depends on who is issuing the MOVE DRMEDIA commands and when, as to whether your COURIERRETRIEVE state tapes are still at the vault, or have already left your vault and are on the way back; but you've got the right idea... -

Re: root required to kill TSM daemons?

I don't know if this is practical for everybody, but we send email about backups to our NT admins same as to the UNIX admins, using AIX sendmail. AIX sendmail can send mail to our EXCHANGE server. I'm not an AIX heavy, but I think my AIX guy just had to know the name of the Exchange server; it wi

Re: List of tapes in vault

You don't need select for this simple one. Use: q drmedia * wheresate=vaultr You can use same command with all other states to see where they are. I have our vault send me an inventory about every 2 months and I compare. You have to remember that their "snapshot" of the Vault and yours will

Re: Export/Import process

Neither. Look at the help for IMPORT NODE. If the filespaces you are importing have identical names to the ones backed up on the new server (and they probably will, since the clients haven't changed), IMPORT will create new filespace names for the imported ones. TSM will NOT merge filespace data

Re: TSM Sendmail and AIX

I feel u can have a look at inn and majordomo also !!! -Original Message- From: Tom Melton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: Re: TSM Sendmail and AIX I use the AIX mhmail command as follows: mhmail $ADDRESS -from $FROM

Re: Export/Import process

Great, Thanks a lot. I'm reading TSM doc as I respond to TSM issues. We've moved a client server from a UNIX based TSM to a TSM(4.2.1.9) started task running on OS/390 v2r9. Now backups take a LOT more time. Where do I begin to look for the why? I see extended IDLE waits. 1,162 BPX-- Idle

Re: 3584 amd SDG R03

David, Check the FILE/TTY Readch and Writech numbers while only one drive is active on the system. Our system is small enough that we get that one-drive-active condition. Thanks. Tab David Longo <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 02/13/2002 06:31:54 PM Please respond to "ADSM: Dist

Re: RESTORE VOLUMES

Hi Garry CStringArray is a class in MFC (You shlould use ODBC to connect TSM tables and a Programming language) If you DO not use C++ or something like it. You have to use some script editor (PERL...) I use Norton Dos. Little example of script. SETLOCAL PUSHD "C:\Program Files\Tivoli\TSM" Echo>C:

Re: Upgradeing 3494 drives

We just went through this upgrade with 2 drives this past weekend and all went pretty well. The only tapes that I had to set to "readonly" were those in a "filling" status. I have run the library approx 10 hrs/day since then and have not had any problems reading the old tapes. We have found a hand

Renaming Node Name

I have been backing up with this name tonis137 and they want to rename this to tonis137old and recreate another server with tonis137 any impacts? i should watch out for?

Re: Novell performance issue

On the TSM server side, run "query db format=detail" and check the "Cache Hit Pct" line. If it is under 98%, you need to increase the number of database buffers in the TSM server. Brandon Eckmann Network and Technology Services Wayne State College Wayne NE. |-+---

Re: Renaming Node Name

Naaa, will the "~old" still be around and backup ? just make sure you set its "NODE" entry in its dsm.sys file if it will be ! When you rename a node, all its data follows it, SCHEDULED TASKS TOO ! So you will have to create a new association for the ~new~ tonis137 once you register it (an

Re: Export/Import process

It's OS/390 V2R9. The LPAR has GIGABIT Ethernet, so throughput should be good. I'll check with our network folks. Thank you VERY much. -Original Message- From: Cook, Dwight E (SAIC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:05 PM To: Hunley, Ike Subject: RE: Expor

Re: List of tapes in vault

Tyree, type "help q drm" this will give you all the states that a DRM tape can have, once you know the difference btween them all you can specify what status you want to display.. I can tell you that "Mountable" are the tapes that need to go to vault... N-joy Gabriel C. Wiley ADSM/TSM Admi

Re: Renaming Node Name

yes, it will be around but no backups, just for restores thx again > -Original Message- > From: Cook, Dwight E (SAIC) [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 14, 2002 12:28 PM > To: [EMAIL PROTECTED] > Subject: Re: Renaming Node Name > > Naaa, will the "~old" still be

tape volume format

Is there a command to use that displays the format of a tape volume? We did an upgrade of our tapedrives from b1a to e1a. Tapes were marked read-only and data was moved off. If some of the tape volumes were not marked read-only or put in read/write erroneously how can you detect which they are?

Antwort: Renaming Node Name

No problems, we already did this => 1) rename node tonis137 tonis137old 2) register node tonis137 This will work Gerhard Wolkerstorfer [EMAIL PROTECTED] (Selva. Perpetua) am 14.02.2002 18:16:45 Bitte antworten an [EMAIL PROTECTED] An: [EMAIL PROTECTED] Kopie: (Blindkopie: Gerhar

Re: List of tapes in vault

David Try asking for what is not in your library. The select below will list every tape not in the library. So, this would also include tapes being transported to/from the vault. select volume_name as "Tape Number", location from drmedia where lib_name is null Rick Saylor Austin Community Colle

Re: Novell performance issue

Thanks for the tip but my cache hit percentage is in the low 99s for both my AIX and Win2K TSM servers. The issue is more likely related to the version of Novell and its components based on reading and comments from others... Here is where we are at: TSA5005.03 TSANDS5.25 SMDR 5.04

Re: Renaming Node Name

Yes, you're going to take a base backup (one time full) after you change the name... i.e. it's going to take longer than your perpetual incremental. -Original Message- From: Selva, Perpetua [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:17 PM To: [EMAIL PROTECTED] Subjec

Re: Antwort: Renaming Node Name

It's not going to take a 1 time full? -Original Message- From: Gerhard Wolkerstorfer [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:47 PM To: [EMAIL PROTECTED] Subject: Antwort: Renaming Node Name No problems, we already did this => 1) rename node tonis137 tonis137old 2

Re: tape volume format

Georgia, I don't know if this helps, here is a script I use to find volumes in private status/readwrite that are empty.. select volume_name from libvolumes where status='Private' and volume_name not in (select volume_name from volumes) and volume_name not in (select volume_name from libvolume

Re: Novell performance issue

George, Your Novell guys should bite the bullet, TSA5UP7 has been out there for at least 6 months, probably even longer, and they work just fine. George Lesho wrote: > Thanks for the tip but my cache hit percentage is in the low 99s for both > my AIX and Win2K TSM servers. The issue is more li

TSM support of STK library in SAN environment

Greetings, I have looked through the listserv archives for an answer to this question, but so far have not found an answer that quite addresses my question. I am about to install TSM 4.2.1 on an IBM pSeries box with FC attach through Brocade switches to FC 9840 tape drives and a STK 9310 Powd

Re: Antwort: Renaming Node Name

For nodes that include the servername as part of the File space - you can also rename the filespace names to match the new server name to prevent a full backup to occur. -Original Message- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:53 A

Re: Novell performance issue

George, I've been at TSA500 5.4 and SMDR 5.5 for 4 months now with no problems running with DSMC ver4 rel2 level 1.7. Brandon Eckmann Network and Technology Services Wayne State College Wayne NE. |-+> | | George Lesho | | |

Sun Solaris and Qlogic QLA2202FS (Sbus) and 3590-EIA

All, Bringing up a Sun Solaris E6000 as a TSM Server and would like to use Qlogic's QLA2202FS Sbus Fibre Channel cards to connect to 3590-E1A. IBM's website only mentions support for QLA2200F (PCI). We can get Emulex LP8000S cards but these are single port whereas the Qlogic cards are available i

Multiple Device Classes

Hello, I currently have one tape device class called 3590_CLASS. All the tapes in the 3494 belong to this devc. I'm using K tapes for this devc. I want to def another devc but I want to specify a specific volume range to use. Is this possible? I have old J tapes which I would like to use for A

Re: PC Magazine Enterprise Backup Article - NO MENTION OF

Paul! I didn't know you were one of "us" ! Ah yes - someone else who remembers the Good Ole operating system, that knew how to SEPARATE user data and customization from the OS. As a former mainframe storage manager, MICROSOFT MAKES ME CRAZY, because they STILL haven't figured that out. Unfortu

Re: Looking for sites with TSM 4.X running on HP-UX server

Robin, We've been having some very interesting conversations with HP and Tivoli about the application problems. They gone through all of our stuff and would like to compare our kernel parameters with someone else that is running 4.1 on HP 9000 L-Class server. Could we get a copy of /sta

Re: NT 4.1.2.20 Client

Thanks for the script. I ran it on a couple of node with mixed results. On my Citrix servers I found a file called svcerror.log & it is full of these messages even after I ran this: 2/14 14:40:13 dscsvc.c(1164): GetRegistryEntries(): Registry Password for node 'METAFRAME01' not set 2/14 14:50:

TSM client schedule triggered by an event?

To All: AIX 4.3.3 TSM server/client 3.7.3 We are backing up our Oracle dbs and AIX OS with TSM 3.7.3 (upgrading to 4.2 very soon!). We have been using server-prompted schedmode for the client for some 3 years now. No problems. We are investigating ways to make our backups more efficient and ou

Re: PC Magazine Enterprise Backup Article - NO MENTION OF

Today, by default TSM will backup the file on every client. You can customize the settings by excluding *most* stuff found on all these systems and only backup a single full client which would be what you would rebuild your desktops with. Also, there is an open RPQ for this functionality to be b

Labels for LTO Tapes

Hello, I was wondering if anyone has found a source for purchasing LTO tape labels in Canada, or if you had a script/program to create the labels you would not mind sharing. We have an IBM 3583 library/NT 4.0 server. Thanks Ann Mason Infrastructure and Operations Technology Support Group St. F

Upgrading client code from 4.1.2 to 4.2.1.23

I was wondering if I can upgrade an AIX client that is currently at TSM 4.1.2 directly to 4.2.1.23 by pulling the install images off of one of the FTP sites OR do I first have to get the CD-ROM that contains the base code 4.2.0, install that, then install the maintenance 4.2.1, and finally install

Re: TSM client schedule triggered by an event?

As your prescheduledcmd script: !/usr/bin/ksh while [[ -s /path/lockfile ]] ; do sleep 30 done Then just schedule the backup for a time shortly after the lockfile is created. It will wait until there is no lockfile, then start within 30 seconds of lockfile removal. Or you can add your comm

Mixing System and customization data

Y'know even IBM hasn't learnt its lesson. In AIX there's a thing called the ODM where you can put bits of customization info. It looks pretty much like the windows registry and because its in system space its hard to restore. It also is in a format that's not easy to edit. And, they keep putt

Re: tape volume format

You can use the mtlib command to query individual tape volumes, there is a field called volume type which will tell you the tape format. mtlib -l/dev/lmcp0 -qV -V# Replace # with your tape number. This is really only good for checking one or two tapes, but you could write a script to do

Re: Labels for LTO Tapes

Save yourself the grief and buy Netc http://www.netcllc.com >>> Ann Mason <[EMAIL PROTECTED]> 15/02/2002 6:44:29 >>> Hello, I was wondering if anyone has found a source for purchasing LTO tape labels in Canada, or if you had a script/program to create the labels you would not mind sharing.

disk pool size,and total number.

Hi SMers Can anybody write based what we have to decide i)diskpool size ii)number of disk pools. We need to take 500Gb data backup(full) every day and we are using Informix onbar.what size of diskpools makes better performance for 500Gb data. We are using max 4 onbar sessions at a time. we h

Re: Sun Solaris and Qlogic QLA2202FS (Sbus) and 3590-EIA

We use the QLA2200F PCI card without any problems. I cannot imagine why there would be a problem with this. I believe the same driver is used for both. The real issue is SBUS is going to be MUCH slower than the PCI card (25mhz vs 66mhz). Yes the IO slot board for PCI is about 10K and you may n

Re: disk pool size,and total number.

I would be tempted to send the Onbar data directly to tape, especially since you have plenty of drives. If you send the data to disk first, you will only be able to run one stream to tape during migration. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs, CO 80949

ANS1030E System ran out of memory

Hi !!! !!~~ I have got error message when run dsmc selective backup. before, This system have been installed HSM module, but uninstall it. TSM Server and Client installed on the same machine. # dsmc selective /handy5/sancbox/2002/1/ -subdir=yes . . . /handy5/sancbox/2002/1/9/

TSM4.1.4 ANS1030E System ran out of memory

Hi !!! !!~~ I have got error message when run dsmc selective backup. before, This system have been installed HSM module, but uninstall it. TSM Server and Client installed on the same machine. # dsmc selective /handy5/sancbox/2002/1/ -subdir=yes . . . /handy5/sancbox/2002/1/

TSM ANS1030E System ran out of memory

Hi !!! !!~~ I have got error message when run dsmc selective backup. before, This system have been installed HSM module, but uninstall it. TSM Server and Client installed on the same machine. # dsmc selective /handy5/sancbox/2002/1/ -subdir=yes . . . /handy5/sancbox/2002/1/9/433/bi12

ANS1030E System ran out of memory

Hi !!! !!~~ I have got error message when run dsmc selective backup. before, This system have been installed HSM module, but uninstall it. TSM Server and Client installed on the same machine. # dsmc selective /handy5/sancbox/2002/1/ -subdir=yes . . . /handy5/sancbox/2002/1/9/433/bi12

Cindy Bogle/Tucson/IBM on vacation-for coverage

I will be out of the office starting February 14, 2002 and will not return until February 20, 2002. 2/14 Kathy Mitton 2/15 Rob Gagliardo 2/18 Bjorn Kutz 2/19 Kathy Mitton

Clientoptset

I defined a client option set with the parameter compress=yes, force yes. Then I associate a node with this client option but when I start an backup at the node, the system tells me that the compression is forced off by the server. Why ? Mit freundlichen Grüßen Oliver Martin Hypo Informatik- G

Antw: TDP for SAP

Hi, can you send your init-file to the list? Wolfgang

Re: TSM ANS1030E System ran out of memory

Hi, You could try the client option: memoryefficientbackup yes Hope this help. -- --- Daniel GERLIC --- CCIN2P3,27 Bd du 11 Novembre,F69622 VILLEURBANNE Cedex,FRANCE mailto:[EMAIL PROTECTED]http://webcc.in2p3.fr/