Informix Experts

Matching: oninit

New ONINIT startup option

cheetahblog Tags: oninit ‎ 4,124 Views

Suppose you have an application which depends on IDS. Your business requirement is application must starts after a successful IDS memory initialization. Previously there was no way you can validate the return code of oninit process to make a decision whether or not IDS initialize successfully. So, if you have a script that automatically starts IDS and the application respectively, it possible the application may start even though IDS failed to initialize.

A new oninit option has introduced to IDS 11.50 that generate a return code. Based on the return code you can customize the script and automate startup process.

The 'oninit -w' command generates following return codes:

0 - when success
1 - when initialization fails or exceed the timeout value

The 'oninit -w' command forces IDS to wait until it successfully initializes before returning to a shell prompt. You can also provide an addition argument for timeout value with '-w' option. Without any timeout value with '-w' option, IDS will use the default value e.g. 10 minutes. If IDS cannot initialize within the timeout period, oninit generates return code 1 and writes following error message to the online.log file:

Warning: wait time expired

The syntax of new command as follows:

oninit -w
oninit -w

You can use the '-w' option with combination of any other oninit initialization options.

Couple of points to remember:

In a high-availability environment, you can only use the 'oninit -w' command on primary server; it is not valid on secondary servers.
The oninit command returns success when sysmaster, sysutils, sysuser and sysadmin are successfully created.

Sanjit Chakraborty[Read More]

Administration Mode Enhancements in IDS 11.10

cheetahblog Tags: users admin single onmode user oninit mode ‎ 3,961 Views

Some customers find the single user mode in IDS 10 limited because only informix and the DBSA group have access tothe database server. In IDS 11.10, you can give access to other DBAs and specific users in addition to informix andthe DBSA group members when the server is in single user mode. I have listed the steps to give access below:

1. Make sure that the onconfig variable ADMIN_USER_MODE_WITH_DBSA is set to 1.

ADMIN_USER_MODE_WITH_DBSA 1

2. Set the onconfig variable ADMIN_MODE_USERS to a comma separated user list.

ADMIN_MODE_USERS tom,don

3. Start the server in single user mode.

oninit -j
user informix, the DBSA group and ADMIN_MODE_USERS have access
oninit -j -U fred, bill
user informix, DBSA Group and users fred and bill have access

You can use this command if you do not want to use ADMIN_MODE_USERS or if you want to override its value.

4. Dynamically change the server mode using onmode.

onmode -j
user informix, DBSA group and ADMIN_MODE_USERS have access
onmode -j -U fred, bill
user informix, the DBSA Group, users fred and bill have access

You can use this command if you do not want to use ADMIN_MODE_USERS or if you want to override its value.
onmode -j -U ' '
user informix and the DBSA group have access

You can use this command to clear the user list.

Suma Vinod

[Read More]

Feed for Blog Entries

Blogs