DSXchange

Craig, When I initially posted my question I wanted to load every single hashed file into memory but after I stumbled upon "System caching is not intended to be used if only a single stage is creating or reading the file." in the PDF I realized my approach is wrong. Craig/Ray, Few more que...

Ray,

Most of our hashed files size is between 256 MB and 1.5 GB. Is there a work-around to catalog a few/most of them?

Thanks
Mav

Is there a limit on the number of Hashed files that can be loaded into memory?

I'm trying to load 258 Hashed files into memory and it looks like it's taking for ever.

Thanks

I wrote:How do I enable Disk Cache?

Think I got it. It's the same document.

Let me give it a try and will update this topic.

Gurus,

I stumbled up "Using System Caching" in "Hash Stage Disk Caching" PDF document. When I tried "DAEMON.FILE.CACHE START 60000" I get "Disk Cache not enabled." error.

How do I enable Disk Cache?

Thanks,
Mav

Hello, We have enough memory to load our entire project. 1) Is there a way to load all Hashed files, present in the project directory, in to memory before we start our ETL run? 2) If yes then would it, by any chance, alter the way our jobs are behaving? We have few jobs that just read the hashed fil...

Thanks Ray.

Hello,

When I run shmtest command with the same unchanged uvconfig file as the parameter, I get different values for DMEMOFF, PMEMOFF, CMEMOFF & NMEMOFF for each run.

1) Why does that happen?

2) How to chose the right set of values?

Thanks,
Mav

Ray, It worked! Now I can open the job. You're the greatest! :D >UPDATE VOC SET F2 = 'RT_BP6487.O' WHERE F0 = 'RT_BP6487.O'; DataStage/SQL: 1 record updated. >BASIC RT_BP6487 * Compiling: Source = 'RT_BP6487/JOB.1835143171.DT.1578736330.IDENT1', Object = 'RT_BP6487.O/JOB.1835143171.DT.1578736330.IDE...

You should have quoted the names in the LIST.ITEM commands. >LIST.ITEM VOC "RT_BP6487" LIST.ITEM VOC "RT_BP6487" 11:20:02 08-18-11 PAGE 1 RT_BP6487 001 F Ardent DataStage Job File 002 RT_BP6487 003 D_DSG_BP.O >LIST.ITEM VOC "RT_BP6487.O" LIST.ITEM VOC "RT_BP6487.O...

Craig/Ray, Here's what I did /ps/dsadm/Ascential/DataStage/Projects/DWDEV> mkdir RT_BP6487.O /ps/dsadm/Ascential/DataStage/Projects/DWDEV> chmod -R 777 RT_BP6487.O /ps/dsadm/Ascential/DataStage/Projects/DWDEV> uv DataStage Command Language 7.5 Copyright (c) 1997 - 2004 Ascential Software Corporation...

Ray,

I couldn't find RT_BP6487.O within the project directory

/ps/dsadm/Ascential/DataStage/Projects/DWDEV> find . -name 'RT_BP6487.O'
/ps/dsadm/Ascential/DataStage/Projects/DWDEV>

What do I do next?

Thanks,
Mav

Ray, RT_BP6487 does exist in the project directory. /ps/dsadm/Ascential/DataStage/Projects/DWDEV> ls RT_BP6487 JOB.1835143171.DT.1578736330.IDENT1 JOB.1835143171.DT.1578736330.TRANS1 JOB.1835143171.DT.1578736330.IDENT2 JOB.1835143171.DT.1578736330.TRANS2 JOB.1835143171.DT.1578736330.IDENT3 JOB.18351...

Hey Craig, How you doing? Long time... There's no file/directory named RT_BP6487.O in project directory. /ps/dsadm/Ascential/DataStage/Projects/DWDEV> ls RT_BP6487.O ls: RT_BP6487.O: No such file or directory Surprisingly there's no such file/directory in PROD box too. However, the job in PROD is ru...

Hello Gurus, There's a Server job within a Sequence. When I try to open or delete it I get "Cannot open file RT_BP6487.O" error. I tried importing the same job from Production but ended up with the same error. All the directories with the project directory have -R 777 dsadm permission. I r...