Does Running p_manage_64 Again "Re-Encrypt" the Z308 Verification?
- 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