V5.5.7.0 on AIX converting over the network to V6.3.4.0 on Linux RedHat. The V5 DB is 260GB at 90%.
The TSM DB is defined on 4x100GB file systems /tsmdb01 - /tsmdb04. Active log is 32GB and archive log file system is 200GB. The extractdb phase seems to complete successfully: ANR0409I Session 1 ended for server $UPGRADETARGET$ (Linux/x86_64). ANR1382I EXTRACTDB: Process 1, database extract, has completed. ANR1383I EXTRACTDB: Found 119 database objects. ANR1384I EXTRACTDB: Processed 75 database objects. ANR1385I EXTRACTDB: Skipped 44 empty database objects. ANR1386I EXTRACTDB: Failed to process 0 database objects. ANR1387I EXTRACTDB: Processed 1,178,563,762 database records. ANR1388I EXTRACTDB: Read 47,215,261 database pages. ANR1389I EXTRACTDB: Wrote 128,524,753,412 bytes. ANR1390I EXTRACTDB: Elapsed time was 2:16:21. ANR1391I EXTRACTDB: Throughput was 53936.19 megabytes per hour. After the ExtractDB phase completes in the InsertDB log: ANR1379I INSERTDB: Read 123,388,191,411 bytes and inserted 1,126,658,997 database entries in 2:10:00 (54310.15 megabytes per hour). ANR1526I INSERTDB: Building indices and checking table integrity. ANR0409I Session 2 ended for server $UPGRADESOURCE$ (AIX-RS/6000). ANR1527I INSERTDB: Checked 69 of 75 database objects in 0:04:03. The file system is full. ANR0171I tbcli.c(10847): Error detected on 27:2, database in evaluation mode. ANR0131E tbcli.c(10847): Server DB space exhausted. ANR0162W Supplemental database diagnostic information: -1: :-968 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0968C The file system is full. ). And a bunch more Transaction hash table.. Lock hash table contents (slots=3002): Note: Enabling trace class TMTIMER will provide additional timing info on the following locks *** no locks found *** ANR1527I INSERTDB: Checked 70 of 75 database objects in 0:14:03. ANR1527I INSERTDB: Checked 70 of 75 database objects in 0:24:03. ANR1527I INSERTDB: Checked 70 of 75 database objects in 0:34:03. ANR1527I INSERTDB: Checked 70 of 75 database objects in 0:44:03. ANR1527I INSERTDB: Checked 70 of 75 database objects in 1:04:03. ANR1527I INSERTDB: Checked 70 of 75 database objects in 1:24:03. And then nothing. It just quits. But it appears to have run several hours after the extract/insert phase had completed. The Linux file systems shows /tsmdb01 at 48%, /tsmdb02 at 100%, /tsmdb03 at 100% and /tsmdb04 at 43%. 2 of the 4 file systems were at 100%, but I should have still had 100GB of database space left. I have since added another /tsmdb05 at 100GB and restarted the process. The other file systems: /home had 4.7GB of free space. /tmp 6.4GB, /var 4.4GB. Any ideas? I've got about 2-3 more hours to see if adding the 100GB of database space will resolve the problem. Bill Boyer DSS, Inc. (610) 927-4407 "Enjoy life. It has an expiration date." - ??
