Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-2072: SQL1366N processing error occurs when starting DB2

Auditing and Monitoring Service ,   Authentication Service ,   Mac & PC Management Service ,  

12 April,16 at 11:45 AM

Applies to: All versions of Centrify DirectControl for IBM DB2

After following documentation (See Page 6 section 4.2 "Using manual procedure" of Centrify DirectControl DB2 agent), it is noticed that there is an error message (see below) when trying to start Db2 instance:

[svcdb2i1@N01D2U414]/db2home/svcdb2i1/sqllib/security64/plugins/group $ db2startSQL1366N  A security plug-in "centrifydc_db2group" processing error occurred on the client. Reason code = "3".

Is there any reason?

The security plug-ins should be installed for each DB2 database instance before configuration. For each DB2 instance, you need to execute the following script(s) as the instance user, replacing db2inst1 with the name of the actual DB2 database instance. There is a typo in our doc. It should read 'plugin' and not 'plugins'. 

For 64 bit instances, run: 

cp /usr/share/centrifydc/<lib64dir>/ ~db2inst1/sqllib/security64/plugin/server/ 

cp /usr/share/centrifydc/<lib64dir>/ ~db2inst1/sqllib/security64/plugin/server/ 

cp /usr/share/centrifydc/<lib64dir>/ ~db2inst1/sqllib/security64/plugin/client/ 

cp /usr/share/centrifydc/<lib64dir>/ ~db2inst1/sqllib/security64/plugin/group/ 

cp /usr/share/centrifydc/lib/ ~db2inst1/sqllib/security32/plugin/client/ 

For 32 bit instances, run: 

cp /usr/share/centrifydc/lib/ ~db2inst1/sqllib/security32/plugin/server/ 

cp /usr/share/centrifydc/lib/ ~db2inst1/sqllib/security32/plugin/server/ 

cp /usr/share/centrifydc/lib/ ~db2inst1/sqllib/security32/plugin/client/ 

cp /usr/share/centrifydc/lib/ ~db2inst1/sqllib/security32/plugin/group/ 

After this, follow the remaining steps mentioned in the document to restart DB2 successfully.