Search:

Not using nodegroups so haven't tried this, but I do a similiar thing for collocation groups.

select node_name, collocgroup_name from nodes where length(collocgroup_name) is null

Not sure of...

You could create new storage pools and use migrate stg.

Also, if the drives are going to be in the same library long term, I would setup different logical libraries for them. We tried keeping...

It might be helpful to describe the problem the PM was trying to solve with this list of filenames, size and tapes.

There is bound to be a better way to solve the problem.

TSM for ERP works differently from the TSM for Databases client.

BOTH log and database backups are archives to TSM.

Try q volh t=dbb

TSM database backup tapes don't belong to a storagepool. If these tapes are TSM database tapes, you may want to change the retention of database tapes.

You can do this for the storage pool as a whole by setting a migration delay.

upd stg <pool_name> migd=90 migc=no rec=100

migrate stg <pool_name> lo=0

The migration will migrate everything...

It looks like the client lost connection to the TSM server. I've seen the "Vendor: Reason Code 18" when running backups are killed either manually or a higher priority process prempts it.
...

I would not use the tape again. Trident's first suggestion is the procedure to restore the data on the damaged tape from the copypools. You can run the following to find the volumes you will need....

I would try to find out why they are private.

q act begind=-30 search=<tape_name>

You may be able to spot why the tape is set to private. No need to check the tapes back out and in. Use this:...

You still have plenty to scratch tapes in the library? I wouldn't worry about which tapes the library picks up. If it attempts to mount a scratch tape and that fails, it will change the tape from...

So what actual problem are you experiencing? There is no point in keeping TSM database backups forever. If you have to restore the TSM database, you will want to get the storage pool tapes back to...

Doing a similiar amount for 50 servers across 2Mb links. It is going to hit the network hard. For us, it is all in the timing. We swamp the lines when no one else is using them. You could look at...

For the database backups, look at Set DRMDBB. To retain database backups for 5 days use 'Set DRMDBB 5'. Typically, you should then set the reuse delay on the storage pools to 5 days too.

After...

Thanks Ralf

Works a treat now.

Hi

In ver5.5, I have been using the following to find the number of minutes tapes are loaded in tape drives. This has been useful in the past for demonstrating why we need more tape drives.
...

When grouping servers for collocation, I would consider then retention periods for the data. The servers in the same group should be expiring their data at the same time as this will reduce the...

What is also of interest is how many files are are in total on each server. TSM is only backing up files which have changes and for the slower server it is possible that it is having to spend alot...

You would use less tapes creating and maintaining copypools than if you try the dated approach of full and incrementals.

How much data is huge? It would help us put it into perspective. Large...

Did the tech mistakenly put the same drive back in again?

On my AIX TSM servers, I have disk and file device classes. The disk device class is used for DB2 logs and the storage pool is caching the data so the last 2-3 days are available without needing a...

Ok, that makes things a little clearer. Are you ready to move everything to the new storage pool? I would update the pool to make the new pool the target for migrations with "upd stg...

Is reducing the maxscratch setting of the storage pool an option?

Would be interesting to know how many nodes are backing up to this storage pool. There will be at least one filling tape per node...

That is wrong and I think you are over complicating things. The move data commands didn't work because you had set the volumes to read only. Move data does work on filling volumes and you do not...

How will that help? If you run out of log space reducing the log space will not help. Speeding up the backup will reduce the time the backup is holding the log open with an active transaction...

I would set them back to readw. Try a move data after that.

This may be of interest. It is a very high level overview of what we did with our BW system. Backup time from 24 hours to 5 hours with the TSM for ERP on AIX and DB2.
...

I would set the number of sessions to 0. DB2 will then automatically use what it thinks the the optimal number of sessions.

Settings I use are:

Number of buffers: 0
Buffer Size: 0...

Whoops, sorry. You have the issue in the logs you provided.

15/10/12 01:46:45 ANR2998W The server log is 81 percent full. The server has
cancelled the oldest transaction in the log. (SESSION:...

That is the same error we get if TSM requires the tape drive for something else. The classic problem is the TDP requires access to the logs to complete the backup, so it goes to restore the logs...

This will depend on whether you used the move media command to remove the full tapes. If you did, then the command will be :

q media * stg=<storage_pool_name> wherestate=mountablen

If you...

I use this query to find nodes which are not assigned to a collocation group. Good to run every now and then to find if any have slipped through the cracks.

select node_name, collocgroup_name...

It does archives in TSM.

Backup data has been exported out of TSM presumably for import into another TSM solution? So long as the export hasn't been done as some sort of archive, these tapes could be deleted.

Use
...

Ok, prole is not running. You need something like this in inittab


pd64:2345:respawn:/usr/tivoli/tsm/tdp_r3/db264/prole -p tdpr3db264

Cheers

If you have auto cleaning enabled on the library then this tape should be checked out of the library and re-added. When the screen on the library prompts which logical library to add it to, press...

You don't need to delete any library config in TSM. First make sure you have 96 empty slots in Library2. Halt TSM. Remove 96 slots from Library2. Add 96 slots to Library one. Start TSM. It will...

DNS is standard name resolution method. Minimal things should need host file entries and something is wrong if you need to rely on that for your systems. You may want to shorten the TTL (Time To...

I've added E9U expansions 3 times and not had to recreate the library. It may depend on whether the control path for the library is changing. Currently doing a number of changes to number of slots...

You don't need to redefine the library. Go into the TS3310 web management console and increase the TSM virtual library from 120 slots to the maximum number available. Restart TSM and it will pick...

Sounds like you need to audit the library. Try the following.

audit library LIB01 checklabel=barcode

I have done this for LTO3 and LTO5 drives in the same library. 4 LTO3 drives and 2 LTO5 drives. The devclasses look like this.


tsm: CHCTSM01>q devclass ltotape f=d
Device Class...

We are still in the same position with production data and TSM data on XIV. Should be resolved over the next month. Our two 5TB databases go straight to tape and we are soon to be using flashcopy...

That is what the console does. You are looking at the live activity log of the TSM server.

Just run "dsmadmc" without the -console. I think then you will get what you are expecting to see.

Have just implemented an XIV at our site. ATM, TSM is on it with production data. We are in the middle of juggling around SAN arrays and TSM will be moved off to it's own array so it is on...

You may just need to do a library audit. I found one in my library and the following after searching the activity log find the issue.

08/11/10 10:15:45 ANR8356E Incorrect volume TSM575L3...