Informix

 View Only

  • 1.  admin( 'onstat', '-g cluster verbose' ) error

    IBM Champion
    Posted Thu March 04, 2021 02:30 PM
    Installed TL version on 2 hosts
    Initialized instance on host1
    cloned on host2 with:

    ifxclone --source=ifmx1 --sourceIP=host1 --sourcePort=14100   \
             --target=ifmx2 --targetIP=host2 --targetPort=14100   \
             --trusted   \
             --createchunkfile  \
             --disposition=HDR    \
             --autoconf
    Execute:
    echo "execute function task( 'onstat', '-g cluster verbose' )" | dbaccess sysadmin
    Your evaluation license will expire on 2021-05-29 19:35:54

    Database selected.

    (expression) onstat -r (repeat) option is not supported with the admin api

    1 row(s) retrieved.

    Database closed.

    When executed with onstat:
    onstat -g cluster verbose
    Your evaluation license will expire on 2021-05-29 19:35:54

    IBM Informix Dynamic Server Version 14.10.FC5TL -- On-Line (Prim) -- Up 02:31:20 -- 1235576 Kbytes
    2021-03-04 20:28:51

    Primary Server:ifmx1
    Current Log Page:11,2012
    Index page logging status: Enabled
    Index page logging was enabled at: 2021/03/04 17:57:38


    -----------------------------------------------------------

    server name: ifmx2
    type: NEAR_SYNC (HDR)
    control block: 0x464e3028
    server status: On
    connection status: Connected
    Last log page sent (log id, page): 11,2012
    Last log page acked (log id, page): 11,2012
    Approximate log page backlog: 0
    SDS cycle not used
    Delayed Apply Not Used
    Stop Apply Not Used
    Time of last ack: 1970/01/01 01:00:00
    Supports Updates: No

    Any thoughts?
    Hrvoje







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

    #Informix


  • 2.  RE: admin( 'onstat', '-g cluster verbose' ) error

    IBM Champion
    Posted Thu March 04, 2021 03:10 PM
    V14.10FC4W1 is working as expected.
    So it is a bug or feature
    Hrvoje

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

    Original Message


  • 3.  RE: admin( 'onstat', '-g cluster verbose' ) error

    Posted Wed March 10, 2021 06:12 AM

    It is a bug ... bit unclear ... IT35329 (which you may not be able to see) ... and 14.10.FC6 SHOULD be okay when released :)



    ------------------------------
    Jon Ritson
    ------------------------------

    Original Message


  • 4.  RE: admin( 'onstat', '-g cluster verbose' ) error

    IBM Champion
    Posted Fri March 12, 2021 02:36 AM
    I've been told that defect/APAR IT36116 was raised
    And yes, C6 will fix that.
    Hrvoje

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

    Original Message