The DB2 Universal Database (UDB) is a cross-platform database system developed by IBM. This chapter introduces the latest version of this software, and enumerates the features that make UDB a good choice for your business.

How do I access IBM DB2 database?

Connecting to your Db2 database

  1. Collect database details and credentials. To connect to your database, you need database details (such as the host name), as well as credentials (such as a user ID and password).
  2. Verify that a supported driver is installed.
  3. Configure your environment.
  4. Confirm ports are available.

How do I download a database from Eclipse?

Here’s how to accomplish the task using the Eclipse Data tooling included with \WTP.

  1. Select Window > Show View > Other, and select Data > Database Explorer.
  2. In the Database Explorer view, right-click the Connections folder and choose New Connection.
  3. Fill out the dialog as shown.
  4. Click Finish.

What is a UDB?

DB2 Universal Database (UDB) is an object-oriented relational database management system (OORDBMS) characterised by multimedia support, content-based queries and an extensible architecture. It is a Web-enabled relational database management system that supports data warehousing and transaction processing.

How do I connect to DB2 database using IBM data Studio?


  1. In IBM Data Studio, click All Databases > New Connection to a database.
  2. On the Local tab, select DB2 for Linux, UNIX, and Windows as the database manager.
  3. On the General tab, enter the following values:
  4. For an SSL connection, click the Optional tab, and then click Add.

How do I remotely connect to a DB2 database?


  1. Log on to the application server with a valid DB2 user ID.
  2. Start the DB2 command line processor. On Windows operating systems, issue the db2cmd command from a command prompt.
  3. Issue the following commands:
  4. Repeat the above steps on the reporting server: