Search found 5 matches

by jjsyht
Sun Mar 15, 2009 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add_to_heap error when reading from system-cache hashfile
Replies: 1
Views: 766

add_to_heap error when reading from system-cache hashfile

I'm getting the following error when reading from a hash file that I've put in the system cache (through CATALOG)

Code: Select all

add_to_heap() - Unable to create temporary cache file. Check that there is sufficient disk space.
None of my volumes are 100% full (using df)

Where should I start???
by jjsyht
Tue Mar 03, 2009 2:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enabling System Caching
Replies: 3
Views: 1052

System Caching in use... READ-ONLY file cache enabled, overriding link private cache What has been said above is everything that needs to be done. And (write) caching shouldn't be set to "None"... no matter if it doesn't seem necessary. Off to the more boring task of modifying all the jobs...
by jjsyht
Mon Mar 02, 2009 10:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job error: ds_ipcgetnext waiting for mutex
Replies: 0
Views: 673

Job error: ds_ipcgetnext waiting for mutex

I'm getting the following error when running a job (STP stage) that is calling a procedure. The procedure has several selects that inputs into variables and a final select that inserts into a table. It fails after 2 minutes in the job. Usually after 2 minutes, the final select (insert) has started. ...
by jjsyht
Mon Mar 02, 2009 7:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enabling System Caching
Replies: 3
Views: 1052

Thanks, this board has been very helpful. It's good to know I'm on the right track. The parameters for using Private/Public link caching is pretty straightforward in the manual, however using the System cache seem to be some level above the other two. I'm thinking that the parameters for System Cach...
by jjsyht
Sun Mar 01, 2009 6:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enabling System Caching
Replies: 3
Views: 1052

Enabling System Caching

Hi, I have multiple jobs referencing the same hash file. I'm guessing I should use System caching for faster speed. Many of these jobs run at the same time I could not see (from HashFile Disk Caching Tech. Bulletin) how to specify that a hash should be in the system cache. There's something about &q...