As per Actian, locations on iidbdb looks good and theres no need to change anything.\nThe entries in iilocations and iilocation_info state that ii_work is using the area specified by II_WORK (the installation primary work location) which is set to /II_WORK/WKLOC1 so that is fine.\n\nActian recommends to:\n\n1. Run infodb data_warehouse and check if II_WORK locations are corrent\n2. ingstop\n3. Rename /II_WORK/ingres/work/default/data_warehouse to /II_WORK/ingres/work/default/dwh\n4. Rename /.../dmp/default/data_warehouse/aaaaaaaa.cnf to /.../dmp/default/data_warehouse/aaaaaaaa.cnf.old\n5. ingstart\n6. Create a dummy table in database data_warehouse\n7. Echo create table dropme as select * from iitables\\g | sql data_warehouse\n\nThis will create a new aaaaaaaa.cnf in the dmp directory\n\nIf all works fine and confirmed that correct two /II_WORK/WKLOC1 and /II_WORK/WKLOC2 are shown by infodb in step1, run the original INSERT SELECT statement to create the 82 million rows table\n\nWhile this is running:\n1. execute $II_SYSTEM/ingres/sig/inglogs/inglogs\n2. cd to the inglogs directory and open pfiles_iidbms* and search for II_WORK. \n3. Double check and make sure only files in /II_WORK/WKLOC1 and /II_WORK/WKLOC2 are open and there is no reference to files in /II_WORK/ingres/work/default/*.\n\n