RE: SQL CONNECT TO Ports

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

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