Re: filespace reporting question

You guys are getting hung up on coverting stuff to days. Just use timestamp arithmetic and the time handling facilities of sql. select filespace_name as "Filespace", node_name as "Node", \ days(current_date)-days(backup_end) as "Last Backup", \ dayname(backup_end) as "Dayof Week" \ fro

Re: can't see drive E in tsm client.

Hi Ofer, Normally when you can not see a drive in the tsm client it is a permissions problem. Can your Win2K machine see the drive while you are signed on? Are you running a cluster environment on Win2K? There are special considerations when backing up cluster servers. Let me know of your progre

Correct SQL Format for Date Duration Selects

This is not a valid SQL statement based on my knowledge of SQL. The reason is DAYS is an INTEGER DECIMAL(15,0). Cannot use a floating to achieve what you are trying to do. The actual way to do this is: where (backup_end mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:50 AM To: [

signon problem

Hi TSMrs, Problem regarding "signon authentication" error. When we are trying to take database backup from Informix Onbar on TSM 3.7 level 2.0 getting error in dsmerror.log file like 12/12/01 19:38:06 sessOpen: Error 137 from signon authentication. 12/12/01 19:38:06 ANS1029E Communicatio

Re: can't see drive E in tsm client.

Is the drive connected via Fibre Channel or SCSI? If it either one of these then I do not believe it should exclude this partition. How about your Domain statement? Does it specifically indicate partitions or does it say all-local or is it left blank? -- Joshua S. Bassi Independent IT Consult

Re: Question Regarding TCPWindowsize on W2K

My understanding is that Win2K will still come shipped by default to only use a tcpwindow size of 64k. Although NT4 couldn't comply with RFC1323 which allowed for larger sliding windows, W2K can. To do this however you will need to "edit the registry". You then could change the setting in TSM e

Re: Question Regarding TCPWindowsize on W2K

That was the limit on NT 4.0. With W2K I usually set it to 128. -- Joshua S. Bassi Independent IT Consultant IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (408)&(831) 332-4006 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:

Re: can't see drive E in tsm client.

Nothing special required for drives mounted on ESS LUNs. Does the E: drive shows up in explorer? Do you have a domain statement that specifically only includes some drives? _ William Mansfield Senior Consultant Solution Technology, Inc Ofer

Re: act log question..

I already set the schedlogname option in client dsm.sys file.. But I really need is to check out backup file list from tsm server database... Any idea?? Any suggestion will be appreciated.. - Original Message - From: "Marc Lowers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sen

Re: Passwordaccess generate

Tom, There is a known issue with the TSM Client 4.2.X where it does not retain the password. There is an APAR about this, I did not write this down. When the password is encrypted somewhere in the encrypted file it have 00 and this cause the password to be truncated. Some time ago I've called s

Re: Rebind deleted inactive files?

As you are talking about active and inactive files you are talking about "backups". All versions of a file (active or inactive) will be bound to a single management class. If you change the managment class that file (all versions of) are being bound to, by updating an include statement, then all

Re: Laptop message

Orin, What is the message? And what version of the TSM client and what version is the TSM server and running on what platform? Sias Dealy --- Orin Rehorst <[EMAIL PROTECTED]> wrote: > The system tries to connect via VPN. > > We suppose the TSM Scheduler service is trying to > pick up schedulin

Re: Help! I need more space

Yes of course I have policies. I am not using LTO or Magstar. I am using AIT tapes. We do not keep the database backups in the library. We ship them offsite to our vault. At the most we have 2 - 3 database backups in the library depending on what day of the week it is. Mark -Original Messag

Re: Archives

-Mark- In my opinion... The ARCHRETention parameter specifies the number of days (from the date of archive) to retain copies. So, if you updated the PD on Oct. 10th with [ TSM> upd do ARCHDOMAIN backret=60 ] then it is not going to affect the files that were already archived prior to the change.

Re: Help! I need more space

I have set this to one for all of my storage pools, I really don't want to set it to zero. Miles -- Miles Purdy System Manager Farm Income Programs Directorate Winnipeg, MB, CA [EMAIL PROTECTED] ph: (2

Re: Rebind deleted inactive files?

Have you tried rebinding everything to an intermediate management class to change all the inactive ones and then setting to the new management class? -Original Message- From: Mark D Baker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 12:54 PM To: [EMAIL PROTECTED] Subject:

Re: 3590 Extended media support.

Yeah, I think that is it. -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 3:01 PM To: [EMAIL PROTECTED] Subject: 3590 Extended media support. Question: Is anyone familiar with exactly what the feature code, Feature 5781 - Extende

TSM V 4.1. restore small files - AIX platform

Question: Is there a way to speed up a restore of a file system with 1000's of small files using TSM. We have seen restores of200-500 mb file systems which have 1000's of small files taking hours to restore. Is there any options I can cha

Re: copy volumes

I think what you are asking here is can you copy your primary pool to multiple copy pools. The answer is yes. So, if you put the selected nodes in their own primary pool then you could have multiple copies of them to the same copy pool and another copy pool and the nodes you do not want multiple

Re: Question Regarding TCPWindowsize on W2K

I am using the same settings for TCPBUFFSIZE and TCPWindowSize and it works for me too. Although, this is what I see in a sniffer capture (Ethereal) during a backup (Win2k server): TSM Server --> TSM Client TCP window size is 17162 TSM Client --> TSM Server TCP window

can't see drive E in tsm client.

Hi All, I have connected a Windows2 file server to an ESS box throw fiber cable. I have a new drive in the file server e:\. I would like to backup the drive with the TSM client. but there is no drive E:\ in the backup\restore client. do I need additional software for that file server to be ab

Re: Help! I need more space

Any way you look at it there is a slot lost in the library, ultrim or magstar. Magstar now hold 120GB. -Original Message- From: Daniel Sparrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:32 AM To: [EMAIL PROTECTED] Subject: Re: Help! I need more space Don't you ha

Re: Help! I need more space

Disk is o.k. for quick restore in house, but what if your facility got wiped out? You also need to have DB copies offsite for true DR situations. David Longo >>> [EMAIL PROTECTED] 12/12/01 12:20PM >>> Hi, I think there is good idea to keep DBbackups on disks (sequential file device class), whe

ADSM TSM Migration

We currently run ADSM 3.1 on MVS and am looking to upgrading to TSM 4.2. We are trying to find a good method to migrate without having to buy another server and have another instance of ADSM/TSM on MVS. This brings me to the question: Does anyone know if we can use TSM 4.2 client code to backup

copy volumes

Is it possible to copy volumes of some selected nodes instead of all nodes on a copy storage pool? Or is there another way I can have two or more copies of volumes of selected nodes in the library. Thanks > - > Yahya Ilyas > Systems Programmer Sr > Systems Integra

Linux ext3fs support

Is there currently a way to back up these filesystems? If not, does anyone have any idea when they might be supported? On my laptop (a RedHat 7.2 testbed) I installed ext3 as the main filesystem. When I bring up the client, all I see is my C: windows drive. None of my ext3 filesystems exist, as f

Re: copy volumes

You will need to put them into their own domain and pool structure to do this effectively. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs, CO 80949 [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com or www.storserver.com (719)531-5926 Fax: (240)539-7175

Re: Laptop message

Orin, I got that same mesasge when I set up my laptop for backup. I use 'mobile ip' because I connect several different ways using my laptop. (i.e home/office/server room/car/ mom's house) When I tried connecting to the TSM server it did the same thing your's did. I set up an account in mobile

Archives

We have set up our Policy Domain for Archives to 365 days. We have been getting tapes called back from storage, but does not seem to do it Monthly, which is when we run archives..It has been 3 months since we have recieved any back. I changed our backup retention grace period on the Policy Doma

Re: filespace reporting question

I have not tried it but typically, SQL dates are in a format of -MM-DD-hh.mm.ss.nn. Have you tried Current_timestamp? The following sql command generated output like what follows: select filespace_name as "Filespace", node_name as "Node", current_timestamp-backup_end as "time since back

3590 Extended media support.

Question: Is anyone familiar with exactly what the feature code, Feature 5781 - Extended Media Support @ $1,350 ea. has for parts? The cost is rediculous and all I see is 5 plastic parts in a bag, 2 screws and a sticker. Seems awful expensive if you ask me. Is this all there is?? Am I missing

Re: WinXP incompatible with V3 Server

On 16 Nov 2001 at 20:30, Roger Deschner wrote, in part: > The only version of the TSM client that works under Windows XP is > V4.2.1.15. However, all V4.2.x.x clients are incompatible with any V3 > server. This is documented on the Tivoli web page, and I have found it > to be true in practice. The

Re: Management class for incr and full backups with TDP for Excha nge 2.2

Del, I read the readme (that sounds strange!) and it says that for incremental's tdp always uses unique file names so the parameter that governs how many copies to keep is the retonly variable. Does this mean that full backups use the same name every time and the parameter to use is the retextra?

Re: filespace reporting question

select filespace_name as "Filespace", node_name as "Node", backup_end as "backup end time" from filespaces where (day(current_timestamp-backup_end) >0 or hour(current_timestamp-backup_end) >3) -Original Message- From: Joseph Dawes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2

Re: Help! I need more space

It seems that this discussion has gone over hand. What Miles needed was some good ideas on how to solve his problems with a library that is full. If somebody has any other bright ideas, please post 'em so that he will get help, instead of discussions on how to handle db backups. What people is

Re: Question Regarding TCPWindowsize on W2K

The range goes from 1 to 2048. For windows 2000 machines use either 1500 or 0. 1500 is usually optimal, but it the system is working fine for network traffic then use 0. 0 will use the windows default setting. Joe Cascanette * Use will also see this setting when trying to increase your internet

Re: Is a mix of 3590E normal tape with long-tape possible?

might explain why all the internals (bunch anyway) were "green" when we had IBM upgrade a bunch of B1A tape drives to E1A drives just a few months back... color coded to indicate usage... -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:

Question Regarding TCPWindowsize on W2K

>From one of my WinTel gurus: - Forwarded by Steven Chaba/RG&E on 12/12/01 11:18 AM - John Wiersma To: Steven Chaba/RG&E@RG&E 12/12/01 cc: 11:01 AM Subject:

Re: Is a mix of 3590E normal tape with long-tape possible?

A regular 3590 tape when used in a 'B' drive capacity is 10GB, extended tape capacity is 2x or 20GB. A regular 3590 tape when used in a 'E' drive capacity is 20GB, extended tape capacity is 2x or 40GB. A 3590 'B' drive can read / write both tapes. A 3590 'E' drive can read / write both tapes. A 35

Re: Help! I need more space

Don't you have policies in your TSM server? Using an LTO library, this would require 12 LTO Ultrium tapes, which means 2.4TB of lost space, if your database isn't big enough. Hope you're not using LTO tapes, rather Magstar tapes. Best Regards Daniel Sparrman ---

Re: Is a mix of 3590E normal tape with long-tape possible?

It is more than a setting. The takeup reel and some other stuff has to be changed in the drive depending on the level of E1A drive it is. The original E1As did not support K tape. -Original Message- From: Jeff Bach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:33 AM T

Re: act log question..

Actually, the schedlogname only works in the TSM.OPT file for the dsmc sched process. Ah, oops, the Scheduler Service in NT. From the command line for a manual incremental, the "> c:\logname" is interpreted by the shell as "redirect standard out to c:\logname" and actually isn't passed to the ap

Rebind deleted inactive files?

I have a customer that wants a particular directory structure to be retained longer than its existing management class. I know I can rebind all the files that currently exist on the client to a new management class and retain those files for as long as I need. But is there a way to rebind the in

Re: Help! I need more space

Hi, I think there is good idea to keep DBbackups on disks (sequential file device class), when much disk space is available, and copy them to other machines in case of TSM server disaster. This will save some space in library for data and lower tape operations. I am using this way for example in

Re: Is a mix of 3590E normal tape with long-tape possible?

Our CE had to change a setting on the 3590E tape drives to allow them to write to the double length tapes. Jeff Bach Home Office Open Systems Engineering Wal-Mart Stores, Inc. WAL-MART CONFIDENTIAL -Original Message- From: Cook, Dwight E (SAIC) [SMTP:[EMAIL PROTECTED]]

Re: Help! I need more space

I don't think keeping two weeks worth of database backups is to protect against database corruption. If your database was corrupt you would know it right away. Rather it is to enable you to retrieve data that was expired that would be lost without being able to go back x number of days. Mark --

Re: Question Regarding TCPWindowsize on W2K

To my knowledge 63 is the limit. -Original Message- From: Steven Chaba [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 11:19 AM To: [EMAIL PROTECTED] Subject: Question Regarding TCPWindowsize on W2K >From one of my WinTel gurus: - Forwarded by Steven Chaba/RG&E on 12/

Re: Question Regarding TCPWindowsize on W2K

My Win2k servers have the following parameters and it works !!! TCPBUFFSIZE 512 * max allowed TXNBytelimit 10240* KB (<= 2 GB) TCPWindowSize 2048 * max W2K:2048, max NT4:63 rv Steven Chaba <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/12/2001 05:19:23 PM Please respond

Re: I: Mount request denied for volume

Try checking out the volume then check it back in. I had the same problem and this worked for me. >>> [EMAIL PROTECTED] 12/12/01 08:34AM >>> > Hi all, > I'm using TSM rel.4.2,STKL700 with four LTO drives. > Recently, cartridge 000131 stuck in drive n°4, I manually removed the > cartridge and p

Re: Mount request denied for volume

I guess u can audit ur library(audit library ) and db(it may take long long time sometimes). -Original Message- From: diciommo.fabio.eds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:35 AM To: [EMAIL PROTECTED] Subject: I: Mount request denied for volume > Hi all, > I

Re: Laptop message

The system tries to connect via VPN. We suppose the TSM Scheduler service is trying to pick up scheduling data from the server. Regards, Orin -Original Message- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:18 AM To: [EMAIL PROTECTED] Subjec

Sharing 3584 between TSM/Win2K and AS/400 (non-TSM)

Configuration will be TSM on Win2k scsi connected to two of the drives and the AS/400 connected to two others. I'm confused about the library control path. Will this be twin-tailed or what? Anybody who is sharing a 3584 between two systems like this or similar, fire away! Thanks, Kelly J. Lip

Re: WINNT GUI showing directory

I still think we need a requirement for the client generate an (OPTIONAL) log on RESTORE. Whine. Whine. Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practica

Re: Is a mix of 3590E normal tape with long-tape possible?

The only issue is the 2X feature (K support) must be on the drive and driver levels have to be high enough to support the search/rewind times. We run just like this on 3590-E1A drives. -Original Message- From: Cook, Dwight E (SAIC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12,

Re: filespace reporting question

I never tried this, but since one hour is .04166 days, can you say ...where (days(backup_end) < (days(current_date)-.04166) ... ? Mr. Lindsay Morris CEO Applied System Design www.servergraph.com 859-253-8000 ofc 425-988-8478 fax >

Re: lan free on 3494

With all the problems with LAN-Free pre 4.2.1.7, I recommend that you upgrade to that level. However, did you define the library as shared correctly? Did you call the library name on the SAN Managed (Storage Agent) the same as that in the TSM Server. They have to be the same name. Look at the D

I: Mount request denied for volume

> Hi all, > I'm using TSM rel.4.2,STKL700 with four LTO drives. > Recently, cartridge 000131 stuck in drive n°4, I manually removed the > cartridge and put back in its home cell. The cartridge and drive n° 4 > aren't broken. > When I started migration I received this message: > > > 07/12/01 20:3

lan free on 3494

Solved it!!. Ive just stopped and restarted the storage agent process. I now have library and drive definitions on the storage agent - which I didn't have before. richard. -- Forwarded by Richard Bates/UK/IBM on 12-12-2001 15:28 --- To: [EMAIL PR

Re: Deleting RMAN versions

Eric, Thanks you very much the delete object command is exactly what I'm looking for i'll use it in this script once I tweak it a little more to strip out headers and spaces: SELECT 'delete object 0', BACKUPS.OBJECT_ID FROM BACKUPS BACKUPS WHERE (BACKUPS.NODE_NAME='EQPSP01_RMAN') AND (BACKUPS

lan free on 3494

Config: TSM Server v4.2 running on AIX 8 x 3590 FC attached drives TSM Client v4.2 running on NT. BA client and storage agent v4.2. I'm trying to setup LAN-free on an NT client. I've done all the config as follows: all zoning so that client and server can see FC drives installed storage agent

filespace reporting question

Does anyone know how to use a select statement like the following but instead of having it report on days have it report on hours? i.e. from now -3 hours and less than 15 days. select filespace_name as "Filespace", node_name as "Node", days(current_date)-days(backup_end) as

Re: Laptop message

What message? -Original Message- From: Orin Rehorst [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:33 AM To: [EMAIL PROTECTED] Subject: Laptop message Installed TSM client on Win2k laptop. Message keeps popping up when laptop is undocked. Please advise. TIA, Orin Rehor

Re: Is a mix of 3590E normal tape with long-tape possible?

>In our library IBM-3494 are 3490E tape-units. This library >will reach its >limits for the number of cartridges. >We think of replacing the 3490E normal tapes by long-tapes. > >Does TSM support a mix of different tapes? Fred, I have the same issue here. The modified 3590 has a green 2x sticker

Re: Help! I need more space

Hi Yes, we only keep 2 copies of the database backups in the LIBRARY, and another 5 copies of site. However, this guys problem was that his LIBRARY was full, and that he needed more space/slots available for scratch volumes in his LIBRARY. And, there are other ways to be certain that you're data

Re: WINNT GUI showing directory

If someone can write up what they think is needed and justify in business terms why, I will try to get it submitted at Share in Nashville. -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:01 AM To: [EMAIL PROTECTED] Subject: Re: WINN

Laptop message

Installed TSM client on Win2k laptop. Message keeps popping up when laptop is undocked. Please advise. TIA, Orin Rehorst

Re: Is a mix of 3590E normal tape with long-tape possible?

3590E normal tapes & long tapes ? ? ? are you referring to "J" tapes & "K" tapes ? (that is all I know of...) J tapes are 3590-B1A tapes which may be written to by 3590-E1A tape drives (a reformat is performed) and K tapes are the 3590-E1A tapes from the start... If this is the case, yes, you can

Set management Class on adsm.sys\...\files

Hi, How is the management class for the ADSM.SYS area set up for NT4 or W2K in the dsm.opt file? I noticed that if a backup is performed, the files take on the default class. If a different management class is needed in this area how can it be changed? I tried the include.systemobject ALL 7DAY o

Re: Set management Class on adsm.sys\...\files

Hi Sam I do not use include.systemobject because it does take some SYSTEM32 file with the reg stuff and I don't wnat to . I juste defined the following CLIENTOPT rule def clientopt NT INCLEXCL 'Include C:\adsm.sys\...\* BCK_REGISTRY' F=Y RV Sam Lovejoy <[EMAIL PROTECTED]>@VM.MARIST.EDU>

FW: Tapes and the TSM.

Did you start "expire inventory' on a regular basis? For instance via an administrative schedule. > -Original Message- > From: Adolph Kahan <[EMAIL PROTECTED]>@CORUS > Sent: Wednesday, December 12, 2001 2:59 PM > To: [EMAIL PROTECTED] > Subject: Re: Tapes and the TSM. > > <<...OLE_

Re: Tapes and the TSM.

Nazir, Run expire inventory to delete expired data, run reclaim to free tapes, If the tapes are really full, buy more tapes; But more imput would have been helpfull... greetings -Oorspronkelijk bericht- Van: Nazir [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 12 december 2001 13:18 Aa

Passwordaccess generate

I have a strange TSM issue concerning passwordaccess. First, the levels. TSM server is on AIX running 4.3.2. The TSM server version is 4.1.4.0. Client is on AIX running 4.3.3, the client version 4.2.1.0. I have 5 machines, all configured as above. 4 of the machines behave correctly with resp

Is a mix of 3590E normal tape with long-tape possible?

In our library IBM-3494 are 3490E tape-units. This library will reach its limits for the number of cartridges. We think of replacing the 3490E normal tapes by long-tapes. Does TSM support a mix of different tapes? If so, is it necessary to make modification in e.i. hardware(3490E modification?) o

Re: Tapes and the TSM.

Are you doing any tape reclaimation? This what you normally do to free up tapes. You will need a few empty tapes before you start this Adolph - Original Message - From: Nazir <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 7:17:50 AM To: <[EMAIL PROTECTED]> Subject: Tapes and the

Re: Help! I need more space

You only keep 2 copies of your database backups? I keep two weeks worth! You realize that without the database backups you can't restore your TSM server farther back than two days ago. Mark -Original Message- From: Daniel Sparrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 1

Tapes and the TSM.

Hi, I have been working with TSM to make backups of my servers. The TSM server is in Windows NT. It works with tapes too. The TSM makes backups and keep it in hard disk, after this sends the data to tapes. But the tapes are full. What Can I do to reuse the tapes? I don4t want to lose any data fro

Re: act log question..

Won't that just attempt to backup a filespace named '>' and 'c:\temp\sched.log'? I've found the easiest way is to specify a log file in the optins file... SCHEDLOGNAME d:\schedlog.dsm Marc. Rosa Leung/Toronto/IBM <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMA

act log question..

May I check backup files list from tsm db.. When I check out "q act log", I can make sure skipped files and backup result.. But I need backup file list for each client... Is there any way to do it? Thanks in advance.. CD DATA CORP. IDC TEAM. KIM IN YOP 14th Floor,Sam Jung Bldg. 237-11,N

Alex Osuna/San Jose/IBM is out of the office.

I will be out of the office starting December 12, 2001 and will not return until December 14, 2001. I will respond to your message when I return. If this is urgent you can contact my backup Ken Zschach at 408-666-5412

Re: Deleting RMAN versions

Hi James! No, you need to have 2.2 when you want to use the tdposync utility. There is another way to get rid of them, but it requires a lot of manual work and its uses non supported TSM commands. Issue the following command through the admin commandline interface: select * from backups where node

Re: How many concurrent backup sets?

On Mon, 10 Dec 2001 16:33:08 +, it was written: >Can't use the -loc >We use tcpip to restore direct from the server over the network to the clients. >Anyway despite the manual do not think that that you can restore a backupset >from >a locally attached tape with netware client. The fault not