DSXchange

Thanks Ray.

We'll change the value of TMPDIR to point to an existing directory with rwx permissions and monitor.

Hello, Finally I got overflowed groups reduced from 175337 to 1401 and 68 badly overflowed to 0. This time I picked a random high number for MINIMUM.MODULUS which is 2000003. But now there are 5459 empty groups. RESIZE HASH_OPTI_TEST1 DYNAMIC MINIMUM.MODULUS 2000003 Date/time stamp in file header ha...

Ray, Sorry I didn't understand your question correctly the first time. Hope I've got it right this time. I did grep 'TMPDIR' /ps/dsadm/Ascential/DataStage/Projects/blah-blah/DSParams and here is what I got TMPDIR\General\-1\DirPath\\1\Project\Temporary directory\Temporary directory path. "TMPDI...

Not sure if this helps but here goes

How about storing .jpeg file in a directory and storing its absolute path name in a varchar field in the table?

Ray, Does project blah-blah have a relative pathname set as its TMPDIR environment variable? No. After I run dsenv and echo $TMPDIR, I see no values returned. The main problem is the internal 39202 error when trying to login to any of the clients. Then when I try to uv I get "Temporary director...

We're not dropping and recreating them every time.

Thanks Craig

DS gurus, After reading through all the posts in this forum containing "Internal Error (39202)" I'm posting this. We had DataStage installed on our PROD box 2 years ago. Everything was running fine until 3 days back. We started getting the below errors frequently. From Designer: Failed to ...

Craig,

How about changing the values in Hashed file stage in the job after the Hashed file has been optimized? Isn't that necessary?

Thanks

Hello, I've been reading a lot of posts since past few days to get a hang of what hashed files are and how to optimize them. I've been successful to some extent but don't feel very confident. With the help of Ray, Craig and other DS gurus (older posts and answers to my questions) I was able to fine ...

Ray / Craig, Once I've optimized the hashed file and have all the OVER.30 data moved over to DATA.30, do I have to modify the existing DataStage jobs? By modify I mean change the modulus and other values in the hashed file stage. Below are the various jobs which touch this hashed file 1) Initial job...

Thanks Ray

Craig/Ray, I found and read several posts, when I searched for RESIZE, and most of them had syntax to convert a 32-bit hashed file to 64-bit. Can I use RESIZE to restructure the existing dynamic hashed file? By restructure I mean increase the number of groups, change the GROUP.SIZE value and other p...

Ray & Craig,

Thanks!

Ray, (3) Almost certainly. To separate inserts/updates into different jobs which is the recommended Stage to stage data? In parallel jobs I used DataSets to stage data. In Server jobs, is it Hashed files? (1) Impossible to say - depends on many other factors, such as what indexes and constraints exi...

Forgot to ask - Is it very common / good practice to disable transaction log when writing to tables in Data Warehousing projects?

Thanks.