Informix

 View Only
Expand all | Collapse all

Updated utils2_ak package available

  • 1.  Updated utils2_ak package available

    IBM Champion
    Posted Fri November 24, 2023 01:07 PM

    Folks:

    I have uploaded updates to myschema and dostats_ng.ec included in the latest utils2_ak.zip package. Here are the changes:

    Added version & copyright to the verbose 2+ output in dostats. Thanks to Chris Karsten for the suggestion.


    Myschema: Fixed the reported length of LVARCHAR type columns when the multibyte flag is set.
    Fixed routine parameter lists in GRANT and REVOKE statements for stored routines that contain complex
    parameters. Thanks to Davorin Kremenjas for reporting these issues.



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


  • 2.  RE: Updated utils2_ak package available

    Posted Mon November 27, 2023 04:59 AM

    Art,

    Where can we find it?



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



  • 3.  RE: Updated utils2_ak package available

    IBM Champion
    Posted Mon November 27, 2023 07:26 AM

    Woops, sorry, you can always find the latest release of my utilities on my web site, free to download and use, at:

    My Utilities

    ASK Database Management remove preview
    My Utilities
    Utils2_ak is my primary package of utilities. This is the November 24, 2023 release. Included: dbping.ec - Tests connections and reports connection time as well as the actual host...
    View this on ASK Database Management >



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



  • 4.  RE: Updated utils2_ak package available

    Posted Tue November 28, 2023 04:46 AM

    Art,

    FYI: In ratios.1170.sql a procedure is called rt() instead of ratios()



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



  • 5.  RE: Updated utils2_ak package available

    IBM Champion
    Posted Tue November 28, 2023 07:20 AM

    Thanks Dennis. Don't remember when or why I did that. Probably I was testing it on a system where I didn't want to overwrite an existing copy and forgot to rename it in the file afterwards. I'll upload a fixed package later today.

    Art



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



  • 6.  RE: Updated utils2_ak package available

    Posted Tue December 05, 2023 05:00 AM

    Art,

    I modified ratios() for 11.70 to meet conditions of read-only replica.
    The original procedure has aborted with a division-by-zero error.



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



  • 7.  RE: Updated utils2_ak package available

    IBM Champion
    Posted Tue December 05, 2023 05:04 PM

    Thank you Dennis. I have included those fixes and a few related ones in an updated package uploaded to my web site today. 

    Folks:I have also updated the ratios.sql script to include the new RAU calculation that will only work in Informix v14.10.FC8 or later. If you have an earlier release you can install the ratios.1410.preFC8.sql which is identical to the ratios.sql in the previous package release with Dennis's fix included.



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