Re: Point-In-Time-Restore

[Joel Fuhrman]

> today again a question concerning Point-In-Time-Restore :
>
> Following situation :
>
> I did make backups of a node for more than half a year. Many files have
> prduced versions on the backup-server, a lot of files did not because they
> did not change since start of backup. My policy says it will keep 10
> versions for lets say 3 month.
>
> Now I start a full backup of the whole client. I produce a new version of
> all files. For many of those files that had only produced one version up to
> this date, the retention-period will cause this older version to be deleted.

The timer to expire the older version starts when it was replaced.  Thus the
older version is available for 3 months, per the above example.

Re: Backup Policies - Kind of FAQs

[Joel Fuhrman]

Exclusively assigned files can not be backed up.

On Wed, 4 Apr 2001, Mahesh Babbar wrote:

>  Hi Gurus,
>
>  Just because I wanted to put all the queries on backup verions and
>  deletion at rest, I have drafted following Statements.
>
>  Would appreciate all yours commnents.
>
>
>  I have a Backup Copy Group parameters with the following values.
>
>  COPYGROUP_NAME: STANDARD
>   VEREXISTS: 7
>  VERDELETED: 7
>RETEXTRA: 30
> RETONLY: 60
>MODE: MODIFIED
>   SERIALIZATION: DYNAMIC
>   FREQUENCY: 0
> DESTINATION: DISKPOOL1
>CHG_TIME: 2001-02-15 12:01:52.00
>   CHG_ADMIN: ADMIN
> PROFILE:
>
>  The backup is scheduled and performed daily incrementally. The
>  EXPIRE INVENTORY runs daily.
>
>  For the easy understanding  of the new users, who daily bug me for
>  the status of their data, ( and even the admins) can I state
>  following with the Capital letters. It would clear some of my
>  doubts also.
>
>  1. No. of Versions of a file kept in the backup system =  7.
>  The oldest version shall expire on the arrival of the 8th version.
>
>  2. No. of Versions to be kept in the backup system after the file is
>  deleted from the client and then incremental backup is performed on
>  the filesystem containing that particular file = 7
>
>  3. A file backed up and not changed is called an ACTTIVE version and
>  remain there in the backup system FOREVER.
>
>  4. A file backed up, changed and then backed up again, in this case,
>  the previous version becomes INACTIVE and the latest version becomes
>  ACTIVE.
>
>  5. The day a file becomes INACTIVE, it gets deleted from backup
>  system after 30 Days.
>
>  6. A file backed up, deleted from the Client, and then incremental
>  backup is  performed on the directory / filesystems containing that
>  file, this file would remain on the system for 60 Days.
>
>  7. If a filesystem is removed from the "Object List" of the schdule,
>  the filesystems remain doesn't get expired and always remain active.
>
>  8. Always INCRMENTAL backup shall be performed. ( Can any body point
>  out if the whole file goes to the backup system or only the DELTA).
>
>  9. A file shall be backed up even if it's open. CONSISTENCY of the
>  file is not guranteed in that case.
>
>  Please comment if I have missed something as far as users' perpective
>  is concerned.
>
>  Thanks & Regards
>
>  Mahesh
>

Re: deleting an undefined volume

[Joel Fuhrman]

Do something like:
   del volhist todate=-4 type=dbbackup
where the -4 is the number of days ago that you did the backup.

Warning: This will release >ALL< database backup volumes prior to then.
However, it this volume is your only backup, it will not be released.

On Wed, 11 Apr 2001, Jon Milliren wrote:

> Hi all,
>
> I'm sorry if this is a dumb question, but here goes... I labeled a
> volume and used this volume for a db backup. My problem is that I forgot
> to define the volume in my copy storage pool. Now, I cannot define it to
> the pool (because it was used for a db backup), nor can I give the
> volume a status of scratch...
>
> How can I get out of this mess? I'd like to simply delete and relabel
> the volume, I have no need to preseve the db backup.
>
> Thanks,
>
> Jon
>
> --
> Jon Milliren
> Systems Administrator
> University of Pittsburgh
> Office of Institutional Advancement
>
> [EMAIL PROTECTED]
> (412) 624-2727 office
> (412) 480-8495 mobile
>

Re: DIRMC - disadvantages only?

[Joel Fuhrman]

Back in November you described this implementation, which makes a major
reduction in the time required to do a DIRMC offsite copy reclamation:

> DIRPOOL primary DISK: NEXTPOOL->DIRFILE
> DIRFILE primary SEQUENTIAL on DISK
> DIRCOPYPOOL copypool TAPE

Would you mind posting the output from a:
 query stg DIRFILE format=detail

and a:
 query devclass 

I'm assuming "SEQUENTIAL on DISK" means a device class type of FILE.  But I
want to be sure, before making the change.

Re: TSM 4.1 on AIX licences

[Joel Fuhrman]

Did you install the first 4.x level from a cdrom?  If not, you don't have
the correct keys.

On Thu, 19 Apr 2001, [iso-8859-2] Hrouda Tomá¹ wrote:

> I tried it and file was created again with the same result  not register
> any license :-((
> 
> > -Pùvodní zpráva-
> > Od:   Davidson, Becky [SMTP:[EMAIL PROTECTED]]
> > Odesláno:   18. dubna 2001 16:55
> > Komu: [EMAIL PROTECTED]
> > Pøedmìt:  Re: TSM 4.1 on AIX licences
> > 
> > Try deleting or moving nodelock to another name and then register
> > 
> > -Original Message-
> > From: Hrouda Tomá¹ [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 18, 2001 9:00 AM
> > To: [EMAIL PROTECTED]
> > Subject: TSM 4.1 on AIX licences
> > 
> > 
> > I have problem with licences in TSM 4.1.3 on AIX:
> > I have still no license for managed system for LAN registered now. When
> > try
> > to register new license by licence file (for example 10mgsyslan.lic) by
> > command:
> > 
> > register license file=/usr/tivoli/tsm/server/bin/10mgsyslan.lic
> > 
> > (I tried also:
> > register license file=/usr/tivoli/tsm/server/bin/10mgsyslan.lic number=1
> > register license file=/usr/tivoli/tsm/server/bin/1mgsyslan.lic number=10
> > register license file=/usr/tivoli/tsm/server/bin/mgsyslan.lic number=10
> > but nothing helps)
> > 
> > on TSM console appears msg:
> > 
> > ANR2852I Current license information:
> > ANR2853I New license information:
> > 
> > and no licences are registerred. (Normally should appear number of
> > registerred MSL, I think.)
> > 
> > I found out, that In file nodelock in server/bin/ directory appears
> > version
> > information "3.7" in register items (??? don't know why !!!), althoug in
> > license file is item CurrentVersion=4.1 !!! (pg 10mgsyslan.lic)
> > Licences were installed from original install CD of TSM for AIX server 4.1
> > (not upgrade from 3.7 server to 4.1), it was clear new TSM 4.1
> > installation.
> > 
> > Do anybody know, how to help me?
> > 
> > 
> > Tomá¹ Hrouda, AGCOM Smiøice
> > Tivoli Certified Consultant
> > Storage Manager Specialist
> > [EMAIL PROTECTED]
> > 049-5941312, 0604-296521
> > ICQ#77892561
> > 
> > 
> > ---
> > Odchozí zpráva neobsahuje viry.
> > Zkontrolováno antivirovým systémem AVG (http://www.grisoft.cz).
> > Verze: 6.0.225 / Virová báze: 107 - datum vydání: 22.12.2000
> > ---
> > Pøíchozí zpráva neobsahuje viry.
> > Zkontrolováno antivirovým systémem AVG (http://www.grisoft.cz).
> > Verze: 6.0.225 / Virová báze: 107 - datum vydání: 22.12.2000
> > 
> ---
> Odchozí zpráva neobsahuje viry.
> Zkontrolováno antivirovým systémem AVG (http://www.grisoft.cz).
> Verze: 6.0.225 / Virová báze: 107 - datum vydání: 22.12.2000
> 

Re: How do I restore files from inactive version?

[Joel Fuhrman]

add the -inactive option to you command.

On Mon, 23 Apr 2001, [BIG5] 321 880053 ®}¸Î¹F wrote:

> My policy is :
> Versions Data Exists 4
> Versions Data Deleted4
> Retain Extra Versions30
> Retain Only Version  60
> 
> I have a test for this case.
> I modify the file : test.txt befor I backup .
> I execute the backup command : dsmc inc test.txt
> I do it 4 times.
> I try to res the oldest file but I always get the latest version.
> 
> I use the command : res file -pic , there is only a version (active version)
> .
> I use the command : q content volumn_name test.txt
> There are 4 versions in the stgpool.
> 
> How do I restore  files  from inactive version?
> 

ANS0106E ReadIndex 1497 and 15647 message index not found

[Joel Fuhrman]

Has anybody encountered these errors and did you find a solution to the
problem?

Since moving to TSM windows client level 4.1.2.12, I'm encountering this
error when backing up to AIX running TSM Server 3.7.3.8:

ANS0106E: ReadIndex 1497 message index not found for message 1497

A backup of the same TSM windows client to AIX running TSM Server 4.1.3
gets:

ANS0106E: ReadIndex 15647 message index not found for message 15647

The problem occurs on both NT4+sp6a and Windows 2000+sp1.

interrupt a running script

[Joel Fuhrman]

Is there a way to interrupt a multi-command scripts?

I've tried updating the script to ACTIVE=NO and then cancelling the current
process. Unfortunately, the next command in the script was still run.

Re: adsm 3.1 and stgpool reclaim threshold

[Joel Fuhrman]

I would search the activity log for all references to the stgpool of
interest.  You should see the command that does the update.  Hopefully with
the time stamp you can find the culprit.

Ex: query act begind=today-1 search=some_stgpool_name


On Thu, 31 May 2001, Steve de Souza wrote:

> Hi,
> Can anyone tell me if there are any conditions which will
> cause a copystorage stgpool to have it's reclaim threshold
> percentage to change to 100% ??? We have no scripts which
> explicitly change it, and yet we find that it changes from 70 to 100
> every day !!
>
> we have run into a problem in that this gets done every morning
> after bkserver finishes.
>
> Any cluses/answers would be much appreciated.
>
> cheers
> steve
>
> 
> Steve de Souza
> Senior System Administrator
> Bunnings Building Supplies
> Perth, WA
> Phone : (08) 9365 1527 /  0409 383 943
> Email : [EMAIL PROTECTED]
>
>
> **
> Bunnings Legal Disclaimer:
>
> 1)  This document is confidential and may contain legally privileged
> information. If you are not the intended recipient you must not
> read, copy, distribute or act in reliance on it.
> If you have received this document in error, please telephone
> us immediately on (08) 9365-1555.
>
> 2)  All e-mails sent to and sent from Bunnings Building Supplies are
> scanned for content. Any material deemed to contain inappropriate
> subject matter will be reported to the e-mail administrator of
> all parties concerned.
>
> **
>

Re: Issues with Win2K SYSTEM OBJECT/SYSTEM FILES backup

[Joel Fuhrman]

I'm glad you posted this as I have the same problem with this idiotic
repetative backup of unchanged objects. It has driven my TSM server to its
knees.  Since I hadn't seen other postings, I thought I had a unique problem
with my database.

On Fri, 1 Jun 2001, Prather, Wanda wrote:

> I have run into some ugly issues with the Win2K backup of the "SYSTEM
> OBJECT".
>
> I'm throwing the information out here to warn other people what to expect,
> and hopefully to get the developers to reconsider the current
> implementation.
>
> The SYSTEM FILES component of the "SYSTEM OBJECT"  on Win2K consists of over
> 1500 .dll and .exe and .obj files from (mostly) the WinNT/system32
> directory.  These files are backed up EVERY TIME an incremental is run, even
> though THE DATA HAS NOT CHANGED.
>
> We have converted over 200 NT desktops to WIn2K PRO.  For each of our Win2K
> PRO systems, this adds 1586 files to the backup every night.
>
> This has had an enormous impact on the TSM server.  The additional data is
> only about 20 GB per night, and that's not a big problem.  But each of the
> SYSTEM FILES still has it's own entry in the TSM data base.
>
> You do the math:  That's over 300,000 additional objects that get added AND
> deactivated each day, which for me means an additional 2.5 HOURS of EXPIRE
> INVENTORY time is needed DAILY.  And all for data THAT HAS NOT CHANGED.
>
> TSM's strength has always been that it DOESN"T back up unchanged data.
> Well, at least it didn't used to...
>
> My problem here is we have another 250 machines to convert from NT to WIn2K.
> They aren't about to buy me a second TSM server to handle the load, when the
> current one worked fine for backing up the same number of NT systems with
> the same amount of user data.  Instead they are looking at some Windows-only
> software to back up the WIndows side of the house.
>
> It appears to me the current TSM implementation is flawed, and will inhibit
> other people's ability to support large Windows environments as well as
> ours.
>
> I put this information into the Requirements for the Oxford Symposium,
> hopefully it will give some additional visibility to the issue.
>
> Any suggestions welcome but don't suggest we give up our ability to do
> full bare-metal restores.
> Management will change the backup software first.
>
> 
> Wanda Prather
> The Johns Hopkins Applied Physics Lab
> 443-778-8769
> [EMAIL PROTECTED]
>
> "Intelligence has much less practical application than you'd think" -
> Scott Adams/Dilbert
> 
>

Re: Issues with Win2K SYSTEM OBJECT/SYSTEM FILES backup

[Joel Fuhrman]

There is one benefit to backing up the system objects every night. Should
you ever need to do a bare metal restore, the system objects will be cached
on disk.  Of course, all the other user files has been pushed out of the
cache; but who cares if user restores require tape mounts.

removing last/only DBSnapshop

[Joel Fuhrman]

I did a snap shot database backup to see what impact, if any, it would have
on the logfile.  Unfortunately, I didn't realize that it is not possible to
delete this backup using normal commands.  I don't want a volume containing
useless data in my library from now until TSM doomsday.

Does anybody know of a back door method to remove the last/only DBSnapshot
volume from the TSM database.

Re: removing last/only DBSnapshop

[Joel Fuhrman]

Unfortunately, the works for all but the last/only volume.  In the output
from the TSM server command 'help del volh', it reads "The latest snapshot
database backup will not be deleted.".

On Mon, 4 Jun 2001, Mark Stapleton wrote:

> Joel Fuhrman wrote:
> > I did a snap shot database backup to see what impact, if any, it would have
> > on the logfile.  Unfortunately, I didn't realize that it is not possible to
> > delete this backup using normal commands.  I don't want a volume containing
> > useless data in my library from now until TSM doomsday.
> >
> > Does anybody know of a back door method to remove the last/only DBSnapshot
> > volume from the TSM database.
>
> I'm not sure who told you a DBS couldn't be deleted. No backdoor is
> necessary:
>
> del volhist begind=-3 type=dbs
>
> All database snapshots will be thus deleted if 1) they are at least 3
> days old, and 2) there is at least one other database backup (including
> full backups).
>
> --
> Mark Stapleton ([EMAIL PROTECTED])
>

Re: removing last/only DBSnapshop

[Joel Fuhrman]

Your sample command is probably used to minimizing the number of dbs copies.
However, I want to get rid of >ALL< copies.  The suggestion made by Wanda
and Richard will at least allow me to free up the tape.

On Tue, 5 Jun 2001, Gill, Geoffrey L. wrote:

> >-Original Message-
> >From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, June 05, 2001 7:50 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: removing last/only DBSnapshop
> >
> >
> >Been there, I don't know the proper way to fix it.
> >But here's a sneaky thing you can do if you have some free disk space:
> >
> >Do another DBSNAPSHOT to DISK.
> >(You'll have to set up a FILE type DEVCLASS).
> >Then you will have 2 DBSNAPSHOTS, so you can delete the
> >DBSNAPSHOT that is
> >on tape in your library.
> >
> >Then use whatever operating system command to scratch the disk
> >DBSNAPSHOT,
> >and free up your disk space.
> >You will be left with a bogus entry in your VOLHISTORY file,
> >but at least
> >it's not taking up space...
>
> I don't understand why this seems to be a problem. I do a dbsnapshot every
> day I have it set up to delete anything older than 7 days and it works fine
> for me.
> del volhistory todate=today-7 type=dbsnapshot
>
> Geoff Gill
> TSM Administrator
> NT Systems Support Engineer
> SAIC
> E-Mail:   [EMAIL PROTECTED]
> Phone:  (858) 826-4062
> Pager:   (888) 997-9614
>

TDP for MS SQL cross server restore

[Joel Fuhrman]

I have 2 Windows 2000 servers each running MS SQL7.  The old machine,
Host-A, is running TDP for MS SQL version 1.1.2.01 while the new machine,
Host-B, is running version 2.2.

I want to restore a database that was backed up on Host-A to Host-B.  When I
attempt to view the backup tree for Host-A on Host-B's tdpsql gui screen,
nothing is displayed and the TSM server logs this error:

ANRD smnode.c(5323): Error validating inserts for event 14995.


Any suggestions as to what is wrong?

Re: tsm mirroring vs pprc

[Joel Fuhrman]

Dave, what the level of the TSM server that caused this problem?

On Tue, 12 Jun 2001, Frost, Dave wrote:

> Richard,
>
> "BTDTGTTS"
>
> We are running tsm using san attached emc for all disk storage.  On initial
> setup of the emc, we decided to stop using log/db mirroring, and use the emc
> mirroring instead.
>
> Soon afterwards, we had 2 instances where we could not restart the server.
> Both times the server failed to restart because of an inconsistency in the
> db log file.  The emc mirroring had faithfully replicated the inconsistency,
> of course.  In each case, the database had to be restored.  Given a 35 GB
> database, a restore can take about 2.5 hours.
>
> IBM said that they "strongly recommend tsm mirroring", preferably with
> verification.
>
> So do we, now.
>
> regards
>
> -=Dave=-
>
> -Original Message-
> From: Richard Bates [mailto:[EMAIL PROTECTED]]
> Sent: 08 June 2001 12:25
> To: [EMAIL PROTECTED]
> Subject: tsm mirroring vs pprc
>
>
> Folks,
>
> Customer site: TSM running on AIX.  2 x IBM Enterprise Storage Server, one
> per data centre. SAN connecting it all together.
>
> Problem: I've seen and read all the posts about TSM mirroring vs AIX
> mirroring vs RAID mirroring.  I understand the probem with partial page
> writes and prefer TSM mirroring.  We had planned to implement TSM mirroring
> with a copy of the database and recovery log on IBM ESS in both of the data
> centres.
>
> However company strategy says that *all* mirroring must be done via PPRC.
> Does anyone have any experience with PPRC?  Can it cope with partial page
> writes?  Am I safer to use TSM mirroring?
>
> Regards
> Richard.
>
> Richard Bates
> Storage Specialist
> ITS - SB - Enterprise Consultancy Services
> ==
> Voice :  00 44  (0) 1926 462298  (HICOM : 662298)  (MOBEX : 270798)
> [EMAIL PROTECTED]
>
> _
> This message has been checked for all known viruses by MessageLabs Virus
> Control Centre.
>
> www.guardianit.com
>
> The information contained in this email is confidential and intended
> only for the use of the individual or entity named above.  If the reader
> of this message is not the intended recipient, you are hereby notified
> that any dissemination, distribution, or copying of this communication
> is strictly prohibited.  Guardian iT Group will accept no responsibility
> or liability in respect to this email other than to the addressee.  If you
> have received this communication in error, please notify us
> immediately via email: [EMAIL PROTECTED]
>
> _
> This message has been checked for all known viruses by MessageLabs Virus Control 
>Centre.
>

Re: Reclaims Ques

[Joel Fuhrman]

I've observed, that once the TSM starts to copy a file, it completes the
copy before stopping.  A huge file can take a long time.  Just for this
reason, I encourage the DBA's to break their dumps into smaller chunks
(~4GB).

On Wed, 20 Jun 2001, Lindsay Morris wrote:

> Thanks Richard, Eric, all---
>
> I've seen the reclaim-won't-let-go situation a lot, and sometimes tried to
> cancel the reclamation process ---
> and STILL, more often than not, it takes 40 minutes for cancel process to
> take effect!
>
> I didn't have NOPREEMPT set (unless it's a default value -- I think it's
> not);
> I didn't have huge files;
> I've seen this on DLT700 and on 3590 drives;
>
> For me it's more curiosity than critical; maybe it's a major annotance for
> some other people.
> I wonder if any developers can shed some light.
>
>
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Loon, E.J. van - SPLXM
> > Sent: Wednesday, June 20, 2001 5:25 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Reclaims Ques
> >
> >
> > Hi Lindsay and Richard!
> > I have seen the exact same thing here!
> > The day before yesterday a user called me about an Oracle database restore
> > that was taking quite some time. I did a q sess and saw that it was in a
> > MediaW state. I have two tape units and TSM was reclaiming a tape. I was
> > also expecting to see the preempting message, but the reclaim was not
> > canceled by TSM. As soon as I did a CANCEL PROC the reclaim stopped, the
> > tapes were dismounted, the clients tape was mounted and the client restore
> > continued.
> > Yesterday we did the exact same thing and the running reclaim WAS
> > cancel by
> > a preemption!
> > So prioritizing works Sometimes...
> > Kindest regards,
> > Eric van Loon
> > KLM Royal Dutch Airlines
> >
> > -Original Message-
> > From: Richard Sims [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 19, 2001 21:48
> > To: [EMAIL PROTECTED]
> > Subject: Re: Reclaims Ques
> >
> >
> > >How long does it usually take for the reclamation process to
> > actually stop,
> > >and release the tape drive(s) so the restore can use them?  I've
> > typically
> > >seen this be 40 minutes or more, but I'm not sure why,  or if something
> > >could be done to speed it up.
> >
> > Lindsay - The first thing I would check is whether you have NOPREEMPT in
> >   your server options file.  Reclamation of onsite volumes itself
> > takes a long time, but at least looks at the Reclamation Threshold between
> > volumes: offsite volume reclamation never looks back, just continuing to
> > process all the volumes it saw that it had to do when it started.
> >
> > If you don't have NOPREEMPT in force, there may be something else at play.
> > Do queries in a future situation and see if an explicit Cancel Process
> > will stop reclamation.
> >
> >   Richard Sims, BU
> >
> >
> > **
> > This e-mail and any attachment may contain confidential and
> > privileged material intended for the addressee only. If you are
> > not the addressee, you are notified that no part of the e-mail or
> > any attachment may be disclosed, copied or distributed, and that
> > any other action related to this e-mail or attachment is strictly
> > prohibited, and may be unlawful. If you have received this e-mail
> > by error, please notify the sender immediately by return e-mail,
> > and delete this message. Koninklijke Luchtvaart Maatschappij NV
> > (KLM), its subsidiaries and/or its employees shall not be liable
> > for the incorrect or incomplete transmission of this e-mail or
> > any attachments, nor responsible for any delay in receipt.
> > **
> >
>

Re: Reclaims Ques

[Joel Fuhrman]

No.

Reclaim is the process of recovering unused portions of tapes by copying the
good stuff to a new tape.

Colocation is an option reduces the number of tapes occupied by the backups
for a system.  This will make restores faster since it reduces the number of
tape mounts at the expense of additional tape mounts for backups and more
partially filled tapes.  Some sites use it for critcal servers.

I suggest reading the Getting Started redbook.  That's not its full name;
but if you search for that you should be able to find it.


On Wed, 20 Jun 2001, Taylor, Garry wrote:

> Hello to all,
> I have a very basic question ( I am new user ) is the Reclaims process the
> same as colocation??
>
> Garry
>
> -Original Message-
> From: Lindsay Morris [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 5:16 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Reclaims Ques
>
>
> Thanks Richard, Eric, all---
>
> I've seen the reclaim-won't-let-go situation a lot, and sometimes tried to
> cancel the reclamation process ---
> and STILL, more often than not, it takes 40 minutes for cancel process to
> take effect!
>
> I didn't have NOPREEMPT set (unless it's a default value -- I think it's
> not);
> I didn't have huge files;
> I've seen this on DLT700 and on 3590 drives;
>
> For me it's more curiosity than critical; maybe it's a major annotance for
> some other people.
> I wonder if any developers can shed some light.
>
>
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Loon, E.J. van - SPLXM
> > Sent: Wednesday, June 20, 2001 5:25 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Reclaims Ques
> >
> >
> > Hi Lindsay and Richard!
> > I have seen the exact same thing here!
> > The day before yesterday a user called me about an Oracle database restore
> > that was taking quite some time. I did a q sess and saw that it was in a
> > MediaW state. I have two tape units and TSM was reclaiming a tape. I was
> > also expecting to see the preempting message, but the reclaim was not
> > canceled by TSM. As soon as I did a CANCEL PROC the reclaim stopped, the
> > tapes were dismounted, the clients tape was mounted and the client restore
> > continued.
> > Yesterday we did the exact same thing and the running reclaim WAS
> > cancel by
> > a preemption!
> > So prioritizing works Sometimes...
> > Kindest regards,
> > Eric van Loon
> > KLM Royal Dutch Airlines
> >
> > -Original Message-
> > From: Richard Sims [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 19, 2001 21:48
> > To: [EMAIL PROTECTED]
> > Subject: Re: Reclaims Ques
> >
> >
> > >How long does it usually take for the reclamation process to
> > actually stop,
> > >and release the tape drive(s) so the restore can use them?  I've
> > typically
> > >seen this be 40 minutes or more, but I'm not sure why,  or if something
> > >could be done to speed it up.
> >
> > Lindsay - The first thing I would check is whether you have NOPREEMPT in
> >   your server options file.  Reclamation of onsite volumes itself
> > takes a long time, but at least looks at the Reclamation Threshold between
> > volumes: offsite volume reclamation never looks back, just continuing to
> > process all the volumes it saw that it had to do when it started.
> >
> > If you don't have NOPREEMPT in force, there may be something else at play.
> > Do queries in a future situation and see if an explicit Cancel Process
> > will stop reclamation.
> >
> >   Richard Sims, BU
> >
> >
> > **
> > This e-mail and any attachment may contain confidential and
> > privileged material intended for the addressee only. If you are
> > not the addressee, you are notified that no part of the e-mail or
> > any attachment may be disclosed, copied or distributed, and that
> > any other action related to this e-mail or attachment is strictly
> > prohibited, and may be unlawful. If you have received this e-mail
> > by error, please notify the sender immediately by return e-mail,
> > and delete this message. Koninklijke Luchtvaart Maatschappij NV
> > (KLM), its subsidiaries and/or its employees shall not be liable
> > for the incorrect or incomplete transmission of this e-mail or
> > any attachments, nor responsible for any delay in receipt.
> > **
> >
>

Re: VGA monitors

[Joel Fuhrman]

What's VGA.  Is that something like a typewriter.

On Fri, 22 Jun 2001, Lori Simcox wrote:

> Just a quick survery - how many people run TSM on machines using VGA
> monitors?
>
> Thanks,
> Lori
>
> ---
> Lori Simcox
> TSM Client Development
> San Jose, CA
> ---
>

tdpsql v2.2 gui opens then immediately closes

[Joel Fuhrman]

tpdsql version 2.2 was working but now the gui window opens and then
immediately closes.

The tdpsql.log file show the request QUERY SQL but there is no connection to
the TSM 4.1.3.0 Server running on AIX 4.3.3 ML06 and there is no entry in
the dsierror.log file.  A command line tdpsqlc QUERY SQL gets the same
results.  However, a tdpsqlc QUERY TSM * /all does list the backups.

Any suggestions as to what would cause this?

log and db volumes on emc symmetrix disk

[Joel Fuhrman]

A long time back there was a discussion as to whether it's better to have
one or multiple tsm volumes per physical disk.  As I remember, the answer
was: assuming the entire physical disk volume was being used by one storage
pool, it was best to create one large tsm volume rather than several smaller
volumes to avoid disk IO contention.

I will be moving my db and log volumes stand alone disk to an emc symmetrix.
Does anyone have a suggestion as to number of tsm volumes that should be
created for each emc logical drive?  Would it be best to put 1 4GB, 2 2GB,
or 4 1GB database TSM volumes on 1 emc logical volume?

Re: ADSM Forms

[Joel Fuhrman]

Get the Redbook whose title is something like Getting Started with Tivoli
Storage Manager.  It will save you a lot of effort.

   http://publib-b.boulder.ibm.com/Redbooks.nsf/Portals

On Sat, 30 Jun 2001, Mark Stapleton wrote:

> On Tue, 26 Jun 2001 12:43:00 -0400, you wrote:
> >Does anyone have a  form they use which shows the preliminary steps
> >required to get a server to the point  where Tsm can be installed and a
> >backup scheduled defined?
>
> Yeah, it's called the QuickStart Guide. The hardcopy comes with every
> copy of the media, and there is a .pdf copy of it on the media, and is
> installed on the server.
>
> --
> Mark Stapleton ([EMAIL PROTECTED])
>

Re: tdpsql v2.2 gui opens then immediately closes

[Joel Fuhrman]

Here is our solution to this problem which was the sql server name as stored
in the sql database was null.  When it was set to the proper name, tdpsql
gui worked.  You can get the server name by doing a sql select @@servername

On Thu, 28 Jun 2001, Bruce Kamp wrote:

> I am having the same problem with SQL 7.0 SP2.  I have had this issue open
> with Tivoli support for 2-3 months now with no resolution.  I did install
> SQL 7 with different character set.  Version 1.1 work fines.  I was never
> able to get 2.2 to work at all.  So far this is the only fixtest they have
> had me try (did not work for me...):
>
> I received a response from our development team requesting that you try
> installing fixtest IC29849_01.exe for TDP for SQL v2.2. According to them,
> it fixes some character set/language problems with SQL Server and so could
> be related to the problem you are currently experiencing. I have attached
> both the readme file and fixtest for you to install. The  readme will
> provides the following information regarding what APARs are fixed:
> 
> 
> The following problems are fixed in this FIXTEST:
>
> IC29849
>
>When using the TDP for SQL 2.2 GUI or command line one may have
>encountered this error:
>   ACO5422E Received the following from the MS SQL server:
>   SQL-DMO  The name 'Unicode locale ID' was not found in the
>   ConfigValues collection.  If the name is a qualified name, use
>   to separate various parts of the name, and try again.
>   Microsoft SQL-DMO (HRESULT:0x80045510)
>The problem occurred with any SQL Server 7.0 sort order that is case
>sensitive, such as binary or dictionary order. A query SQL or any
>backup command would fail. Both the GUI and the command line would
>not work.  SQL 2000 does not experience this problem.
>
> IC30018
>
>The /relocate option on the command line does not process
>logical file names that are transaction log files.
>When used with the /partial option, it would not process logical
>file names that were not members of the /groups or /files specified.
>
> -Original Message-
> From: Del Hoobler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 6:54 AM
> To: [EMAIL PROTECTED]
> Subject: Re: tdpsql v2.2 gui opens then immediately closes
>
>
> Joel,
>
> Are you able to do a backup from the command line interface?
> It looks as if the communication with the SQL server is
> causing some type abnormal program termination.
> The only thing I can think of right off hand is that
> the registry containing connection information was somehow
> corrupted... but without a trace there is no way I can tell.
> To get to the bottom of this, it will require some
> traces to be gathered.  Please call IBM/Tivoli support.
>
> Thanks,
>
> Del
>
> ----
>
> Del Hoobler
> IBM Corporation
> [EMAIL PROTECTED]
>
> "It's a beautiful day.  Don't let it get away."  -- Bono
>
>
>
>
> Joel Fuhrman
> <[EMAIL PROTECTED]   To: [EMAIL PROTECTED]
> NGTON.EDU> cc:
> Sent by: "ADSM:Subject: tdpsql v2.2 gui
> opens then immediately closes
> Dist Stor
> Manager"
> <[EMAIL PROTECTED]
> T.EDU>
>
>
> 06/27/2001 11:17
> PM
> Please respond
> to "ADSM: Dist
> Stor Manager"
>
>
>
>
>
> tpdsql version 2.2 was working but now the gui window opens and then
> immediately closes.
>
> The tdpsql.log file show the request QUERY SQL but there is no connection
> to
> the TSM 4.1.3.0 Server running on AIX 4.3.3 ML06 and there is no entry in
> the dsierror.log file.  A command line tdpsqlc QUERY SQL gets the same
> results.  However, a tdpsqlc QUERY TSM * /all does list the backups.
>
> Any suggestions as to what would cause this?
>

Re: Mount Retention Period

[Joel Fuhrman]

Check out UPDATE DEVICE

On Thu, 2 Aug 2001, David Nash wrote:

> Is there any way to change the mount retention
> period for a drive in an automated library?  If
> so, how?
>
> Thanks,
>
> --David Nash
>   Systems Administrator
>   The GSI Group
>

Re: AIX 4.3.3 list of excludable files & filesystems

[Joel Fuhrman]

Is the windows 2000 version available yet?

On Mon, 13 Aug 2001, Ray Schafer wrote:

> The Bare Metal Restore product from The Kernel Group
> (http://www.tkg.com/products/bmr/tsm) has the ability to use the backup
> data in TSM to recover your server.  The "prepare to restore" operation
> can be issued with a single command and will create a customized restore
> procedure that will automatically recover the entire machine, or if you
> prefer, just the rootvg.  The prepare to restore operation will also
> allocate the BMR file and boot server components so they will answer the
> network boot and NFS requests of the server being recovered.
>
> It works well, and the restore is automated: prepare to restore and
> network boot.  That's it.
>
> Lisa Cabanas wrote:
>
> >Thanks for your reply, Herfried.  It brings to mind some other questions
> >regarding other volume groups.  Say you have all your Oracle stuff on one
> >or two different vgs.  Would you need to have done a savevg sometime in
> >the past to get the vg back, or at bare metal time would you need to
> >manually create the volume group and lvs and fss associated with it, and
> >then fill it with the data from TSM?
> >
> >I went and looked for a bare metal Redbook for AIX and found the one from
> >1997 that deals with AIX 4.1-- is it still pretty applicable to 4.3.3?  I
> >wonder if TSM still "supports" a bare metal for AIX, or if it is now
> >unsupported like Win2K is?
> >
> >
> >thanks
> >lisa
> >
> >
> >
> >
> >Herfried Abel <[EMAIL PROTECTED]>
> >08/09/2001 01:52 AM
> >Please respond to "ADSM: Dist Stor Manager"
> >
> >
> >To: [EMAIL PROTECTED]
> >cc: (bcc: Lisa Cabanas/SC/MODOT)
> >Subject:Re: AIX 4.3.3 list of excludable files & filesystems
> >
> >
> >
> >Lisa,
> >
> >All the filesystems within the rootvg are backed up with a mksysb as long
> >as they are not explicit excluded from rthe mksysb. In general AIX does
> >not
> >delete (major) files on reboot as other UNIX's do ( eg /tmp ).
> >This is how we do the restore of an AIX machine :
> >1) restore mksysb
> >2) restore "OS-definitions" via TSM ( rootvg filesystems eg. /etc ) ( TSM
> >Client already restored by mksysb )
> >3) restore filesystems (non rootvg) via TSM
> >4) restore application-data ( DBs eg. ORACLE,SAPDB, MSSQL etc ) via TDP
> >Agents in necessary.
> >
> >Step 2) depends on the time-difference between the mksysb and the last
> >config changes of AIX. Should not be necessary if you make a mksysb after
> >every config change , as all of the sysadmins do :-)
> >
> >So what we do, we dont exclude files from the rootvg in the TSM backup (
> >AIX-OS is not really need much space ) but we exclude lots of temporary
> >application files. We think that at this point we can find a lot of
> >temporary data (eg. SAP rollfiles ).Of cause you have to know your
> >application / Datebase very well, so that you dont exclude a file by
> >mistake.
> >
> >herfried
> >
> >
> >
> >
> >
> >Lisa Cabanas <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 08.08.2001
> >18:20:26
> >
> >Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> >
> >Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> >
> >
> >To:   [EMAIL PROTECTED]
> >cc:
> >
> >Subject:  AIX 4.3.3 list of excludable files & filesystems
> >
> >
> >Has anyone ever compiled a list of files and/or file systems that can be
> >excluded from backup either because they are dynamically created by the OS
> >at
> >reboot/syncvg etc
> >or because they are included in a mksysb?
> >
> >
> >
> >
> >
> >
> >
> >
> >The information contained in this transmission, which may be
> >confidential and proprietary, is only for the intended recipients.
> >Unauthorized use is strictly prohibited. If you receive this
> >transmission in error, please notify me immediately by telephone
> >or electronic mail and confirm that you deleted this transmission
> >and the reply from your electronic mail system.
> >
> >
> >
>

backing up only 1 directory on Windows

[Joel Fuhrman]

I have a Windows system running TSM client 4.2.0.0 from which I want to
backup just the directory 'C:\Users' and all of its subdirectories and
files.  I don't want to backup any other directories or files from that
system.  I tried these dsm.opt specifications:

   exclude.dir "C:\*"
   include.dir "C:\Users\...*"

A gui initiated incremental backup, excluded everything, including
C:\Users\...\*, from the C: drive.

Can you suggest the settings that will do what I want?

Re: Oracle Backup Error

[Joel Fuhrman]

look in the dsmierror log

On Wed, 15 Aug 2001, Amini, Mehdi wrote:

> We ran Oracle backup for the first time last night and it failed with the
> following message:
> "ANS1512E Scheduled Event 'backup" Failed.  Return Code = 3
>
> I looked at dsmcsched & dsmerror and nothing. Any idea where I can find what
> happened?
>
> Mehdi Amini
> LAN/WAN Engineer
> ValueOptions
> 3110 Fairview Park Drive
> Falls Church, VA 22042
> Phone: 703-208-8754
> Fax: 703-205-6879
>
>
>
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the sender by email, delete and destroy this message and its
> attachments.
>
>
> **
>

Re: Boot from CD

[Joel Fuhrman]

Try press either  or  after 'keyboard' is displayed.

On Wed, 15 Aug 2001, Gill, Geoffrey L. wrote:

> This a little off topic since it's an AIX question but I'm sure with the
> knowledge out there it can be answered. How do I get an M80 to boot from the
> AIX CD instead of the disk.  Inserting the CD and starting after a complete
> shutdown obviously doesn't work. I'd like to do some playing around before I
> have to go into production and wiping and installing is one of the things
> I'd like to do.
>
> Thanks for the help
>
> Geoff Gill
> TSM Administrator
> NT Systems Support Engineer
> SAIC
> E-Mail:   [EMAIL PROTECTED]
> Phone:  (858) 826-4062
> Pager:   (888) 997-9614
>

Re: TSM 4.2 (AIX), licensing..

[Joel Fuhrman]

Someone reported in the last couple of weeks that this was a bug. The server
will run but it will generate a lot of log entries.

On Wed, 15 Aug 2001, Tom Tann{s wrote:

> Hello!
>
> I upgraded a server from 4.1 to 4.2 today.
>
> I've only managed to register one 50mgsyslan.lic whith the command
> register lic file=50mgsyslan.lic number=12
>
> additional attempts toregister more result in the same..
>
> tsm: SUMO>register license file=50mgsyslan.lic
> ANR2852I Current license information:
> ANR2827I Server is licensed to support Managed System for LAN for a
> quantity of 60.
> ANR2853I New license information:
> ANR2827I Server is licensed to support Managed System for LAN for a
> quantity of 60.
>
> tsm: SUMO>
>
> (Its 60 now because I successfully registered one 10mgsyslan.lic)
>
>
> After several attempts I took a look at the nodelock-file, and this file
> seems to be updated correctly, with one entry for each of my attempts..
>
> .
> .
> .
> .
> # Managed System for LAN 50 Licen
> 6fb1ea8d2ebc.a3.89.a3.25.04.00.00.00 8umtikm47qkykpffafnaa "" "4.2"
> #[admin_comment] "" "" "0" "0" "0"
> # Managed System for LAN 50 Licen
> 6fb1ea8d2ebc.a3.89.a3.25.04.00.00.00 8umtikm47qkykpffafnaa "" "4.2"
> #[admin_comment] "" "" "0" "0" "0"
>
>
>
>
> So... Could this be a bug, or am I missing something here?
>

Re: tape drive unavailable WHEN THEY ARE!!!!!

[Joel Fuhrman]

Maybe its a false error.  Do you have enough tapes available to the tape
pool?  Do a "query  f=d" and look for Maximum Scratch Volumes
Allowed: and see how that compares to the number of tapes in use.

Also try a "query drive" to make sure all the drives are available and
defined to the correct devtype.

On Tue, 14 Aug 2001, Joe Faracchio wrote:

> Just moved my 1200 user production system to a new system and
> I've gotta solve this before my diskpool fills up completely!!
>
> I'm having a whole lot of problems with tape mounts and was wondering
> if anyone can summarize the known problems fixes for this.
> (what combination of devices.rte and TSM work without problems)
>
> I'm on AIX 4.3.3 with TSM 4.1.3. Its a 3466 NSM
> I've got a 3494 with two 3590s.
>
> In a nutshell:
> I can do a:
>   backup stg diskpool copypool
> with NO PROBLEMS.  But if I do:
>
>   upd stg diskpool hi=1 low=0 migproc=2
>
> I get :
>  ANR8447E No drives are currently available in library  3494LIB.
>  ANR1401W Mount request denied for volume 200332 - mount
>   failed.
>
> I've also seen this with onsite and offsite reclamations.
>
> any help would be much appreciated.
>
> thanks  joe.f.
>
> Joseph A Faracchio,  Systems Programmer, UC Berkeley
> Private mail on any topic should be directed to :
>[EMAIL PROTECTED]
>

Re: how to EXPIRE UNIX files from unmounted/deleted file system

[Joel Fuhrman]

The delete filespace is a great command for getting rid of old data and
freeing up lots of tape space.  I know, as I wiped out the archives for 5 or
6 servers before realizing that it wasn't just deleting backups.

This command should require an entry in the TYPE= field instead of
defaulting to all.  Also the query filespace command should have a
TYPE= parameter which defaults to ALL (for backupward compatability).

On Fri, 17 Aug 2001, Peter Gotwalt wrote:

> Watch out with the delete filespace command. When doing so all the archived
> files (comming from that filespace) are deleted too! And is that what you
> want?
> So check first if there are any archived files connected to that
> filesystem - save then - and then you can do a delete filespace.
>
> Peter Gotwalt
>
> - Original Message -
> From: "David Longo" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 16, 2001 8:54 PM
> Subject: Re: how to EXPIRE UNIX files from unmounted/deleted file system
>
>
> To delete a filesystem from backup of a UNIX system is easy.
> To see for sure how it is, do a : q filespace nodename *
> this will show you filespace names as stored.  Then do
> delete filespace nodename filespacename
> Don't remember if it totally goes away then or at next expiration,
> but it will be gone from all tapes for sure at next expiration/reclamation
> run.
>
> David Longo
>
> >>> [EMAIL PROTECTED] 08/16/01 02:13PM >>>
> Hello all,
> In my seemingly never ending quest to get my tape retention clean, I
> have come across a UNIX CLIENT problem.  There were some file systems that
> were created for doing a temporary move/copy procedures.  While the File
> system existed, it was backed up.  Now I have a tape that is 5 months old
> and has a bunch of data on it that worthless but does not want to change to
> a status of INACTIVE.  I know I could take the tape and scratch it with a
> DISCARD DATA option, but I want to do this in a clean way and make it a part
> of the Stand Operating Procedure.  Does anyone know the proper change to put
> into the include/exclude list so this UNIX client will have these files
> marked INACTIVE?
> Matt
>
>
>
> "MMS " made the following
>  annotations on 08/16/01 15:01:58
> 
> --
> This message is for the named person's use only.  It may contain
> confidential, proprietary, or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it, and notify the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient.  Health First reserves the right to monitor all e-mail
> communications through its networks.  Any views or opinions expressed in
> this message are solely those of the individual sender, except (1) where the
> message states such views or opinions are on behalf of a particular entity;
> and (2) the sender is authorized by the entity to give such views or
> opinions.
>
> 
> ==
>

Re: Option file and optionset

[Joel Fuhrman]

Go get the redbook whose title is something like "getting started with
ADSM".  It will save you a lot of false starts.

I use something like this:

/* Base Option Set */

define cloptset  base description='Base Set'
define clientopt base dirmc dir
define clientopt base schedmode prompted
define clientopt base TxnByteLimit 25600

/* Windows Option Set */

copy cloptset base win
update cloptset win description='Windows Clients'
/* Exclude files that cannot be recovered without corrupting the */
/* Operating System or ADSM itself. */
define clientopt win inclexcl 'exclude "?:\microsoft uam volume\...\*"'
   seq=3
define clientopt win inclexcl "exclude ?:\...\*.swp" seq=6
define clientopt win inclexcl 'exclude "?:\...\EA DATA. SF"' seq=9
define clientopt win inclexcl "exclude ?:\...\pagefile.sys" seq=12
... etc ...

On Tue, 10 Oct 2000, Walker, Lesley R wrote:

> Michel Engels wrote:
> > You have to combine both syntaxes. an example would look like:
> >
> > DEF CLIENTO FRED INCLEXCL EXCLUDE "/foo/*"
> >
> Well I thought this looked hopeful, but no such luck.  It still complains
> about EXCLUDE as an invalid keyword.  The full output is as follows:
>
> tsm: TESTSERVER>def cliento inclexcl exclude /kernel/genunix
> ANR2056E DEFINE CLIENTOPT: Invalid option name - EXCLUDE. Retry using
> the full optionname.
> ANS8001I Return code 3.
>
> > "Walker, Lesley R" <[EMAIL PROTECTED]> on 10/09/2000 06:16:26 AM
> >
> > While we're on this topic, can someone give an example of the syntax
> > (3.7.3
> > on Solaris) to specify an include/exclude statement in the client option
> > set?  I've read the Admin Ref, and tried a couple of ways but it comes
> > back
> > with errors:
> >
> > DEF CLIENTO FRED EXCLUDE /foo/*
> > results in: Invalid option name - EXCLUDE"
> >
> > DEF CLIENTO FRED INCLEXCL "/path/filename"
> > DEF CLIENTO FRED INCLEXCL "ex /foo/*"
> > both result in: DEFINE CLIENTOPT: Invalid option value
> > (and yes, the file exists in the first one)
> >
> > What am I doing wrong?
> > Why doesn't the manual have an example, dammit?
>

aix 3.1.0.7 client with 4.1.x server

[Joel Fuhrman]

Is anyone backing up an AIX node using ADSM client level 3.1.0.7 to a 4.1.x
TSM Server?  If yes, have you done a restore.

As I read the web page
  http://www.tivoli.com/support/storage_mgr/compatibility.html
the ADSM client is "not supported"; but it doesn't say that it won't work.

Re: aix 3.1.0.7 client with 4.1.x server

[Joel Fuhrman]

I prefer to be on current levels.  However, I have some old AIX boxes that
have to stay on AIX 4.2.1 because of other software and/or they are not
worth the cost of the upgrade.  Since Tivoli choice to require 4.3.x, I now
have an unresolvable conflict between to software packages.

On Tue, 10 Oct 2000, Andy Raibeck wrote:

> Not only isn't it supported, but please bear in mind that 3.1
> will be going out of service in January 2001 (right around the
> corner).
>
> I would recommend upgrading to supported software levels rather
> than trying to use an unsupported configuration (even if you
> could make it work).
>
> Best regards,
>
> Andy
>
> Andy Raibeck
> IBM/Tivoli
> Tivoli Storage Manager Client Development
> e-mail: [EMAIL PROTECTED]
> "The only dumb question is the one that goes unasked."
>
> Is anyone backing up an AIX node using ADSM client level 3.1.0.7 to a 4.1.x
> TSM Server?  If yes, have you done a restore.
>
> As I read the web page
>   http://www.tivoli.com/support/storage_mgr/compatibility.html
> the ADSM client is "not supported"; but it doesn't say that it won't work.
>

Re: Autoresponders

[Joel Fuhrman]

If the list administrator could add a Precedence=bulk header, then most Unix
vacation programs will suppress the automatic reply.  That would reduce some
of the traffic and not require any action by the receivers.

On Tue, 10 Oct 2000, Gerhard Rentschler wrote:

> Hello,
> are all these automatic mail repliers really necessary? After sending mail
> to adsm-l I normally get more "out of office" replies than any other answers
> concerning my mail. I think it is a bad idea to have such a mail responder
> when being subscribed to a mailing list like adsm-l.
> Best regards
> Gerhard
>
> ---
> Gerhard Rentschleremail:[EMAIL PROTECTED]
> Regional Computing Center tel.   ++49/711/685 5806
> University of Stuttgart   fax:   ++49/711/682357
> Allmandring 30a
> D 70550
> Stuttgart
> Germany
>

Re: periodic ADSM/TSM shutdown

[Joel Fuhrman]

We had several occurances over many months that required bouncing the server
because a non-existant transaction had a high numbered log page locked.
This occurred after a problem with our ACSLS systems or a tape drive; but
not after every problem.  You have the problem when the percent utilization
of the log file doesn't reduce to near zero after a database backup.  Since
moving to 3.7.1 we have not had the problem.

On Thu, 12 Oct 2000, Davidson, Becky wrote:

> I am running
> AIX 4.3.3 on an S80
> ADSM 3.1.2.40 (yes I know I am trying to get us to upgrade but you ever see
> anything move fast in corporate world?)
>
> A couple of weeks ago I ran into a problem that the server couldn't
> successfully backup the database and my log file filled up...I solved it by
> cycling the ADSM server.  Then two days later BMC told us that we need to
> cycle the ADSM server on a regular basis.  What are everyone's thoughts on
> that?  I looked around and haven't seen any recommendations.
>
> TIA
>
> Becky Davidson
> Data Manager/AIX Administrator
> EDS/Earthgrains
> voice: 314-259-7589
> fax: 314-877-8589
> email: [EMAIL PROTECTED]
>

Re: TSM 3.73. include/exclude statements: where should they be?

[Joel Fuhrman]

One other comment.  If you modify the contents of the inclexcl file, you
must restart the scheduler service because it only reads this file on
startup.

On Sun, 5 Nov 2000, Richard Sims wrote:

> >I have inherited TSM totally on my own now and have to learn real fast.
> >I need to know where the include/exclude statements should go.
> >The manuals say:
> >  dsm.opt or dsmserv.opt or dsmserv.opt.smp
> >
> >The previous ADSM operator was to have setup the include/excludes, but when I
> >look in the *.opt files, I don't see any of them there.
> ...
> >Env.: 2 H70 RS6K, 4.3.3, TSM 3.7.3 server, client still at 3.1.?.
>
> Which "manuals" are you looking at?
> Chapter 7 of the ADSM 3.1 Unix Backup-Archive Clients manual, under
> Creating an Include-Exclude Options File says:
>
> You can specify the include and exclude options in the client system
> options file. You can also create an include-exclude options file to
> exclude specific files from backup services, and to assign specific
> management classes to files.
>
> Under the specific Include and Exclude options description:
>
> Place this option in the Include-Exclude options file or the client system
> options file (dsm.sys).
>
> Richard Sims, BU
>

Re: TSM 3.73. include/exclude statements: where should they be?

[Joel Fuhrman]

I have this statement in the server name stanza in the file dsm.sys
   Inclexcl /var/tsm/backup.exclude
Naturally the directory and file name can be anything you like.  This
applies to Unix.  NT/Windows does not use the include/exclude file.

On Sun, 5 Nov 2000, Richard Sims wrote:

> >I have inherited TSM totally on my own now and have to learn real fast.
> >I need to know where the include/exclude statements should go.
> >The manuals say:
> >  dsm.opt or dsmserv.opt or dsmserv.opt.smp
> >
> >The previous ADSM operator was to have setup the include/excludes, but when I
> >look in the *.opt files, I don't see any of them there.
> ...
> >Env.: 2 H70 RS6K, 4.3.3, TSM 3.7.3 server, client still at 3.1.?.
>
> Which "manuals" are you looking at?
> Chapter 7 of the ADSM 3.1 Unix Backup-Archive Clients manual, under
> Creating an Include-Exclude Options File says:
>
> You can specify the include and exclude options in the client system
> options file. You can also create an include-exclude options file to
> exclude specific files from backup services, and to assign specific
> management classes to files.
>
> Under the specific Include and Exclude options description:
>
> Place this option in the Include-Exclude options file or the client system
> options file (dsm.sys).
>
> Richard Sims, BU
>

Re: logexpire.c

[Joel Fuhrman]

Look for the subject "Informix ONBAR logical logs" in the January 1999 time
frame.  One of those messages contained the code.

On Tue, 7 Nov 2000, Roger C Cook wrote:

> I have seen references to this program for expiring Informix logs backed up
> to adsm. I would really appreciate it if someone could either e-mail this to
> me, or maybe suggest another suggestion using the onsmsync utility (which
> just gave me a "XBSA Error (BSAGetNextQueryObject): Backup object does not
> exist in Storage Manager." when I tried it). Thanks in advance.
>
> Roger C Cook
> [EMAIL PROTECTED]
> Backup Admin
> RCG Information Services
>

Re: General Help

[Joel Fuhrman]

The closest thing to an FAQ, is Richard Sims' web page
http://people.bu.edu/rbs/.  A great book for a newbie is the Redbook
SG24-5416-01 Getting Started with Tivoli Storage Manager.

On Tue, 7 Nov 2000, Joshua S. Bassi wrote:

> Read the manuals, go to class, and monitor this list...
>
>
> --
> Joshua S. Bassi
> IBM Certified- AIX Support, HACMP, SAN
> Enterprise Disk(Shark)& Tape Solutions
> Tivoli Certified Consultant - ADSM/TSM
> [EMAIL PROTECTED]
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Kevin Alfred
> Sent: Tuesday, November 07, 2000 10:33 AM
> To: [EMAIL PROTECTED]
> Subject: General Help
>
>
> Does anyone know of any good resources for FAQ's and other general help such
> as newsgroups or a webpage for TSM 4.1?  We just recently installed TSM and
> need help with configuration.
>
> Kevin Alfred
> PC Tech
> Elliott Electric Supply
> (936) 569-1184 ext. 4065
> mailto:[EMAIL PROTECTED]
>

3.7.3.8 tivoli.tsm.msg.en_US.server

[Joel Fuhrman]

I'm trying to install the TSM Server 3.7.3.8 patches to a 3.7.3.0
installation running on AIX 4.3.3.0.  My problem is that smit does not list
the tivoli.tsm.msg.en_US.server in the installable filesets.  Any
suggestions as to what would cause this?

-
selected section from .toc  -- wrapped lines are indented for readability
-
PA3738M.bff 4 R S tivoli.tsm.msg.en_US.server {
tivoli.tsm.msg.en_US.server 03.07.0003.0008 1 N U en_US Tivoli Storage
Manager Server Common Messages - US English
[
*prereq tivoli.tsm.msg.en_US.server  3.7.0.0
%
/usr/lib/nls/msg/en_US 8864
/usr/lpp/SAVESPACE 8864
/usr/lib/objrepos 8
INSTWORK 56 16
%
%
%
IC26881  1 LABEL LIBVOLUME W/ OVERWRITE=YES CAN OVERWRITE THE LABELS OF
Ultrium  1 - Add support for IBM LTO Ultrium Devices
Drv_Rtry  1 - Improvement to mount retry processing for drive in use in a
  shared library
]
}


installp -l -d /aix43/tsm/aixsrv  output

  Fileset NameLevel I/U Q Content
  
  tivoli.tsm.devices.rte  3.7.3.8S  b usr,root
#   Tivoli Storage Manager Device Support runtime

  tivoli.tsm.msg.en_US.server 3.7.3.8S  N usr
#   Tivoli Storage Manager Server Common Messages - US E

  tivoli.tsm.server.rte42 3.7.3.8S  N usr,root
#   Tivoli Storage Manager Server Runtime

-
lslpp -l tivoli.tsm.msg.en_US.devices  output
-
  Fileset  Level  State  Description


Path: /usr/lib/objrepos
  tivoli.tsm.msg.en_US.devices
 3.7.3.0  COMMITTED  Tivoli Storage Manager
Devices
 SMIT Menus - US English

--
lslpp -l tivoli*  shows all filesets as 3.7.3.0  COMMITTED
--

Re: Unsubscribe Request

[Joel Fuhrman]

"You may leave the list at any  time by sending a "SIGNOFF ADSM-L" command
to [EMAIL PROTECTED]"  The command goes in the body of the message, not
the subject line.

On Fri, 10 Nov 2000, manjunath krishna wrote:

> Hello,
>
> I am no longer in to ADSM, can anyone tell me how to
> unsuscribe, sorry for the inconvenience.
>
> Regds,
>
> Manjunath
>
> __
> Do You Yahoo!?
> Thousands of Stores.  Millions of Products.  All in one Place.
> http://shopping.yahoo.com/
>

Re: anyone use CLIENTACTION from external scheduler?

[Joel Fuhrman]

Sorry - the "SIGNOFF ADSM-L" response was for another question.

Re: anyone use CLIENTACTION from external scheduler?

[Joel Fuhrman]

"You may leave the list at any  time by sending a "SIGNOFF ADSM-L" command
to [EMAIL PROTECTED]"  The command goes in the body of the message, not
the subject line.

On Fri, 10 Nov 2000, MC Matt Cooper (2838) wrote:

> Hello all,
> I am looking at running some CLIENTACTION scripts from our TSM
> server on MVS.  I am trying to set it up so the client will do the backup,
> the MVS job/script waits for the backup to complete (WAIT=YES) , then have
> the script query the completion of the backup.  This way I can find a way to
> report back to our scheduler and it can go on with bringing the data bases
> backup on the client, at the proper time, if the backup completes
> successfully or notify the proper person if it doesn't.  I am playing around
> basically with the following script for starters.  I was wondering if anyone
> else has already went down this road and can tell me any pitfalls or better
> ways of getting this done.  I haven't even started on a script/rexx/? to
> parse the query response yet.
> Thanks Matt
>
> DEFINE CLIENTACTION DT0179 DOMAIN=STANDARD ACTION=SELECTIVE   -
>OBJECTS='"C:\*"  "D:\*" "D:\MY DOCUMENTS\*" '  WAIT=YES
>
> QUERY EVENT STANDARD * NODE=DT0179 FORMAT=DETAILED
>

Re: FWD: inclexcl problems

[Joel Fuhrman]

the exclude.fs should be just the name of the mount point, i.e.
   EXCLUDE.FS /ofa1/*  < this is wrong
   EXCLUDE.FS /ofa1< I think this will work


On Wed, 15 Nov 2000, Jeannine Walter wrote:

> All,
> I am having problems with the inclexcl list on this machine.  I have tried
> several different variations on it and it still seems to ignore the exclude
> statements.  On this box, it's a major problem since the excludes total
> almost 4TB of data.  The weird thing is that it seems to recognize and do
> the include statements.  Can anyone help?
> Tivoli recommendations:
> EXCLUDE /ofa/.../*
> EXCLUDE /ofa?/.../*
> EXCLUDE /ofa?/.../*
> EXCLUDE /ofa1?/.../*
> EXCLUDE /ofa_bkup/.../*
>
> My list:
> EXCLUDE /ofa/*
> EXCLUDE /ofa?/*
> EXCLUDE.FS /ofa1/*
> EXCLUDE.FS /ofa2/*
> EXCLUDE.FS /ofa3/*
> EXCLUDE.FS /ofa4/*
> EXCLUDE.FS /ofa5/*
> EXCLUDE.FS /ofa6/*
> EXCLUDE.FS /ofa7/*
> EXCLUDE.FS /ofa8/*
> EXCLUDE.FS /ofa9/*
> EXCLUDE.FS /ofa10/*
> EXCLUDE.FS /ofa11/*
> EXCLUDE.FS /ofa12/*
> EXCLUDE.FS /ofa13/*
> EXCLUDE.FS /ofa14/*
> EXCLUDE.FS /ofa15/*
> EXCLUDE.FS /ofa_bkup/*
>
> Neither are working.
> Output of q fi on the server:
> PDW2STL3B
> /ofaSUN  VxFS  94,894.0  89.7
> /ofa0   SUN  VxFS  56,320.0  58.1
> /ofa1   SUN  VxFS  56,320.0  62.3
> /ofa2   SUN  VxFS  56,320.0  50.2
> /ofa3   SUN  VxFS  56,320.0  48.0
> /ofa4   SUN  VxFS  56,320.0  61.4
> /ofa5   SUN  VxFS  17,154.0 100.0
> /ofa6   SUN  VxFS  17,154.0  91.2
> /ofa7   SUN  VxFS  56,320.0  46.0
> /ofa8   SUN  VxFS  56,320.0  45.0
> /ofa9   SUN  VxFS  56,320.0  44.8
> /ofa10  SUN  VxFS  34,309.0  75.6
> /ofa11  SUN  VxFS  34,309.0  72.8
> /ofa12  SUN  VxFS  56,320.0  31.5
> /ofa13  SUN  VxFS  34,309.0  68.4
> /ofa14  SUN  VxFS  34,309.0  11.8
> /ofa15  SUN  VxFS  34,309.0  79.9
> /ofa_bkup   SUN  VxFS  128,160.  31.9
>
>
> Thanks for any and all help.
> Jeannine walter
>

Re: FWD: inclexcl problems

[Joel Fuhrman]

No, its not a stupid suggestion.  I suspect the fast majority of TSM/ADSM
admins have been bit by this design.  I personnally think the product should
reread the file before each backup or archive.

On Thu, 16 Nov 2000, Ruddy STOUDER wrote:

>  May be a stupid suggestion but keep in mind that the scheduler must be
> stopped/restarted to take the new list into account.
>
> Ruddy
>
> --
> From: Joel Fuhrman
> To: [EMAIL PROTECTED]
> Sent: 11/15/2000 10:52:02 PM
> Subject: Re: FWD: inclexcl problems
>
> the exclude.fs should be just the name of the mount point, i.e.
>EXCLUDE.FS /ofa1/*  < this is wrong
>EXCLUDE.FS /ofa1< I think this will work
>
>
> On Wed, 15 Nov 2000, Jeannine Walter wrote:
>
> > All,
> > I am having problems with the inclexcl list on this machine.  I have
> tried
> > several different variations on it and it still seems to ignore the
> exclude
> > statements.  On this box, it's a major problem since the excludes
> total
> > almost 4TB of data.  The weird thing is that it seems to recognize and
> do
> > the include statements.  Can anyone help?
> > Tivoli recommendations:
> > EXCLUDE /ofa/.../*
> > EXCLUDE /ofa?/.../*
> > EXCLUDE /ofa?/.../*
> > EXCLUDE /ofa1?/.../*
> > EXCLUDE /ofa_bkup/.../*
> >
> > My list:
> > EXCLUDE /ofa/*
> > EXCLUDE /ofa?/*
> > EXCLUDE.FS /ofa1/*
> > EXCLUDE.FS /ofa2/*
> > EXCLUDE.FS /ofa3/*
> > EXCLUDE.FS /ofa4/*
> > EXCLUDE.FS /ofa5/*
> > EXCLUDE.FS /ofa6/*
> > EXCLUDE.FS /ofa7/*
> > EXCLUDE.FS /ofa8/*
> > EXCLUDE.FS /ofa9/*
> > EXCLUDE.FS /ofa10/*
> > EXCLUDE.FS /ofa11/*
> > EXCLUDE.FS /ofa12/*
> > EXCLUDE.FS /ofa13/*
> > EXCLUDE.FS /ofa14/*
> > EXCLUDE.FS /ofa15/*
> > EXCLUDE.FS /ofa_bkup/*
> >
> > Neither are working.
> > Output of q fi on the server:
> > PDW2STL3B
> > /ofaSUN  VxFS  94,894.0  89.7
> > /ofa0   SUN  VxFS  56,320.0  58.1
> > /ofa1   SUN  VxFS  56,320.0  62.3
> > /ofa2   SUN  VxFS  56,320.0  50.2
> > /ofa3   SUN  VxFS  56,320.0  48.0
> > /ofa4   SUN  VxFS  56,320.0  61.4
> > /ofa5   SUN  VxFS  17,154.0 100.0
> > /ofa6   SUN  VxFS  17,154.0  91.2
> > /ofa7   SUN  VxFS  56,320.0  46.0
> > /ofa8   SUN  VxFS  56,320.0  45.0
> > /ofa9   SUN  VxFS  56,320.0  44.8
> > /ofa10  SUN  VxFS  34,309.0  75.6
> > /ofa11  SUN  VxFS  34,309.0  72.8
> > /ofa12  SUN  VxFS  56,320.0  31.5
> > /ofa13  SUN  VxFS  34,309.0  68.4
> > /ofa14  SUN  VxFS  34,309.0  11.8
> > /ofa15  SUN  VxFS  34,309.0  79.9
> > /ofa_bkup   SUN  VxFS  128,160.  31.9
> >
> >
> > Thanks for any and all help.
> > Jeannine walter
> >
>

Re: Upgrade

[Joel Fuhrman]

Do you have "tivoli.tsm.devices.acsls" installed?  If yes, did you define
the drives using "smit adsmtape"?

On Fri, 17 Nov 2000, Shekhar Dhotre wrote:

> Hi Richard ,
> yes the drives  are not available to both AIX and tivoli ,
>   when i am trying to reconfigure them
>  by cfgmgr comand , gives following error.
>
>
> lsdev: 0514-521 Cannot find information in the predefined device
> configuration database for the customized device mt0.
> lsdev: 0514-521 Cannot find information in the predefined device
> configuration database for the customized device mt1.
> rmt0 Available 10-60-00-5,0 SCSI 4mm Tape Drive
> mt0  Available 20-60-00-3,0 N/A
> mt1  Available 20-60-00-4,0 N/A
>
> what i am thinking is to remove mt0 and mt1  and then run cfgmgr , also opening
> call with IBM
>
> thanks
> Shekhar
>
>
>
>
> "[EMAIL PROTECTED]/P=Internet/A= /C=us" on 11/17/2000 09:59:45 AM
> Please respond to "[EMAIL PROTECTED]/P=Internet/A= /C=us" @ X400
> To: "[EMAIL PROTECTED]/P=Internet/A= /C=us"@X400
> cc:
>
> Subject: Re: Upgrade
>
> >When upgrading from 3.7.2 to 3.7.4 it gave Following  messages
> >i am using ACSLS 5.3.0. seems to be drive related error.
> >
> ...
> >
> >lsdev: 0514-521 Cannot find information in the predefined device
> >configuration database for the customized device mt0.
>
> This AIX message is obliquely saying that the device driver is not installed
> for the device.  Go into SMIT and have a look around.
> The classic problem with 'mt' devices is that they are the *SM name for
> devices which are also known to the operating system as 'rmt' devices;
> and if the operating system goes at them first, it gets them and in effect
> takes then away from *SM.
>  Richard Sims, BU
>

Re: DIRMC - disadvantages only?

[Joel Fuhrman]

On DIRPOOL, what is the setting for "Cache Migrated Files"?

On Tue, 28 Nov 2000, William Boyer wrote:

> Another disadvantage is reclamation of the copypool for the DIRMC disk pool.
> If the primary pool is a disk pool, then TSM server only reads 1
> file/directory at a time during reclamation of the offsite copypool for the
> DIRMC primary pool. This makes the reclamation process REAL slow! Tivoli
> says 'working as designed' and would only take an enhancement request on it,
> not an APAR. Originally my storage pool was:
>
> DIRPOOL primary DISK
> DIRCOPYPOOL copypool TAPE
>
> To get around this 'feature' a co-worker of mine came up with this new
> stgpool structure:
>
> DIRPOOL primary DISK: NEXTPOOL->DIRFILE
> DIRFILE primary SEQUENTIAL on DISK
> DIRCOPYPOOL copypool TAPE
>
> The DIRPOOL is small, only 50MB. The DIRFILE is set to 100MB filesize. The
> client backkups put the directories in the DIRPOOL and then the daily server
> processes are:
>
> BA STG DIRPOOL DIRCOPYPOOL
> BA STG DIRFILE DIRCOPYPOOL
> UPD STG DIRPOOL HI=0 LO=0   (Migrate for DIRFILE)
>
> This way when reclamation occurs on DIRCOPYPOOL, the primary pool is a
> SEQUENTIAL pool and then TSM reads them in batches. It's a LOT faster this
> way.
>
> One problem I encountered with DIRMC was with some of the older TSM and ADSM
> clients. I was getting errors on the client when trying to send a directory
> entry that the  server was out of storage pool space in the DIRPOOL. Turns
> out this is an APAR (Can't remember the number) in the client where it
> calculates the size incorrectly on NT clients with security assigned for
> directories. To fix this upgrade to the latest client, or add
> SKIPNTPERMISSIONS YES to the DSM.OPT file on the client.
>
> Bill Boyer
> DSS, Inc.
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> France, Don G (Pace)
> Sent: Monday, November 27, 2000 4:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: DIRMC - disadvantages only?
>
> < clip >
>

Re: NT Disaster Recovery

[Joel Fuhrman]

Wanda published the W2k version on September 13th.

On Wed, 29 Nov 2000, Kelly J. Lipp wrote:

> Yes, the procedure remains the same: build an OS in a directory other than
> c:\winnt.  Install the client, restore c:, restore the registry and reboot
> to c:\winnt.
>
> I've way oversimplified this.  Wanda Prather published a procedure for this
> a couple of months ago.  A quick search of the archives for bare metal wanda
> will probably yield the article with the procedure.
>
> 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: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Armstrong, Brad
> Sent: Wednesday, November 29, 2000 12:45 PM
> To: [EMAIL PROTECTED]
> Subject: NT Disaster Recovery
>
>
> With NT Backup Client v3.1, you had to use a second "recovery" partition, to
> restore a complete NT system/boot partition including the registry.  For
> example, if you lost your c: drive.  Is this still the case with NT Backup
> Client v3.7?
>
> Brad Armstrong
> DTM Messaging
> Canada Customs Revenue Agency
> 613-941-6726
> [EMAIL PROTECTED]
>

Re: Database Space???

[Joel Fuhrman]

You need to specify the level and the type of hardware (aix, nt, etc) of
your TSM/ADSM server.  There was an older ADSM level that failed to expire
files properly.  Maybe you are running that level.

On Sun, 12 Nov 2000, Saad Al-Sakran wrote:

> Hi ever one
> My database size is increasing sharply and I do not do any changing if u have any 
>possible causes please tell me what is the proper way to deal with this situation.
>
> Thanks for all
> best regards
> Saad Al-Sakran
> LAN Administrator
>

query archive /*

[Joel Fuhrman]

TSM 3.7.2.0 client on AIX; TSM 3.7.3.8 server on AIX

The command
   dsmc q arch '/*' -subdir=yes

shows the archives for all but one filesystem.  To see the missing
filesystem requires
   dsmc q arch '/advscratch2/*' -subdir=yes

Any thoughts as to why the /advscratch2 archive would not be listed by the
first command?

Re: query archive /*

[Joel Fuhrman]

Boy is that lame!  It looks like the first file system used for an archive
is the file system used from then on.  So if the client doesn't know from
which file system the first archive was done, they are going to have a tough
time guessing where to find it.

On Tue, 5 Dec 2000, Cook, Dwight E wrote:

> To see information you need to be as specific as at least the file system...
> So /sdvscratch2 is a file system (I would bet)
> Dwight
>
> -Original Message-
> From: Joel Fuhrman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 04, 2000 3:04 PM
> To: [EMAIL PROTECTED]
> Subject: query archive /*
>
>
> TSM 3.7.2.0 client on AIX; TSM 3.7.3.8 server on AIX
>
> The command
>dsmc q arch '/*' -subdir=yes
>
> shows the archives for all but one filesystem.  To see the missing
> filesystem requires
>dsmc q arch '/advscratch2/*' -subdir=yes
>
> Any thoughts as to why the /advscratch2 archive would not be listed by the
> first command?
>

Re: query archive /*

[Joel Fuhrman]

Reversing the options had no affect.

The problem is that the "client" can not find all occurrences of an archive
unless they remember every filesystem that ever existed.

The dba's dump the database to a file and then archive it, re-using the
description for a previous archives of this database.  If the dump/archive
is done using different file systems due to space constraints (or it was
unmounted and it went to root), the client has to remember both filesystem
names.  If it happens to be a 3 year archive and one of the filesystems is
renamed or removed, the client is going to have to have a good memory and
g-d forbid they should quit.

It seems to me that there should be some syntax that the "client" can use to
find all their archive.  A simple 'q arch' and 'q arch desc="some desc"'
would do nicely.

On Wed, 6 Dec 2000, Richard Sims wrote:

> > TSM 3.7.2.0 client on AIX; TSM 3.7.3.8 server on AIX
> >
> > The command
> >dsmc q arch '/*' -subdir=yes
> >
> > shows the archives for all but one filesystem.  To see the missing
> > filesystem requires
> >dsmc q arch '/advscratch2/*' -subdir=yes
> >
> > Any thoughts as to why the /advscratch2 archive would not be listed by the
> > first command?
>
> The command documentation specifies coding options before filespace
> names, which may make a difference in your case.
> Always observe invocation syntax regarding the order of operands:
> some applications simply take and process each operand as it
> occurs in the command line, rather than going through them all
> first before figuring out what to do.  Keep in mind also that
> applications change from release to release, and so deviations
> from syntax that might work in one release might not in another.
>Richard Sims, BU
>

Re: LOG usage over 100% - backups failing

[Joel Fuhrman]

When I had this problem, several times, stopping and restarting the server
freed the pinned transaction log record.  The problem I had (on a older
level) was that the log file did not reduce after a database backup.  Other
things to consider is reducing your activity log retention value and to turn
off roll forward logging; at least until you figure out your problem.

On Mon, 11 Dec 2000, Vijay Havaralu wrote:

> Hello every one,
> We are running tsm-server ver 3.7.20 on aix 4.3.2 with about 400 gb per day
> backup.
> Our adsm db-size is close to 100 gb and growing daily.
> Almost each day log is overflowing with 100%, all backups fails, and server
> recovers & continues
> We are already using max 5.4 gb of log and can not increase any more on log
> volume.
>
> I appreciate, if anybody has any solutions this problem to reduce log usage
> or extend log beyond 5.4gb.
>
> Thanks, vijay.
>

emulex LP8000 HBA

[Joel Fuhrman]

I'm trying to configure a new H80 AIX 4.3.3 host with TSM 4.1.1 using an
Emulex LP8000 host bus adapter connected to an STK 9840 fibre channel disk
drive.  Per the installation instructions in the Quick Start Guidem I loaded
the fibre channel pre-req's for the fcrte fileset; but they seem to be for
the Emulex LP7000 card.  Config manager, cfgmgr, wants the level 8 drivers
which I don't believe IBM released.  So I loaded the drivers from Emulex.
Cfgmgr will configure the devices; but "smit tsm_devices" fails to list or
find any fiber channel devices.

If you have a working config using the Emulex LP8000 would you mind sharing
how you set it up?

Re: emulex LP8000 HBA

[Joel Fuhrman]

It took a process of comparing the different cards on the Emulex web
page.  Since its a short card with only 2 jumpers, it was an lp8000.  After
running cfgmgr, an lsdev -C shows lpfc0 as Emulex LP8000 Fibre Channel
Adapter.

On Wed, 13 Dec 2000, Suad Musovich wrote:

> How can you tell whether it's a LP8000 (short of ripping off the lid)?
>
> Cheers, Suad
> --
>
>
> On Wed, Dec 13, 2000 at 12:25:17AM -0800, Joel Fuhrman wrote:
> > I'm trying to configure a new H80 AIX 4.3.3 host with TSM 4.1.1 using an
> > Emulex LP8000 host bus adapter connected to an STK 9840 fibre channel disk
> > drive.  Per the installation instructions in the Quick Start Guidem I loaded
> > the fibre channel pre-req's for the fcrte fileset; but they seem to be for
> > the Emulex LP7000 card.  Config manager, cfgmgr, wants the level 8 drivers
> > which I don't believe IBM released.  So I loaded the drivers from Emulex.
> > Cfgmgr will configure the devices; but "smit tsm_devices" fails to list or
> > find any fiber channel devices.
> >
> > If you have a working config using the Emulex LP8000 would you mind sharing
> > how you set it up?
>

Re: emulex LP8000 HBA

[Joel Fuhrman]

Rejean Larivee - your analysis is correct.

I loaded the Emulex device drivers, devices.pci.lpfc.diag and
devices.pci.lpfc.rte.  I did that because `cfgmrg` needed the filesets,
devices.pci.df1000f8, devices.pci.fibre-channel, and
devices.pci.pciclass.0c0400 but they are on the AIX 4.3.3 cdrom nor could I
find them on the web site.  Were can I find these drivers?

On Wed, 13 Dec 2000, Burton, Robert wrote:

> Rejean...thanks for the info...how do you load firmware onto the emulex card
> after you have de-installed the emulex drivers.  You have to
> use the lputil utility to do this
>
> Robert Burton
> Open System Storage Analyst
> Royal Bank of Canada
> 315 Front St West
> Toronto, On, M5V 3A4
> 416-348-3849
> email: [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Rejean Larivee/Quebec/IBM [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 13, 2000 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: emulex LP8000 HBA
>
>
> Hello,
> your adapter needs to be configured as "fcs0" device
> for it to work with the TSM smit menus.
> Since your adapter is defined as an lpfc0 device, this tells
> me that you have loaded the "emulex" device driver.
> The Emulex device driver corresponds to the following filesets :
>  devices.pci.lpfc.diag
>  devices.pci.lpfc.rte
> Those filesets are provided by Emulex. In order to have
> the device recognized as a fcs0 device instead of lpfc0
> device, you need to remove those two filesets and
> rerun cfgmgr. You of course will need to have the proper
> IBM AIX fibre channel filesets installed. Those filesets
> are dicussed in the TSM server readme.
>
> Have a great day !
>
> -
> Rejean Larivee
> IBM TSM/ADSM Level 2 Support
>
>
>
> Joel Fuhrman <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/13/2000
> 01:58:24 PM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
>
> To:   [EMAIL PROTECTED]
> cc:
> Subject:  Re: emulex LP8000 HBA
>
>
> It took a process of comparing the different cards on the Emulex web
> page.  Since its a short card with only 2 jumpers, it was an lp8000.  After
> running cfgmgr, an lsdev -C shows lpfc0 as Emulex LP8000 Fibre Channel
> Adapter.
>
> On Wed, 13 Dec 2000, Suad Musovich wrote:
>
> > How can you tell whether it's a LP8000 (short of ripping off the lid)?
> >
> > Cheers, Suad
> > --
> >
> >
> > On Wed, Dec 13, 2000 at 12:25:17AM -0800, Joel Fuhrman wrote:
> > > I'm trying to configure a new H80 AIX 4.3.3 host with TSM 4.1.1 using
> an
> > > Emulex LP8000 host bus adapter connected to an STK 9840 fibre channel
> disk
> > > drive.  Per the installation instructions in the Quick Start Guidem I
> loaded
> > > the fibre channel pre-req's for the fcrte fileset; but they seem to be
> for
> > > the Emulex LP7000 card.  Config manager, cfgmgr, wants the level 8
> drivers
> > > which I don't believe IBM released.  So I loaded the drivers from
> Emulex.
> > > Cfgmgr will configure the devices; but "smit tsm_devices" fails to list
> or
> > > find any fiber channel devices.
> > >
> > > If you have a working config using the Emulex LP8000 would you mind
> sharing
> > > how you set it up?
> >
>

Re: FWD URL: http://www.emulex.com/ts/fc/docs/frame8k.htm

[Joel Fuhrman]

Thanks.  I had already loaded and installed the file 'lpfc.4.0.2.2.installp'
for AIX from that site.  It defines the adapter as 'lpfc0' but TSM expects
it to be "fcs0".

On Wed, 13 Dec 2000, Ed Finnell wrote:

> Perhaps???
>
> http://www.emulex.com/ts/fc/docs/frame8k.htm
>
>
>
>
> Edward(Ed) J. Finnell,III
> eSystems Proj. Mgr.
> www.ua.edu
>
>
> Download the Farscape Browser at http://www.scifi.com/farscape/
>

Re: upgrade from ADSM 3.1 to TSM 3.7

[Joel Fuhrman]

I sent a list of my problems to ADSM-L list when we did the upgrade; but I
don't have that list any more.  The biggest item is to be sure you have the
cdrom. Its required for license server.

On Thu, 14 Dec 2000, Thomas Denier wrote:

> > time is running to fast. The year will end in a few days and the support for
> my
> > ADSM too. So I have to upgrade mit ADSM 3.1 to TSM 3.7.
> > Server is OS390.
> >
> > Are there any known problems??? I looked at ADSM.ORG but found nothing. Does
> it
> > mean that I will have no bad surprise after upgrade???
>
> We just went through this upgrade with no major problems.
>
> When we ordered TSM 3.7, we got a product tape for the initial release and a
> cumulative PTF tape to bring the server up to a then recent service level. The
> install documentation claimed that there was no PTF tape. We had to call IBM
> just to get the volume serial number for the PTF tape that wasn't supposed to
> exist. IBM initially argued that they couldn't help us because we were asking
> for usage information rather than defect support. Ignoring the PTF tape was
> not an option; the initial release had some serious bugs that were fixed in
> the first few service levels.
>
> Dataset names are changed. If a file created during an ADSM install had a DSN
> that started with 'ADSM', the corresponding file created during a TSM install
> will have a DSN starting with 'TSM'. We had to change started task JCL, batch
> jobs that ran DSMADMC to automate administrative functions, and NetView
> allocate commands needed to allow NetView CLISTs to execute DSMADMC.
>
> TSM 3.7 introduces a new server option named FIXEDIOBUFSIZE, designed to
> improve the performance of VSAM I/O. This was initially implemented
> incorrectly and introduced a major data integrity exposure. Don't set this
> option to a non-zero value unless you are very sure you have the fix for the
> bug installed.
>
> We use SQL-BackTrack on some of our Unix clients to back up Oracle databases.
> Only very recent levels of the ADSM ODBC module are officially supported for
> used with a TSM 3.7 server. Our tests indicated that older ODBC modules would
> in fact work, but we upgraded to maintain vendor support for our configuration.
>

Re: TDP for Informix on HP-UX

[Joel Fuhrman]

What level is your customer on?  They "modified" the interface slightly in
one of the 3.7 levels such that the free library won't work.  Now you have
to pay an outlandish price for the TDP which is just a library almost
identical in size to the one that was free.

On Thu, 14 Dec 2000, Joshua S. Bassi wrote:

> But you don't need TDP for Informix!  I have customers using Onbar to
> backup Informix on HP-UX directly to the *SM API.
>
>
> --
> Joshua S. Bassi
> IBM Certified- AIX Support, HACMP, SAN
> Enterprise Disk(Shark)& Tape Solutions
> Tivoli Certified Consultant - ADSM/TSM
> [EMAIL PROTECTED]
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Keith Davey
> Sent: Tuesday, December 12, 2000 1:59 PM
> To: [EMAIL PROTECTED]
> Subject: Re: TDP for Informix on HP-UX
>
>
> Good Day Sir,
>
> There has never been support for Informix on HPUX.  However announcment
> 299-281 on IBMLink states that there is intent to release a 64 bit TDP for
> Informix on HPUX in a forthcomming release.  Unfortunatly I can not be
> specific on what release that will be in.
>
> Keith Davey
> Tivoli Systems
>
>
> On Tue, 12 Dec 2000, Talafous, John G. wrote:
>
> > What happened to support for TDP for Informix on HP-UX??? Looking at the
> > Tivoli site, I find that there is no information on this configuration.
> Now,
> > if I need a backup solution for this, am I going to be forced to look at
> > other solutions?  What happened, Tivoli?
> >
> > John G. Talafous  IS Technical Principal
> > The Timken CompanyGlobal Software Support
> > P.O. Box 6927 Data Management
> > 1835 Dueber Ave. S.W. Phone: (330)-471-3390
> > Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
> > [EMAIL PROTECTED]   http://www.timken.com
> >
>

command to create an activity log entry

[Joel Fuhrman]

Is there a command to create an activity log entry.  I didn't see anything
in the manual; but sometimes are there are undocumented features.  I have
this long running script from which I would like to log progress messages.

Re: TDP for Informix on HP-UX

[Joel Fuhrman]

We continued to use the library from the previous version until we ordered
the TDP product.  I can't remember if we had to use xbsa.o or bsashr10.o or
both.  We use AIX, so there may be some differences.  Since we were not
confortable relying on backups done with an unsupported configuration, we
paid the road bandit (Tivoli) and bought TDP for Informix.

On Fri, 15 Dec 2000, Talafous, John G. wrote:

> That is exactly what happened. My DBA indicates the interface USED to work.
> Then, when they upgraded (Both HP-UX and Informix), the interface just quit.
> That's the problem. Does anyone know of a workaround???
>
> Once again, Server is TSM 3.7.2 on AIX 4.3.2 (3466-C00). Client is HP-UX
> 11.0 with Informix 7.31 fc4 and fc7.
>
> John G. Talafous  IS Technical Principal
> The Timken CompanyGlobal Software Support
> P.O. Box 6927 Data Management
> 1835 Dueber Ave. S.W. Phone: (330)-471-3390
> Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
> [EMAIL PROTECTED]   http://www.timken.com
>
>
> -Original Message-
> From: Joel Fuhrman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 14, 2000 6:30 PM
> To: [EMAIL PROTECTED]
> Subject: Re: TDP for Informix on HP-UX
>
>
> What level is your customer on?  They "modified" the interface slightly in
> one of the 3.7 levels such that the free library won't work.  Now you have
> to pay an outlandish price for the TDP which is just a library almost
> identical in size to the one that was free.
>
> On Thu, 14 Dec 2000, Joshua S. Bassi wrote:
>
> > But you don't need TDP for Informix!  I have customers using Onbar to
> > backup Informix on HP-UX directly to the *SM API.
> >
> >
> > --
> > Joshua S. Bassi
> > IBM Certified- AIX Support, HACMP, SAN
> > Enterprise Disk(Shark)& Tape Solutions
> > Tivoli Certified Consultant - ADSM/TSM
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Keith Davey
> > Sent: Tuesday, December 12, 2000 1:59 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: TDP for Informix on HP-UX
> >
> >
> > Good Day Sir,
> >
> > There has never been support for Informix on HPUX.  However announcment
> > 299-281 on IBMLink states that there is intent to release a 64 bit TDP for
> > Informix on HPUX in a forthcomming release.  Unfortunatly I can not be
> > specific on what release that will be in.
> >
> > Keith Davey
> > Tivoli Systems
> >
> >
> > On Tue, 12 Dec 2000, Talafous, John G. wrote:
> >
> > > What happened to support for TDP for Informix on HP-UX??? Looking at the
> > > Tivoli site, I find that there is no information on this configuration.
> > Now,
> > > if I need a backup solution for this, am I going to be forced to look at
> > > other solutions?  What happened, Tivoli?
> > >
> > > John G. Talafous  IS Technical Principal
> > > The Timken CompanyGlobal Software Support
> > > P.O. Box 6927 Data Management
> > > 1835 Dueber Ave. S.W. Phone: (330)-471-3390
> > > Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
> > > [EMAIL PROTECTED]   http://www.timken.com
> > >
> >
>

Re: include/exclude

[Joel Fuhrman]

> (1) If I change the include/exclude file, when are the changes "read"?  Do I
> have to kill and then restart the daemon (dsmc)?

The include/exclude file is read when the program starts thus it must be
restarted after each change.

> (2) Is there any way to test my include/exclude statements using the
> backup/restore GUI?

Yes, the GUI marks excluded files with a red x and excluded file systems are
not shown in the list of files.  Again, you must restart the GUI each time
you change the include/exclude file.

Re: storagetek 9740 with drives 9840 and TSM 4.1 on AIX 4.3.3 platform

[Joel Fuhrman]

I have a powderhorn library but I believe the TSM setup is the same.  Before
doing the TSM config, configure the drives via "smit tsm_devices"..

tsm> register license file=1library.lic
tsm> def libr acs0 libt=acsls acsid=0
tsm> define drive acs0 mt0 device=/dev/mt0 acsdrvid=0,2,3,0 online=yes

Your acsid may be different and your acsdrvid most likely will be different.


On Tue, 2 Jan 2001, Giuseppe Taccone wrote:

> Is there anybody that have any experiences about this kind of configuration with TSM 
>4.1?
>
>
> library STK9740 Storagetek
> drives 9840
>
> TSM 4.1
>
> OS 4.3.3 AIX
>
>
> I've very a lot problems to use it with TSM 4.1 on AIX system  without ACSLS 
>software.
>
>
>please if there's somebody that have already done this 
>configuration send me email
>
>
>
>
> thank 
>you very much
>
>
>
> Giuseppe Taccone
>   TSM Manager
>  I.A.N. s.rl.
> V.le Fulvio Testi, 11
> 20092 Cinisello Balsamo (Mi)
> Tel +390261866362
> Fax +390261866315
> Email: [EMAIL PROTECTED]
>

Re: TSM 4.1.2 for Windows NT - ERROR

[Joel Fuhrman]

Is a client Optionset defined for this node on the server?

On Thu, 4 Jan 2001, Kleynerman, Arthur wrote:

> Hello all:
>
> I am seeing the following error in my dsmerror.log:
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\TEMPORARY INTERNET FILES\...\*' found while processing the client
> options passed by the server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\COOKIES\...\*' found while processing the client options passed by
> the server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\RECYCLE*\...\*' found while processing the client options passed by
> the server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\*.VIR' found while processing the client options passed by the
> server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\CACHE\...\*' found while processing the client options passed by the
> server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\*.TMP' found while processing the client options passed by the
> server.
> This might produce unexpected results.
>
> 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> ?:\...\*.MP3' found while processing the client options passed by the
> server.
> This might produce unexpected results.
>
>
> This is the output from "Q INCLEXL" on the client:
>
> tsm> q inclexcl
> Node Name: ARTHUR.KLEYNERMAN
> Session established with server TSM_SERVER_01: AIX-RS/6000
>   Server Version 3, Release 7, Level 3.0
>   Server date/time: 01/03/2001 10:37:35  Last access: 01/03/2001 10:35:52
>
> *** FILE INCLUDE/EXCLUDE ***
> Mode Function  Pattern (match from top down)  Source File
>  - -- -
> No exclude directory statements defined.
> Excl All   #\...\*.MP3Server
> Excl All   #\...\*.TMPServer
> Excl All   #\...\CACHE\...\*  Server
> Excl All   #\...\*.VIRServer
> Excl All   #\...\RECYCLE*\...\*   Server
> Excl All   #\...\COOKIES\...\*Server
> Excl All   #\...\TEMPORARY*FILES\...\*Server
> Excl All   #\IBMDOS.COM   dsm.opt
> Excl All   #\IBMBIO.COM   dsm.opt
> Excl All   #\...\SYSTEM32\CONFIG\...\*dsm.opt
> Excl All   #\...\SYSTEM32\CONFIG\*.*  dsm.opt
> Excl All   #\...\*.PARdsm.opt
> Excl All   #\...\PAGEFILE.SYS dsm.opt
> Excl All   #\...\386SPART.PAR dsm.opt
> Excl All   #\...\WIN386.SWP   dsm.opt
> Excl All   #\...\*.SWPdsm.opt
> Excl All   #\...\EA DATA. SF  dsm.opt
> Excl All   #\MICROSOFT UAM VOLUME\...\*.* dsm.opt
> Excl All   #\MICROSOFT UAM VOLUME\...\*   dsm.opt
> Excl All   #\MICROSOFT UAM VOLUME\*.* dsm.opt
> Excl All   #\MICROSOFT UAM VOLUME\*   dsm.opt
> Excl All   #\MACINTOSH VOLUME\...\*.* dsm.opt
> Excl All   #\MACINTOSH VOLUME\...\*   dsm.opt
> Excl All   #\MACINTOSH VOLUME\*.* dsm.opt
> Excl All   #\MACINTOSH VOLUME\*   dsm.opt
> No encryption include/exclude statements defined.
>
> Thanks!
>
> Arthur.
>
>
> ---
>
> The information contained in this e-mail message, and any attachment thereto, is 
>confidential and may not be disclosed without our express permission.  If you are not 
>the intended recipient or an employee or agent responsible for delivering this 
>message to the intended recipient, you are hereby notified that you have received 
>this message in error and that any review, dissemination, distribution or copying of 
>this message, or any attachment thereto, in whole or in part, is strictly prohibited. 
> If you have received this message in error, please immediately notify us by 
>telephone, fax or e-mail and delete the message and all of its attachments.  Thank 
>you.
>
> Every effort is made to keep our network free from viruses.  You should, however, 
>check this e-mail message, as well as any attachment thereto, for viruses.  We take 
>no responsibility and have no liability for any computer virus which may be 
>transferred via this e-mail message.
>

Re: TSM 4.1.2 for Windows NT - ERROR

[Joel Fuhrman]

Your "q inclexcl" is showing the results of mixing the server optionset with
the clients inclexcl list so you are not going to see duplicates in that
output.  What is on your clients inclexcl list?

On Thu, 4 Jan 2001, Kleynerman, Arthur wrote:

> Yes it is. This seems to suggest that there are duplicate include/exclude
> statements, but there are none, as far as I can tell.
>
> -Original Message-
> From: Joel Fuhrman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 04, 2001 3:03 PM
> To: [EMAIL PROTECTED]
> Subject: Re: TSM 4.1.2 for Windows NT - ERROR
>
>
> Is a client Optionset defined for this node on the server?
>
> On Thu, 4 Jan 2001, Kleynerman, Arthur wrote:
>
> > Hello all:
> >
> > I am seeing the following error in my dsmerror.log:
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\TEMPORARY INTERNET FILES\...\*' found while processing the client
> > options passed by the server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\COOKIES\...\*' found while processing the client options passed by
> > the server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\RECYCLE*\...\*' found while processing the client options passed by
> > the server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\*.VIR' found while processing the client options passed by the
> > server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\CACHE\...\*' found while processing the client options passed by
> the
> > server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\*.TMP' found while processing the client options passed by the
> > server.
> > This might produce unexpected results.
> >
> > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > ?:\...\*.MP3' found while processing the client options passed by the
> > server.
> > This might produce unexpected results.
> >
> >
> > This is the output from "Q INCLEXL" on the client:
> >
> > tsm> q inclexcl
> > Node Name: ARTHUR.KLEYNERMAN
> > Session established with server TSM_SERVER_01: AIX-RS/6000
> >   Server Version 3, Release 7, Level 3.0
> >   Server date/time: 01/03/2001 10:37:35  Last access: 01/03/2001 10:35:52
> >
> > *** FILE INCLUDE/EXCLUDE ***
> > Mode Function  Pattern (match from top down)  Source File
> >  - -- -
> > No exclude directory statements defined.
> > Excl All   #\...\*.MP3Server
> > Excl All   #\...\*.TMPServer
> > Excl All   #\...\CACHE\...\*  Server
> > Excl All   #\...\*.VIRServer
> > Excl All   #\...\RECYCLE*\...\*   Server
> > Excl All   #\...\COOKIES\...\*Server
> > Excl All   #\...\TEMPORARY*FILES\...\*Server
> > Excl All   #\IBMDOS.COM   dsm.opt
> > Excl All   #\IBMBIO.COM   dsm.opt
> > Excl All   #\...\SYSTEM32\CONFIG\...\*dsm.opt
> > Excl All   #\...\SYSTEM32\CONFIG\*.*  dsm.opt
> > Excl All   #\...\*.PARdsm.opt
> > Excl All   #\...\PAGEFILE.SYS dsm.opt
> > Excl All   #\...\386SPART.PAR dsm.opt
> > Excl All   #\...\WIN386.SWP   dsm.opt
> > Excl All   #\...\*.SWPdsm.opt
> > Excl All   #\...\EA DATA. SF  dsm.opt
> > Excl All   #\MICROSOFT UAM VOLUME\...\*.* dsm.opt
> > Excl All   #\MICROSOFT UAM VOLUME\...\*   dsm.opt
> > Excl All   #\MICROSOFT UAM VOLUME\*.* dsm.opt
> > Excl All   #\MICROSOFT UAM VOLUME\*   dsm.opt
> > Excl All   #\MACINTOSH VOLUME\...\*.* dsm.opt
> > Excl All   #\MACINTOSH VOLUME\...\*   dsm.opt
> > Excl All   #\MACINTOSH VOLUME\*.* dsm.opt
> > Excl All   #\MACINTOSH VOLUME\*   dsm.opt
> > No encryption include/exclude statements defined.
> >
> > Thanks!
> >
> > Arthur.
> >
> >
> > 

Re: TSM 4.1.2 for Windows NT - ERROR

[Joel Fuhrman]

With those statements shown below, you shouldn't be getting duplicates.
I'm about out of ideas.  It would seems as though a different dsm.opt files
is being used. I would rename (hide) this dsm.opt and see if the client
connects to the server.

On Fri, 5 Jan 2001, Kleynerman, Arthur wrote:

> Client (dsm.opt) include/exclude list:
>
> Exclude "*:\macintosh volume\*"
> Exclude "*:\macintosh volume\*.*"
> Exclude "*:\macintosh volume\...\*"
> Exclude "*:\macintosh volume\...\*.*"
> Exclude "*:\microsoft uam volume\*"
> Exclude "*:\microsoft uam volume\*.*"
> Exclude "*:\microsoft uam volume\...\*"
> Exclude "*:\microsoft uam volume\...\*.*"
> Exclude "*:\...\EA DATA. SF"
> Exclude *:\...\*.swp
> EXclude *:\...\win386.swp
> Exclude *:\...\386spart.par
> Exclude *:\...\pagefile.sys
> Exclude *:\...\*.par
> Exclude *:\...\SYSTEM32\CONFIG\*.*
> Exclude *:\...\SYSTEM32\CONFIG\...\*
> Exclude *:\IBMBIO.COM
> Exclude *:\IBMDOS.COM
>
> Server (client option set) include/exclude list:
>
> INCLEXCL   0Yes   exclude
> ?:\...\Temporary*Files\...\*
> INCLEXCL   1Yes   exclude
> ?:\...\cookies\...\*
> INCLEXCL   2Yes   exclude
> ?:\...\recycle*\...\*
> INCLEXCL   3Yes   exclude ?:\...\*.vir
>
> INCLEXCL   4Yes   exclude ?:\...\cache\...\*
>
> INCLEXCL   5Yes   exclude ?:\...\*.tmp
>
> INCLEXCL   6Yes   exclude ?:\...\*.mp3
>
>
>
>
> -Original Message-
> From: Joel Fuhrman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 04, 2001 7:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: TSM 4.1.2 for Windows NT - ERROR
>
>
> Your "q inclexcl" is showing the results of mixing the server optionset with
> the clients inclexcl list so you are not going to see duplicates in that
> output.  What is on your clients inclexcl list?
>
> On Thu, 4 Jan 2001, Kleynerman, Arthur wrote:
>
> > Yes it is. This seems to suggest that there are duplicate include/exclude
> > statements, but there are none, as far as I can tell.
> >
> > -Original Message-
> > From: Joel Fuhrman [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 04, 2001 3:03 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: TSM 4.1.2 for Windows NT - ERROR
> >
> >
> > Is a client Optionset defined for this node on the server?
> >
> > On Thu, 4 Jan 2001, Kleynerman, Arthur wrote:
> >
> > > Hello all:
> > >
> > > I am seeing the following error in my dsmerror.log:
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\TEMPORARY INTERNET FILES\...\*' found while processing the client
> > > options passed by the server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\COOKIES\...\*' found while processing the client options passed
> by
> > > the server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\RECYCLE*\...\*' found while processing the client options passed
> by
> > > the server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\*.VIR' found while processing the client options passed by the
> > > server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\CACHE\...\*' found while processing the client options passed by
> > the
> > > server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\*.TMP' found while processing the client options passed by the
> > > server.
> > > This might produce unexpected results.
> > >
> > > 01/02/2001 18:01:43 ANS1497W Duplicate include/exclude option 'EXCLUDE
> > > ?:\...\*.MP3' found while processing the client options passed by the
> > > server.
> > > This might produce unexpected results.
> > >
> > >
> > > This is the output f

TDP for Oracle and passwordaccess generate

[Joel Fuhrman]

The TDP for Oracle Version 2.1 documentation says the PasswordAccess must be
set to Prompted.  Usually you want "PasswordAccess Generate" which is
current setting for the Scheduler Service on this AIX host.

Is "PasswordAccess Prompted" a true requirement or a just case of bad
documentation.

TDP for Oracle license

[Joel Fuhrman]

I've registered the server license for TDP for Oracle.  Is there also a
client license?

The DBA's haven't been able to get the RMAN script to connect to the TSM
server.  They called Oracle and Oracle said the TDP for Oracle must be
installed from the cdrom in order to get the license.  I installed from a
down load file.  I didn't install from the CD because it is the ADSM
version.

TSM client: 4.1.2.0
TSM Server: 3.7.3.8
TDP Oracle: 2.1.1.0
AIX:4.3.3.6

Re: Full Recovery Log

[Joel Fuhrman]

Bouncing the TSM server should release the pinned log entry.

On Mon, 29 Jan 2001, Van Ruler, Ruud R SSI-ISES-31 wrote:

> L&g
>
> I am running TSM3.7 server on S/390.
> Recovery log is in normal mode.
> I am running a FULL DB backup every day.
> At this moment the Recovery Log  reached the maximum Available Space (MB).
> There is however space to Extend (Maximum Extension (MB): 1,696).
> But whatif at some point Maximum Extension (MB): 0 
> I cannot define anymore log volumes because i have reached the maximum
> Available Space !!!
>
> please advise what to do 
>
> thanks.
>
> Ruud van Ruler,  Shell Services International BV - ISES/32
> Our Data Storage Management home page:
> http://sww2.shell.com/os390/
> > Room 0C/G06
> > Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL
> Tel : +31 (0)70 - 3034644, Fax 4011, Mobile +31 (0)6-55127646
> Email Internet: [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
>
> R.vanRuler
>

Re: tape mount retention behaviour

[Joel Fuhrman]

I thought it always worked this way.  At one time I was going to put in a
request to have two mount retention times.  One for when there are no
pending request for a drive and the other for when there are pending
request.

On Mon, 5 Feb 2001, Joe Faracchio wrote:

> I recently upgraded from 3.1.2.20 to 3.7.2.0
> and notice a very annoying behaviour.
>
> The system keeps an idle tape mounted for the full retention period
> specified despite the pending mounts that are waiting.
>
> when / where will this be fixed???
>
> thanks ... joe.f.
>
> Joseph A Faracchio,  Systems Programmer, UC Berkeley
>

Re: tape mount retention behaviour

[Joel Fuhrman]

I'm using ACSLS (STK).  When I'm doing something like a simultaneous
migration of 3 storage pools to 2 tape drives, the behavior I observed, in
the past, is that when the first migration completes, it tape was not
unmounted until the mount retention period expires.  Thus the third
migration has to wait the mount retention period before it could get a tape.
I get around this by reducing the mount retention to zero during those
process that create tape queueing.  I will have to check if this behavior
still exists in my current level.


On Mon, 5 Feb 2001, Alex Paschal wrote:

> Joseph, Joel, out of curiosity, is there any chance are you using EXTERNAL
> library types?
>
> I know TSM will dismount an idle volume if it needs a mountpoint in 3494's
> as Kent has pointed out.  I think it may behave the same way with a SCSI
> library type also.
>
> In fact, on a hunch, I just now checked my TSM 3.7 Admin Guide, Appendix A,
> External Media Management Interface Description.  The valid return codes for
> a Volume Mount Request are:
> SUCCESS
> DRIVE_ERROR
> LIBRARY_ERROR
> VOLUME_UNKNOWN
> VOLUME_UNAVAILABLE
> CANCELLED
> TIMED_OUT
> INTERNAL_ERROR
> There is nothing that indicates waiting for a mount point.  That could
> account for idle volumes not being dismounted; TSM doesn't know that the
> External Library Manager is waiting for a mount point.
>
> Alex Paschal
> Storage Administrator
> Freightliner, LLC
> (503) 745-6850 phone/vmail
>
> -Original Message-
> From: Kent J. Monthei [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 5:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: tape mount retention behaviour
>
>
> We also use ADSM 3.1.2.20 (for Solaris) with IBM 3494 Libraries and have
> observed behavior consistent with that described by Joseph in the original
> email
> - an idle mount will be immediately dismounted if/when there is another
> mount
> pending and no other drive is available.  However, we also recently dropped
> the
> mount retention from the default 60 minutes down to just 5 minutes.
>
> Under what scenarios (or rationale) does it make sense to force tapes to
> remain
> mounted more than 5 minutes after a client backup session has completed?
>
> -Kent M., GSK
>
>
>
>
>
>
> [EMAIL PROTECTED] on 05-Feb-2001 19:57
>
>
>
> Please respond to [EMAIL PROTECTED]
>
> To:   ADSM-L
> cc:(bcc: Kent J Monthei/CIS/PHRD/SB_PLC)
> Subject:  Re: tape mount retention behaviour
>
>
>
>
> I thought it always worked this way.  At one time I was going to put in a
> request to have two mount retention times.  One for when there are no
> pending request for a drive and the other for when there are pending
> request.
>
> On Mon, 5 Feb 2001, Joe Faracchio wrote:
>
> > I recently upgraded from 3.1.2.20 to 3.7.2.0
> > and notice a very annoying behaviour.
> >
> > The system keeps an idle tape mounted for the full retention period
> > specified despite the pending mounts that are waiting.
> >
> > when / where will this be fixed???
> >
> > thanks ... joe.f.
> >
> > Joseph A Faracchio,  Systems Programmer, UC Berkeley
> >
>

Re: deleting copypool tapes.

[Joel Fuhrman]

Also, the string in the where clause needs to be quoted.

dsmadmc select * from volumes WHERE STGPOOL_name='COPYPOOL'

On Tue, 20 Feb 2001, Bernhard Unold wrote:

> 1) The poolnames in the output of dsmadmc are in CAPITAL letters. So you
> can try
>   dsmcadmc q vol | grep COPYPOOL
> or
>   dsmcadmc q vol | grep -i copypool
> 2) Try the following:
>   dsmadmc select * from volumes WHERE STGPOOL_name=COPYPOOL
> 3) You can get more info with
>   dsmadmc help select
>   dsmadmc select * from tables
> 
> 
> Shekhar Dhotre schrieb:
> > 
> > Hi ,
> > trying to get output of the copypool tapes ,
> > 
> > medrs2:dsmadmc -id=shekhar  -pa=himalaya q vol | grep copypool > /tmp/tape
> > medrs2:cd /tmp
> > medrs2:ls -la tape
> > -rw-r--r--   1 root system 0 Feb 20 09:13 tape   (This file shows 
>`0`  bytes  in size.  )
> > medrs2:
> > 
> > tsm: TSM>select * from volumes whertestgpool=copypool
> > ANR2907E Unexpected SQL operator token - '='.
> > 
> > |
> >  ...V
> >  select * from volumes whertestgpool=copypool
> > 
> > ANS8001I Return code 3.
> > 
> > tsm: TSM>help ANR2907E
> > ---
> > 
> > ANR2907E Unexpected SQL operator token - 'token'.
> > 
> > Explanation: A syntax error occurred because an SQL operator token was found
> > that can not legally be used at the specified position within the SQL
> > statement. Examples of SQL operator tokens are +, *, <, and =.
> > 
> > System Action: The SQL query is terminated.
> > 
> > User Response: None.
> > 
> > Bernhard Unold <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
> > 02/20/2001 06:54:04 AM
> > 
> > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > 
> > Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> > 
> > To:   [EMAIL PROTECTED]
> > cc:
> > 
> > Subject:  Re: deleting copypool tapes.
> > 
> > Tsm doesn't allow  wildchars in the volume name of the delete command.
> > So you can make a script with awk or something else. First generate a
> > list of the volumes:
> >   dsmcadmc q vol | grep copypool
> > or
> >   dsmadmc select * from volumes WHERESTGPOOL=COPYPOOL
> > WHEREDEVCLASS=STK9710
> > and take the list as input for awk to generate the delete commands.
> > 
> > Nicholas Cassimatis schrieb:
> > >
> > > Select the volumes with the GUI, and pick Delete!
> > >
> > > Nick (Don't mess with my GUI)  Cassimatis
> > > [EMAIL PROTECTED]
> > >
> > > "I'm one cookie away from happy." - Snoopy (Charles Schulz)
> > > - Forwarded by Nicholas Cassimatis/Raleigh/IBM on 02/19/01 01:19 PM
> > > -
> > >
> > > "Kelly J.
> > > Lipp"To: [EMAIL PROTECTED]
> > >  > > com> Subject: Re: deleting copypool
> > tapes.
> > > Sent by:
> > > "ADSM: Dist
> > > Stor Manager"
> > > <[EMAIL PROTECTED]
> > > IST.EDU>
> > >
> > > 02/14/01 02:46
> > > PM
> > > Please respond
> > > to lipp
> > >
> > > One at a time!
> > >
> > > Kelly J. Lipp
> > > Storage Solutions Specialists, Inc.
> > > PO Box 51313
> > > Colorado Springs CO 80949-1313
> > > (719) 531-5926
> > > Fax: (240) 539-7175
> > > Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
> > > www.storsol.com
> > > www.storserver.com
> > >
> > > -Original Message-
> > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> > > Shekhar Dhotre
> > > Sent: Wednesday, February 14, 2001 12:10 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: deleting copypool tapes.
> > >
> > > Hi all ,
> > >what is the command that will delete all (90)  copypooltapes  in one
> > > shot
> > > ..
> > > I am trying
> > >
> > >  DELETE VOLUME   *   WHERESTGPOOL=COPYPOOL WHEREDEVCLASS=STK9710
> > > discarddata=yes  with no luck
> > > 02/14/01   13:34:08  ANR2401E DELETE VOLUME: Volume * is not defined in a
> > >
> > > thanks
> > > shekhar
> > 
> > --
> > Mit freundlichen Grüßen
> > 
> > Bernhard Unold
> > (See attached file: Bernhard.Unold.vcf)
> > 
> >   
> >   Name: $RFC822.eml
> >$RFC822.emlType: application/x-unknown-content-type-eml_auto_file
> >   Encoding: base64
> 
> -- 
> Mit freundlichen Grüßen
> 
> 
> Bernhard Unold

Re: Onbar API versus Informix Data Protection?

[Joel Fuhrman]

No they are not the same.  As I understand it, TDP take the Onbar commands
and translates them into API commands.

On Wed, 21 Feb 2001, Hagen Finley wrote:

> Is there a distinction between utilizing the ADSM/TSM API to run onbar for informix 
>databases and the TSM Informix Data Protection product (TDP)? I can't quite get clear 
>whether the TDP and the API are
> synonymous, or whether the TDP is either a wholly different product or an 
>enhancement of the API. Thanks for your comments.
>
> Hagen Finley
> Longs Drugs
>
>
>

Re: FIVE questions for TSM 4.1.2 (server on AIX, clients on Windows)

[Joel Fuhrman]

> 5.  Can we "lock down" the option to restore files to any location other
> than their original location so that "first level" support can restore files
> from users' home directories, but not restore them to a location where they
> can view them?  EXAMPLE:  I'd like to off-load some of my less technical
> responsibilities to our Support Center, but I don't want to give them the
> security to 'snoop' other peoples' home directories.

With TSM, the end users can restore their own files as long as the "own" the
file (i.e. in Unix, having group write permission is not sufficient).

STK Libattach vs Advanced Device Support feature

[Joel Fuhrman]

Since you are using STK Libattach does that mean you did not have to license
the "Advanced Device Support" feature from Tivoli to control the powderhorn?

On Tue, 27 Feb 2001, Ron Pavan wrote:

> Not all STK Libraries require acsls, but the powderhorn does.  We have 2
> powderhorns in a SAN using STK 16 port switches (brocade), 10 9840FC Drives
> and a Dell 6450 Win2k Cluster running TSM 4.1.2.  We use STK Libattach
> software to make up the communications between TSM and ACSLS.
>
> -Original Message-
> From: Shekhar Dhotre [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 27, 2001 7:20 AM
> To: [EMAIL PROTECTED]
> Subject: Re: TSM, SAN and ACSLS
>
>
>
> What will  be affected if i don`t use ACSLS software ,  we are having
> STK9710 .
>
>
>
>
> "Collins, Brenda" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
> 02/27/2001
> 07:11:12 AM
>
> Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
> Sent by:  "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>
>
> To:   [EMAIL PROTECTED]
> cc:
>
> Subject:  Re: TSM, SAN and ACSLS
>
>
> We are using the STK Powderhorn with 9840 drives in a TSM 3.7 (AIX)
> environment and TSM4.1 (OS/390) environment. We will soon be implementing
> some fiber drives also to a new TSM (AIX) server.  Whenever you use the STK
> libraries, you are forced to use the ACSLS software also. We do have a tape
> SAN implemented.
> Brenda
>
> -Original Message-
> From: Walker, Lesley R [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 9:52 PM
> To: [EMAIL PROTECTED]
> Subject: TSM, SAN and ACSLS
>
>
> Sorry if this is an FAQ, I've spent a bit of time looking but haven't found
> a definitive answer.
>
> Is this possible:
>
> TSM 3.7.x on Solaris
>connected to
> SAN switch (don't know what model, but assume it's a supported one)
>connected to
> StorageTek PowderHorn (9840 drives, ACSLS controlled)
>
> >From a quick look at the Redbook (Using Tivoli Storage Manager in a SAN
> environment), SCSI libraries are supported from TSM 3.7 onwards, but I can't
> find any mention of ACSLS.
>
> Has anyone done it?  Tried it and failed?
>
> This is the configuration I am expected to implement, and I don't have much
> experience of SANs, so any hand-holding would be appreciated.
>
> --
> Lesley Walker
> Unix Engineering, EDS New Zealand
> [EMAIL PROTECTED]
> "I feel that there is a world market for as many as five computers"
> Thomas Watson, IBM corp. - 1943
>

Re: Why does a point in time restore try to restore deleted files.

[Joel Fuhrman]

On what date and time was the file deleted.

On Tue, 27 Feb 2001, Marc Layne wrote:

> Hi All
> I posted a question yesterday about point in time restore but i wish to
> clarify my question. Basically i need to know why if a file was backed up on
> the 10 October 2000  and subsequently deleted, and i do a point in time
> restore to February 23 2001.. why is it trying to restore the deleted file.
> PIT restore is done via the GUI. Even if i am doing full backups..surely if
> the file odes not exist..(has been deleted) then PIT restore should not try
> and restore it . I run a Expire inventory every day.
> rete=30
> reto=10
> TSM ver 3.7 for NT server
> TSM ver 3.7 for NT client
> Thanks
> Marc
> _
> Marc Layne
> Product Manager - Services, Storage and Software Solutions
> Faritec
> Mobile: +27 82 4169086email: [EMAIL PROTECTED]
> 
> Office:  + 27 21 7629702   http://www.faritec.co.za/
> 
> _
>
>
> "This message may contain information which is confidential, private or
> privileged in nature.   If you are not the intended recipient, you may not
> peruse, use, disseminate, distribute or copy this message or file which is
> attached to this message.  If you have received this message in error,
> please notify the sender immediately by e-mail,  facsimile or telephone and
> thereafter return and/or destroy the original message.
>  Any views of this communication are those of the sender except where the
> sender specifically states them to be those of Faritec (Proprietary) Limited
> ("Faritec") and/or Midrange Distribution Services (Pty) Ltd.
> Please note that the recipient must scan this e-mail and any attached files
> for viruses and the like.  While we do everything possible to protect
> information from viruses, Faritec accepts no liability of whatever nature
> for any loss, liability, damage or expense resulting directly or indirectly
> from the access and/or downloading of any files which are attached to this
> e-mail message."
>

Re: Wanted: NUMBERFORMAT=0

[Joel Fuhrman]

I agree with the concept. However I would like a distinct parameters say
"COMMASeparator [YES | NO]" which would effect the output for
process, session, and filesize values and DATESeparator [YES | NO] which
would effect the output for the date (and possible time).

On Thu, 1 Mar 2001, Peter Dümpert wrote:

> Hi TSM-development,
>isn't it possible to have a NUMBERFORMAT which just produces the
> SIMPLEST form of a number, i.e. W_I_T_H_O_U_T  ANY national separator ?
> 
> NUMBERFORMAT=1 is very near to what I want, but any 1000s-separator (the
> "comma") should be omitted too.
> 
> I don't want to present here various examples, but just point to items
> like a "Session id" growing bigger than 10  or "filesize 1,234,567"
> being just an INTEGER, so processing without any "hickhack" should be
> possible.
> 
> Hope some others, being fed up with the NUMBERFORMAT, will second.
> 
> -- 
> MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> Peter Dümpert   Email: [EMAIL PROTECTED]
> Rechenzentrum der Technischen Universität   Fax  : ++49/531/391-5549
> D 38092 BraunschweigTel  : ++49/531/391-5535
>  
> 

Re: Urgent: server down , lvmAddVol error on restart

[Joel Fuhrman]

If your server level is 4.1.x or lower then "THE ABSOLUTE MAXIMUM SIZE OF A
LOG IS 5.3 gb".

On Thu, 16 May 2002, chris rees wrote:

> Hi ALL
>
> In a bit of a pickle. TSM server has crashed as the log filled up.
> The log size is 5196M.
>
> I have dsmfmt another log file of 1024Mb and tried to do
> dsmserv extend log /volumename 100
> but get the dreaded lvmAddVol error.   I thought the limit was 5.5Gb hence
> would have expected to be able to extend this.
>
> any ideas
>
> TIA
>
> Chris
>
> _
> Join the world s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>

Re: SQL statement

[Joel Fuhrman]

search www.adsm.org and will find hundreds of SQL examples.

On Wed, 29 May 2002, Bernard Rosenbloom wrote:

> I have an immediate need to create a list of all my registered nodes and
> the storage pool(s) each node backs up to. I know almost nothing about
> creating an SQL statement so if anyone can assist, I would appreciate it
> very much.
>
>
>
> Thank You
> Bernard Rosenbloom
> [EMAIL PROTECTED]
>

Re: q libv showed 'private' STATUS but blank LAST_USE

[Joel Fuhrman]

Check the tape out and then back in with a status=scratch.

On Wed, 5 Jun 2002, Chuck Lam wrote:

> TSM 4.1.4 running in AIX 4.3.3
>
> After I came back from the Memorial weekend, I noticed
> a bunch of tapes with 'private' Status but blank
> Last_Use when I did a 'q libv'.  'q vol volume_name'
> on these tapes returned with 'NO MATCH'.  There were
> problems with one of the tape drives over that weekend
> and a lot of tapes were marked as 'UNAVAILABLE' by
> TSM, but I was able to make them work again by
> modifying the access=readwrite.  However, I cannot
> even 'q volume' this bunch of tapes, since TSM seemed
> to lose track of them.
>
> Can anyone help me with this problem?
>
> TIA
>
>
>
> __
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>

Re: good readings

[Joel Fuhrman]

Get the redbook "Getting Started with Tivoli Storage Manager: Implementation
Guide

On Wed, 12 Jun 2002, Rick W wrote:

> Hey all,
> I am a bit new to the list and am in a position to implement TSM 4.2 and
> would like to get some good reading material so that I can better
> understand TSM.  Would anyone have some good recommendations?  I have a
> couple of the redbooks and have been going through them but if anyone would
> have some further recommendations (websites, books, etc) I would appreciate
> them.
>
> R.
>

2 volume ranges with distinct usage in 1 library

[Joel Fuhrman]

I have 2 sites each one contains an STK silo. Currently I write my offsite
storage tapes where the operators are located. The local copy is written at
the other site.  Each site has a unique tape number range which makes it
easy to track the offsite volumes. However because the operator's site has a
new backup generator, we now want to write the local copy at this site.

Is there a way to have one volume number range of scratch tapes be used for
the primary backup while using a second volume number range of scratch tapes
for the offsite copy pool all within one silo?

I know its possible to define 2 libraries which share the same ACSLSid. But
this solutiuon seems to require splitting the drives between the 2 libraries
and that is not an acceptable.  Or is there a way to define the same drive
in 2 libraries without creating a drive contention problem?

Re: TSM Scheduler on WinNT and Win2K

[Joel Fuhrman]

Someone on this list noted that this problem seems to occur on
multi-processor systems.  I use the restart recover action to avoid the
problem.

On Thu, 19 Sep 2002, Martinez, Matt wrote:

> Hi all,
>
> The TSM Scheduler Service on most of my Win2k and NT4.0 boxes will
> not start up after a reboot. When I go in and start the service manually it
> starts up fine. I can't seem to find any errors in the Event Log. Any help
> you can provide will be appreciated.
>
> Thanks,
> Matt
>

Re: Problem deleting filespace SYSTEM OBJECT

[Joel Fuhrman]

and did it solve the problem and were you on 5.1.1.6?

On Thu, 19 Sep 2002, Burton, Robert wrote:

> we are having the same problemand the auditdb for a 37 GB database took
> over 26 HRs...
> 
> thanks
> Robert Burton 
> Enterprise Storage Network Analyst 
> Royal Bank of Canada 
> 315 Front St West 
> Toronto, On, M5V 3A4 
> * 416-348-3849 
> * [EMAIL PROTECTED]  
> 
> 
> -Original Message-
> From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 19, 2002 11:42 AM
> To: [EMAIL PROTECTED]
> Subject: Problem deleting filespace SYSTEM OBJECT
> 
> 
> Hello,
> I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
> Using the command
> del filespace rus_zsdsinz 'SYSTEM OBJECT'
> I get the following messages in the activity log:
> 09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
> the
>BACKGROUND at 16:20:33.
> 09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
> RUS_ZSDSINZ
>started as process 452.
> 09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
> data)
>for node RUS_ZSDSINZ started.
> 09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
> deleting
>group leader 0 585684848.
> 09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
> the
>BACKGROUND completed with completion state FAILURE at
>16:20:34.
> I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
> and retry the delete filespace command. It didn't help. The next advice was
> to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
> filespace. The next thing to do would be a dsmserv auditdb. However, this
> would take a lot of time with my 55 GB database.
> 
> Has anyone else seen this? Level 1 told me that he found only one similar
> problem.
> Best regards
> Gerhard
> ---
> Gerhard Rentschleremail:[EMAIL PROTECTED]
> Regional Computing Center tel.   ++49/711/685 5806
> University of Stuttgart   fax:   ++49/711/682357
> Allmandring 30a
> D 70550
> Stuttgart
> Germany
> 
> 
>--
> This e-mail may be privileged and/or confidential, and the sender does not waive any 
>related rights and obligations. Any distribution, use or copying of this e-mail or 
>the information it contains by other than an intended recipient is unauthorized. If 
>you received this e-mail in error, please advise me (by return e-mail or otherwise) 
>immediately. 
> 
> Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et 
>obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message 
>ou des renseignements qu'il contient par une personne autre que le (les) 
>destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, 
>veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen. 
> 
> 
> ==
> 

Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND

[Joel Fuhrman]

To me is seems as though the worker sessions should be informing the control
session as to the amount of work they have done.  Each time the worker
reports in, the control session would send a heart beat to the server thus
avoiding this annoying timeout.

On Wed, 18 Sep 2002, Seay, Paul wrote:

> The problem is the summary table is broken right now.  I just got off the
> phone with Level 2.  We think we have identified the cause of the problem.
> As it turns out the SUMMARY table records are written by the "control"
> session, not the actual backup sessions.  What is happening is the control
> sessions are timing out and a new control session is being formed to send
> the statistics information.  If you look at the start and end timestamps
> with the following select and then look at the activity log you will see
> what I am talking about.  This select lists all sessions that have a byte
> count of zero.  You will notice the start and end timestamps are usually the
> same or only a few seconds apart.  The reason is the wrong numbers are being
> recorded.
>
> select entity, number, start_time, end_time from summary where bytes=0 and
> start_time >current_timestamp-5 days and activity = 'BACKUP' order by 1,3
>
> The issue is I can envision this is going to be very difficult to fix in the
> current design.
>
> It will be interesting.
>
>
>
> Paul D. Seay, Jr.
> Technical Specialist
> Naptheon Inc.
> 757-688-8180
>
>
> -Original Message-
> From: Mark Bertrand [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2002 2:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Backup reporting
>
>
> Paul and all,
>
> When I attempt to use any of the following select statements my "Total MB"
> returned is always 0. I get my list of nodes but there is never any numbers
> for size.
>
> Since this is my first attempt at select statements, I am sure I doing
> something wrong. I have tried from command line and through macro's.
>
> I am trying this on a W2K TSM v4.2.2 server.
>
> Thanks,
> Mark B.
>
> -Original Message-
> From: Seay, Paul [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 16, 2002 11:43 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Backup reporting
>
>
> See if these will help:
>
> /* SQL Script:   */
> /*   */
> /* backup_volume_last_24hours.sql*/
> /* Date   Description*/
> /* 2002-06-10 PDS Created*/
>
> /* Create Report of total MBs per each session */
>
> select entity as "Node Name  ", cast(bytes/1024/1024 as decimal(10,3))
> as "Total MB  ",  cast(substr(cast(end_time-start_time as char(17)),3,8) as
> char(8)) as "Elapsed  ", substr(cast(start_time as  char(26)),1,19) as
> "Date/Time  ", case when cast((end_time-start_time) seconds as
> decimal) >0 then  cast(bytes/cast((end_time-start_time) seconds as
> decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as  "
> MB/Sec" from summary where start_time>=current_timestamp - 1 day and
> activity='BACKUP'
>
> /* Create Report of total MBs and length of backup for each node */
>
> select entity as "Node Name  ", cast(sum(bytes/1024/1024) as
> decimal(10,3)) as "Total MB",  substr(cast(min(start_time) as
> char(26)),1,19) as "Date/Time   ",
> cast(substr(cast(max(end_time)-min(start_time)  as char(20)),3,8) as
> char(8)) as "Length   " from summary where start_time>=current_timestamp -
> 22 hours and  activity='BACKUP' group by entity
>
> /* Create Report of total backed up*/
>
> select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup"
> from summary where start_time>=current_timestamp  - 1 day and
> activity='BACKUP'
>

Re: Problem deleting filespace SYSTEM OBJECT

[Joel Fuhrman]

Yes I have this problem.  The reason I needed to delete the system objects
was because they were not being deleted by EXPIRE INVENTORY and they were
consuming 30% of my database space.

My suggestion to all TSM admins is to do a
   QUERY OCCUPANCY * "SYSTEM OBJECT"
to verify that you do not have excessive copies.

On 5.1.1.4, I did the CLEANUP BACKUPGROUP and I still could not delete the
system objects.  I reran the cleanup command numerous times and each time it
reported inspecting and deleting fewer objects than the previous run.  The
number was still in the 2000 range when I gave up and installed 5.1.1.6.
On this level, expiration still failed to delete the system objects but I
could manually delete most of them.  As of now I have 6 servers where I can
not delete the system objects. I have an open PMR.

On Thu, 19 Sep 2002, Gerhard Rentschler wrote:

> Hello,
> I ran into the following problem with TSM 5.1.1.4 on AIX 4.3.3.
> Using the command
> del filespace rus_zsdsinz 'SYSTEM OBJECT'
> I get the following messages in the activity log:
> 09/18/02 16:20:33 ANR0984I Process 452 for DELETE FILESPACE started in
> the
>BACKGROUND at 16:20:33.
> 09/18/02 16:20:33 ANR0800I DELETE FILESPACE * (fsId=4) for node
> RUS_ZSDSINZ
>started as process 452.
> 09/18/02 16:20:33 ANR0802I DELETE FILESPACE * (fsId=4) (backup/archive
> data)
>for node RUS_ZSDSINZ started.
> 09/18/02 16:20:34 ANRD imfsdel.c(1860): ThreadId<84> Error 1123
> deleting
>group leader 0 585684848.
> 09/18/02 16:20:34 ANR0985I Process 452 for DELETE FILESPACE running in
> the
>BACKGROUND completed with completion state FAILURE at
>16:20:34.
> I opened a PMR. Level 1 suggested to run the command "cleanup backupgroup"
> and retry the delete filespace command. It didn't help. The next advice was
> to upgrade to TSM 5.1.1.6 and retry the cleanup backupgroup and del
> filespace. The next thing to do would be a dsmserv auditdb. However, this
> would take a lot of time with my 55 GB database.
>
> Has anyone else seen this? Level 1 told me that he found only one similar
> problem.
> Best regards
> Gerhard
> ---
> Gerhard Rentschleremail:[EMAIL PROTECTED]
> Regional Computing Center tel.   ++49/711/685 5806
> University of Stuttgart   fax:   ++49/711/682357
> Allmandring 30a
> D 70550
> Stuttgart
> Germany
>

Re: Select command to q client name and version

[Joel Fuhrman]

select left(platform_name,13) as "PLATFORM_NAME"  -
,  left(node_name,13) as "NODE_NAME " -
,  cast(client_version  as CHAR(1)) ||  '.' -
|| cast(client_release  as CHAR(1)) ||  '.' -
|| cast(client_levelas CHAR(1)) ||  '.' -
|| cast(client_sublevel as CHAR(2)) as "LEVEL  " -
,  left(option_set,6)   as "OPTION_SET" -
,  contact as "Contact " -
   from nodes

On Thu, 19 Sep 2002, Alexander Verkooijen wrote:

> On 19-Sep-02 Karla Ross wrote:
>
> > Does anyone have a select command that will show me the clients and what
> > version of TSM they are running?  My TSM servers are running TSM v4.1, 4.2,
> > and 5.1.
>
> select node_name,client_version,client_release,client_sublevel from nodes
>
> ---
> Alexander Verkooijen([EMAIL PROTECTED])
> Senior Systems Programmer
> SARA High Performance Computing
>

Re: Anyone tried 5.1.1.6?

[Joel Fuhrman]

I found that the SYSTEM OBJECT which were not unicode were never deleted
unless I did it manually.  A QUERY OCC * "SYSTEM OBJECT" (without the
NAMETYPE=UNICODE option) will let you know if you have that problem.  Also,
did you run the command CLEANUP BACKUPGROUPS?  For me, on 5.1.1.4 it ran but
never cleaned everything up and it wouldn't run on 5.1.1.6.  I finally had
to do an AUDITDB FIX=YES.

On Tue, 24 Sep 2002, Gretchen L. Thiele wrote:

> Hi Fred,
>
> I just took a v4.2.2.12 AIX server to v5.1.1.6 last Saturday.
> All I can say is 'not pretty'. This is due to the SYSTEM OBJECT
> problem. If you don't know what this is, you will soon if you
> have WinXP and Win2K clients backing up to v4 and pre v5.1.1.6
> servers.
>
> The basic problem is that TSM isn't expiring anything in the
> SYSTEM OBJECTs filespace. Some of our clients had over 20GB
> in these filespaces! Needless to say, the database blew up
> while trying to find out what was going on.
>
> To see if you have this problem, you can type in
>
> show version  "SYSTEM OBJECT" namet=uni > file
>
> (only use namet=uni if the filespace is unicode). Then
> check through the file and look for the number of occurrences
> of a file, say ROUTE.EXE. A normal SYSTEM OBJECT filespace,
> with four versions, shouldn't be over a gig.
>
> The good news is that v5.1.1.6 does NOT have the SYSTEM
> OBJECT problem and the new server is doing very well.
>
> I am writing up the post mortem on the conversion and will
> post to the list later this week (at the request of Tivoli
> level 2).
>
> Gretchen Thiele
> Princeton University
>

Re: Problem deleting filespace SYSTEM OBJECT

[Joel Fuhrman]

My responses are within the text ...

On Tue, 24 Sep 2002, Gerhard Rentschler wrote:

> Hello,
> in the meantime I upgraded to 5.1.1.6. With this level I could delete the
> filespace without problem.
> However, I couldn't resist to try "cleanup backupgroup" again. Under 5.1.1.4
> it worked. It only seemed strange that it obviously didn't finish its work,
> as Joel described:
> > On 5.1.1.4, I did the CLEANUP BACKUPGROUP and I still could not delete the
> > system objects.  I reran the cleanup command numerous times and
> > each time it
> > reported inspecting and deleting fewer objects than the previous run.
>
> On 5.1.1.6 cleanup backupgroup stopped immediately with return code 4. In
> the activity log I found the following messages:
> 09/24/02 10:31:51 ANR2017I Administrator GERHARD issued command: CLEANUP
>BACKUPGROUPS
> 09/24/02 10:31:51 ANRD imutil.c(6663): ThreadId<67> Failure deleting
>member 0 585368742 for group 1637 3 - encountered
>repeatedly in loop.
> 09/24/02 10:31:51 ANRD imutil.c(3931): ThreadId<67> Error 19
> deleting
>dependents for node 0 fs 0 and leader 1637 3.
> Now I'm little bit concerned. Is cleanup backupgroup broken or is it my
> database?
>

The CLEANUP did the same thing for me on 5.1.1.6 until I did an AUDITDB
FIX=YES.  After doing the auditdb, it ran properly.

> > My suggestion to all TSM admins is to do a
> >QUERY OCCUPANCY * "SYSTEM OBJECT"
> > to verify that you do not have excessive copies.
> >
> How can you tell from the output of the q occ command how many excessive
> copies you have?

For most of my servers, the system object consists of about 1800 objects and
require 230 MB. Do the math and you will know if you have excessive backups.

>
>
> BTW, I cannot confirm that system objects are not expired. I used the
> following SQL statement in the middle and at the end of an expiration
> process:
> select sum(num_files) from occupancy where filespace_name='SYSTEM OBJECT'
> The first number I got was 1043479, the last 1012998. So I got rid of at
> least 30481 files.
>
> Best regards
> Gerhard
> ---
> Gerhard Rentschleremail:[EMAIL PROTECTED]
> Regional Computing Center tel.   ++49/711/685 5806
> University of Stuttgart   fax:   ++49/711/682357
> Allmandring 30a
> D 70550
> Stuttgart
> Germany
>

Re: WIN2k Clients Backing up Executables ALL THE TIME

[Joel Fuhrman]

> All system files are backed up every time regardless of whether they are
> changed.

This is thanks to the stupidity of Microsoft's inclusion of the event logs
as part of the system objects.

On Thu, 26 Sep 2002, Rushforth, Tim wrote:

> Windows 2000 backs up the system files (a whole whack of dll's and exe's) as
> part of the system object.  The default domain for an incremental includes
> the System Object.  You can change the default ALL-LOCAL domain to not
> include the system object BUT be aware that the SYSTEM OBJECT also contains
> the registry, event logs, cluster db, active db, comm db ...)
>
> All system files are backed up every time regardless of whether they are
> changed.
>
> Tim Rushforth
> City of Winnipeg
>
> -Original Message-
> From: Miles Purdy [mailto:[EMAIL PROTECTED]]
> Sent: September 26, 2002 1:57 PM
> To: [EMAIL PROTECTED]
> Subject: WIN2k Clients Backing up Executables ALL THE TIME
>
> Hi folks,
>
> TSM Server 5.1.1.6 (was 4.1.1 but behavior is the same) (on AIX 4.3.3)
> TSM Windows Client 5.1.1.5 (was 4.2.1 but behavior is the same)
> Windows W2K SP2
>
> My problem is that the W2K clients are always backing up a whack of .exe's
> and .dll's. The reason that it is backing them up is that the modified
> date/time keeps getting updated. Interestingly enough, the time seems to be
> when the TSM schedule starts! These files are obviously not changing.
>
> The other thing is it seems to be backing up the files as system objects and
> not files. If I run 'dsmc inc c:', it backs up about 10mb. If I run 'dsmc
> inc' it backs up around 800mb.
>
> Any ideas?
>
> Miles
>
>
> 
> --
> Miles Purdy
> System Manager
> Agriculture and Agri-Food Canada,
> Information Systems Team,
> Farm Income Programs Directorate
> Winnipeg, MB, CA
> [EMAIL PROTECTED]
> ph: (204) 984-1602 fax: (204) 983-7557
>
> "If you hold a UNIX shell up to your ear, can you hear the C?"
> 
> -
>

Re: Space reclamation runs, but tapes don't free up

[Joel Fuhrman]

You can find it documented in the back of the Admin. Reference.  I did an
audit before upgrading from 4.1.1.5 to 5.1.1.2 and I had to do it again on
5.1.1.6. So if you are going to do an audit, I would recommend waiting until
you are on 5.1.1.6

On Wed, 2 Oct 2002, Johnn D. Tan wrote:

> Paul:
> 
> What is the exact syntax for auditdb? I've seen you mention it twice
> now. I'm on 4.1.3 server (migrating to 5.1.1.6 tomorrow!) and don't
> see this mentioned anywhere. This is part of 4.2 and later?
> 
> johnn
> 
> 
> >My recommendations is for people to get to 4.2.2.12 or higher for those of
> >us on 4.2 and get the backupgroups cleaned up before attempting a 5.1.1.6
> >migration.  This probably includes running an auditdb before starting the
> >ugprade as well.
> >
> >Paul D. Seay, Jr.
> >Technical Specialist
> >Naptheon Inc.
> >757-688-8180
> >
> >
> >-Original Message-
> >From: Burton, Robert [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, October 02, 2002 9:30 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Space reclamation runs, but tapes don't free up
> >
> >
> >There is a known problem opened with IBM on this...  We were told to upgrade
> >to tsm 4.2.2.4 or higher...this seemed to clean up most but not all these
> >problems...  If you q content on the tape it is empty, yet if you try to do
> >reclamation or delete it you are informed that there is still data on it
> >We were told we would have to issue an auditdb to clean it up...this would
> >knock our production server off the air for over 27 hrs...so we opted no to
> >do this
> >
> >When we tried to upgrade from tsm 4.2.2.4 to tsm 5.1.0.0 we experienced the
> >following problem:
> >
> >Item PQ64254
> >
> >
> >
> >   APAR Identifier .. PQ64254   Last Changed..02/09/12
> >   ANRD IMINIT.C  GROUP.MEMBERS ERROR 8 UPGRADEDB
> >
> >We were informed to upgrade to 5.1.1.4 or higher and run a cleanup
> >backupgroups commandthis also fixed nothing
> >
> >I have an additiona PMR opened with IBM on this problem and am waiting to
> >hear back...
> >
> >thanks
> >Robert Burton
> >Enterprise Storage Network Analyst
> >Royal Bank of Canada
> >315 Front St West
> >Toronto, On, M5V 3A4
> >* 416-348-3849
> >* [EMAIL PROTECTED] 
> >
> >
> >
> >-Original Message-
> >From: John Naylor [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, October 02, 2002 8:53 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re: Space reclamation runs, but tapes don't free up
> >
> >
> >Michael,
> >Why has your tape got a status of filling ?
> >That would be a reason why it would not return to scratch
> >Are all your problem tapes like that?
> >
> >
> >
> >
> >Michael Moore <[EMAIL PROTECTED]> on 10/02/2002 01:34:26 PM
> >
> >Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> >
> >To:   [EMAIL PROTECTED]
> >cc:(bcc: John Naylor/HAV/SSE)
> >Subject:  Re: Space reclamation runs, but tapes don't free up
> >
> >
> >
> >We are having a similar problem with our server (v4.2.2.12, on OS/390
> >v2.10).
> >
> >Here is my problem:
> >
> >The reclaim runs, and ends, but the tapes are not being updated as empty. If
> >I run an audit of the tape volume, it will then go to empty, and be deleted
> >during our next MOVEDRMEDIA command.  Here is an expamle of one tape that we
> >ran the audit on:
> >
> >
> >
> >Before Audit query:
> >   Volume Name: 321343
> > Storage Pool Name: DEV_TAPEOS
> > Device Class Name: 3590_OFFSITE_COPY
> >   Estimated Capacity (MB): 9,216.0
> >  Pct Util: 0.0
> > Volume Status: Filling
> >Access: Offsite
> >Pct. Reclaimable Space: 100.0
> >   Scratch Volume?: Yes
> >   In Error State?: No
> >  Number of Writable Sides: 1
> >   Number of Times Mounted: 2
> > Write Pass Number: 1
> > Approx. Date Last Written: 08/01/2002 01:20:28
> >Approx. Date Last Read: 08/01/2002 00:31:52
> >   Date Became Pending:
> >Number of Write Errors: 0
> > Number of Read Errors: 0
> >   Volume Location: TSM390
> >ast Update by (administrator): MOOREH
> > Last Update Date/Time: 08/01/2002 01:34:34
> >
> >
> >After Audit query:
> >Volume Name: 321343
> >  Storage Pool Name: DEV_TAPEOS
> >  Device Class Name: 3590_OFFSITE_COPY
> >Estimated Capacity (MB): 0.0
> >   Pct Util: 0.0
> >  Volume Status: Empty
> > Access: Offsite
> > Pct. Reclaimable Space: 0.0
> >Scratch Volume?: Yes
> >In Error State?: No
> >   Number of Writable Sides: 1
> >Number of Times Mounted: 2
> >  Write Pass Number: 1
> >  Approx. Date Last Written: 08/01/2002 01:20:28
> > Approx. Date Last Read: 08/01/2002 00:31:52
> >Date Became Pending:
> > Number of

Re: TSM: DB Best Practises ?

[Joel Fuhrman]

There is a great Redbook which you should be able to find by searching
for: getting started with tsm

On Thu, 3 Oct 2002, Riaan Louwrens wrote:

> Hi There,
>
> Been monitoring the list the last couple of weeks. Seeing as we are
> relatively new to the "world of TSM".
>
> I havent come across this (yet) in any of the admin / installation / user
> guides but I woudl like to know if there is a "best practises" w.r.t
> maintaining our tivoli server. (this is where the personal experience out
> there REALLY comes in handy ...) I have already drawn up a short list - feel
> free to add to it 
>
> Daily Backups
> Reclamation (daily)
> Migration
> Create Offsite Copies
> Expiration
> Backup TSM DB
> SnapShot TSM DB
> Backup Volhist
> Expire Inv
>
> If possible any integrity or consistency check that we can run  to verify
> the DB ? TSM internal commands ? or external utilities ?
>
> Second Question: (I know I am pushing it - but seeing as I already have the
> guru's attention) - Does TSM have a utility that "scans" in a tape and
> re-populates the DB ? Example: We have a tape and we arent sure what data it
> contains - can one "scan" (for lack of a better term) the contents ? Can one
> restore from that tape (say to a temp location) to view the contents ?
>
> Any help is appreciated.
>
>
> Regards,
>
>
> Riaan Louwrens
> Source Consulting SA
>

Re: Renaming a TSM server.

[Joel Fuhrman]

You can also set up a CNAME in DNS to map the old name to the new name. Then
you can change the client files as time permits.

On Tue, 8 Oct 2002, Pétur Eyþórsson wrote:

> Questions:
> 
> Is this possible without damaging the DB ?
> 
> What other steps should be added ?
> 
> Has anyone done this before ?
> 
> 
> Yes this is realy easy.
> 
> This is a OS case. if your OS (Operatin System), if your Ip, DNS
> configurations have been configured there should be no problem.
> 
> The only thing you need to do with the TSM server is this command
> 
> SET TSMSERVERNAME &the name of your server&
> 
> Kvedja/Regards
> Petur Eythorsson
> Taeknimadur/Technician
> IBM Certified Specialist - AIX
> Tivoli Storage Manager Certified Professional
> Microsoft Certified System Engineer
> 
> [EMAIL PROTECTED]
> 
>  Nyherji Hf  Simi TEL: +354-569-7700
>  Borgartun 37105 Iceland
>  URL:http://www.nyherji.is
> 
> 
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
> Ochs, Duane
> Sent: 8. október 2002 15:35
> To: [EMAIL PROTECTED]
> Subject: Renaming a TSM server.
> 
> 
> Good Morning everyone,
>  Due to some reallocating of resources it has become necessary to relocated
> one of my TSM servers and Jukebox. Our company has historically prefixed
> system names with the  geographical location of the installation.
> 
> I would like to change the name of the TSM server to comply with this naming
> structure.
> 
> My plan:
> 
> Change the TSM server name and IP address to comply with the corporate
> standard in the new plant.
> 
> Update my DNS to reflect the new system.
> 
> Change every client's server identification to point to the new IP.
> 
> Restart all schedulers and remote web services on all clients using this new
> IP.
> 
> 
> Duane Ochs
> Systems Administration
> Quad/Graphics Inc.
> 414.566.2375
> 

Re: Invalid data.

[Joel Fuhrman]

Read up on 'reclamation' which is controlled by a storage pool option.  If
you are running the most current TSM server version, check the 'move data'
command options.


On Wed, 6 Feb 2002, Nazir wrote:

> Hi,
>
> I want to delete the invalid data inside the tapes of my storage pool. How
> do i do it?
> Is there a way to do it manually?
>
> Thanks in advance,
> Nazir
>

backup of win2k system files fails

[Joel Fuhrman]

One windows 2000 server backup fails when trying to backup the system files.
The backup is being run under the administrator account.  Nothing of
interest is logged in the TSM folders or in the TSM server application log.
The windows application log contains the following entry.  Any suggestions
as how to solve this problem would be appreciated.

Event Type: Warning
Event Source:   PerfProc
Event Category: None
Event ID:   2002
Date:   2/24/2002
Time:   10:45:35 PM
User:   N/A
Computer:   A23
Description:
Unable to open the job object Winlogon Job 0-298f2 for query access.  The
calling process may not have permission to open this Job.  The status
returned is data DWORD 0.
Data:
: 02 00 00 00   

Re: How to use string operators in select statement - TSM.

[Joel Fuhrman]

Or you can do a "query act msg=2565"

On Thu, 28 Feb 2002, mobeenm wrote:

> Sree Kumar,
> Its absolutely possiblem to do that. Try the following
>
> select * from actlog where message like 'ANR2565I%'
>
> I think this should do the trick. Hope the climate in Bangalore is good :-)
>
> Regards
> Mobeen
>
> Mobeen Mahamood C.M
> Systems Manager Lead
> Micron Semiconductor Asia
> Singapore
>
>
>
>
>
> > -Original Message-
> > From: Pothula S Paparao [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 28, 2002 5:15 PM
> > To: [EMAIL PROTECTED]
> > Subject: How to use string operators in select statement - TSM.
> >
> >
> > Hi TSM'ers
> > The below is the message from select output (select * from actlog)
> > All I want to know is whether or not possible to caputue only
> > the message
> > no (ex. ANR2565I) using select query. I tried using string
> > operations in
> > select command. didnt help much. If any select expert tried
> > this pls let me
> > know. Im very much intrested to know about it.
> >
> > Thanks in advance.
> >
> >
> > DATE_TIME: 2001-12-30 00:00:02.00
> > MSGNO: 2565
> >  SEVERITY: I
> >   MESSAGE: ANR2565I 0 schedules for immediate client actions have been
> > deleted.
> >
> >
> > Regards
> >
> > Sreekumar.
> > SO
> > IBM Singapore.
> > Phone : 65-8402634
> >
>

scheduler service overwrites baclient's password

[Joel Fuhrman]

The password key which is located in the registry at
HKLM\software\ibm\adsm\backupclient\nodes\W7\adsm is removed
when the scheduler service is started.  The scheduled log contains:

03/15/2002 18:11:11 Querying server for next scheduled event.
03/15/2002 18:11:11 Node Name: W7
03/15/2002 18:11:11 Please enter your user id : ANS1029E
Communications have been dropped.
03/15/2002 18:11:11 Scheduler has been stopped.

Removing and re-installing the Scheduler Service and TSM (version 4.2.1.20)
did not help.


BACKGROUND: The system was created using a clone disk on which the TSM
installed.  After the disk is cloned, the hostname is changed along with
the sids.  The host then joins the domain. The TSM client is used to
register with the TSM server.  Finally, the TSM scheduler service is created
and it wipes out the password.

Any suggestions would be appreciated.

Re: Tapes Blank Under Last Use

[Joel Fuhrman]

In our case, these occur when there is a problem mounting a database backup
tape.  The TSM server request the mount and marks the volume private.  When
the mount fails, TSM neither enters it as a dbbackup in the volhistory nor
does it return it to the scratch pool.  I learned this when a faulty drive
caused all scratch tapes to become private.  When this happens, I just check
the tape out and then check it back in as scratch.  TSM will not check it in
unless its empty.

On Wed, 27 Mar 2002, Michael Benjamin wrote:

> This seems like normal behaviour...
>
> q vol
> q drm
> q libvol
> q content
>
> Will return nothing for a library volume marked Private with no last use. It
> has not been allocated to
> a storage pool, the library doesn't know anything about it, except the fact
> it's been marked as private
> and therefore not to use it unless requested. The request never occurs of
> course and your library can
> fill up with nolastuse tapes.
>
> Check out any tapes in this state, run the above commands and see if there
> is any data on them, if not
> then you can relabel the tapes as scratch or just check them back in as
> scratch and problem solved.
>
> More than likely a scratch tape loaded with a write protect.
>
> > -Original Message-
> > From: Gene Greenberg [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 26, 2002 9:30 PM
> > To:   [EMAIL PROTECTED]
> > Subject:  Tapes Blank Under Last Use
> >
> > Hi,
> >
> > I don't get stumped too often, no more than once a day, but I've run into
> > a
> > couple of problems I can't figure out.  I'm using a 3575 library with
> > server
> > running 4.3.3 aix. For the last two or three days I'm getting nothing when
> > I run
> > an eject script.  When I run a q libv I have tapes that have nothing in
> > the
> > column under last use.  When I try to query the volume under the q vol
> > command
> > or q drmedia command nothing comes up.
> >
> > Going through the act log I'm getting many messages of volumes that are
> > marked
> > offsite and still contains files which could not be move ANR1163W.  I
> > don't know
> > how we got to this point, but if anyone has any ideas please let me know.
> >
> > Thanks,
> >
> > Gene
>
> **
> Bunnings Legal Disclaimer:
>
> 1)  This document is confidential and may contain legally privileged
> information. If you are not the intended recipient you must not
> read, copy, distribute or act in reliance on it.
> If you have received this document in error, please telephone
> us immediately on (08) 9365-1555.
>
> 2)  All e-mails sent to and sent from Bunnings Building Supplies are
> scanned for content. Any material deemed to contain inappropriate
> subject matter will be reported to the e-mail administrator of
> all parties concerned.
>
> **
>

Re: 4.2.1.32 problem with systemobject on Citrix

[Joel Fuhrman]

I do _not_ run Citrix.  However, I had the same problem on a server whose
systemdisk was D:.  One of the 4 start up files (boot.ini, ntldr, etc.) was
missing.  Installing the missing file allows the backup of the
systemobjects.

I think the missing file is displayed by NT's backup utility.

On Wed, 1 May 2002, Bruce Kamp wrote:

> Join the club.  I have been working with Tivoli for a couple of months
> on this (even though they don't support Citrix).  They had me upgrade to
> 4.2.1.30.  There thinking is that it has to do with the CAD starting
> scheduler.  When I stopped using managed services it stopped hitting my TSM
> server every 10 minutes.
> I'm still testing the rest of it.
> I'll let you know what I find out
>
> ---
> Bruce Kamp
> Network Analyst II
> Memorial Healthcare System
> E: [EMAIL PROTECTED]
> P: (954) 987-2020 x4597
> F: (954) 985-1404
> 
>
>
> -Original Message-
> From: Ken Long [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 7:42 PM
> To: [EMAIL PROTECTED]
> Subject: 4.2.1.32 problem with systemobject on Citrix
>
>
> Hello all...
>
> Backups of a W2K server running Citrix Metaframe XPe are failing, with the
> following error in the server activity log:
>
>04/30/02   18:17:36  ANR0480W Session 9355 for node CITRIXADTEST
>(WinNT) terminated - connection with client severed.
>
> After 10 minutes, the server reconnects with the client and the backup
> restarts, only to fail again a few minutes later.  The following error
> occurs in the dsmerror.log, but I often see such failures on non-Citrix
> servers without the backup stopping:
>
>04/30/2002 18:17:35 ANS4987E Error processing '\\citrixadtest\m
>$\WINNT\system32 \Perflib_Perfdata_380.dat': the object is in use by
>another process
>
>
> Following the invaluable information on this forum, I looked at the solution
> for the "sysfiles not on C:" problem, which I thought was fixed in 4.2.1.32.
>
> To test, I changed DOMAIN from ALL-LOCAL to just "M: N:" and the backup
> succeeded.  I reset DOMAIN to "M: N: SYSTEMOBJECT" and the backup failed
> again.
>
> I'm using 4.2.1.32 on a W2K domain controller, backing up the system objects
> without problems.  What's up, am I missing something, or is backing up
> system objects on Citrix servers still broken?
>
> Thanks... Ken
>