Informix

 View Only

New release of utils2_ak! Also some great news!

  • 1.  New release of utils2_ak! Also some great news!

    IBM Champion
    Posted Mon April 19, 2021 06:40 PM
    Folks, I uploaded an update of utils2_ak to my web site (www.askdbmgt.com/my-utilities)

    GREAT NEWS! The ESQL/C bug that has prevented dbcopy from copying lvarchar type columns
    since v3.50.xC5 (over 10 years) has finally been fixed as of CSDK v4.50.FC5! Yippee! That means
    that only remaining limitations on using dbcopy are having more than one BYTE or TEXT column 
    or CLOB or BLOB columns (coming soon).

    Added new features:

      -A - lock the source table in exclusive mode. When used with -a (lock target table) this can make
    dbcopy run MUCH faster!
      -G - Print run time and data copy rate during and following the copy.
      -v - Verbose status display that includes processing steps not otherwise displayed.
      -c disable active triggers on the source table. Re-enable them after the copy completes.
      -C disable active triggers on the target table. Re-enable them after the copy completes.
    The -c & -C prevent SELECT and INSERT triggers on the tables from firing during the mass copy.



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    #Informix