Informix

 View Only

  • 1.  IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    Posted Thu January 25, 2024 12:53 PM

    Should there be any differences between the SMI tables contained in the sysmaster database under IBM Informix 14.10 compared to HCL OneDB 2.0.1? 

    Of particular interest are the ReadAhead related tables:

    • sys_ra_act_queues
    • sys_ra_act_daemons
    • sys_ra_ptn_stats
    • sys_ra_thrd_stats

    Whilst the IBM documentation makes reference to them, I am unable to find any reference in the HCL documentation or the OneDB sysmaster database itself. For ease of access here are the URLs to the online documentation provided by both IBM and HCL...

    IBM: The System-Monitoring Interface Tables

    HCL: The System-Monitoring Interface Tables

    What am I missing here ? Were the two not meant to be identical with the exception of a re-branding exercise?

    Any guidance will be appreciated.



    ------------------------------
    Kirit Rana

    Data Platform Services | OpenBet
    Informix | PostgreSQL | Kafka | Redis | Cassandra


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


  • 2.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    IBM Champion
    Posted Thu January 25, 2024 03:07 PM

    HI,

    Depends which version of OneDB you are talking about.


    As per The new Readahead tables appears in IBM Informix 14.10.xC7 - https://www.ibm.com/docs/en/informix-servers/14.10?topic=overview-whats-new-in-informix#concept_v1410xc7__1410xc7_onstat-rah

    As per https://www.ibm.com/support/pages/security-bulletin-ibm-informix-dynamic-server-vulnerable-arbitrary-code-execution-due-apache-log4j-cve-2021-44228-0  Log4J 2.17.1 appears in 14.10.FC7W1.

    As per https://help.hcltechsw.com/onedb/2.0.1/1infocenter/new_features_ce_2.html 

    As per https://help.hcltechsw.com/onedb/2.0.1/1infocenter/new_features_ce_2.html Log4J 2.17.1 does not appear in OneDB until 2.0.1.2.

    Therefore

    • the Readahead tables appear in 14.10.xC7
    • IBM Informix 14.10.FC7W = OneDB 2.0.1.2

    Between OneDB 2.0.1.0 and 2.0.1.2 is 2.0.1.1 so HCL OneDB 2.0.1.0 could be older than IBM Informix 14.10.xC7.

    David.



    ------------------------------
    David Williams
    ------------------------------

    Original Message


  • 3.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    IBM Champion
    Posted Thu January 25, 2024 05:36 PM

    Kirit:

    The enhanced RA tables came in with 14.10.fc7 and enhanced again in Fc8. The latest OneDB release is equivalent to v14.10.fc4 with a few fc6 features and bug fixes added. 

    OneDB v3.0.0 will be resynched with IBM Informix version 15.0.0.0 (new numbering for v15) when they are released sometime around Q2 or early Q3. From then on HCL has committed to keep OneDB in sync with Informix with perhaps some additional features that IBM isn't interested in from time to time.

    Art

    Art



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

    Original Message


  • 4.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    Posted Thu January 25, 2024 06:37 PM
    Edited by Kirit Rana Thu January 25, 2024 06:39 PM

    Art and David,

    If as Art states the latest HCL OneDB version marries up with Informix 14.10.FC4 then I have my answer.

    [ informix@informix-01 ] ~/server > onstat -

    HCL OneDB Server Version 2.0.1.3 -- On-Line (Prim) -- Up 55 days 07:49:25 -- 111462948 Kbytes

    HCL OneDB 2.0.1.3 presents with...

    [ informix@informix-01 ] ~ > echo "SELECT tabname FROM systabnames WHERE dbsname = 'sysmaster' AND tabname[1,6] = 'sys_ra';" | dbaccess sysmaster

    Database selected.

    No rows found.

    Database closed.

    The evidence is plain to see. Much obliged for your prompt responses chaps.

    ------------------------------
    Kirit Rana


    Data Platform Services | OpenBet
    Informix | PostgreSQL | Kafka | Redis | Cassandra

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

    Original Message


  • 5.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    IBM Champion
    Posted Thu January 25, 2024 08:17 PM

    You can check the version equivalence between OneDB and IDS by querying DBINFO('version','full')

    It reports the Informix level versions from either.



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

    Original Message


  • 6.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    Posted Fri January 26, 2024 03:47 AM

    You are not wrong Art...

     

    [ informix@informix-01 ] ~ > echo "SELECT DBINFO('version','full') FROM systables WHERE tabid = 1;" | dbaccess sysmaster

    Database selected.

    (constant)                           

    HCL OneDB Server Version 14.10.FC4EE

    1 row(s) retrieved

    Database closed.

    Good to know. OneDB 2.0.1.3 = Informix 14.1.FC4EE. Thanking you kindly.



    ------------------------------
    Kirit Rana
    ------------------------------

    Original Message


  • 7.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    IBM Champion
    Posted Fri January 26, 2024 07:19 AM
    Exactly 14.10.FC4 but with some FC5&6 fixes included as far as I have been able to determine.



    Original Message


  • 8.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    IBM Champion
    Posted Fri January 26, 2024 10:56 AM
    Or

    select DBINFO('onedb' 'full')

    for the OneDB version

    On 1/25/2024 7:16 PM, Art Kagel via IBM TechXchange Community wrote:
    0100018d43570ffb-d65e8189-0e78-446f-b741-a3c9d62195c3-000000@email.amazonses.com">
    You can check the version equivalence between OneDB and IDS by querying DBINFO('version','full') It reports the Informix level versions from...



    Original Message


  • 9.  RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

    Posted Mon January 29, 2024 10:50 AM

    Thanks Paul.

    Noted



    ------------------------------
    Kirit Rana
    ------------------------------

    Original Message