Example of data value encryption in DB2

When using DB2, database security requires us to consider things. This article provides a simple example. In this example, encryption and decryption of passwd are set globally, use the db2 database encryption function encrypt and decrypt_char. For your reference, I hope to enlighten you.

Example:

1.
C:> db2 create table encode_demo (col1 varchar (100) for bit data) // the data in the col1 field is stored in binary format.
The DB20000ISQL command is successfully completed.

2.
C:> db2 set encryption password = 'loveunix '// sets the passwd for encryption and decryption.
The DB20000ISQL command is successfully completed.

3.
C:> db2 values (encrypt ('loveunix ') // preview the encrypted loveunix
1
---------------------------------------------------
X '08bc44ff6a05a3d5240e86cfb2ce60f243aa83c41b7221d7'

4.
C:> db2 insert into encode_demo values (encrypt ('loveunix ') // insert records
The DB20000ISQL command is successfully completed.

5.
C:> db2 select decrypt_char (col1) as encode from encode_demo // decrypt and retrieve records
ENCODE
--------------------------------------------------------------------------------
Loveunix
1 record selected.