Data Stage

prams · Post by **prams** » Thu Jun 14, 2007 12:38 am

When I execute a Lookup job I'm getting the following error message bcz of some space issue.

LKP_AL_YES_COEP,0: Could not map table file "/dsetlsoft/datastage/Ascential/DataStage/Datasets/lookuptable.20070613.ujo03nc (size 1733722784 bytes)": Not enough space

Error finalizing / saving table /tmp/dynLUT6390006fc4e533

Could you guess what could be the reason?

We tried to increase data stage temp directory memory. But still we r getting the same error msg.

balajisr · Post by **balajisr** » Thu Jun 14, 2007 12:43 am

Duplicate of the duplicate post. Please delete the other post.

JoshGeorge · Post by **JoshGeorge** » Thu Jun 14, 2007 1:07 am

It can be because of many reasons:
/Ascential/DataStage/Datasets" directory doesn't have enough space. Your installation might not be using /tmp for temporary files, check your configuration file this. File size limit for the user executing the job is not adequate, lookup table size might have crossed that limit.
If your ref. data is huge consider using a join stage instead of look up.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 14, 2007 1:16 am

Let's do the math. 1,73,37,22,784 bytes divided by 300 lakh rows = 58 bytes per row (approximately). That seems reasonable.
So how much free disk space do you have in the file system on which /dsetlsoft/datastage/Ascential/DataStage/Datasets exists?

rprasanna28 · Post by **rprasanna28** » Thu Jun 14, 2007 1:57 am

we have 40GB free space over there

ArndW · Post by **ArndW** » Thu Jun 14, 2007 2:24 am

Space where? In /tmp or in /dsetlsoft?

rprasanna28 · Post by **rprasanna28** » Thu Jun 14, 2007 2:39 am

In temp directory

balajisr · Post by **balajisr** » Thu Jun 14, 2007 2:47 am

How much free space do you have in "/dsetlsoft/datastage/Ascential/DataStage/Datasets?

rprasanna28 · Post by **rprasanna28** » Thu Jun 14, 2007 4:25 am

"/dsetlsoft/datastage/Ascential/DataStage/Datasets" has a free space of 39GB

ArndW · Post by **ArndW** » Thu Jun 14, 2007 5:46 am

And how much space at runtime in your scratch directory as pointed to in the config file?