I am using SMS and would like to enable multipage file allocation to increase the performance. Could anyone guide me how to do so? I was not able to find "db2empfa" command in the bin directory.
Also i would like to know what are the factors which could be altered to give a thrust in the performance of the DB. Like what configuration parameters would do increase the performance? My main concerns are bulk inserts and nested queries.
512 MB Ram, Pentium 3, 600 MHz. <-- This is just a test machine
300 tables, Avg. of 400,000 records in some tables (most are empty), Maximum of 14,000,000 records (about 5 tables).