#49 IQ as archive server, few tables are not using RLV store

[Anonymous]

Hi JPM,

I am migrating from ASE as archive to IQ as archive for better storage management.

1. using latest asemon_logger version V3.2.3.
2. Created dbspace with RLV store
3. Monitoring an ASE version 16 server to be archived to IQ asemon.

few tables are enabled for RLV Store, and few are not.
one of the biggest table "StmtStat" is causing 1 row inserts as it is not set for RLV Store.

Noticed, these 2 xml files are creating few tables with RLV_store='N'
MonSQL_V16SP03.xml: <t use_rlv_store="N">
MonSQL.xml: <t use_rlv_store="N"></t></t>

Any parcitular reason to disable RLV on these?
If i enable it, will it work?

Regards,
NKB

[Jean-Paul Martin]

Hi,
yes it's normal
StmtStats has an IDENTITY column and Imust get the new value for each insert
Regards
JPM