Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 8: Connectivity and networking

Darliene Hopes (dlhopes@us.ibm.com), DB2 Solution Migration Consultant, IBM
Darliene Hopes
Darliene Hopes is a DB2 solution migration consultant at IBM. She has been working with DB2 for Linux, UNIX, and Windows since the start of her career. She is an IBM Certified DB2 database administrator who has been recently and consistently contributing to the DB2 community.

Summary:  This tutorial aims to explain the process of configuring communications and the processes of cataloging databases, remote servers (nodes), and Database Connection Services (DCS) databases. You will also get introduced to DB2® Discovery and learn how to manage connections to System z® and System i® host databases. You will also learn about Lightweight Directory Access Protocol (LDAP). This tutorial prepares you for Part 8 of the DB2® 10.1 DBA for Linux®, UNIX®, and Windows® certification exam 611.

View more content in this series

Date:  25 Oct 2012
Level:  Intermediate PDF:  A4 and Letter (389 KB | 20 pages)Get Adobe® Reader®

Comments:  

Conclusion

Databases stored on a server are accessed by remotely stored applications using a distributed connection, which allows administrators to remotely manage databases and servers. For this to take place, recognized communication protocols must be used. The following communication protocols are recognized by DB2:

  • NetBios
  • TCP/IP (most frequently used)
  • Named pipe

To access a database stored on a remote server, you must catalog the database. You must also catalog the node on the local server containing the database.

To access the data stored in a DB2 for z/OS or a DB2 for i5/OS database:

  1. Configure TCP/IP communications on the DB2 Connect server
  2. Catalog the TCP/IP node
  3. Catalog the System z or System i database as a DCS database
  4. Catalog the System z or System i database
  5. Bind utilities and applications to the System z or System i database server

DB2 discovery provides an easy way to catalog a remote server and a database without having to know detailed communication-specific information. DB2 discovery uses one of two methods to process a discovery request: search and known. At the server level, instance level, and database level, you can enable or disable DB2 discovery and control how discovery requests are initiated.

LDAP is an industry-standard access method to directory services. Each database server provides database information to the LDAP directory when the databases are created. DB2 supports IBM LDAP client on AIX, Solaris, HP-UX 11.11, Windows, and Linux.

This tutorial was created to provide you with the processes for configuring communications and cataloging databases/servers, as well as introduce to you the concepts of DB2 discovery and LDAP. It was also designed to help you prepare for the DB2 10.1 DBA for Linux, UNIX, and Windows certification exam (exam 611). You should now have a better understanding of DB2 connectivity and networking, as well as be able to:

  • Catalog a local/remote DB2 database
  • Catalog a remote server
  • Identify the steps to access data stored on DB2 for z/OS or DB2 for i5/OS database
  • Identify characteristics of DB2 locks (common locks shared across all platforms)
  • Understand how configuration parameters control the behavior of DB2 discovery
  • Register a database/server with LDAP

7 of 9 | Previous | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=842457
TutorialTitle=DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 8: Connectivity and networking
publish-date=10252012
author1-email=dlhopes@us.ibm.com
author1-email-cc=