In-place upgrade with DBDELIMITER problem

Hi all, just opened case: If you have audti turned on or you use external spaces, you have to unset DBDELIMITER before in-place upgrade. Explaination: During in-place upgrade two scripts are responsible for unloading and loading data: smi_unld and smi_load smi_unld just unloads tables sysaudit and sysextspaces - without setting DBDELIMITER smi_load just counts number of fields in unl file presuming "|" is DBDELIMITER and since got wrong number of columns throws an error since DBDELIMITER is sth else. So unset DBDELIMITER before in-place upgrade or quick fix is to modify smi_unld and smi_load - add this DBDELIMIER="|"; export DBDELIMITER right after # smi is created in English DB_LOCALE=en_us.8859-1; export DB_LOCALE CLIENT_LOCALE=en_us.8859-1; export CLIENT_LOCALEHvroje ------------------------------ Hrvoje Zokovic ------------------------------ #Informix

Thanks, Hrvoje. That's good to know! ------------------------------ Doug Lawry Oninit Consulting ------------------------------

Support opened defect idsdb00111482 for this issue. Waiting for APAR Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------