Update 3: This behavior was caused by the new dbsrv17 -k option which disables all sorts of performance-related properties like PROPERTY ( 'ActiveReq' ).

Update 2: FWIW the behavior of CacheHits and CacheRead was first noticed on August 1 so it dates from before build 2100.

Update 1: This may be the tip of the iceberg... there may be other properties returning zero, such as the database-level ActiveReq and ConnCount properties. The phrase "may be" is carefully chosen because I haven't created a reproducible like the one shown below, I have only noticed that the Foxhound 4 Database Monitor display for a fresh 17.0.4.2100 database ... is ... starkly ... useless.

When a database file created with 17.0.0.1359 is run on an 17.0.4.2100 engine, the database-level and connection-level CacheHits and CacheRead properties all work OK; see Test 1 below.

However, when the database file is created with 17.0.4.2100, all those properties return zero; see Test 2 below.

Background: This startling symptom turned up in Foxhound 4 regression testing. Test 1 used the original demo17 database as delivered with SQL Anywhere 17 GA, and Test 2 uses a fresh 17.0.4.2100 database filled from demo17 via dbunload and dbisql reload.

-- Test 1: 17.0.0.1359 database file on 17.0.4.2100 engine

SELECT COUNT(*) FROM GROUPO.SalesOrderItems;

SELECT version AS database_file_version FROM SYSHISTORY WHERE operation = 'INIT';

SELECT @@VERSION AS engine_version, Number, PropName, Value 
  FROM sa_conn_properties() 
 WHERE PropName IN ( 'CacheHits', 'CacheRead' )
 ORDER BY Number, PropName;

SELECT @@VERSION AS engine_version, PropName, Value 
  FROM sa_db_properties() 
 WHERE PropName IN ( 'CacheHits', 'CacheRead' )
 ORDER BY PropName;

COUNT()
1097

database_file_version
'17.0.0.1359'

engine_version,Number,PropName,Value
'17.0.4.2100',1,'CacheHits',65257
'17.0.4.2100',1,'CacheRead',65257
'17.0.4.2100',24,'CacheHits',60139
'17.0.4.2100',24,'CacheRead',60139

engine_version,PropName,Value
'17.0.4.2100','CacheHits',255825204
'17.0.4.2100','CacheRead',255825205

-- Test 2: 17.0.4.2100 database file on 17.0.4.2100 engine

SELECT COUNT(*) FROM GROUPO.SalesOrderItems;

SELECT version AS database_file_version FROM SYSHISTORY WHERE operation = 'INIT';

SELECT @@VERSION AS engine_version, Number, PropName, Value 
  FROM sa_conn_properties() 
 WHERE PropName IN ( 'CacheHits', 'CacheRead' )
 ORDER BY Number, PropName;

SELECT @@VERSION AS engine_version, PropName, Value 
  FROM sa_db_properties() 
 WHERE PropName IN ( 'CacheHits', 'CacheRead' )
 ORDER BY PropName;

COUNT()
1097

database_file_version
'17.0.4.2100'

engine_version,Number,PropName,Value
'17.0.4.2100',1,'CacheHits',0
'17.0.4.2100',1,'CacheRead',0
'17.0.4.2100',3,'CacheHits',0
'17.0.4.2100',3,'CacheRead',0

engine_version,PropName,Value
'17.0.4.2100','CacheHits',0
'17.0.4.2100','CacheRead',0