Oninit cdi / Archive
Talk to an expert →

Common sqlhosts file

Posted in 2006

Topics: Server Administration, Networking & sqlhosts Configuration, Jobs, Consulting & Announcements

Thakkar, Sunil — — source: IIUG Forums & Mailing Lists

Hi, I have different applications and different environment for each application. Applications A1, A2, A3 Environment DEV, QA, PROD Is it ok for me to have one sqlhost file that will have entries for each combination. I am also looking at putting all the entries in the /etc/services file. Would it be of any concern/worry if I put this entries. /etc/services file would have A1_dev_tcp 3101 A1_qa_tcp 3102 A1_prod_tcp 3103 A2_dev_tcp 3201 A2_qa_tcp 3202 Similarly I am planning to have a common sqlhost file that would have all the entries A1_dev_tcp A1_dev_shm onipcshm host1 a1_dev_shm A1_dev_tcp ontlitcp host1 a1_dev_tcp A1_qa_shm onipcshm host2 a1_dev_shm A1_qa_tcp ontlitcp host2 a1_dev_tcp Let me know if you need additional details. Thanks, Sunil Thakkar Sr. Consultant - DBA BearingPoint || 6399 S Fiddlers Green Cir Greenwood Village, CO 80111 - 4915 || Office: 720.493.7012 || Cell: 720.299.6464 || Fax: 720.920.4000 || sunil.thakkar@bearingpoint.com || www.bearingpoint.com ******************************************************************************** ******************* The information in this email is confidential and may be legally privileged Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ******************************************************************************** *******************

↪ replying to Thakkar, Sunil
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

Nothing wrong with any of that. It is essentially how things were designed to be used. Art S. Kagel ----- Original Message ----- From: Sunil Thakkar <ids@iiug.org> At: 7/18 17:41:49 Hi, I have different applications and different environment for each application. Applications A1, A2, A3 Environment DEV, QA, PROD Is it ok for me to have one sqlhost file that will have entries for each combination. I am also looking at putting all the entries in the /etc/services file. Would it be of any concern/worry if I put this entries. /etc/services file would have A1_dev_tcp 3101 A1_qa_tcp 3102 A1_prod_tcp 3103 A2_dev_tcp 3201 A2_qa_tcp 3202 Similarly I am planning to have a common sqlhost file that would have all the entries A1_dev_tcp A1_dev_shm onipcshm host1 a1_dev_shm A1_dev_tcp ontlitcp host1 a1_dev_tcp A1_qa_shm onipcshm host2 a1_dev_shm A1_qa_tcp ontlitcp host2 a1_dev_tcp Let me know if you need additional details. Thanks, Sunil Thakkar Sr. Consultant - DBA BearingPoint || 6399 S Fiddlers Green Cir Greenwood Village, CO 80111 - 4915 || Office: 720.493.7012 || Cell: 720.299.6464 || Fax: 720.920.4000 || sunil.thakkar@bearingpoint.com || www.bearingpoint.com ******************************************************************************** ******************* The information in this email is confidential and may be legally privileged Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ******************************************************************************** ******************* ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Thakkar, Sunil
Support Informix — — source: IIUG Forums & Mailing Lists

That will work fine. You could put more instances (=INFORMIXSERVER) on one host, if you need or on different hosts (as you do host1, host2) As long as the onconfig parameter SERVERNUM is unique for each INFORMIXSERVER Yves -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Sent: 18 July 2006 23:37 To: ids@iiug.org Subject: Common sqlhosts file [7123] Hi, I have different applications and different environment for each application. Applications A1, A2, A3 Environment DEV, QA, PROD Is it ok for me to have one sqlhost file that will have entries for each combination. I am also looking at putting all the entries in the /etc/services file. Would it be of any concern/worry if I put this entries. /etc/services file would have A1_dev_tcp 3101 A1_qa_tcp 3102 A1_prod_tcp 3103 A2_dev_tcp 3201 A2_qa_tcp 3202 Similarly I am planning to have a common sqlhost file that would have all the entries A1_dev_tcp A1_dev_shm onipcshm host1 a1_dev_shm A1_dev_tcp ontlitcp host1 a1_dev_tcp A1_qa_shm onipcshm host2 a1_dev_shm A1_qa_tcp ontlitcp host2 a1_dev_tcp Let me know if you need additional details. Thanks, Sunil Thakkar Sr. Consultant - DBA BearingPoint || 6399 S Fiddlers Green Cir Greenwood Village, CO 80111 - 4915 || Office: 720.493.7012 || Cell: 720.299.6464 || Fax: 720.920.4000 || sunil.thakkar@bearingpoint.com || www.bearingpoint.com **************************************************************************** *********************** The information in this email is confidential and may be legally privileged Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. **************************************************************************** *********************** **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visiter notre site web: http://www.dofi.fgov.be

Glossary