Symptom
- The value of column "update_time" in SYSIQTAB is not shown correctly on a secondary node.
- The problem happens after completing a DML, not a DDL.
- After completing a DML against an IQ base table, the value of a column "update_time" on a secondary node has '0000-01-00 00:00:00.000'.
select A.Table_id, T.table_name, dateformat( t.update_time,'mm/dd/yyyy hh:mm:ss.nnnnnn')
from SYS.SYSIQTAB as A, SYS.SYSTABLE as T
where A.table_id = T.table_id
and T.table_name in ('AAA' ) ;
Table_id, table_name, update_time
12032, 'AAA', '0000-01-00 00:00:00.000',
Read more...
Environment
SAP IQ 15.4
Product
SAP Sybase IQ 15.4
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.