Appendix F. Diagnosing DB2 Connectivity Problems

Figure F.1 illustrates what happens when you issue a CONNECT TO database statement. It also shows how the system database, node, and DCS directories are used during the process.

Figure F.1. Database connection flowchart

For example, when the CONNECT TO SAMPLE statement is issued, DB2 first looks for the database alias SAMPLE in the system database directory. This is the alias used for the database with the name MYSAMPLE. If the alias is not found, you get an SQL1013N error. If it is found, DB2 checks if this is a local or remote database. If it is a local database, DB2 initiates ...

Get Understanding DB2®: Learning Visually with Examples 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.