IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------ 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 ------------------------------

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 ------------------------------

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 ------------------------------

Exactly 14.10.FC4 but with some FC5&6 fixes included as far as I have been able to determine.

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...

Thanks Paul. Noted ------------------------------ Kirit Rana ------------------------------