Printer FriendlyEmail Article Link

Why are RRO table dates not being updated?

Answer

 

Check to insure the OPTCOMPIND is set to 0 in the informix onconfg file.

OPTCOMPIND 2 # To hint the optimizer

To:

OPTCOMPIND 0 # To hint the optimizer

 

(hpomp89i)$ date
Tue Aug 19 10:52:08 CDT 2008

(hpomp89i)$ cat rro_table.dat
PG4 08/16/2008
PG2 08/16/2008
QNN 08/18/2008
PG3 08/17/2008
QCC 08/18/2008

Mon Aug 18 17:10:06 OK Fetch Initiated
Mon Aug 18 18:00:01 IDLE Inserted request for rro(PG2), date(08/16/2008) from blue to
Mon Aug 18 18:00:01 IDLE Inserted request for rro(QNN), date(08/18/2008) from blue to
Mon Aug 18 18:00:01 server_localhost_40000
Mon Aug 18 18:00:01 FETCH OCY/DIY (PG2, 20080816) from blue to
Mon Aug 18 18:00:02 OK Fetch Initiated
Mon Aug 18 18:00:02 server_localhost_40001
Mon Aug 18 18:00:02 FETCH OCY/DIY (QNN, 20080818) from blue to
Mon Aug 18 18:00:03 OK Fetch Initiated
Mon Aug 18 18:00:21 server_localhost_40000
Mon Aug 18 18:00:21 FETCH OCY/DIY (PG3, 20080817) from blue to
Mon Aug 18 18:00:22 OK Fetch Initiated
Mon Aug 18 18:01:09 server_localhost_40001

Product : TINT