Informix

 View Only
  • 1.  In-place upgrade with DBDELIMITER problem

    IBM Champion
    Posted Thu November 10, 2022 07:31 AM
    Edited by System Fri January 20, 2023 04:10 PM
    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_LOCALE

    Hvroje


    ------------------------------
    Hrvoje Zokovic
    ------------------------------
    #Informix


  • 2.  RE: In-place upgrade with DBDELIMITER problem

    Posted Thu November 10, 2022 12:10 PM
    Thanks, Hrvoje. That's good to know!

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 3.  RE: In-place upgrade with DBDELIMITER problem

    IBM Champion
    Posted Tue November 15, 2022 02:43 AM
    Support opened defect idsdb00111482 for this issue.
    Waiting for APAR
    Hrvoje


    ------------------------------
    Hrvoje Zokovic
    ------------------------------