#8 asemon_logger_V2.7.19 - fail to set 'archive_DBMS' to "IQ"

[Anonymous]

Hi -

Asemon_logger version - asemon_logger_V2.7.19
Sybase/SAP IQ version - SAP IQ/16.0.0.809/150327/P/sp08.30/Enterprise Linux64 - x86_64 - 2.6.18

The code that checks to see what the type of archive server

ResultSet rs=stmt.executeQuery("select substring(@@version, 1, charindex('/', @@version)-1)");
rs.next();
String product= rs.getString(1);
if (product.equalsIgnoreCase("SYBASE IQ"))
Asemon_logger.archive_DBMS = "IQ";
else
Asemon_logger.archive_DBMS = "ASE";
stmt.close();

is looking for "SYBASE IQ"

Where as the result is now

substring(@@version,1,charindex('/',@@version)-1)

SAP IQ

which causes asemon_logger to treat the IQ Server like it's an ASE.

[Jean-Paul Martin]

Hi,
there will be a new version of asemon_logger (V3) able to store collected data directly into IQ 16 with RLV store (at least IQ16SP10 ) This V3 version is currenlty in test. Should be available by the end of this year.