Document toolboxDocument toolbox

Hashed File Stage

Summary

Hashed File stages represent a hashed file which is a sequential file that uses a hashing algorithm to distribute records across one or more groups on disk. The Hashed File Stage can be used to access UniVerse files.

IBM Documentation

Server Stage: Hashed File Stages - IBM Documentation

Parallel Stage: DRS Connector stage - IBM Documentation

Conversion Notes

Key points you should know:

  • Server Hashed Files stages are converted to Parallel DRS Connector stage (for good reasons), which means that Server jobs which stored their data in Hashed Files will be converted to Parallel jobs which read from / write to the storage mechanisms supported by the DRS Connector (Oracle, DB2 or ODBC)

  • Hashed files which are loaded or maintained by the S2PX solution are stored in your database using a S2PX-specific format.

  • Any persistent data you use (i.e. which enables one execution of a job to communicate changes to subsequent executions of a job) which is stored in Hashed Files will need to be loaded in to your DRS-compatible data storage platform

Structural changes

The Hashed File stage can be used to both read and write, sometimes simultaneously within the same job design, which is not a job design supported by the DRS stage. The way these patterns are handled is to create seperate Jobs for the Insert and Read sides of the process, and orchestrate them using an S2PX-generated Job Sequence.

See Parallel Job Structural Differences.

Server features not supported

Feature

Asset Query (?)

Comment

Feature

Asset Query (?)

Comment

Clear file before writing

Hashed File Not Clearing Before Writing

This query detects Hashed Files that do not have the ‘Clear file before writing’ option checked.

This means that your job design will require you to implement a data storage layer replacing your hashed file and will require an appropriate mechanism for preserving

Hashed File filesystem storage

Hashed Files to be Migrated to DB

S2PX conversion also generates utility Server Jobs intended for the one-time migration of Hashed Files to database tables in a DRS-supported relational database. This query tells you when these load Jobs will be created.

See Also

 

© 2015-2024 Data Migrators Pty Ltd.