Page 1 of 2

Fatal Error

Posted: Wed May 11, 2005 8:01 am
by mmanes
Hi everyone,
I've the following error:

Lookup_188,7: Could not map table file "/dstageeetl3/Dataset/lookuptable.20050510.knizooc (size 88760064 bytes)": Not enough space

Additional Info:
- the filesystem and RAM are not busy at run-time
- in a different machine it runs succesfully by 12 parallel degree
- I'm using in both cases the memory windows
- on the machine where the error is detected, the problem is the same using both 12 and 16 parallel degree.

Can you help me?

Thank you in advance,
Matteo.

Posted: Wed May 11, 2005 8:13 am
by Eric
Are the HP-UX kernal parameters configured correctly?

Posted: Wed May 11, 2005 8:17 am
by mmanes
Yes Eric,
all environment variables in uvconfig, DSParams and kernel are the same in both machines.

Posted: Wed May 11, 2005 8:27 am
by blewip
Have you run out of space on a filesystems?

Re: Fatal Error

Posted: Wed May 11, 2005 8:39 am
by ArndW
mmanes wrote:Hi everyone,
I've the following error:

Lookup_188,7: Could not map table file "/dstageeetl3/Dataset/lookuptable.20050510.knizooc (size 88760064 bytes)": Not enough space

Additional Info:
- the filesystem and RAM are not busy at run-time
- in a different machine it runs succesfully by 12 parallel degree
- I'm using in both cases the memory windows
- on the machine where the error is detected, the problem is the same using both 12 and 16 parallel degree.

Can you help me?

Thank you in advance,
Matteo.
Matteo, do a "df -k /dstageeetl3/Dataset/"; it would seem that your filesystem might be full

Posted: Wed May 11, 2005 8:40 am
by mmanes
blewip,
the filesystem is not full.

Posted: Wed May 11, 2005 8:44 am
by ArndW
Mateo,

does that filesystem have more than 88Mb free space? If not, you have found your cause.

Posted: Wed May 11, 2005 8:46 am
by mmanes
Filesystem and RAM are monitored by me during execution of the job and both were free.

Posted: Wed May 11, 2005 8:50 am
by mmanes
The free sace of that filesystem is 300 GB min at run-time.

Posted: Wed May 11, 2005 12:43 pm
by T42
ulimit -a. Verify that you (and dsadm) have the ability to create files that large.

Posted: Wed May 11, 2005 1:08 pm
by mmanes
> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1991680
stack(kbytes) 80896
memory(kbytes) unlimited
coredump(blocks) 4194303

Posted: Wed May 11, 2005 4:46 pm
by T42
Try it within DataStage. Do an ExecSH with that command.

Posted: Thu May 12, 2005 3:59 am
by mmanes
That command were executed by the same user of the jobs

Posted: Thu May 12, 2005 4:12 pm
by T42
Please provide the result from within the DataStage job, as I asked. The results CAN be different, despite using the same username to run jobs.

Posted: Fri May 13, 2005 3:51 am
by mmanes
The execution of ulimit -a from DataStage is:

time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 1991680
stack(kbytes) 80896
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles (descriptors) 1024

Have u some ideas?

Thank u in advance.