Fatal error on SQLAllocHander... setting up env. using DB2

rajm438 · Post by **rajm438** » Fri Oct 22, 2004 3:07 pm

running a px job and getting fatal error on a SQLAllocHandler.

Fatal Error: Fatal: SQLAllocHandle: Failed to allocate environment handle 'ENV'.

DB2 UDB/API stage is working find and can see sql results.

what could be a problem here... running on datastage px 7.x on AIX

-RajM438

ray.wurlod · Post by **ray.wurlod** » Fri Oct 22, 2004 4:29 pm

From past experience I know that the DB2 API is quite similar to the ODBC API.

The SQLAllocEnv function (which SQLAllocHandle probably calls when needing an environment handle) does little more than set up a small amount of memory for managing the environment in which connection information will be managed. Typically (assuming there are no bugs in the code) it only fails if you've run out of memory and can't malloc() sufficient memory.

None of that helps you, except to suggest that you monitor usage of memory in the process that is running the job. I think you're going to need to log a call with your support provider on this one.