IDS Forum

RE: Onconfig name

Posted By: Penza Kenneth at MITA
Date: Monday, 12 May 2014, at 3:43 a.m.

In Response To: Re: Onconfig name (Art Kagel)

Art,

Thanks a lot for your feedback, I will add store the onconfig
name within the database and query it form the code.

Thanks again
Kenneth Penza

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Art Kagel
Sent: Friday, 09 May 2014 16:50
To: ids@iiug.org
Subject: Re: Onconfig name [32976]

Kenneth:

Since you are running v10.00 and the server's environment is not
available through SQL directly, I would suggest one of two approaches:

1. Create your own repository table in each instance either in a

separate database that you can query by DBSERVERNAME, or

2. Create a flat file with the information you need that the Java app

can read into a data structure at startup, say an associative array
keyed

by the server's DBSERVERNAME.

Either way you can acquire the DBSERVERNAME from the server or from
where ever you are getting the information about which instance to
connect to.
However, I suggest getting the server name from the server so that the
app can connect to any DBSERVERALIAS, connection manager SLA name, or
sqlhosts group name should you change things around to use one or more
of those and still be able to look up the correct information simply
without having to maintain multiple, essentially redundant, mappings.

Art

Art S. Kagel, Principal Consultant
ASK Database Management

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions

and do not reflect on the IIUG, nor any other organization with which I
am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.

On Fri, May 9, 2014 at 10:17 AM, Penza Kenneth at MITA
<kenneth.penza@gov.mt
> wrote:

> Hi Fernando,
>
> Yes, I am find thank you:) Yes sure, actually we have a set of shell
> scripts
> that do most of our housekeeping tasks. At the moment I am writing a
Java
> application that extracts some data from the Informix instance,
process it
> and
> sends out some pdf's. In order to be consistent with our directory
> structure I
> need to put some logs to a directory with name d$ONCONFIG for a
particular
> instance. Since from the Java application I am processing 3/4
instances, I
> need to get this info from the engine.
>
> Regards
> Kenneth Penza
> Systems Engineer | Service Management Department
> MALTA INFORMATION TECHNOLOGY AGENCY
>
> Email:
> Office:
> URL:
> kenneth.penzat@gov.mt
> +356 2599 2867
> http://www.mita.gov.mt
>
> Please read our Legal Notice: http://emailpolicy.mita.gov.mt
> Kindly consider your environmental responsibility before printing this

> e-mail
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Fernando
> Nunes
> Sent: Friday, 09 May 2014 12:23
> To: ids@iiug.org
> Subject: Re: Onconfig name [32972]
>
> Hello Kenneth,
>
> Hope you're fine and it's nice to "see you" here :) I doubt it would
be
> possible without some relatively weird trick... the views you mention
did
> not
> exist in V10...
> But can we know why you need it? If you want to access the values
inside
> onconfig, those are available in sysmaster:syscfgtab
>
> Regards.
>
> On Fri, May 9, 2014 at 8:35 AM, KENNETH PENZA <kenneth.penza@gov.mt>
> wrote:
>
> > Hi,
> >
> > I am developing a JDBC application, and need to read from within SQL

> > the onconfig environment variable.
> >
> > >From with IDS 11.70, I can extract the need information using the
query:
> >
> > select trim(env_value) env_value from informix.sysenv where env_name
=
> > 'ONCONFIG';
> >
> > The code needs to run on IDS 10 as we have not migrated it yet. Can
> > you please provide some pointers from were I can read the onconfig
> > name ?
> >
> > Kenneth
> >
> >
> >
> >
>
>
>
************************************************************************
*******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com
> My email works... but I don't check it frequently...
>
> --089e013a18c20b84a604f8f4fb15
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a113373023130c104f8f8b502

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Onconfig name
  KENNETH PENZA -- Friday, 9 May 2014, at 3:35 a.m.
  • Re: Onconfig name
    Fernando Nunes -- Friday, 9 May 2014, at 6:22 a.m.
    • RE: Onconfig name
      Penza Kenneth at MITA -- Friday, 9 May 2014, at 10:17 a.m.
      • Re: Onconfig name
        Art Kagel -- Friday, 9 May 2014, at 10:49 a.m.
        • RE: Onconfig name
          Penza Kenneth at MITA -- Monday, 12 May 2014, at 3:43 a.m.
      • Re: Onconfig name
        Fernando Nunes -- Friday, 9 May 2014, at 12:47 p.m.
  • Re: Onconfig name
    Art Kagel -- Friday, 9 May 2014, at 9:00 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.