DB2 FOR LUW / DB2FORLUW / A50 - DB2

"SET ENCRYPTION PASSWORD" TRIGGER/SPL CAN CAUSE SQLCODE -20143

If you have the following:
- A Table with a TRIGGER that call a SPL.
- The SPL uses DECRYPT_CHAR and/or ENCRYPT.

Then if you perform the following:
SET ENCRYPTION PASSWORD 
INSERT INTO 
SET ENCRYPTION PASSWORD ''
SET ENCRYPTION PASSWORD 
INSERT INTO 

The 2nd INSERT will fail with  SQLCODE -20143

****************************************************************
* USERS AFFECTED:                                              *
* All Platforms.                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v10.5 Fixpack 10 or later.                    *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

24.11.2017
16.07.2018
16.07.2018