DSXchange

When you do a lookup against a hashed file, it's random. (Parallel jobs read the entire reference data set into memory - server jobs do not.) The hashed file can only be loaded into memory if it's smaller than the read cache that you currently have configured (default 128KB from memory). The one rec...

GROUP.SIZE 1 = separation 4
GROUP.SIZE 2 = separation 8
Any other value in HFC will cause a warning message to be displayed.
The CREATE.TABLE statement generated by HFC will include a GROUP.SIZE 2 clause if required. GROUP.SIZE 1 is the default, so does not have to be included.

Think about the size of this hashed file on disk, and the amount of disk head movement required when pages in the hashed file are being accessed randomly.

Key searches in hashed file use the hashing algorithm to go directly to the page on which the record is stored. View Data has to scan through a buffer into which it has loaded the hashed file's contents.

Just curious - under what ID did you run the DirectoryAdmin tool?

If your repository is DB2 and you're using logging to the common repository, then your logs are already in DB2.

Otherwise I'd recommend using a server job, because in the local repository hashed files are used to store job logs and server jobs are specifically equipped to deal with hashed files.

Can you do this join in the database, with B.column1 indexed? Is it table B that has the millions of records? If not, do the range lookup first, then the left outer join downstream of that.

Execute Command ---> User Variables ---> Start Loop <------- End Loop | ^ | | +-----> Job -----+ In the Execute Command activity list the file using cat or type command. In the User Variables activity convert any @FM (line terminators) in the command output into some useful delimiter characters tha...

There are such scripts, and XML files. Your official support provider will guide you through the process. (It would be dangerous - not least legally - for us to attempt to do so lacking the complete knowledge of your system that you will provide to your support provider using the MustGather guidelin...

As a general rule we (I, at least) do not provide answers to interview questions, on the grounds that it is the candidate's own knowledge that is being investigated in the interview. We are happy to help with questions of the nature of "have I got this right?" but do not supply answers &q...

Job monitor app not running.

How strange. When I did an exact search for "Process meta data not available in database" it got 17 hits (including this thread).

Welcome aboard. What's "not working" about your job design? What are you expecting to get and what are you getting?

Or use pxEreplace() function, documented on DSXchange.

You can put the loop in a sequence, perhaps driving the loop from a query against the source system's system tables to derive a list of table names to be transferred.