List of CLIP ID in TSM 7.1

[amirulhaq]

Background: We are migrating Centera Storage to ECS Storage for TSM Server 7.1 under Ondemand 9.5, and we need list of clip ids in TSM Server 7.1,  does anyone know the TSM table which the clip id reside.

[Norbert Novotny]

It's not a perfect but you get an idea.

Replace:

• tmsinst1 password with yours
• ARCHIVE_NAME with your CMOD Instance name

Just a note:

• The ECS supports S3 protocol as well as CAS (Centera), you would be better of move to CMOD 10.1 and migrate from TSM/Centera to CMOD/S3.
• The TSM/Centera clips are *NOT* 1:1 with CMOD load files. The TSM stores some "preamble" in the file before it is stroed as clip in Centera.

Cheers,
 N.

Code: [Select]

#!/usr/bin/bash
if [ $# -ne 2 ] ; then
        echo "Usage: `basename $0` agid_name doc_name"
        exit 1
fi
AGID_NAME=$1
DOC_NAME=$2

db2 connect to tsmdb1 user tsminst1 using XXX_tsminst1Password_XXX >/dev/null 2>&1
trap 'db2 terminate' exit

SQL="select cast(assg.pvrpos as varchar(128) for sbcs data) from tsmdb1.AS_Segments assg join tsmdb1.AF_Segments afsg on
assg.volid=afsg.volid and afsg.bfid in (
select a.object_id from tsmdb1.archives a where a.filespace_name='/ARCHIVE_NAME/$AGID_NAME'
and a.LL_NAME = '$DOC_NAME') and assg.start=afsg.start"

echo $SQL | db2 -x +p
exit $?