Too Many files open

Hi ,

  We are using a Tool which runs on Unix Server.  Have a Event which have some join operation and tries to open files depending on the join operation. So get the error 

config/variants/orcl6/partitions/ml6/data/ap_PCardMap.csv (Too many open files)

   Can someone please suggest how to get rid of it.  This is the ulimit. 

ulimit -a
time(seconds) unlimited
file(blocks) 2097151
data(kbytes) 131072
stack(kbytes) 32768
memory(kbytes) 32768
coredump(blocks) 2097151
nofiles(descriptors) 2000

Is there any way to know how may descriptors is the event using. we can get the PID as its been run on WebSpehere .. please suggest .. Thanks in Advance

if its a /proc based system you can retrieve the number of file handlers that are opened as

/proc/PID/fd/

PID - pid of the running process
along with the other files opened you would have the other file descriptors like 0, 1, 2 and 63

sorry a correction .. i was abt to say .. we cant get the process id of the Event ..

its a proc based system .. nyway where in we can know which Process id correct to which even ( i mean the name of the job )

i cant understand

if you dont have the pid you should be aware of the name in which the process is run right ?

then that would do..........