Re: Informix in offline mode

Posted in 2003

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.