>> On Thu, 30 Jul 2009 08:25:22 -0400, Richard Mochnaczewski
>> <Richard.Mochnaczewski AT STANDARDLIFE DOT CA> said:
> We are currently looking at upgrading our TSM 5.4.3 AIX server
> running two instances ( each instance database size is around 120Gb
> ). Reading some documentation on the IBM site, I see the database
> conversion takes a very long time. If anyone has done the upgrade,
> what was your experience ?
In the beta, I did one of 108G; it summed to about 6 hours. This was
on a 4-core 520 with 8G of core, on SAN disk which was not
particularly busy.
ANR1382I EXTRACTDB: Process 1, database extract has completed.
ANR1383I EXTRACTDB: Found 126 database objects.
ANR1384I EXTRACTDB: Processed 87 database objects.
ANR1385I EXTRACTDB: Skipped 39 empty database objects.
ANR1386I EXTRACTDB: Failed to process 0 database objects.
ANR1387I EXTRACTDB: Processed 328,684,545 database records.
ANR1388I EXTRACTDB: Read 16,904,997 database pages.
ANR1389I EXTRACTDB: Wrote 41,616,250,531 bytes.
ANR1390I EXTRACTDB: Elapsed time was 0:41:20.
ANR1395I INSERTDB: Process 1, database insert, has completed.
ANR1397I INSERTDB: Found 87 database objects.
ANR1398I INSERTDB: Processed 87 database objects.
ANR1399I INSERTDB: Failed to process 0 database objects.
ANR1517I INSERTDB: Processed 328,684,545 database records.
ANR1518I INSERTDB: Read 41,616,250,531 bytes.
ANR1519I INSERTDB: Elapsed time was 4:42:12.
ANR1445I INSERTDB: Throughput was 8438.27 megabytes per hour.
ANR1446I RUNSTATS: Table updating statistics started.
ANR0136I Table updating statistics performed successfully for 119 of 119.
ANR1528I RUNSTATS: Table updating statistics completed in 0:24:49.
- Allen S. Rout
|