>> On Thu, 30 Jul 2009 08:25:22 -0400, Richard Mochnaczewski >> <[email protected]> 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
