IBM Support

DB2 fails to start with error SQL1365N db2start or db2stop failed in processing the plugin "libguard_db2_exit_64" after a DB2 upgrade

Troubleshooting


Problem

This technote describes an error that can occur following a DB2 instance upgrade when DB2 Exit is configured for Guardium monitoring.

Symptom

Following a successful instance upgrade of DB2 the DB2 software fails to start with the exception:


[db2inst1@mrserver logs]$ db2start
SQL1365N  db2start or db2stop failed in processing the plugin "libguard_db2_exit_64". Reason code = "13".
06/01/2018 14:23:19     0   0   SQL1365N  db2start or db2stop failed in processing the plugin "". Reason code = "".
SQL1032N  No start database manager command was issued.  SQLSTATE=57019

Cause

The libguard_db2_exit_64 library was removed by the upgrade activity.

Environment

DB2 10.5 upgraded to 11.1 on Linux

Diagnosing The Problem

In the db2 diag log the following exceptions will be observed:


2018-06-01-14.19.37.927659-240 I23381E464            LEVEL: Severe
PID     : 13897                TID : 140487105177344 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000
HOSTNAME: mrserver.swg.usma.ibm.com
EDUID   : 1                    EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloSystemControllerMain, probe:3250
MESSAGE : ZRC=0x803607F6=-2143942666=SQLJC_ERROR_COMMEXIT_NOT_FOUND
          "Communication buffer exit library not found"


2018-06-01-14.19.37.928235-240 I23846E461            LEVEL: Event
PID     : 13884                TID : 140118412760864 PROC : db2star2
INSTANCE: db2inst1             NODE : 000
HOSTNAME: mrserver.swg.usma.ibm.com
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:7595
MESSAGE : ZRC=0xFFFFFAAB=-1365
          SQL1365N  db2start or db2stop failed in processing the plugin "".
          Reason code = "".

Resolving The Problem

The libguard_db2_exit_64 library needs to be copied back to the following directory$DB2INSTANCE/sqllib/security64/plugin/commexit/

for example:

cp  /usr/local/guardium/modules/STAP/10.1.4_r103106_1-1525356928/files/lib/libguard_db2_exit_64.so   /home/db2inst1/sqllib/security64/plugin/commexit

 

[db2inst1@mrserver commexit]$ db2start
06/01/2018 14:31:17     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
20 August 2018

UID

ibm10715667

Page Feedback