|
Problem IT44199
|
Status: Closed |
EXT_DIRECTIVES ONCONFIG PARAMETER CHANGE IS NOT REFLECTED IN ONLINE.LOG
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
A change in the EXT_DIRECTIVES onconfig parameter is not
reflected or show in the online.log file like it should:
Onconfig parameter modified from to .
Here is the original value for EXT_DIRECTIVES:
Configuration Parameter Info
id name type maxlen units rsvd
tunable
231 EXT_DIRECTIVES INT4 2
min/max : 0,2
default : 0
onconfig: 2
current : 2
Changing the value dinamically won't also work as expected and
described in the documentation:
prompt$> onmode -wf EXT_DIRECTIVES=0
Configuration Parameter to be changed is not valid or not
supported
with this option.
One might change its value in the onconfig file and bounce the
engine:
prompt$> grep EXT_DIRECTIVES $INFORMIXDIR/etc/$ONCONFIG
# EXT_DIRECTIVES - Controls the use of external SQL directives.
EXT_DIRECTIVES 0
prompt$> onmode -ky; sleep 5; oninit -v
New value:
Configuration Parameter Info
id name type maxlen units rsvd
tunable
231 EXT_DIRECTIVES INT4 2
min/max : 0,2
default : 0
onconfig: 0
current : 0
There's no change input in the online.log file. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
****************************************************************
"Note that changing the value of EXT_DIRECTIVES on the fly will
not affect existing sessions. The value of the [on]config
parameter is consulted only when a session connects to the
server." -- Informix Engineering |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
****************************************************************
"Note that changing the value of EXT_DIRECTIVES on the fly will
not affect existing sessions. The value of the [on]config
parameter is consulted only when a session connects to the
server." -- Informix Engineering |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.07.2023
02.06.2024
02.06.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
