{{ t('Configuration Wizard: DB2 Database') }}
{{ t('Host Information') }}
{{ t('Configure DB2 Monitoring') }}

{{ t('Administration Settings') }}

{{ t('Please replace XXXXX with your version.') }}
  1. {{ t('Please download a recent version of the following packages from here') }} ( https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers )
    • Runtime Client (rtcl)
    • Driver package (DS Driver)
  2. {{ t('Add the following to {0}', {"0": "/etc/environment"}) }}
    LD_LIBRARY_PATH=/opt/ibm/db2/VXX.X/lib64
    DB2DIR=/opt/ibm/db2/VXX.X
    DB2_HOME=/opt/ibm/db2/VXX.X
    DB2LIB=/var/lib/nagios/sqllib/lib
    DB2INSTANCE=nagios
  3. {{ t('Installation') }}
    tar xf vXXXX_linuxx64_rtcl.tar.gz
    cd rtcl/
    ./db2_install
    
    tar xf vXXXX_linuxx64_dsdriver.tar.gz
    cd dsdriver
    ./installDSDriver
    cp -r include /opt/ibm/db2/VXX.X/
    
    /opt/ibm/db2/VXX.X/instance/db2icrt -a server -u nagios nagios
    
    source /etc/environment
    
    apt-get install libdbi-perl libaio1
    cpan -i DBD::DB2
  4. {{ t('Create User within Database') }}
    {{ t('To ensure, that openITCOCKPIT is able to query information from the database, you need to add a operationsystem user called "nagios" (with same group name).') }}
    {{ t('Maybe there is already a user {0}, wich is beeing used to monitore the operatingsystem.', {"0": '"nagios"'}) }}
    {{ t('Afterwords you need to enable the monitoring switches:') }}
    update dbm cfg using dft_mon_bufpool on
    update dbm cfg using dft_mon_lock on
    update dbm cfg using dft_mon_timestamp on
    {{ t('The nagios user (resp. the nagios group) is going to get the needed privileges and after a restart of the database, everything is prepared.') }}
    db2 update dbm cfg using sysmon_group nagios
    db2 grant select,update on table SYSTOOLS.STMG_DBSIZE_INFO to nagios
    db2stop; db2start
  5. {{ t('Restart the DB2 server to apply the changes.') }}
    db2stop; db2start