Initially i used the Microsoft OLE DB provider for DB2. Then I changed to driver provided by IBM. Its working fine now. Its generation 60K files without any issue.

Thanks...

I checked for the memory leak, but there is no problem in the code.