Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
Back to discussions
Expand all | Collapse all

HASH SHA1/SHA256/MD5 hardware acceleration

  • 1.  HASH SHA1/SHA256/MD5 hardware acceleration

    Posted 14 days ago

    Hello,

    we use datavault modeling, in all our dataware loading we compute lot of HASH. all table a column organazied (BLU)

    we have lot of theses select:

    select BINARY(HASH(UPPER(COALESCE(TRIM(stg1."COL1_CA_BK"), '-2')), 2), 16) AS "B_hk" ....

    a simple load of a 50 millions row tables without hash compute take juste a couple of secondes, when we compute hash the load is much much slower.

    i'm wandering if DB2 use intel hardware acceleration (Intel QAT) to compute the HASH. 

    best regards,



    ------------------------------
    malek shabou
    ------------------------------


Related Content