Page 1 of 1
environment handle 'ENV' error
Posted: Thu Feb 11, 2010 4:51 pm
by bmarko22
Trying to do a view data on s DB2UDB stage. It works just fine in other projects to the same instance/db. Something appears to be wrong in just this project. Any possible causes? Thanks all.
PMDBtoBCSREF..DB2_UDB_API_0: SQLAllocHandle: Failed to allocate environment handle 'ENV'.
PMDBtoBCSREF..DB2_UDB_API_0.DSLink1: DSP.Open GCI $DSP.Open error -100.
Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project GBSDM_Proj
Re: environment handle 'ENV' error
Posted: Thu May 27, 2010 11:27 am
by DataDoctor
I am getting same error. Please let me know if you resolved this problem.
Posted: Thu May 27, 2010 11:34 am
by ray.wurlod
This can be a failure to load the ODBC driver or - on Windows - the ODBC driver manager.
Posted: Thu May 27, 2010 12:20 pm
by DataDoctor
Thanks for prompt reply as you always do. I am using DB2 API stage. Still I have to set up ODBC?
Posted: Thu May 27, 2010 12:24 pm
by DataDoctor
Here are errors.
Code: Select all
DB2_UDB_API_51,0: Failure during execution of operator logic. [api/operator_rep.C:340]
DB2_UDB_API_51,0: Fatal Error: Fatal: SQLAllocHandle: Failed to allocate environment handle 'ENV'. [dscapiop.C:1882]
node_node1: operator [DB2_UDB_API_51], partition 0 of 1, processID 1060948 on node1, player 2 terminated unexpectedly. [processmgr/player.C:150]
main_program: Unexpected exit status 1 [processmgr/slprocess.C:420]
main_program: Step execution finished with status = FAILED. [sc/sc_api.C:252]
Posted: Thu May 27, 2010 6:53 pm
by ray.wurlod
No. The DB2 API is very similar in construction to the ODBC API - with some minor variants (for example ENV rather than HENV for the name of the environment handle). However, it's still probably an inability to load a driver of some kind.