RE: SQL CONNECT TO Ports

[michael@xxxxxxxxxxxxxxxxxx]

thanks Bruce...

> -------- Original Message --------
> Subject: RE: SQL CONNECT TO Ports
> From: "R Bruce Hoffman" <bruce.hoffman@xxxxxxxxxxxxxxxxx>
> Date: Fri, February 18, 2005 11:39 am
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> Actually, that's the DRDA connection port for OS/400. DRDA is why
> clients need the DB2 Connect software to use the 400.
> 
> On an LUW server, the connections don't have to be drda. 
> 
> The service port is configurable and is usually left at the install
> default of 50000.
> 
> The actual connections to the instance on Windows DB2 servers, from the
> Control Center, come in on 445. Services files show this as microsoft_ds
> which also has a UDP component.
> 
> 
> On Fri, 2005-02-18 at 11:12, michael@xxxxxxxxxxxxxxxxxx wrote:
> > Thanks...
> > 
> > > -------- Original Message --------
> > > Subject: RE: SQL CONNECT TO Ports
> > > From: "John Brandt Sr." <pgmr@xxxxxxxxxxxxxxx>
> > > Date: Fri, February 18, 2005 11:06 am
> > > To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> > > 
> > > 446 is the listener, 8471 is non-ssl and 9471 is ssl data.
> > > 
> > > John Brandt 
> > > iStudio400.com 
> > > (903) 523-0708 
> > > Home of iS/ODBC - MSSQL access from iSeries and RPG. 
> > > 
> > > 
> > > 
> > > 
> > > -----Original Message-----
> > > From: michael@xxxxxxxxxxxxxxxxxx [mailto:michael@xxxxxxxxxxxxxxxxxx]
> > > Sent: Friday, February 18, 2005 7:50 AM
> > > To: Midrange Systems Technical Discussion
> > > Subject: SQL CONNECT TO Ports
> > > 
> > > 
> > > Anyone know what ports are used (need to be open) when doing a SQL
> > > CONNECT TO to a Windows box running DB2?
> > > 
> > > TIA...
> > > 
> > > 
> > > -- 
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> > > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> > > 
> > > ---
> > > Incoming mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.849 / Virus Database: 577 - Release Date: 1/27/05
> > >  
> > > 
> > > -- 
> > > No virus found in this incoming message.
> > > Checked by AVG Anti-Virus.
> > > Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/05
> > >  
> > > 
> > > -- 
> > > No virus found in this outgoing message.
> > > Checked by AVG Anti-Virus.
> > > Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/05
> > >  
> > > -- 
> > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> > > list
> > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/midrange-l.
> -- 
> "Bigamy is having one wife too many. Monogamy is the same."
> -- Oscar Wilde
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.