Oninit cdi / Archive
Talk to an expert →

Informix 7.31 TC2 is Y2K Compliant?

Posted in 2000

Topics: Storage & Space Management, Stored Procedures & SPL, Error Codes & Troubleshooting

paul — — source: Informix-list mailing list archive (1991-1998)

Dear all We found our Informix 7.31 TC2 ran on NT4 server with SP4 has some Y2K problem, there are two message log display wrong date with "1900/x/x" : 1.agent_ol_tiptop.log 1900/12/1 08:20:47 - ISAM error: duplicate value for a record with unique key. 1900/12/1 12:03:39 - Admin agent for ol_tiptop started. 1900/12/1 12:03:40 - ISAM error: duplicate value for a record with unique key. 1900/12/1 12:03:40 - ISAM error: duplicate value for a record with unique key. 1900/12/1 17:21:14 - Admin agent for ol_tiptop started. 1900/12/1 17:21:16 - ISAM error: duplicate value for a record with unique key. 1900/12/1 17:21:16 - ISAM error: duplicate value for a record with unique key. 1900/12/1 18:03:30 - Admin agent terminated. 1900/12/1 18:08:16 - Admin agent for ol_tiptop started. 1900/12/1 19:52:49 - Admin agent terminated. 1900/12/1 19:57:32 - Admin agent for ol_tiptop started. 1900/13/1 08:37:20 - Admin agent for ol_tiptop started. 2.event_ol_tiptop.log 1900/8/1 01:14:12 - Database Server: A Archive completed alert occurred dbspaces 'rootdbs, pidbs, logdbs, dsdbs, pirep'.. 1900/10/1 09:20:41 - Database Server: An OnLine Initialization Failure alert occurred. 1900/10/1 11:51:53 - Database Server: A Archive completed alert occurred dbspaces 'rootdbs, pidbs, logdbs, dsdbs, pirep'.. Will these error date infect the database server?

↪ replying to paul
Helmut Leininger — — source: Informix-list mailing list archive (1991-1998)

paul wrote: > Dear all > We found our Informix 7.31 TC2 ran on NT4 server with SP4 has some Y2K > problem, there are two message log display wrong date with "1900/x/x" : > > 1.agent_ol_tiptop.log > 1900/12/1 08:20:47 - ISAM error: duplicate value for a record with unique > key. > 1900/12/1 12:03:39 - Admin agent for ol_tiptop started. > 1900/12/1 12:03:40 - ISAM error: duplicate value for a record with unique > key. > 1900/12/1 12:03:40 - ISAM error: duplicate value for a record with unique > key. > 1900/12/1 17:21:14 - Admin agent for ol_tiptop started. > 1900/12/1 17:21:16 - ISAM error: duplicate value for a record with unique > key. > 1900/12/1 17:21:16 - ISAM error: duplicate value for a record with unique > key. > 1900/12/1 18:03:30 - Admin agent terminated. > 1900/12/1 18:08:16 - Admin agent for ol_tiptop started. > 1900/12/1 19:52:49 - Admin agent terminated. > 1900/12/1 19:57:32 - Admin agent for ol_tiptop started. > 1900/13/1 08:37:20 - Admin agent for ol_tiptop started. > > 2.event_ol_tiptop.log > 1900/8/1 01:14:12 - Database Server: A Archive completed alert occurred > dbspaces 'rootdbs, pidbs, logdbs, dsdbs, pirep'.. > 1900/10/1 09:20:41 - Database Server: An OnLine Initialization Failure alert > occurred. > 1900/10/1 11:51:53 - Database Server: A Archive completed alert occurred > dbspaces 'rootdbs, pidbs, logdbs, dsdbs, pirep'.. > > Will these error date infect the database server? What's your setting of DBCENTURY and DBDATE ? It looks as if DBCENTURY is not set and DBDATE=Y2DM, so Informix will force 19 for the century Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.

Glossary