Oninit cdi / Archive
Talk to an expert →

What does DIRECTIVES ONCONFIG parameter mean?

Posted in 2000

Topics: Storage & Space Management, Server Administration, Logging & Checkpoints

Mister Creosote — — source: Informix-list mailing list archive (1991-1998)

Can anybody shed some light on the usage and meaning of the $ONCONFIG parameter DIRECTIVES. As can be seen from the following extract, it would appear to have been changed from 0 to 1. However, the $ONCONFIG file itself has a zero within it. I am guessing the engine has overridden this value but am intrigued as to its use, as we have recently been getting strange date format results. Regards 17:55:22 Quiescent Mode 17:55:26 Informix Dynamic Server Stopped. 17:55:30 Segment locked: addr=0x82000000, size=50331648 Mon Apr 17 17:55:32 2000 17:55:32 Event alarms enabled. ALARMPROG = '/usr/informix/log_full_tms.sh' 17:55:37 DR: DRAUTO is 0 (Off) / 17:55:37 Requested shared memory segment size rounded from 484KB to4096KB 17:55:37 Informix Dynamic Server Version 7.31.UC2 Software SerialNumber AAC# J751945 17:55:37 Informix Dynamic Server Initialized -- Shared MemoryInitialized. 17:55:37 Physical Recovery Started. 17:55:37 Physical Recovery Complete: 0 Pages Restored. 17:55:37 Logical Recovery Started. 17:55:40 Logical Recovery Complete. 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks 17:55:41 Onconfig parameter DIRECTIVES modified from 0 to 1. ^^^^^^^^^^ 17:55:41 Dataskip is now OFF for all dbspaces 17:55:41 Quiescent Mode 17:55:41 Checkpoint Completed: duration was 0 seconds. Mr Creosote -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Mister Creosote
Yuri Dovgart — — source: Informix-list mailing list archive (1991-1998)

Mister Creosote <glynb@my-deja.com> wrote in message news:8dg10q$lil$1@nnrp1.deja.com... > Can anybody shed some light on the usage and meaning of the $ONCONFIG > parameter DIRECTIVES. As can be seen from the following extract, it > would appear to have been changed from 0 to 1. However, the $ONCONFIG > file itself has a zero within it. I am guessing the engine has > overridden this value but am intrigued as to its use, as we have > recently been getting strange date format results. ONCONFIG param DIRECTIVES turns on or off usage of optimizer directives. With DIRECTIVES set to 1 you can rule the optimizer with directives. In other case plans will be generated according to the cost estimates. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > Regards > > 17:55:22 Quiescent Mode > 17:55:26 Informix Dynamic Server Stopped. > 17:55:30 Segment locked: addr=0x82000000, size=50331648> > Mon Apr 17 17:55:32 2000 > > 17:55:32 Event alarms enabled. ALARMPROG > = '/usr/informix/log_full_tms.sh' > 17:55:37 DR: DRAUTO is 0 (Off) > / > 17:55:37 Requested shared memory segment size rounded from 484KB to> 4096KB > 17:55:37 Informix Dynamic Server Version 7.31.UC2 Software Serial> Number AAC# > J751945 > 17:55:37 Informix Dynamic Server Initialized -- Shared Memory> Initialized. > 17:55:37 Physical Recovery Started. > 17:55:37 Physical Recovery Complete: 0 Pages Restored. > 17:55:37 Logical Recovery Started. > 17:55:40 Logical Recovery Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 17:55:41 Onconfig parameter DIRECTIVES modified from 0 to 1. > ^^^^^^^^^^ > 17:55:41 Dataskip is now OFF for all dbspaces > 17:55:41 Quiescent Mode > 17:55:41 Checkpoint Completed: duration was 0 seconds.> > Mr Creosote > > -- > "Just a waffer thin mint?" > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

Glossary