• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
After our initial data load, p_manage_64 was run and the result can be seen below: the Z308_VERIFICATION field contains the encrypted value of the password.

ALEPH:USR00> select Z308_REC_KEY, Z308_VERIFICATION, Z308_ENCRYPTION from z308;
Z308_REC_KEY Z308_VERIFICATION Z
--------------------------- ---------------------------------------- -
006479 USM50 be9a352ca4b42c4ca4d42c6ca4f42c8ca4142cac H
00ID188 USM50 d8fb5643cbdb4323cbbb4303cb9b43e3cb7b43c3 H
00ID192 USM50 d8fb564fc7d74f2fc7b74f0fc7974fefc7774fcf H
00ID194 USM50 d8fb5544ccdc4424ccbc4404cc9c44e4cc7c44c4 H
00ID205 USM50 d8fb5446cede4626cebe4606ce9e46e6ce7e46c6 H

Question: if p_manage_64 is run again, what will happen to the encryption? Will the encrypted field be "re-encrypted"?

Resolution:
The Z308_VERIFICATION contents will remain the same. The field is NOT "re-encrypted".

BEFORE p_manage_64:
>> select * from z308 where substr(Z308_REC_KEY, 23, 27) = 'USM50';
Z308_REC_KEY Z308_VERIFICATION Z3 Z308_ID Z3 Z
--------------------------- ---------------------------------------- -- ------------ -- -
006479 USM50 be9a352ca4b42c4ca4d42c6ca4f42c8ca4142cac 00 6479 AC H
00ID188 USM50 d8fb5643cbdb4323cbbb4303cb9b43e3cb7b43c3 00 ID188 AC H
00ID192 USM50 d8fb564fc7d74f2fc7b74f0fc7974fefc7774fcf 00 ID192 AC H
00ID194 USM50 d8fb5544ccdc4424ccbc4404cc9c44e4cc7c44c4 00 ID194 AC H
00ID205 USM50 d8fb5446cede4626cebe4606ce9e46e6ce7e46c6 00 ID205 AC H

AFTER p_manage_64:
006479 USM50 be9a352ca4b42c4ca4d42c6ca4f42c8ca4142cac 00 6479 AC H
00ID188 USM50 d8fb5643cbdb4323cbbb4303cb9b43e3cb7b43c3 00 ID188 AC H
00ID192 USM50 d8fb564fc7d74f2fc7b74f0fc7974fefc7774fcf 00 ID192 AC H
00ID194 USM50 d8fb5544ccdc4424ccbc4404cc9c44e4cc7c44c4 00 ID194 AC H
00ID205 USM50 d8fb5446cede4626cebe4606ce9e46e6ce7e46c6 00 ID205 AC H

SIDE-BY-SIDE
00ID205 USM50 d8fb5446cede4626cebe4606ce9e46e6ce7e46c6 00 ID205 AC H
00ID205 USM50 d8fb5446cede4626cebe4606ce9e46e6ce7e46c6 00 ID205 AC H

See also SKB 16384-21524 for more information about p_manage_64 and Z308 verification encryption.

(keywords: p-manage-64 manage_64)

• Article last edited: 10/8/2013