heap file. what is it?

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

heap file. what is it?

Post by admin »

This is a topic for an orphaned message.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Hi Jean-Guy,
--- "Desilets, Jean-Guy" wrote:
> Where I could get a list of all parameters available (configuration
> server
> parameters) and there meaning?

The readme.txt is usually pretty good with this sort of thing. With regards to the hash stage this is what it has to say:

==========README.TXT - DataStage 4.0===================
The Hashed File Stage
=====================
The Hashed File stage uses memory-mapped files instead of real memory as its internal cache. This facilitates loading large reference tables into memory and writing large target files.

The new environment variables required and their default values are as follows:

DS_MMAPPATH=/tmp
DS_MMAPSIZE=32
DS_MAXWRITEHEAPS=1

DS_MMAPPATH is the location where you want your memory-mapped files to be generated. DS_MMAPSIZE is the size in MB of the files you want to generate. Depending on the size of the file you are loading, one or more of these files is generated to hold the records which need to be in memory at any given time. DS_MAXWRITEHEAPS controls the number of DS_MMAPSIZE heaps that get created during write caching. If this value is set to zero (0) no write caching is performed.

Note: You must have enough space in the directory specified by
DS_MMAPPATH to hold all the memory-mapped files the Hashed
File stage generates. You need at least as much space in your
DS_MMAPPATH directory as the size of the largest file you expect
the hashed file stage to process plus the value of DS_MMAPSIZE.
You can change the values for DS_MMAPPATH, DS_MMAPSIZE and
DS_MAXWRITEHEAPS in the uv.rc script, where they are set and
exported.
======END OF README.TXT==============

Regards,
Anthony Corrente.


_____________________________________________________________________________
http://clubs.yahoo.com.au - Yahoo! Clubs
- Join a club or build your own!
Locked