Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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