How to connect Java/JDBC with Connection Manager
Khan asked how a Java/JDBC app should connect to a Connection Manager SLA when the sqlhosts entry 'oltp' is a group (with members oltp1/oltp2 on different ports), so no single port could be put in the JDBC URL. Answers: either define the group on the client (e.g. Windows registry/setnet32, per IBM technote swg21447622), or let the driver read a sqlhosts file directly, e.g. jdbc:informix-sqli:/stores:informixserver=oltp;user=xxx;password=yyy;SQLH_TYPE=FILE;SQLH_FILE=/informix/etc/sqlhosts. This is documented in the Informix JDBC Driver Programmer's Guide. Khan's follow-up about whether the sqlhosts file must be on the client wasn't answered in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello All, Can someone share any link, which could specify how to connect a java (JDBC) application to the connection manager. Actually, I am running two redundant connection manager having 2 SLA's in each CM file. Below you will find the details of the configuration. Now, I wanted to know that if I wanted to connection my JAVA/JDBC application with OLTP SLA then what port I should mention in the JDBC URL? I am trying to connect it using following URL, but I am not sure port I should mention, because ports are mentioned for oltp1 & oltp2, not for oltp. jdbc:informix-sqli://hostname:???/stores:informixserver=oltp Can someone post a correct JDBC URL for me? #========================================================== # Connection Manager 1 Config File #========================================================== # Connection Manager name NAME osk_cmsm_1 # Connection Manager message file LOGFILE /home/informix/osk_cmsm_1.log CM_TIMEOUT 60 #default value is 60 DEBUG 1 EVENT_TIMEOUT 30 #default value is 60 SECONDARY_EVENT_TIMEOUT 30 # BODY # Connection Unit 1 CLUSTER ha_1 { INFORMIXSERVER osktest1_tcp SLA oltp1 DBSERVERS=primary SLA reports1 DBSERVERS=primary FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 } #========================================================== # Connection Manager 2 Config File #========================================================== # Connection Manager name NAME osk_cmsm_2 # Connection Manager message file LOGFILE /home/informix/osk_cmsm_2.log CM_TIMEOUT 60 #default value is 60 DEBUG 1 EVENT_TIMEOUT 30 #default value is 60 SECONDARY_EVENT_TIMEOUT 30 # BODY # Connection Unit 1 CLUSTER ha_2 { INFORMIXSERVER osktest1_tcp SLA oltp2 DBSERVERS=primary SLA reports2 DBSERVERS=primary FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 } #================================================================= # entries in $INFORMIXDIR/etc/sqlhosts file for CM-1 & CM-2 ( to make CM redundant) #================================================================= oltp group - - c=0 oltp1 onsoctcp hostname oltp1 g=oltp #entry to SLA1 in CM-1 oltp2 onsoctcp hostname oltp2 g=oltp #entry to SLA1 in CM-2 reports group - - c=0 reports1 onsoctcp hostname reports1 g=reports #entry to SLA1 in CM-1 reports2 onsoctcp hostname reports2 g=reports #entry to SLA1 in CM-2 ================================================================ # entries in /etc/services file for CM-1 & CM-2 (redundant CMs) ================================================================ oltp1 61570/tcp #entry for SLA1 in CM-1 oltp2 61571/tcp #entry for SLA1 in CM-2 reports1 61572/tcp #entry for SLA2 in CM-1 reports2 61573/tcp #entry for SLA2 in CM-2 I look forward for the support. Thanks. Regards, Khan
What you want to do is setup an Informix group on the client that contains the 4 SLAs into two groups (one for oltp and one for reports). I'm not sure what your client OS is, but here is a tech article on how to set that up for windows clients: http://www-01.ibm.com/support/docview.wss?uid=swg21447622 -Justin -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of O KHAN Sent: Monday, July 08, 2013 7:07 AM To: ids@iiug.org Subject: How to connect Java/JDBC with Connection Manager [30770] Hello All, Can someone share any link, which could specify how to connect a java (JDBC) application to the connection manager. Actually, I am running two redundant connection manager having 2 SLA's in each CM file. Below you will find the details of the configuration. Now, I wanted to know that if I wanted to connection my JAVA/JDBC application with OLTP SLA then what port I should mention in the JDBC URL? I am trying to connect it using following URL, but I am not sure port I should mention, because ports are mentioned for oltp1 & oltp2, not for oltp. jdbc:informix-sqli://hostname:???/stores:informixserver=oltp Can someone post a correct JDBC URL for me? #========================================================== # Connection Manager 1 Config File #========================================================== # Connection Manager name NAME osk_cmsm_1 # Connection Manager message file LOGFILE /home/informix/osk_cmsm_1.log CM_TIMEOUT 60 #default value is 60 DEBUG 1 EVENT_TIMEOUT 30 #default value is 60 SECONDARY_EVENT_TIMEOUT 30 # BODY # Connection Unit 1 CLUSTER ha_1 { INFORMIXSERVER osktest1_tcp SLA oltp1 DBSERVERS=primary SLA reports1 DBSERVERS=primary FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 } #========================================================== # Connection Manager 2 Config File #========================================================== # Connection Manager name NAME osk_cmsm_2 # Connection Manager message file LOGFILE /home/informix/osk_cmsm_2.log CM_TIMEOUT 60 #default value is 60 DEBUG 1 EVENT_TIMEOUT 30 #default value is 60 SECONDARY_EVENT_TIMEOUT 30 # BODY # Connection Unit 1 CLUSTER ha_2 { INFORMIXSERVER osktest1_tcp SLA oltp2 DBSERVERS=primary SLA reports2 DBSERVERS=primary FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 } #================================================================= # entries in $INFORMIXDIR/etc/sqlhosts file for CM-1 & CM-2 ( to make CM redundant) #================================================================= oltp group - - c=0 oltp1 onsoctcp hostname oltp1 g=oltp #entry to SLA1 in CM-1 oltp2 onsoctcp hostname oltp2 g=oltp #entry to SLA1 in CM-2 reports group - - c=0 reports1 onsoctcp hostname reports1 g=reports #entry to SLA1 in CM-1 reports2 onsoctcp hostname reports2 g=reports #entry to SLA1 in CM-2 ================================================================ # entries in /etc/services file for CM-1 & CM-2 (redundant CMs) ================================================================ oltp1 61570/tcp #entry for SLA1 in CM-1 oltp2 61571/tcp #entry for SLA1 in CM-2 reports1 61572/tcp #entry for SLA2 in CM-1 reports2 61573/tcp #entry for SLA2 in CM-2 I look forward for the support. Thanks. Regards, Khan ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
OK, so, oltp doesn't have a port because it is a group entry. You can define a group in the PC's registry and define an OLTP DSN on it, so you may be able to use JDBC using a DSN, but I do not know how to connect to a group using a JDBC connection string describing the connection directly. Perhaps it doesn't need a port number/name. Have you defined the group in the windows registry? If not, check out this link: http://www-01.ibm.com/support/docview.wss?uid=swg21447622 Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 10:06 AM, O KHAN <theultimateboy@hotmail.com> wrote: > Hello All, > > Can someone share any link, which could specify how to connect a java > (JDBC) > application to the connection manager. > > Actually, I am running two redundant connection manager having 2 SLA's in > each > CM file. Below you will find the details of the configuration. > > Now, I wanted to know that if I wanted to connection my JAVA/JDBC > application > with OLTP SLA then what port I should mention in the JDBC URL? > > I am trying to connect it using following URL, but I am not sure port I > should > mention, because ports are mentioned for oltp1 & oltp2, not for oltp. > > jdbc:informix-sqli://hostname:???/stores:informixserver=oltp > > Can someone post a correct JDBC URL for me? > > #========================================================== > # Connection Manager 1 Config File > #========================================================== > # Connection Manager name > NAME osk_cmsm_1 > > # Connection Manager message file > LOGFILE /home/informix/osk_cmsm_1.log > > CM_TIMEOUT 60 #default value is 60 > DEBUG 1 > EVENT_TIMEOUT 30 #default value is 60 > SECONDARY_EVENT_TIMEOUT 30 > > # BODY > # Connection Unit 1 > CLUSTER ha_1 > { > > INFORMIXSERVER osktest1_tcp > > SLA oltp1 DBSERVERS=primary > > SLA reports1 DBSERVERS=primary > > FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 > } > > #========================================================== > # Connection Manager 2 Config File > #========================================================== > # Connection Manager name > NAME osk_cmsm_2 > > # Connection Manager message file > LOGFILE /home/informix/osk_cmsm_2.log > > CM_TIMEOUT 60 #default value is 60 > DEBUG 1 > EVENT_TIMEOUT 30 #default value is 60 > SECONDARY_EVENT_TIMEOUT 30 > > # BODY > # Connection Unit 1 > CLUSTER ha_2 > { > > INFORMIXSERVER osktest1_tcp > > SLA oltp2 DBSERVERS=primary > > SLA reports2 DBSERVERS=primary > > FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 > > } > > #================================================================= > # entries in $INFORMIXDIR/etc/sqlhosts file for CM-1 & CM-2 ( to make CM > redundant) > #================================================================= > oltp group - - c=0 > oltp1 onsoctcp hostname oltp1 g=oltp #entry to SLA1 in CM-1 > oltp2 onsoctcp hostname oltp2 g=oltp #entry to SLA1 in CM-2 > > reports group - - c=0 > reports1 onsoctcp hostname reports1 g=reports #entry to SLA1 in CM-1 > reports2 onsoctcp hostname reports2 g=reports #entry to SLA1 in CM-2 > > ================================================================ > # entries in /etc/services file for CM-1 & CM-2 (redundant CMs) > ================================================================ > oltp1 61570/tcp #entry for SLA1 in CM-1 > oltp2 61571/tcp #entry for SLA1 in CM-2 > > reports1 61572/tcp #entry for SLA2 in CM-1 > reports2 61573/tcp #entry for SLA2 in CM-2 > > I look forward for the support. Thanks. > > Regards, > Khan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0158acf0a7e7cf04e101c04b
you can use SQLH_TYPE/SQLH_FILE in the URL to connect a group name "jdbc:informix-sqli/sotres:informixserver=oltp; user=foo;password=XXXX;SQLH_TYPE=FILE; SQLH_FILE=/informix/sqlhosts"
Very cool! Where is this documented, Jinming? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 11:35 AM, JINMING XIAO <jxiao@us.ibm.com> wrote: > you can use SQLH_TYPE/SQLH_FILE in the URL to connect a group name > > "jdbc:informix-sqli/sotres:informixserver=oltp; > user=foo;password=XXXX;SQLH_TYPE=FILE; > SQLH_FILE=/informix/sqlhosts" > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c356e2adf24304e101d72e
I see one example with HDR pair group name in http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do cnotes.doc/uc7/jdbc_docnotes_3.00.html we can connect to any group name in SQLHOSTS file the same way. Thanks
Ahh, The JDBC Driver's Programming Guide was dropped from the PDF documentation set after 11.10, it no longer appears in the PDF doc sets or the11.50, 11.70, or 12.10 doc sets and I don't remember needing to use groups with Windows clients before 11.50. I do still see the section and page in the Information Center for v12.10! Thanks Jinming! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 12:08 PM, JINMING XIAO <jxiao@us.ibm.com> wrote: > I see one example with HDR pair group name in > > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do cnotes.doc/uc7/jdbc_docnotes_3.00.html > > we can connect to any group name in SQLHOSTS file the same way. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1133e4146b552f04e10267c7
Hi All, Here is how you can connect to a group using JDBC: *"jdbc:informix-sqli:/database_name:informixserver=group_xxxxx;* *user=xxx;password=YYY;SQLH_TYPE=FILE;* *SQLH_FILE=/informix/etc/sqlhosts"* where xxx is the username and YYY is the password. SQLH_FILE contains the path to the sqlhosts file. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 08/07/13 17:32, Art Kagel a écrit : > OK, so, oltp doesn't have a port because it is a group entry. You can > define a group in the PC's registry and define an OLTP DSN on it, so you > may be able to use JDBC using a DSN, but I do not know how to connect to a > group using a JDBC connection string describing the connection directly. > Perhaps it doesn't need a port number/name. > > Have you defined the group in the windows registry? If not, check out this > link: > > http://www-01.ibm.com/support/docview.wss?uid=swg21447622 > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 10:06 AM, O KHAN<theultimateboy@hotmail.com> wrote: > >> Hello All, >> >> Can someone share any link, which could specify how to connect a java >> (JDBC) >> application to the connection manager. >> >> Actually, I am running two redundant connection manager having 2 SLA's in >> each >> CM file. Below you will find the details of the configuration. >> >> Now, I wanted to know that if I wanted to connection my JAVA/JDBC >> application >> with OLTP SLA then what port I should mention in the JDBC URL? >> >> I am trying to connect it using following URL, but I am not sure port I >> should >> mention, because ports are mentioned for oltp1& oltp2, not for oltp. >> >> jdbc:informix-sqli://hostname:???/stores:informixserver=oltp >> >> Can someone post a correct JDBC URL for me? >> >> #========================================================== >> # Connection Manager 1 Config File >> #========================================================== >> # Connection Manager name >> NAME osk_cmsm_1 >> >> # Connection Manager message file >> LOGFILE /home/informix/osk_cmsm_1.log >> >> CM_TIMEOUT 60 #default value is 60 >> DEBUG 1 >> EVENT_TIMEOUT 30 #default value is 60 >> SECONDARY_EVENT_TIMEOUT 30 >> >> # BODY >> # Connection Unit 1 >> CLUSTER ha_1 >> { >> >> INFORMIXSERVER osktest1_tcp >> >> SLA oltp1 DBSERVERS=primary >> >> SLA reports1 DBSERVERS=primary >> >> FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 >> } >> >> #========================================================== >> # Connection Manager 2 Config File >> #========================================================== >> # Connection Manager name >> NAME osk_cmsm_2 >> >> # Connection Manager message file >> LOGFILE /home/informix/osk_cmsm_2.log >> >> CM_TIMEOUT 60 #default value is 60 >> DEBUG 1 >> EVENT_TIMEOUT 30 #default value is 60 >> SECONDARY_EVENT_TIMEOUT 30 >> >> # BODY >> # Connection Unit 1 >> CLUSTER ha_2 >> { >> >> INFORMIXSERVER osktest1_tcp >> >> SLA oltp2 DBSERVERS=primary >> >> SLA reports2 DBSERVERS=primary >> >> FOC ORDER=HDR,RSS TIMEOUT=5 RETRY=3 >> >> } >> >> #================================================================= >> # entries in $INFORMIXDIR/etc/sqlhosts file for CM-1& CM-2 ( to make CM >> redundant) >> #================================================================= >> oltp group - - c=0 >> oltp1 onsoctcp hostname oltp1 g=oltp #entry to SLA1 in CM-1 >> oltp2 onsoctcp hostname oltp2 g=oltp #entry to SLA1 in CM-2 >> >> reports group - - c=0 >> reports1 onsoctcp hostname reports1 g=reports #entry to SLA1 in CM-1 >> reports2 onsoctcp hostname reports2 g=reports #entry to SLA1 in CM-2 >> >> ================================================================ >> # entries in /etc/services file for CM-1& CM-2 (redundant CMs) >> ================================================================ >> oltp1 61570/tcp #entry for SLA1 in CM-1 >> oltp2 61571/tcp #entry for SLA1 in CM-2 >> >> reports1 61572/tcp #entry for SLA2 in CM-1 >> reports2 61573/tcp #entry for SLA2 in CM-2 >> >> I look forward for the support. Thanks. >> >> Regards, >> Khan >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --089e0158acf0a7e7cf04e101c04b > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Thanks for the help, please also tell me that if this sqlhosts path is the file path at the client environment side (i.e. in my case windows path, where I need to create an identical sqlhosts) or it is the sqlhosts path at the Informix Server side i.e. $INFORMIXDIR/etc/sqlhosts? jdbc:informix-sqli:/stores:informixserver=oltp;SQLH_TYPE=FILE;SQLH_FILE=??? Also, just to confirm that if I needed to create the sqlhosts file at the clients side (windows), then , I will still be needed to define groups using setnet32 or not? Thanks in advance for your help!
Aarrgghh!! The manual's been renamed the "Informix JDBC Driver Programmer's Guide" and the index is, naturally in alphabetical order. Missed it. Thanks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 1:19 PM, Hai-Nhu Tran <hntran@us.ibm.com> wrote: > Hi Art, > > The JDBC Driver's Programming Guide is still available in PDF as part of > those doc sets. Here are the links to those PDFs for download: > > 12.10: http://www-01.ibm.com/support/docview.wss?uid=swg27023505 > 11.70: http://www-01.ibm.com/support/docview.wss?uid=swg27019520 > 11.50: http://www-01.ibm.com/support/docview.wss?uid=swg27010058 > > If you're seeing another location where this particular PDF seems to be > missing, please let me know and we'll get that corrected. Thanks! > > Hai-Nhu > > --------------------- > Hai-Nhu Tran > Manager, Information Development for Informix > hntran@us.ibm.com > 415.545.2007 | T/L: 473.2007 > Read the Informix doc team blog: > www.ibm.com/developerworks/mydeveloperworks/blogs/idsdoc > > > > From: Art Kagel <art.kagel@gmail.com> > To: ids@iiug.org, > Date: 07/08/2013 09:19 AM > Subject: Re: How to connect Java/JDBC with Connection Manag [30776] > ------------------------------ > > > > Ahh, The JDBC Driver's Programming Guide was dropped from the PDF > documentation set after 11.10, it no longer appears in the PDF doc sets or > the11.50, 11.70, or 12.10 doc sets and I don't remember needing to use > groups with Windows clients before 11.50. I do still see the section and > page in the Information Center for v12.10! > > Thanks Jinming! > > Art > > Art S. Kagel > Advanced DataTools (*www.advancedatatools.com*<http://www.advancedatatools.com/>; > ) > Blog: *http://informix-myview.blogspot.com/*<http://informix-myview.blogspot.com/>; > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 12:08 PM, JINMING XIAO <*jxiao@us.ibm.com*<jxiao@us.ibm.com>> > wrote: > I see one example with HDR pair group name in > * > ** > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do cnotes.doc/uc7/jdbc_docnotes_3.00.html > *<http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm. docnotes.doc/uc7/jdbc_docnotes_3.00.html> > > we can connect to any group name in SQLHOSTS file the same way. > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > --089e01493380fa344904e1036dfa
Hi Art, The JDBC Driver's Programming Guide is still available in PDF as part of those doc sets. Here are the links to those PDFs for download: 12.10: http://www-01.ibm.com/support/docview.wss?uid=swg27023505 11.70: http://www-01.ibm.com/support/docview.wss?uid=swg27019520 11.50: http://www-01.ibm.com/support/docview.wss?uid=swg27010058 If you're seeing another location where this particular PDF seems to be missing, please let me know and we'll get that corrected. Thanks! Hai-Nhu --------------------- Hai-Nhu Tran Manager, Information Development for Informix hntran@us.ibm.com 415.545.2007 | T/L: 473.2007 Read the Informix doc team blog: www.ibm.com/developerworks/mydeveloperworks/blogs/idsdoc From: Art Kagel <art.kagel@gmail.com> To: ids@iiug.org, Date: 07/08/2013 09:19 AM Subject: Re: How to connect Java/JDBC with Connection Manag [30776] Ahh, The JDBC Driver's Programming Guide was dropped from the PDF documentation set after 11.10, it no longer appears in the PDF doc sets or the11.50, 11.70, or 12.10 doc sets and I don't remember needing to use groups with Windows clients before 11.50. I do still see the section and page in the Information Center for v12.10! Thanks Jinming! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Jul 8, 2013 at 12:08 PM, JINMING XIAO <jxiao@us.ibm.com> wrote: I see one example with HDR pair group name in http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do cnotes.doc/uc7/jdbc_docnotes_3.00.html we can connect to any group name in SQLHOSTS file the same way. Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.