Directories/files we know that has reference to locations:\n\n1.Database configuration file aaaaaaaa.cnf /II_DATABASE/ingres/data/default/data_warehouse \n2.Database configuration file aaaaaaaa.cnf in /II_CKPT/ingres/dmp/default/data_warehouse\n\t# use ls -l / cksum and make sure these two are identical \n3.The aaaaaaaa.ext in /II_CKPT/ingres/dmp/default/data_warehouse\n4.The X100 location_map file in /II_DATABASE/ingres/data/default/data_warehouse/wal\n\n \tRemove or modify any information you find related to II_WORK/ingres.\n\n5.Connect to iidbdb and check all system catalogs that might be related. \n\nsql +U -u'$ingres' iidbdb\nSELECT VARCHAR(table_name,32) FROM iitables WHERE table_name LIKE '%loc%' OR table_name LIKE '%ext%'\\g \n+--------------------------------+\n?col1 ?\n+--------------------------------?\n?iiextended_relation ?\n?iilocation_info ?\n?iimulti_locations ?\n?iiextend_info ?\n?iiextend ?\n?iilocations ?\n?iiexternal ?\n?ii_locks ?\n?ii_dbd_locations ?\n?iiqrytext ?\n?iiget_table_locations ?\n?iicolumn_locations ?\n+--------------------------------+\n\nIn particular, check iilocation_info, iiextend_info, iiextend, iilocations and modify/correct any reference to the old (/II_WORK/ingres/) location.\n