How to prevent the startup of the scheduler threads

Problem(Abstract)

This article presents a method of preventing the startup of the scheduler threads during IDS server initialization

Resolving the problem

INTRODUCTION

The Scheduler is a component of IBM Informix® Dynamic Server™ (IDS) that executes tasks defined in the sysadmin database. These tasks are coordinated by the dbScheduler and dbWorker threads within the server. There may be occasions when it is required to prevent the startup of these threads, for example if an assert failure occurs during initialization of the server. This article describes a method to temporarily prevent the startup of the threads used by the Scheduler.


STEPS

1. As the root or informix user create the empty file $INFORMIXDIR/etc/sysadmin/stop. one way to do this is to use the Unix command touch.
2. Stop and restart IDS.
3. During initialization the following message will appear in the message log:

SCHAPI: "INFORMIXDIR/etc/sysadmin/stop" file is present.
Bypassing dbScheduler and dbWorker threads startup.

Important: If the reason for preventing the startup of the Scheduler threads was due to an error such as assert failure then that problem may still exist when the Scheduler is restarted. This document describes a temporary workaround and not a solution to this type of problem and you should search for other documents that refer to this topic for a solution.

http://www-01.ibm.com/support/docview.wss?uid=swg21260058