We are still running TSM 5.5.3 and are an IBM shop with DS8300, XIV Gen3 and
XIV Gen2 behind SVC 8G4's servicing the I/O.
We run a Windows 2003 Enterprise MSCS with 7 instances across the two nodes.
Our expiration runs straight after we've completed a full database backup to
tape, from around midday with a duration set to 8 hours (to fit within our
housekeeping window) and doesn't complete within that time.
It's relatively slow, and I suspect two things:
1. The amount of change does fill the log and causes and incremental DB backup
to file dev class to occur
2. The DB volumes, logs and storage pools all reside within the same DS8300
managed mdisk group. We are getting some I/O contention. (Currently
investigating via TPC).
Results from select scripts:
select capacity_mb as "Capacity MB", pct_utilized as "Percentage in use",
cast(capacity_mb*pct_utilized/100 as integer) as "Used MB" from db
Capacity MB Percentage in use Used MB
----------- ----------------- -----------
224000 74.6 167104
select activity, cast((end_time) as date) as "Date",
(examined/cast((end_time-start_time) seconds as decimal(18,13))*3600) "Objects
Examined/Hr" from summary where activity='EXPIRATION' and
days(end_time)-days(start_time)=0
ACTIVITY Date Objects Examined/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2012-04-21 882000
EXPIRATION 2012-04-22 1026000
EXPIRATION 2012-04-23 637200
EXPIRATION 2012-04-24 828000
EXPIRATION 2012-04-25 957600
EXPIRATION 2012-04-26 741600
EXPIRATION 2012-04-27 856800
EXPIRATION 2012-04-28 950400
EXPIRATION 2012-04-29 1202400
EXPIRATION 2012-04-30 1260000
EXPIRATION 2012-05-01 1249200
EXPIRATION 2012-05-02 1256400
EXPIRATION 2012-05-03 1281600
EXPIRATION 2012-05-04 1224000
EXPIRATION 2012-05-05 1000800
EXPIRATION 2012-05-06 1090800
EXPIRATION 2012-05-07 417600
EXPIRATION 2012-05-08 277200
EXPIRATION 2012-05-09 504000
EXPIRATION 2012-05-10 403200
EXPIRATION 2012-05-11 399600
EXPIRATION 2012-05-12 378000
EXPIRATION 2012-05-13 496800
EXPIRATION 2012-05-14 378000
EXPIRATION 2012-05-16 410400
EXPIRATION 2012-05-17 522000
EXPIRATION 2012-05-18 500400
EXPIRATION 2012-05-19 518400
EXPIRATION 2012-05-20 655200
Also, the following for DB Backups to 3592 tape:
2:26:46 PM BENPTSM2 : select activity, cast((end_time) as date) as "Date",
(examined/cast((end_time-start_time) seconds as decimal(18,13))*3600) "4KB
Pages Backed Up/Hr" from summary where activity='FULL_DBBACKUP' and
days(end_time)-days(start_time)=0
ACTIVITY Date 4KB Pages Backed Up/Hr
------------------ ---------- ---------------------------------
FULL_DBBACKUP 2012-04-21 73890000
FULL_DBBACKUP 2012-04-22 75380400
FULL_DBBACKUP 2012-04-23 75103200
FULL_DBBACKUP 2012-04-24 71359200
FULL_DBBACKUP 2012-04-25 69228000
FULL_DBBACKUP 2012-04-26 71769600
FULL_DBBACKUP 2012-04-27 71845200
FULL_DBBACKUP 2012-04-28 58233600
FULL_DBBACKUP 2012-04-29 74278800
FULL_DBBACKUP 2012-04-30 59860800
FULL_DBBACKUP 2012-05-01 70426800
FULL_DBBACKUP 2012-05-02 58071600
FULL_DBBACKUP 2012-05-03 66938400
FULL_DBBACKUP 2012-05-04 58345200
FULL_DBBACKUP 2012-05-05 63194400
FULL_DBBACKUP 2012-05-06 67053600
FULL_DBBACKUP 2012-05-07 75934800
FULL_DBBACKUP 2012-05-08 48895200
FULL_DBBACKUP 2012-05-09 52092000
FULL_DBBACKUP 2012-05-10 64537200
FULL_DBBACKUP 2012-05-11 72997200
FULL_DBBACKUP 2012-05-12 58957200
FULL_DBBACKUP 2012-05-13 55652400
FULL_DBBACKUP 2012-05-14 69825600
FULL_DBBACKUP 2012-05-15 67780800
FULL_DBBACKUP 2012-05-16 49273200
FULL_DBBACKUP 2012-05-17 36838800
FULL_DBBACKUP 2012-05-18 44359200
FULL_DBBACKUP 2012-05-19 38671200
FULL_DBBACKUP 2012-05-20 55594800
FULL_DBBACKUP 2012-05-21 61837200
+----------------------------------------------------------------------
|This was sent by jharris AT jubilee.id DOT au via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
|