IBM Support

How to find DB2 for i database name, version, and communication ports.

Question & Answer


Question

What is the db2 for i database name?
What is the db2 for i database version?
What are the db2 for i ports?

Cause

The purpose of this technote is to answer common questions about DB2 for i database.

Answer

1. What is the db2 for i database version?
 

Db2 for i is an integrated relational database manager on the IBM i operating system.

Db2 for i is part of the IBM i operating system, therefore, DB2 for i version is the same as the IBM i operating system one.  You can issue DSPPTF (Display PTF status) command to see the operating release. 

You can also use GO LICPGM, option 10, (Display installed licensed programs), and press F11, to find the IBM i operating system version.

licpgm

2. How do I find the db2 for i database name?
 

Issue WRKRDBDIRE command to find DB2 for i database name.  

WRKRDBDIRE

Note that the relational database entry with *LOCAL remote location is the DB2 for i database name on this IBM i system. 

With Db2 for i, independent auxiliary storage pools (ASPs), also known as independent disk pools, allow you to have one or more separate databases associated with each ASP group. You can set up databases using primary independent disk pools.

3. What are the db2 for i ports?
Applications running on the operating system can access the data in tables from any subsystem. Applications running outside of the operating system can use IBM DRDA (Distributed Relational Database Architecture) to connect to the DB2 for IBM i database and access data in tables through communication ports 446, 447 and 448.
 
LOCAL_PORT    LOCAL_PORT_NAME
446                                     drda                      
447                                     ddm
448                                  ddm-ssl

The DDM (Distributed Data Management) or DRDA (Distributed Relational Database Architecture)TCP/IP server listens on port 446 (the well-known DRDA port), port 447 (the well-known DDM port), and port 448 (the well-known TLS port). The Db2 for i implementation of DDM does not distinguish between the two ports 446 and 447, so both DDM and DRDA access can be done on either port.



 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

Modified date:
07 January 2025

UID

ibm17179560

Page Feedback