Adding user-defined functions

Install Netcool Configuration Manager user-defined functions to your database user to prevent the schema installation from reporting errors.

Procedure

  1. Download the Netcool Configuration Manager user-defined function jar (ibm_tivoli-ncm_db2_udf.jar) unto the DB2 Server in your Netcool Configuration Manager database user home directory, for example /home/ncmdbuser.
  2. Login to the DB2 server as Netcool Configuration Manager database user 'ncmdbuser'.
  3. Source the db2profile if not already configured in your unix login profile: 
    .  /home/db2inst1/sqllib/db2profile
  4. Install the user-defined functions: 
    db2 connect to itncm user ncmdbuser using <db password>
db2 "CALL SQLJ.INSTALL_JAR('file:/home/ncmdbuser/ibm_tivoli-ncm_db2_udf.jar', ncm_db2_udf)"
db2 "CALL SQLJ.REFRESH_CLASSES()"

What to do next

Important: After installing the schema during the installation process, ensure that you grant 'execute' permissions on the functions to your Netcool Configuration Manager database user (after installation has completed).
You now prepare the operating system.