Page 1 of 1
SQLAllocHandle: Failed to allocate environment handle 'ENV'
Posted: Wed Mar 18, 2009 7:28 am
by anothai
OS:AIX
Information Server 8.0.1
This is server job for read data from DB2 API and write into text file
Error at DB2 API when view data or run job:
db2_CORAUDIT : SQLAllocHandle: Failed to allocate environment handle 'ENV'
Thanks
Posted: Wed Mar 18, 2009 8:00 am
by chulett
Custom sql or generated by the stage? Regardless, please post your sql and let us know if you're doing anything 'before' or 'after' in the stage as well. In other words... details. I'd also be curious if you've ever used the DB2 stage before and just this one has a problem or this is your first time ever attempting to use it.
Details.
Posted: Wed Mar 18, 2009 9:07 am
by anothai
it very simple SQL (select ... from ), and I try run on the other environment. It fine. thanks
Posted: Wed Mar 18, 2009 9:26 am
by chulett
Ok, so much for details. [sigh]
What's different about this 'other environment'? As Ray would say, 'Nothing is not the correct answer'.
Posted: Wed Mar 18, 2009 10:17 am
by Sainath.Srinivasan
What if you run outside datastage but from DS server?
Posted: Thu Mar 19, 2009 9:56 am
by anothai
The other environment is just " vmware " and OS is redhat.
I have to say job design is OK but some environment set up is wrong.
Thank you.
Posted: Thu Mar 19, 2009 10:08 am
by chulett
I would say so, too. What does your official support provider have to say on the subject?