Getting under the hood with DB2 for TSM Admins

By
Dec 21, 2011
No Comments

Over at the TSMADmin blog, Chad Small recently posted “DB2 Doesn’t Make a Difference.”  Chad was concerned that he was not seeing a performance boost in his database queries after upgrading from TSM 5.5 to 6.x. As you know, one of the biggest changes in TSM 6.x is that it is now backed by DB2. […]

Disabling caching on a primary stgpool and deleting the volumes in TSM

By
Sep 13, 2011
2 Comments

I recently needed to shrink a primary stgpool with devclass DISK on a TSM 5.5 server  in order to free up space.  Since the stgpool had a device class of DISK and caching was enabled, I wasn’t able to directly shrink the stgpool by moving the data within volumes and then deleting the empty volumes. […]

TSM 6.2 shut down, ADM6017E in db2diag.log

By
Aug 11, 2011
No Comments

This morning, I noticed that one of my TSM 6.2 servers had stopped running over night.  No DB2 processes or dsmserv were running. I checked the TSM logs, but only found errors from the dsmadmc client: 08/11/11 09:08:52 ANS5216E Could not establish a TCP/IP connection with address ‘TSM1.LANIGERA.COM:1500’. The TCP/IP error is ‘Connection refused’ (errno […]

TSM 6.2.3 released

By
Aug 5, 2011
2 Comments

IBM has released Tivoli Storage Manager v6.2 Fix Pack 2 (6.2.3). Looks like a lot of bugfixes, in particular a DB2 reorg bug. As usual, I’ll let everyone else go first and see what breaks.  Thanks, dudes!

Enabling deduplication on a primary storage pool in TSM 6.2

By
Aug 2, 2011
2 Comments

I recently had the need to enable deduplication on an existing 5.5TB storage pool residing on a TSM 6.2 server.  The storage pool has a FILE (disk-based sequential access) device class, and is used to store virtual volumes from a remote 5.5 server.   So, even though it is configured as a primary pool, its […]

Oracle and TSM for Databases: Part 2

By
Jun 30, 2011
4 Comments

In the first installment of this series, I discussed some of the basic concepts in using Tivoli Storage Manager for Databases to backup and recover Oracle databases.  In this installment, we’ll look at how to keep TSM and Oracle in sync. When backing up a typical filespace, the TSM backup-archive (BA) client compares what files […]

Oracle and TSM for Databases: Part 1

By
Feb 15, 2011
5 Comments

One of the most confusing areas for TSM admins is backing up Oracle databases using TSM for Databases (frequently referred to by its old name, Tivoli Data Protection or TDP).  In this series, I’ll provide an overview of how to use TSM to backup Oracle databases, with a special emphasis on problems you may face […]

Cloning Oracle databases with RMAN

By
Jan 4, 2011
No Comments

Some of the hats I currently wear include being the backup administrator and sometime DBA.  The two overlap, since I use IBM’s Tivoli Storage Manager (TSM) to handle all of our Oracle-related backups and restores. By restoring backups of a production environment to a nonproduction one (eg, a development or testing instance), you can make […]