Jul 26


It seems I am always upgrading tape formats in an effort to keep up with my growth. I have decided it would be best for the procedure I follow to be well documented. I use Atape for the drives and I use the Tivoli Storage Manager driver for the library. This is the method I follow for configuring the drives.

1) From TSM:
Save the output from the device queries, and save the current device configuration (the filename is optional):

query library
query drive f=d
query path f=d
query devclass f=d
backup devconfig [ filename=devconfig.bak ]

2) From AIX:
List the tape devices:

lsdev -Cc tape

Remove the drive and library device names:

rmdev -dl

For example, if the drive device name is /dev/rmt1:

rmdev -dl rmt1

3) Upgrade Atape
Ftp the Atape driver in binary mode from ftp://index.storsys.ibm.com/devdrvr/AIX or ftp://ftp.software.ibm.com/storage/devdrvr/AIX

Remove the older Atape driver (optional):

installp -u Atape.driver

Install and commit the Atape driver. For example, if you downloaded the file to /tmp/Atape.12.0.8.0.bin:

installp -acXd /tmp/Atape.12.0.8.0.bin all

Configure the tape device:

cfgmgr -v

(-v is not required but will show where it hangs if it does)

Verify the new devices are Available:

lsdev -Cc tape

(Note: While not always absolutely necessary, it is strongly recommended to reboot the system after upgrading the Atape.driver)

4) From TSM:
While it is recommended to remove and redefine the paths after any hardware change, including upgrading Atape.driver, sometimes it is not necessary to do anything else after upgrading Atape. If the activity log reports I/O errors for the library or drives, sometimes it is only necessary to force the TSM server to communicate with the drives to resolve them:

update path srctype=server desttype=drive library= device= online=yes

If this does not resolve the I/O errors, then continue with steps 5-7.

5) Delete the drive and library paths
For each drive:

delete path srctype=server desttype=drive library=

For the library:

delete path srctype=server desttype=library

6) Redefine the drive and library paths

define path srctype=server desttype=library device=/dev/ online=yes
define path srctype=server desttype=library library= devicename=/dev/ online=yes

(Use the devconfig file as a guide for the definitions.)

References:
IBM Tivoli Storage Manager for AIX Administrator’s Reference
Atape device driver README ftp://index.storsys.ibm.com/devdrvr/AIX/README

Apr 14

If you are using the new 6.1 client you can use the 5.5 odbc driver. Tested and working on vista x64.

Sep 2


A quick way to find nodes that are not in a collocation group and how much data they are using up. I one onsite stgpool that uses collocation so I specify that I only want to look at data in that stgpool.
select nod.node_name, nod.collocgroup_name, sum(oc.physical_mb/1024) as GB from nodes nod, occupancy oc where nod.node_name=oc.node_name and oc.stgpool_name='MYSTGPOOL' group by nod.node_name, nod.collocgroup_name

This is how I find out what tapes I need to move data off of after running the above query and if I define nodes into a collocation group when they previous where not in one. This was I can reclaim tapes immediatly rather than waiting for data to expire off the tape and space reclaimation to run against the tape.
select distinct volume_name from volumeusage where node_name IN ('NODE1', 'NODE2', 'NODEX') and stgpool_name='MYSTGPOOL'

I hope to update this list as I think of other selects I use often.

« Previous Entries