DB2 Connect User's Guide

The Database Concept

The term database is used throughout this book to describe a relational database management system (RDBMS). Other systems with which DB2 Connect communicates may use the term database to describe a slightly different concept. The DB2 Connect term database can also refer to:

MVS (Version 4 and earlier)

A DB2 for MVS/ESA subsystem identified by its LOCATION NAME.

The LOCATION NAME can be determined by logging in to TSO and issuing the following SQL query using one of the available query tools:

   select current server from sysibm.sysdummy1

LOCATION NAME is also defined in the Boot Strap Data Set (BSDS) and is provided in the DSNL004I message (LOCATION=location), which is written when the Distributed Data Facility (DDF) is started.

OS/390 (Version 5 and later)

A DB2 Universal Database for OS/390 subsystem identified by its LOCATION NAME.

The LOCATION NAME can be determined by logging into TSO and issuing the following SQL query using one of the available query tools:

   select current server from sysibm.sysdummy1

LOCATION NAME is also defined in the Boot Strap Data Set (BSDS) as well as the DSNL004I message (LOCATION=location), which is written when the Distributed Data Facility (DDF) is started.

VSE

DB2 for VSE running in a partition identified by its DBNAME

VM

DB2 for VM running in a CMS virtual machine identified by its DBNAME

OS/400

DB2 Universal Database for AS/400, an integral part of the OS/400 operating system. Only one database can exist on an AS/400 machine. If the database will be used by applications outside the AS/400 system, the database must be given a name in the relational database directory. This name is known as the Relation Database Name (RDB Name).

To display the RDB Name of your AS/400 system execute the command WRKRDBDIRE on your AS/400. The RDB Name of your Local system has *LOCAL specified in the Remote Location column. To change the RDB Name use the command CHGRDBDIRE.