total bytes backed not equal total bytes in copypool

[waire]

hi,

Environment is TSM Server 5.2.0.2, TSM client 5.2.3.0, AIX 5.1-ML9, NO DRM.

My nightly backup schedule starts about 21.00pm to 2.00am.
02:30: backup disk_pool to copy_tape_pool
06:00:backup of Primary_tape_pool to Copy_tape_pool

other admin schedules run between 08:30 - 19.00, including migration of disk pool to primary_tape_pool

Operation report has been scheduled to gather stats for the last 24hrs between 10.00am to 10.00am(next day). When i compare "total GB backed up" between 21.00-2.00am and entries in "actlog", there seems to be a mismatch. Operational Reports shows e.g "total GB backed = 100GB
and actlog shows the total of
Disk_pool to copy_tape_pool and
Primary_tape_pool to copy_tape_pool = 90GB.

Hence copy_tape_pool data may not be consistent with total data backed up over the night.


Thanks.

 

[Pepeda]

If you do a "backup stg Primary_tape_pool copy_tape_pool" after your migration has finished you can see if it still has to backup something (it should not) .... and now you certainly are consistent.

 

[mateinone]

check the sum of your primary pools and copy pools from the occupancy table to see if your copy data is up to date

If you are using unix, try the following... (it is in TB, so change to GB if appropriate)

#!/usr/bin/ksh

if [[ $# -ne 1 ]]
then
echo Error
echo "Usage `basename $0` tsmserver"
return 1
fi
TSM="$1"
TSM_PSWD=/your/passfile
TSM_CMD=dsmadmc
read ID PASSWORD < ${TSM_PSWD}
tsmCMD="${TSM_CMD} -id=${ID} -pa=${PASSWORD} -comma -dataonly=yes -se=$TSM"

PRIMARY=`$tsmCMD "select cast((sum(logical_mb)/1024/1024) as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY'))"`
COPY=`$tsmCMD "select cast((sum(logical_mb)/1024/1024 )as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='COPY'))"`
DIFF=`echo $PRIMARY $COPY|awk '{print $1-$2}'`


echo
echo "\t______________________________________"
echo
echo "\t TSM STORAGE POOL COPY DATA"
echo "\t______________________________________"
echo
echo "\tPRIMARY\t\tCOPY\t\\tDIFF"
echo "\t$PRIMARY\t\t$COPY\t\t$DIFF"
echo
echo "\t______________________________________"
echo

 

[waire]

Ran the SQL tsm server console, but what exactly is the "logical_gb". Would this illustrate Copy pool data amounts to 13.76 terabyte and Primary pool data amounts to 24.51 terabyte and hence a mismatch?.

tsm: TSMSRVR>select cast((sum(logical_mb)/1024/1024 )as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='COPY'))

LOGICAL_GB
------------
13.76

tsm: TSMSRVR>select cast((sum(logical_mb)/1024/1024) as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY'))

LOGICAL_GB
------------
24.51

 

[mateinone]

Ran the SQL tsm server console, but what exactly is the "logical_gb". Would this illustrate Copy pool data amounts to 13.76 terabyte and Primary pool data amounts to 24.51 terabyte and hence a mismatch?.

tsm: TSMSRVR>select cast((sum(logical_mb)/1024/1024 )as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='COPY'))

LOGICAL_GB
------------
13.76

tsm: TSMSRVR>select cast((sum(logical_mb)/1024/1024) as decimal (10,2)) logical_gb from occupancy where (stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY'))

LOGICAL_GB
------------
24.51

yeah that should read logical TB

and yeah you have a lot of data in the Primary pool that is not in the copy pool, in fact you have nearly 11TB worth

 

[waire]

Cheers for the SQL, that extra 11TB worth of data belongs to HSM data which resides in the primary pool. There is no copy pool for HSM data however it is backed up first before migration.
So with HSM data (currently 10,574,176.45 mb) excluded there is a near match with Primary and Copy data. However my daily report still shows approx 5-10g of mismatch. e.g

77gb (operation report last 24 hrs. current time 10.00am). Backup runs from 21.00pm to 02.00am.

when i query the actlog to verify data backed up from disk storage to copy tape and Primary tape to copy tape, the total backed up data is

65gb

archiving operation e.g db2 logs does not account for much i.e data.
can data migrated via HSM be categories as a backup operation.

cheers