IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
Posted in 2024
Kirit Rana asked why the ReadAhead SMI tables (sys_ra_*) in Informix 14.10 sysmaster are missing from HCL OneDB 2.0.1. David Williams and Art Kagel explained they arrived in 14.10.FC7, while OneDB 2.0.1.3 equals 14.10.FC4 plus some FC5/FC6 fixes. Art noted DBINFO('version','full') shows the equivalent level; Paul Watson added a OneDB-specific DBINFO call.
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
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 ------------------------------
Related threads
- IDS 14.10.FC5 on Ubuntu 20.04 - can't start shm listener
- PDF documentation is available!!!
- Detect if we are inside a transaction
- -999 Not implemented yet.
- idle session consuming lots of cpu time, but doing nothing apparently