First off, I am running TSM v4.2.2.12 on OS/390 v2.10. We backup
aproximately 150 nodes daily.
Problem: We use backupsets for DR purposes! Not my choice.. But since I
work in a "Services" enviornment, I don't have much choice.
Anyway, we currently create backupsets for aproximately 24 NT nodes at
different times of the week, some are 2 times per week, others are only 1
time per week. The problem is that at times, due to locks that occur, the
server can appear to "hang up" for period of 20 minutes or more.
To help limit this problem, I try to arrange the generate backup processes,
so that only 1 large was is done per day (500,000 objects or larger). In
order for me to best arrange them, I run a select command to see how many
files each node has:
select node_name as "Node", -
sum(num_files) as "Number of Files", -
sum(physical_mb) as "Physical Size (MB)" -
from occupancy -
where (node_name = 'ITGC2AARTHUR1' or -
node_name = 'ITGC2AARTHUR2' or -
node_name = 'ITGC2AARTHUR3' or -
node_name = 'ITGC2AARTHUR4' or -
node_name = 'ITGC2ACSSAP' or -
node_name = 'ITGC2APRODTRAN' or -
node_name = 'ITGC2ARFSM' or -
node_name = 'ITGC2AS1' or -
node_name = 'ITGC2A01' or -
node_name = 'ITGC2AWEBPDM1' or -
node_name = 'ITGC2AWEBPDM2' or -
node_name = 'ITGC2BDC' or -
node_name = 'ITGC2APWAPP1' or -
node_name = 'ITGC2AMQSI' or -
node_name = 'ITGC2APWORACLE' or -
node_name = 'ITXF2ATESTDIR1')and -
(stgpool_name = 'BACKUP_TAPE_LOCAL' or -
stgpool_name = 'DEV_TAPE' or -
stgpool_name = 'BACKUP_TAPE_REMOTE') -
group by node_name > 'itnp.tsm.backup.sets.gaither'
I get the following report:
Node Number of Files Physical Size
(MB)
------------------ ---------------
---------------------------------
ITGC2AARTHUR1 292908
19452.30
ITGC2AARTHUR2 68814
1244.02
ITGC2AARTHUR3 65409
8427.65
ITGC2AARTHUR4 119935
5596.03
ITGC2ACSSAP 67197
6334.58
ITGC2AMQSI 38881
1566.20
ITGC2APRODTRAN 65510
4255.41
ITGC2APWAPP1 120954
12103.70
ITGC2APWORACLE 51195
14195.47
ITGC2ARFSM 104272
3886.81
ITGC2AS1 25466
1057.40
ITGC2AWEBPDM1 114771
12846.37
ITGC2AWEBPDM2 23726
1502.93
ITGC2A01 242472
11977.89
ITGC2BDC 107016
18545.14
ITXF2ATESTDIR1 1781020
20934.72
The only problem with it, seems that it is not entirely accurate. For
example, the backupset for ITGC2BDC, completed with the following
information:
ANR3505I Backup set for ITGC2BDC as DR.220248777 used volume 347199.
ANR0987I Process 153 for GENERATE BACKUPSET running in the BACKGROUND
processed 89000 items with a completion state of SUCCESS at 12:19:30.
According to this, it only processed 89000 items, but the number of files I
show in my report is 107016. I assume that the backupset only contains
"active" files, and the script accounts for "active" and "inactive". Is
there another table that I can get more accurate information from?
Thanks for your help!!
By the way, all of the help with scripts lately has been great!! Thanks
everyone that contributed!!!
Michael Moore
VF Services Inc.
