Hash access (ACCESSTYPE='H', 'HN', or 'MH') 
(deprecated)
The ACCESSTYPE column in the plan table has a value of 'H', 'HN', or 'MH', when the table
being accessed is organized by hash, and hash access is used to access the data. Hash-organized
table spaces are deprecated and likely to be unsupported in the future.
FL 504 Hash-organized tables are deprecated. Beginning in Db2 12, packages that are bound with APPLCOMPAT(V12R1M504) or higher cannot create hash-organized tables or alter existing tables to use hash-organization. Existing hash-organized tables remain supported, but they are likely to be unsupported in the future.
Hash access is efficient for
queries that use equal predicates to access a single row on a table.
Hash access also reduces CPU load. However the use of hash access
requires additional storage space for maintenance of the hash space.
If a table is organized by hash, index clustering is unavailable on
that table.
When a hash access path is selected for a parallel group, parallelism is not selected for that parallel group, however Db2 might select parallelism for other parallel groups in the query.
When star join is enabled, Db2 does
not use hash access for either the fact or dimension tables when a
query contains a qualified star join.