Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
In-place upgrade with DBDELIMITER problem
Answered: grey (solid confidence) — Not a question; a tip that in-place upgrade needs DBDELIMITER unset, with a defect raised. No answer needed.
Hrvoje Zokovic — source: IBM Community (ConnectedCommunity.org) Informix forum
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
↪ replying to Hrvoje Zokovic
Doug Lawry — source: IBM Community (ConnectedCommunity.org) Informix forum
Thanks,
Hrvoje. That's good to know!
------------------------------
Doug Lawry
Oninit Consulting
------------------------------
↪ replying to Hrvoje Zokovic
Hrvoje Zokovic — source: IBM Community (ConnectedCommunity.org) Informix forum
Support opened
defect idsdb00111482 for this issue.
Waiting for APAR
Hrvoje
------------------------------
Hrvoje Zokovic
------------------------------
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.