Re: Informix in offline mode

Posted in 2003

Summary

Eyal Goren had an Informix 7.2 OnLine instance on Windows NT that went offline. Jonathan Leffler asked for platform, version, oninit errors and the online log. The posted log showed normal initialization and a stop. utkanbir guessed the server stopped because it was started from a command-line window and advised starting it from Services. Fernando Nunes replied about INFORMIXSERVER. Unresolved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades

Jonathan Leffler — Thu, 13 Nov 2003 05:39:39 GMT — source: Usenet: comp.databases.informix

Eyal Goren wrote: > I am trying to install a product that is based on Informix server > (7.2). > > The problem is that after Installation, and reboot, the Informix is in > offline mode, and refuses to go online. > > Any ideas ??? Why 7.2 - you should be upgraded by now. As John said - which platform? Which detailed version number? What are the error messages from oninit? What's in the online log file? The answer should be there, more or less. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler

Eyal Goren — 13 Nov 2003 03:47:28 -0800 — source: Usenet: comp.databases.informix

Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<vOEsb.11220$6c3.10434@newsread1.news.pas.earthlink.net>... > Eyal Goren wrote: > > I am trying to install a product that is based on Informix server > > (7.2). > > > > The problem is that after Installation, and reboot, the Informix is in > > offline mode, and refuses to go online. > > > > Any ideas ??? > > Why 7.2 - you should be upgraded by now. > > As John said - which platform? Which detailed version number? > > What are the error messages from oninit? What's in the online log > file? The answer should be there, more or less. Hi, The platform is Windows NT, the online log is this: Wed Nov 12 14:59:58 2003 14:59:58 DR: DRAUTO is 0 (Off) 15:00:19 INFORMIX-OnLine Initialized -- Complete Disk Initialized. 15:00:20 Checkpoint Completed: duration was 0 seconds. 15:00:20 Dataskip is now OFF for all dbspaces 15:00:20 On-Line Mode 15:00:31 Building 'sysmaster' database ... 15:00:35 Logical Log 1 Complete. 15:00:38 Logical Log 2 Complete. 15:00:39 Checkpoint Completed: duration was 0 seconds. 15:00:45 Logical Log 3 Complete. 15:00:46 Logical Log 4 Complete. 15:00:48 Logical Log 5 Complete. 15:00:50 Logical Log 6 Complete. 15:00:53 Logical Log 7 Complete. 15:01:08 'sysmaster' database built successfully. 15:01:08 Init operation complete - Mode Online Initialized 15:01:27 Checkpoint Completed: duration was 0 seconds. 15:05:31 INFORMIX-OnLine Stopped. Wed Nov 12 15:07:10 2003 15:07:10 DR: DRAUTO is 0 (Off) 15:07:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 15:07:39 Physical Recovery Started. 15:07:39 Physical Recovery Complete: 0 Pages Restored. 15:07:39 Logical Recovery Started. 15:07:42 Logical Recovery Complete. 1 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 15:07:42 Onconfig parameter ALARMPROGRAM modified from <blank> to D:\\Informix\\etc\\no_log.bat. 15:07:42 Onconfig parameter MAX_PDQPRIORITY modified from 0 to 100. 15:07:42 Dataskip is now OFF for all dbspaces 15:07:42 Init operation complete - Mode Online 15:07:42 On-Line Mode 15:07:54 Checkpoint Completed: duration was 1 seconds. 17:25:46 INFORMIX-OnLine Stopped. Wed Nov 12 17:27:22 2003 17:27:22 DR: DRAUTO is 0 (Off) 17:27:45 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 17:27:45 Physical Recovery Started. 17:27:45 Physical Recovery Complete: 0 Pages Restored. 17:27:45 Logical Recovery Started. 17:27:48 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 17:27:48 Dataskip is now OFF for all dbspaces 17:27:48 Init operation complete - Mode Online 17:27:48 On-Line Mode 17:28:00 Checkpoint Completed: duration was 0 seconds. 17:44:39 INFORMIX-OnLine Stopped. Wed Nov 12 17:46:15 2003 17:46:15 DR: DRAUTO is 0 (Off) 17:46:38 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 17:46:38 Physical Recovery Started. 17:46:38 Physical Recovery Complete: 0 Pages Restored. 17:46:38 Logical Recovery Started. 17:46:41 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 17:46:41 Dataskip is now OFF for all dbspaces 17:46:41 Init operation complete - Mode Online 17:46:41 On-Line Mode 17:46:52 Checkpoint Completed: duration was 0 seconds. 17:55:54 INFORMIX-OnLine Stopped. Wed Nov 12 17:57:28 2003 17:57:28 DR: DRAUTO is 0 (Off) 17:57:50 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 17:57:50 Physical Recovery Started. 17:57:50 Physical Recovery Complete: 0 Pages Restored. 17:57:50 Logical Recovery Started. 17:57:56 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 17:57:56 Dataskip is now OFF for all dbspaces 17:57:56 Init operation complete - Mode Online 17:57:56 On-Line Mode 17:58:08 Checkpoint Completed: duration was 1 seconds. 18:19:26 INFORMIX-OnLine Stopped. Wed Nov 12 18:20:58 2003 18:20:58 DR: DRAUTO is 0 (Off) 18:21:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 18:21:39 Physical Recovery Started. 18:21:39 Physical Recovery Complete: 0 Pages Restored. 18:21:39 Logical Recovery Started. 18:21:42 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 18:21:42 Dataskip is now OFF for all dbspaces 18:21:42 Init operation complete - Mode Online 18:21:42 On-Line Mode 18:21:53 Checkpoint Completed: duration was 0 seconds. Thu Nov 13 08:46:40 2003 08:46:40 INFORMIX-OnLine Stopped. Thu Nov 13 08:48:16 2003 08:48:16 DR: DRAUTO is 0 (Off) 08:48:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 08:48:39 Physical Recovery Started. 08:48:39 Physical Recovery Complete: 0 Pages Restored. 08:48:39 Logical Recovery Started. 08:48:42 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 08:48:42 Dataskip is now OFF for all dbspaces 08:48:43 Init operation complete - Mode Online 08:48:43 On-Line Mode 08:48:54 Checkpoint Completed: duration was 0 seconds. 11:19:23 Checkpoint Completed: duration was 0 seconds.

↪ replying to Eyal Goren

utkanbir — 13 Nov 2003 05:36:48 -0800 — source: Usenet: comp.databases.informix

just a guess, if uou start informix by using command line , oninit , whenever this window closes , so dbserver does. Start db server by using services. Kind Regards, hope eyal_goren@bmc.com (Eyal Goren) wrote in message news:<88eabf1e.0311130347.5d4291c5@posting.google.com>... > Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<vOEsb.11220$6c3.10434@newsread1.news.pas.earthlink.net>... > > Eyal Goren wrote: > > > I am trying to install a product that is based on Informix server > > > (7.2). > > > > > > The problem is that after Installation, and reboot, the Informix is in > > > offline mode, and refuses to go online. > > > > > > Any ideas ??? > > > > Why 7.2 - you should be upgraded by now. > > > > As John said - which platform? Which detailed version number? > > > > What are the error messages from oninit? What's in the online log > > file? The answer should be there, more or less. > > Hi, > The platform is Windows NT, the online log is this: > Wed Nov 12 14:59:58 2003 > > 14:59:58 DR: DRAUTO is 0 (Off) > 15:00:19 INFORMIX-OnLine Initialized -- Complete Disk Initialized. > 15:00:20 Checkpoint Completed: duration was 0 seconds. > 15:00:20 Dataskip is now OFF for all dbspaces > 15:00:20 On-Line Mode > 15:00:31 Building 'sysmaster' database ... > 15:00:35 Logical Log 1 Complete. > 15:00:38 Logical Log 2 Complete. > 15:00:39 Checkpoint Completed: duration was 0 seconds. > 15:00:45 Logical Log 3 Complete. > 15:00:46 Logical Log 4 Complete. > 15:00:48 Logical Log 5 Complete. > 15:00:50 Logical Log 6 Complete. > 15:00:53 Logical Log 7 Complete. > 15:01:08 'sysmaster' database built successfully. > 15:01:08 Init operation complete - Mode Online Initialized > 15:01:27 Checkpoint Completed: duration was 0 seconds. > 15:05:31 INFORMIX-OnLine Stopped.> > Wed Nov 12 15:07:10 2003 > > 15:07:10 DR: DRAUTO is 0 (Off) > 15:07:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 15:07:39 Physical Recovery Started. > 15:07:39 Physical Recovery Complete: 0 Pages Restored. > 15:07:39 Logical Recovery Started. > 15:07:42 Logical Recovery Complete.> 1 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 15:07:42 Onconfig parameter ALARMPROGRAM modified from <blank> to > D:\\Informix\\etc\\no_log.bat. > 15:07:42 Onconfig parameter MAX_PDQPRIORITY modified from 0 to 100. > 15:07:42 Dataskip is now OFF for all dbspaces > 15:07:42 Init operation complete - Mode Online > 15:07:42 On-Line Mode > 15:07:54 Checkpoint Completed: duration was 1 seconds. > 17:25:46 INFORMIX-OnLine Stopped.> > Wed Nov 12 17:27:22 2003 > > 17:27:22 DR: DRAUTO is 0 (Off) > 17:27:45 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 17:27:45 Physical Recovery Started. > 17:27:45 Physical Recovery Complete: 0 Pages Restored. > 17:27:45 Logical Recovery Started. > 17:27:48 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 17:27:48 Dataskip is now OFF for all dbspaces > 17:27:48 Init operation complete - Mode Online > 17:27:48 On-Line Mode > 17:28:00 Checkpoint Completed: duration was 0 seconds. > 17:44:39 INFORMIX-OnLine Stopped.> > Wed Nov 12 17:46:15 2003 > > 17:46:15 DR: DRAUTO is 0 (Off) > 17:46:38 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 17:46:38 Physical Recovery Started. > 17:46:38 Physical Recovery Complete: 0 Pages Restored. > 17:46:38 Logical Recovery Started. > 17:46:41 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 17:46:41 Dataskip is now OFF for all dbspaces > 17:46:41 Init operation complete - Mode Online > 17:46:41 On-Line Mode > 17:46:52 Checkpoint Completed: duration was 0 seconds. > 17:55:54 INFORMIX-OnLine Stopped.> > Wed Nov 12 17:57:28 2003 > > 17:57:28 DR: DRAUTO is 0 (Off) > 17:57:50 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 17:57:50 Physical Recovery Started. > 17:57:50 Physical Recovery Complete: 0 Pages Restored. > 17:57:50 Logical Recovery Started. > 17:57:56 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 17:57:56 Dataskip is now OFF for all dbspaces > 17:57:56 Init operation complete - Mode Online > 17:57:56 On-Line Mode > 17:58:08 Checkpoint Completed: duration was 1 seconds. > 18:19:26 INFORMIX-OnLine Stopped.> > Wed Nov 12 18:20:58 2003 > > 18:20:58 DR: DRAUTO is 0 (Off) > 18:21:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 18:21:39 Physical Recovery Started. > 18:21:39 Physical Recovery Complete: 0 Pages Restored. > 18:21:39 Logical Recovery Started. > 18:21:42 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 18:21:42 Dataskip is now OFF for all dbspaces > 18:21:42 Init operation complete - Mode Online > 18:21:42 On-Line Mode > 18:21:53 Checkpoint Completed: duration was 0 seconds.> > Thu Nov 13 08:46:40 2003 > > 08:46:40 INFORMIX-OnLine Stopped.> > Thu Nov 13 08:48:16 2003 > > 08:48:16 DR: DRAUTO is 0 (Off) > 08:48:39 INFORMIX-OnLine Initialized -- Shared Memory Initialized. > 08:48:39 Physical Recovery Started. > 08:48:39 Physical Recovery Complete: 0 Pages Restored. > 08:48:39 Logical Recovery Started. > 08:48:42 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 08:48:42 Dataskip is now OFF for all dbspaces > 08:48:43 Init operation complete - Mode Online > 08:48:43 On-Line Mode > 08:48:54 Checkpoint Completed: duration was 0 seconds. > 11:19:23 Checkpoint Completed: duration was 0 seconds.

↪ replying to utkanbir

Fernando Nunes — Thu, 13 Nov 2003 14:52:36 +0000 — source: Usenet: comp.databases.informix

utkanbir wrote: > just a guess, > > if uou start informix by using command line , oninit , whenever this > window closes , so dbserver does. Start db server by using services. > > Kind Regards, > hope starts INFORMIXSERVER Regards.