Cataloging Apache Derby Databases

In the DRDA topology, each Apache Derby database is known only in relation to the Apache Derby Network Server that serves application requests to the database; therefore, to catalog a single database, you must tell the DB2 client which node it must connect to in order to access the database. Relative to all of the authentication methods available to the DB2 family of databases, the only authentication method that the Apache Derby Network Server supports is server-based authentication. Therefore, the syntax for cataloging an Apache Derby database on the DB2 client is as follows:

bash$ db2 CATALOG DATABASE database-name AT NODE node-name \
    AUTHENTICATION SERVER

For example, to catalog a database called YMLD on ...

Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.