Usage of the DB2 create server statement

I believe everyone has some knowledge about the DB2 create server statement. The following describes the usage of the DB2 create server statement. I hope it will help you.

The following provides several examples to illustrate how to use the DB2 create server statement to register servers for the wrapper on DB2 series data sources. This topic contains a complete example of how to use all required parameters to create a server. It also contains an example with optional server options.

Complete example:

The following example shows how to use the create server statement to CREATE a SERVER definition for the DB2 wrapper:

Create server DB2SERVER TYPE DB2/zos version 6 WRAPPER DRDA
AUTHORIZATION "spalten" PASSWORD "db2guru"
OPTIONS (DBNAME 'clients390 ')
DB2SERVER
Name specified for the DB2 database server. This name must be unique. Duplicate server names are not allowed.
TYPE DB2/ZOS
Specifies the type of data source server for which access is being configured.
VERSION 6
The version of the DB2 database server to be accessed.
WRAPPER DRDA
The name specified in the create wrapper statement.
AUTHORIZATION "spalten"
Authorization ID in the data source. This identifier must have BINDADD permission in the data source. This value is case sensitive.
PASSWORD "db2guru"
The password associated with the authorization ID in the data source. This value is case sensitive.
DBNAME 'clients390'
The alias of the DB2 database to be accessed. This alias is defined when you use the catalog database Command to CATALOG the DATABASE. This value is case sensitive.

This database name is required for the DB2 data source.
 

Overview of DB2 Flow Control clauses

Principle of DB2 cursor

Two ways to store db2 logs

Common DB2 cycle usage

DB2 Directory structure