IBM Db2 Developer ( v11 ) – Post Installation Review

Background

Upon installing IBM Db2 Developer ( v11) wanted to go in and review our installation.

BTW, here is the Install post for Windows :-

IBM Db2 Developer ( v11 ) – Installation on Windows
Link

Review

Outline

  1. DB2
    • Registry
  2. Network
    • Network Ports
  3. OS Security Groups
    • Windows
      • Security Account Management Database

Db/2

Registry

db2set

Syntax

db2set

Sample

db2set -all

Output

db2set_20180909_1128AM.PNG

Network

Network Ports

Linux

/etc/services
File Info

Port are listed in the /etc/services file.

Sample

cat /etc/services | grep -i db2

Output

etc.services.20180909.0641PM.PNG

Windows

c:\windows\system32\drivers\etc\services
File Info

Port are listed in the c:\windows\system32\drivers\etc\services file.

Sample

type c:\windows\system32\drivers\etc\services | find "DB2"

Output

etc.services.20180909.0602PM.PNG

 

 

OS Security Groups

Introduction

If the DB/2 Register item DB2_EXTSECURITY is enabled, the accounts that are listed in the DB2ADMNS and DB2USERS groups are authorized accordingly.

Windows

SAM Account Database

net localgroups
Syntax

net localgroups {group-name}

Sample

net localgroups DB2ADMNS

Output

netlocalgroup_db2users_20180909_0627PM

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s