Search:

I run expiration twice in my daily maintenance script:

- Expiration is run the first time with a duration slightly shorter than the amount of time it takes to complete a full expiration cycle. At...

This could be the problem you're running into when doing a PIT restore:
...

Try this for the first one:

Select Schedule_name, count(NODE_NAME) from associations where domain_name='TIER$1' GROUP by schedule_name

The only way to control the volume names would be to use preallocated volumes vs scratch volumes. See HELP DEFINE VOLUME for more info.

This is what I use to get a list of schedules with no associated nodes:

select schedule_name,domain_name from client_schedules where concat(domain_name,schedule_name) not in (select distinct...

There's an APAR for this issue: http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1IC76997

In addition to installing the IBM device driver in exclusive mode, make sure the Windows "Removable Storage" service is stopped and disabled. It's enabled by default on Windows 2003.

-Mike

I've run into this problem before. You may need to increase the VEREXISTS and RETEXTRA settings for the management class you're using for directories. It's too late to help you for this particular...

I have the following in writing from my IBM sales guy:

If I have a VMware ESX server with virtual servers running on it and each virtual server has the TSM client loaded on it and is backing up...

I've seen this problem occur when the upgrade didn't go right. The only way I know of to fix it is to uninstall the client, reboot, and then reinstall the client. Do not skip the reboot step!

-...

Yes.

- Mike

Yeah, I'm still having that issue too. But at least I know how to get around that now. I'm just glad the backups are working again.

- Mike

Yes, that solved the problem here as well. Thanks!

- Mike

If I stop and restart the service, it takes "Client Scheduler Service" back out of the data value when the service starts. Also, whether that value is there or not, the Setup Wizard still acts like...

We are having the exact same problem here after upgrading to version 6.2.1.0. Have you submitted a PMR? I'm seriously considering it.

- Mike

No, I installed the 64-bit version of TSM.

We migrated TSM 5.4.3.0 from a 32-bit Windows server to a 64-bit Windows server. We did a normal database restore. No import/export was necessary.

I believe the only time you would need to do...

3.25 hours, 15.5 million objects

Based on your Q LIBVOL output, it looks like the tape may be orphaned. Read here for more information:

http://adsm.org/forum/showthread.php?t=18695&highlight=orphan

-Mike

Stephan,

I can tell you the one gotcha that bit me. The node will be disassociated from all schedules, because schedules are domain specific. You'll need to associate the node with a schedule...

I produce the list during the move of the tapes.

For tapes going offsite:


move drmedia * wherestate=mountable remove=bulk tostate=vault cmd="&VOL" cmdfilename="d:\drm-moved-to-vault.txt"
...

It does work. I've done it.

I've never lost any settings either. It does re-inventory the entire library however.

Mike

I capture the list of tapes as they are being ejected by DRM:



move drm * wherestate=mountable cmd="&VOL" cmdfilename="d:\drm-moved-to-vault.txt"


Mike

Jon,

What error are you getting when you attempt to get to the web interface?

Mike

Give this a try:

select distinct node_name from occupancy where stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY' and devclass='DISK')

nabildz,

Here are some web sites that I've found to be helpful:

http://www.lascon.co.uk/d005104.htm
http://thobias.org/tsm/sql/index.html
http://www.general-storage.de/tsmsqlbt01.html...

Hey mikeymac,

I just learned how to do queries like this in one SQL statement. Here's how you would do this one:

select sum(case when msgno=1340 then 1 else 0 end)-sum(case when msgno=1341...

I have SANDISCOVERY turned on and I noticed that all my devices changed designation when I upgraded my IBM tape driver. With version 6.1.4.1 of the driver, all the devices showed up as mtw.x.y.z and...

Having been through this several times before, I think I can offer some advice. The first time this happened I was completely freaked out. I was a new TSM administrator and didn't have a clue how...

Good luck using mediatype after upgrading to version 5.4.1.0. Apparently IBM quietly decided to change the mediatype field from integer to string in this version. It was still integer when we were...

This is the query that I use:



select node_name from nodes where node_name not in (select distinct node_name from associations)



-Mike

When I was looking at my volume history, I noticed a reference to a backup set that seems to be orphaned because it belongs to a node that doesn't exist. Since the DELETE BACKUPSET command requires...

I added a condition to check if the volume is in the library:



select volume_name,pct_utilized from volumes where stgpool_name='{pool name}' and pct_utilized>99 and volume_name in (select...

You can get the information you're looking for from the registry.



Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\servicename\Parameters, substituting the name of your...

I can't speak for 8mm tapes but in my experience with LTO tapes, 99% of the time it is the drive that causes these types of errors. One time we actually had 6 LTO2 drives all go bad within a month. ...

Try this:



select a.volume_name,a.copy_type,a.stgpool_name,b.pct_utilized from volumeusage a, volumes b where node_name='<NODENAME>' and a.volume_name=b.volume_name order by a.stgpool_name

This is the query that I use:



select node_name from nodes where node_name not in (select distinct node_name from associations)

We ended up having to call support on this issue and I wanted to let you know what the resolution was. We weren't using a DSM.OPT file and apparently you need one. Here is what the IBM tech sent...

I am a Tivoli administrator of a Windows-based Tivoli server and most of our clients are Windows clients. There are a couple HP-UX clients that are maintained by one of our customers and they are...

Aaron,



Thanks for enlightening me. That makes sense now. You are the man.



Mike

Hello. I am fairly new to TSM so I'm hoping someone can assist me with an issue I am having with reclamation. I set the reclaim threshhold to 80 on one of my storage pools but I noticed that...