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:
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:
Task | Actions |
---|---|
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 systems | Database 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 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 |
IBM DB2 bug fix to implement | In 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 Host | As 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. |