Exactly 14.10.FC4 but with some FC5&6 fixes included as far as I have been able to determine.
Original Message:
Sent: 1/26/2024 3:47:00 AM
From: Kirit Rana
Subject: RE: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
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:
Sent: Thu January 25, 2024 08:16 PM
From: Art Kagel
Subject: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
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:
Sent: Thu January 25, 2024 06:37 PM
From: Kirit Rana
Subject: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
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:
Sent: Thu January 25, 2024 05:36 PM
From: Art Kagel
Subject: IBM Informix 14.10 vs HCL OneDB 2.0.1 sysmaster schema
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:
Sent: Thu January 25, 2024 12:53 PM
From: Kirit Rana
Subject: 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
------------------------------