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

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:

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

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

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 - Switzerland

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 reverse DNS

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

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

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

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

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

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

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 tapes

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

Re: TSM Sendmail and AIX

I use the AIX mhmail command as follows: mhmail $ADDRESS -from $FROM -subject $SUBJECT -cc $CC /tmp/from_off Of course I supply the variables $ADDRESS, $FROM, $SUBJECT and $CC but the email looks like it came from whomever I specify. The mail headers do indeed show the true account on the AIX

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.

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

Re: TSM Sendmail and AIX

I use mail -s [EMAIL PROTECTED] file name mailx can also be used. sendmail latest version has to be downloaded and sendmail.conf variable are to be set up accordingly. Balanand Pinni -Original Message- From: Tom Melton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002

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

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--

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

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 handful

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: 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:

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

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 around

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:

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

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]

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

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

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

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.

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

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

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

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

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

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

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. We

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

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

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 . . .

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-

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/