IDS Forum

Re: need refresher on DBSERVERNAME/ALIASES/NETTYPE

Posted By: Nick Lello
Date: Tuesday, 19 April 2011, at 6:51 a.m.

In Response To: need refresher on DBSERVERNAME/ALIASES/NETTYPE/SQL (Norma Jean Sebastian)

In some specific versions of IDS using Shared Memory for a large number of
connections was attributed to the engine crashing; it may be that your
predecessors came accross this issue and configured sqlhosts to use soctcp.

I do not know if this issue exists with your current version of the engine.

Regarding the relationship between configuration items:-

- INFORMIXSERVER is a pointer to matching entry/entries in SQLHOSTS which

specifies the connection type and attributes for connecting to a specific

engine (or group of engines).

- DBSERVERNAME/ALIASES are also pointers to (the same) matching entries

in SQLHOSTS and are used to specify which connections to listen to.

- NETTYPE specifies the number of threads listening for a connection type

and the maximum number of connections each thread can handle. It also

specifies whether the thread runs on a CPU VP or NET VP.

Assuming your engine has sufficient shm listeners already configured you may
be able to affect a change to shm connectivity simply by:-

1. Change the connector type in SQLHOSTS from onsoctcp to onipcshm (or

onipcstr if you wish to use streams) --- please verify the connector type

names before proceeding.

2. Bounce the engine.

Regards,
Nick

On 18 April 2011 18:15, Norma Jean Sebastian <njiiug@gmail.com> wrote:

> Hello,
>
> Please point me to a good refresher document about setting INFORMIXSERVER
> and it's relation to DBSERVERNAME/ALIASES
> and relation to NETTYPE
> and relation to SQLHOSTS...
>
> the system i have inherited seems to have all users log in to the onsoctcp
> connection instead of shared memory....
> system is HP-UX Risc, running Informix 11.70.FC1GE.
>
> but all our users open terminal sessions to the informix DB engine server
> so
> why not have them connect through shared memory?
> wouldn't shared memory be faster?
> is there a limit to the number of people who can connect via shared memory?
>
> Thanks for the help/refresher on this, it has been a long time since I have
> had to think through this concept.
>
> Norma Jean (NJ) Sebastian
>
> --0016e6476306e906f004a134883c
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--

Nick Lello | Web Architect
o +44 (0) 8433309374 | m +44 (0) 7917 138319
Email: nick.lello at rentrak.com
RENTRAK | www.rentrak.com | NASDAQ: RENT

--bcaec520f0216b047f04a143339c

Messages In This Thread

• need refresher on DBSERVERNAME/ALIASES/NETTYPE/SQL
  Norma Jean Sebastian -- Monday, 18 April 2011, at 1:15 p.m.
  • Re: need refresher on DBSERVERNAME/ALIASES/NETTYPE
    Jonathan Leffler -- Monday, 18 April 2011, at 1:37 p.m.
  • Re: need refresher on DBSERVERNAME/ALIASES/NETTYPE
    Fernando Nunes -- Monday, 18 April 2011, at 1:43 p.m.
    • RE: need refresher on DBSERVERNAME/ALIASES/NET....
      Joerg Volz -- Monday, 18 April 2011, at 1:46 p.m.
  • Re: need refresher on DBSERVERNAME/ALIASES/NETTYPE
    Nick Lello -- Tuesday, 19 April 2011, at 6:51 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.