Chapter 3. Connectivity with DB2 UDB for iSeries 51
Figure 3-16 Specify the system options
Figure 3-16 appears. Check the configuration and click Next.
Figure 3-17 Specify the security options
As in Figure 3-17, you have to specify the authentication method of the user for
this database. You can select the Use authentication value in server’s DBM
configuration or the Server authentication (SERVER). Since the instance
db2inst1 DBM is also configured as “SERVER” by default, they are the same as
the result. SERVER authentication means that the user profile and the password
which are used to connect to the OS/400 are checked as a normal user profile of
52 DB2 UDB for Linux on iSeries: Implementation Guide
the OS/400 partition in the OS/400 side. To check the instance DBM parameter,
you can use the following command:
>db2 get database manager configuration|grep AUTHENTICATION
Click Finish.
Figure 3-18 The test tool window
The Test Connection window opens (Figure 3-18). Select all connection types,
and type the valid OS/400 user profile name and the password. Then click Test
Connection.
Figure 3-19 The test result
Chapter 3. Connectivity with DB2 UDB for iSeries 53
If the test succeeded, a window as in Figure 3-19 appears. Click Cancel.
Figure 3-20 The db2ca main window after the database is added
Now the database has added successfully. You can check the node or database
directory settings as in Figure 3-20. You can use the following commands to
check the configuration (Figure 3-21):
> db2 list node directory
> db2 list database directory
54 DB2 UDB for Linux on iSeries: Implementation Guide
Figure 3-21 Checking the node and database directory
db2inst1@linux02:~> db2 list node directory
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = NDE8D6BB
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = as05
Service name = ddm-rdb
db2inst1@linux02:~> db2 list database directory
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = OS400
Database name = AS05
Node name = NDE8D6BB
Database release level = a.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Database 2 entry:
Database alias = SAMPLE
Database name = SAMPLE
Local database directory = /home/db2inst1
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
db2inst1@linux02:~>
Get DB2 for Linux on iSeries: Implementation Guide 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.
