IBM DB2 for LUW Database

This page explains how to prepare a IBM DB2 for LUW database for the connectivity to SAP Focused Run.

Currently the following monitoring application are supported for IBM DB2 for LUW databases:

Preparations in the Managed Database

TaskActions

Install database

Install IBM DB2 for LUW 9.7 or higher

You need at least IBM DB2 for LUW 9.7, optionally install the latest IBM DB2 for LUW 9.7 and latest Patches from support.sap.com/swdc -> Databases -> DB2
Configure Database for non-SAP NetWeaver systemsDatabase configuration according to SAP recommendations; especially all MON_* configuration parameters. See SAP Note 1334923.
Check the "db2greg" executable availability

Optional operation

The DB2 plugin of the SAP Host Agent calls the db2greg executable to detect installed IBM DB2 databases. This Plugin needs to be present on the filesystem, otherwise no IBM database can be detected by the SAP Host Agent during Outside Discovery Execution.

Search sequence is

/db2/%3[A-Z0-9]/sqllib/bin/db2greg
/db2/db2%3[A-Z0-9]/sqllib/bin/db2greg 
/usr/local/bin/db2ls

Note: %3[A-Z0-9] is the pattern for <SID>. 

Check that the "db2greg" plugin is properly deployed to this directory by SAP and IBM Standard (depending on version and product) for managed Systems on IBM DB2 or Standalone IBM DB2 with SAP Focused Run.

Check returned database properties

Optional operation

From the hostctrl exe folder execute: saphostctrl -function GetDatabaseProperties -dbname <DBSID> -dbtype db6

Web method returned successfully:

Database/DBRelease=09.07.xxxx
Database/ConfigurationDirectory/Default=/<DBTYPE>/<DBSID>/sapdbctrl-config
Database/InstanceList=Name=0;Host=<FDQN>;Port=xxxx
Database/ConnectAddress=
Database/ManagementHosts=<hostname>

IBM DB2 bug fix to implementIn case you are using SHA PL29, you might face a DB2 Defect related to db2gcf and the reporting of instances. Check the IBM DB2 Website
Run Outside Discovery on the HostAs prerequisites, you shall install the SAP Host Agent and run Outside Discovery as described in page Preparing Outside Discovery.

Check Needed Data Suppliers

The IBM DB2 DB can be used in stand-alone or associated to an ABAP or Java Stack

The IBM DB2 DB can be used in stand-alone or associated to an ABAP or Java Stack.

Therefore, the corresponding Data Supplier needs to be setup.

See the SAP NetWeaver Application Server ABAP or SAP NetWeaver Application Server Java pages.

LMDB database association

Virtualization relations of the database must be done manually

Optional operation

Open LMDB and search for your virtual DB. Check the assigned Physical / Logical Database.