Very Computer

by **Thomas G. Smit** » Sun, 31 Dec 1899 09:00:00

Is there a command to force the engine to show me what all the onconfig
parameters (and other perhaps unknown parameters) have been set to?

by **Rob Wils** » Sun, 31 Dec 1899 09:00:00

Use oncheck -pr to see what they were set to last time you brought up the
engine, onstat -c to print out the current onconfig file (not necessarily what
you are running with), or run a query against sysconfig (select * from
sysconfig;). Especially interesting in sysconfig is the effective and
original column. You can see what has changed.

HTH

: Is there a command to force the engine to show me what all the onconfig
: parameters (and other perhaps unknown parameters) have been set to?

--
Rob Wilson

by **Marichamy, Udaykuma** » Sun, 31 Dec 1899 09:00:00

onmode -c

Uday

-----Original Message-----

Sent: Wednesday, April 28, 1999 2:19 PM

Subject: onconfig parameters

Is there a command to force the engine to show me what all the onconfig
parameters (and other perhaps unknown parameters) have been set to?

by **Sujit...** » Sun, 31 Dec 1899 09:00:00

Thomas

onstat -c shows you the contents of the ONCONFIG file, but then so does vi
$INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question?

HTH
Sujit

cc: (bcc: Sujit Pal)
Subject: onconfig parameters

Is there a command to force the engine to show me what all the onconfig
parameters (and other perhaps unknown parameters) have been set to?

by **Chuck Renau** » Sun, 31 Dec 1899 09:00:00

Quote:> onstat -c shows you the contents of the ONCONFIG file, but then so does vi
> $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question?

Does onstat -c reflect changes made by onmode commands? I
should try that and see...that, to me, would be the compelling
reason for showing the configuration of the engine instead of the
.onconfig file...

by **Richard Thom** » Sun, 31 Dec 1899 09:00:00

I think you mean onstat -c.

onmode -c performs a checkpoint...

Richard

On Wed, 28 Apr 1999 15:12:26 -0500, "Marichamy, Udaykumar"

>onmode -c

>Uday

>-----Original Message-----

>Sent: Wednesday, April 28, 1999 2:19 PM

>Subject: onconfig parameters

>Is there a command to force the engine to show me what all the onconfig
>parameters (and other perhaps unknown parameters) have been set to?

by **Thomas G. Smit** » Sun, 31 Dec 1899 09:00:00

Let me restate my original question in a more verbose, less comprehensive
manner:

I need to force the engine to vomit back to me what the current settings are for
all config parameters -- *in memory*, not in the misleading config file --
something like 0racle's SHOW PARAMETERS command in sqlplus/svrmgrl. Is IDS even
capable of such a basic reporting function? Sorry, onstat -c isn't what I need
-- Kewpie doll to first _correct_ answer.

> > onstat -c shows you the contents of the ONCONFIG file, but then so does vi
> > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question?

> Does onstat -c reflect changes made by onmode commands? I
> should try that and see...that, to me, would be the compelling
> reason for showing the configuration of the engine instead of the
> .onconfig file...

by **Marichamy, Udaykuma** » Sun, 31 Dec 1899 09:00:00

You are right. Thanks for the correction.

Uday

-----Original Message-----

Sent: Thursday, April 29, 1999 4:27 AM

Subject: Re: onconfig parameters

I think you mean onstat -c.

onmode -c performs a checkpoint...

Richard

On Wed, 28 Apr 1999 15:12:26 -0500, "Marichamy, Udaykumar"

>onmode -c

>Uday

>-----Original Message-----

>Sent: Wednesday, April 28, 1999 2:19 PM

>Subject: onconfig parameters

>Is there a command to force the engine to show me what all the onconfig
>parameters (and other perhaps unknown parameters) have been set to?

by **Thomas J. Girsc** » Sun, 31 Dec 1899 09:00:00

First of all, it's a "Cupie" doll, and secondly, there's no way to do
EVERYTHING you want, but you _can_ get most of it. But it's not 100%
straightforward.

If you do an 'oncheck -pr' that will give you most of the shared-memory type
parameters, along with scads of other stuff.

Other things, like tape parameters and the like, it always checks the
ONCONFIG file every time it's needed, so it's not stored in the reserved
pages anywhere.

Cupie doll, please!

> Let me restate my original question in a more verbose, less comprehensive
> manner:

> I need to force the engine to vomit back to me what the current settings
are for
> all config parameters -- *in memory*, not in the misleading config
file --
> something like 0racle's SHOW PARAMETERS command in sqlplus/svrmgrl. Is
IDS even
> capable of such a basic reporting function? Sorry, onstat -c isn't what I
need
> -- Kewpie doll to first _correct_ answer.

> > > onstat -c shows you the contents of the ONCONFIG file, but then so
does vi
> > > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question?

> > Does onstat -c reflect changes made by onmode commands? I
> > should try that and see...that, to me, would be the compelling
> > reason for showing the configuration of the engine instead of the
> > .onconfig file...

by **Carlso** » Sun, 31 Dec 1899 09:00:00

Are you using IDS 7.x?

If so, then why not

database sysmaster
select * from sysconfig

It even shows you what the default values are.

John Carlson
Informix DBA
WHSmith USA

> Let me restate my original question in a more verbose, less comprehensive
> manner:

> I need to force the engine to vomit back to me what the current settings are for
> all config parameters -- *in memory*, not in the misleading config file --
> something like 0racle's SHOW PARAMETERS command in sqlplus/svrmgrl. Is IDS even
> capable of such a basic reporting function? Sorry, onstat -c isn't what I need
> -- Kewpie doll to first _correct_ answer.

> > > onstat -c shows you the contents of the ONCONFIG file, but then so does vi
> > > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question?

> > Does onstat -c reflect changes made by onmode commands? I
> > should try that and see...that, to me, would be the compelling
> > reason for showing the configuration of the engine instead of the
> > .onconfig file...

by **Richard Thom** » Sun, 31 Dec 1899 09:00:00

As I think someone else has already said, oncheck -pr returns the
values of the config paramaters, as they currently are within
the engine, which is not necessarily the same as the values in the
onconfig file.

Richard

PS I'm not a yank, so what is a "Kewpie doll", and would I want one
if I was given it?!!

Quote:>Let me restate my original question in a more verbose, less comprehensive
>manner:

>I need to force the engine to vomit back to me what the current settings are for
>all config parameters -- *in memory*, not in the misleading config file --
>something like 0racle's SHOW PARAMETERS command in sqlplus/svrmgrl. Is IDS even
>capable of such a basic reporting function? Sorry, onstat -c isn't what I need
>-- Kewpie doll to first _correct_ answer.

by **Rob Pro** » Sun, 31 Dec 1899 09:00:00

Hi,

You should use: onstat -c and not onmode -c (this executes a checkpoint).

Greetings,

Rob Prop
Database Consultant
Informa Automatisering B.V.

> onmode -c

> Uday

> -----Original Message-----

> Sent: Wednesday, April 28, 1999 2:19 PM

> Subject: onconfig parameters

> Is there a command to force the engine to show me what all the onconfig
> parameters (and other perhaps unknown parameters) have been set to?

r.prop.vcf
< 1K Download

by **Obnoxio The Clow** » Sun, 31 Dec 1899 09:00:00

Quote:
>First of all, it's a "Cupie" doll,

Bzzzzt! Wrong! It _is_ a Kewpie doll. :-)

http://www.geocities.com/EnchantedForest/2088/antique.htm

(No, it's not my site, no matter how sad you think I am... :-)

> > -- Kewpie doll to first _correct_ answer.

Get Your Private, Free Email at http://<

by **Randall Youn** » Sun, 31 Dec 1899 09:00:00

>Is there a command to force the engine to show me what all the onconfig
>parameters (and other perhaps unknown parameters) have been set to?

At Informix Online 7.23, there is a sysmaster table that tells you what the
archive pages recognize. I use it but don't have my scripts in front of
me. Take a gander through the sysmaster tables and you will probably guess
the name of the table. Be advised that some of the onconfig variables can
be modified without bouncing the engine and they won't be in the sysmaster
table.

Randall Young