Error During View Data in DB2_UDB_ENTERPRISE Stage
Moderators: chulett, rschirm, roy
Error During View Data in DB2_UDB_ENTERPRISE Stage
Hi,
I am trying to view data in DB2_UDB_ENTERPRISE stage. I am getting following error
##E IIS-DSEE-TOSH-00205 16:06:52(005) <main_program> PATH search failure:
##E IIS-DSEE-TOSH-00384 16:06:52(006) <main_program> Could not locate operator definition, wrapper, or Unix command for "db2read"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E IIS-DSEE-TCOS-00029 16:06:52(008) <main_program> Creation of a step finished with status = FAILED.
Following is the steps I have done prior to View Data in DB2_UDB_ENTERPRISE stage.
1. Import table definition using ODBC.
2. Loaded table on the dslink
3. In Properties Tab --> Read Method = "Auto Generated"
4. SQL Query --> this contains the SQL select query
5. Table --> MyTable
What could be the reason. Any advice to fix this up.
Regards,
-Sumit C
I am trying to view data in DB2_UDB_ENTERPRISE stage. I am getting following error
##E IIS-DSEE-TOSH-00205 16:06:52(005) <main_program> PATH search failure:
##E IIS-DSEE-TOSH-00384 16:06:52(006) <main_program> Could not locate operator definition, wrapper, or Unix command for "db2read"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E IIS-DSEE-TCOS-00029 16:06:52(008) <main_program> Creation of a step finished with status = FAILED.
Following is the steps I have done prior to View Data in DB2_UDB_ENTERPRISE stage.
1. Import table definition using ODBC.
2. Loaded table on the dslink
3. In Properties Tab --> Read Method = "Auto Generated"
4. SQL Query --> this contains the SQL select query
5. Table --> MyTable
What could be the reason. Any advice to fix this up.
Regards,
-Sumit C
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It says "Path Search Failure"
But in my environment variables under General category my path variables are already set
LD_LIBRARY_PATH = /usr/lib:.
PATH = /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
I am new to Datastage enviornment.
Could you please help me out and let me know what more to fix.
But in my environment variables under General category my path variables are already set
LD_LIBRARY_PATH = /usr/lib:.
PATH = /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
I am new to Datastage enviornment.
Could you please help me out and let me know what more to fix.
Your PATH and LD_LIBRARY_PATH are missing all of the settings usually added by sourcing the "dsenv" script; where did you check these? The first line of the direcotr log file of a job run will show you the environment settings that were used, so perhaps instead of "view data" you can compile and run the job and get this information.
After installation of Datastage we are for the first time trying to connect dB2 files. So we might be missing some of the setup. Do we need to do some setup on iSeries (AS/400) Box too?
following are the settings as copied from Director Event Detail
LD_LIBRARY_PATH=/app/DataStage/InformationServer/Server/Projects/scmdev/buildop:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSParallel:/app/DataStage/InformationServer/Server/PXEngine/user_lib:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/Projects/scmdev/RT_BP17.O:/app/DataStage/InformationServer/Server/branded_odbc/lib:/app/DataStage/InformationServer/Server/DSEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/uvdlls:/app/DataStage/InformationServer/ASBNode/apps/jre/bin:/app/DataStage/InformationServer/ASBNode/apps/jre/bin/classic:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/db/app/oracle/product/10.2/lib32:/lib:/usr/lib:.
LIBPATH=/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/lib32:/app/DataStage/InformationServer/Server/branded_odbc/lib:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/uvdlls:/app/DataStage/InformationServer/ASBNode/apps/jre/bin:/app/DataStage/InformationServer/ASBNode/apps/jre/bin/classic:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/db/app/oracle/product/10.2/lib32:
PATH=/app/DataStage/InformationServer/Server/Projects/scmdev/wrapped:/app/DataStage/InformationServer/Server/Projects/scmdev/buildop:/app/DataStage/InformationServer/Server/Projects/scmdev/RT_BP17.O:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSParallel:/app/DataStage/InformationServer/Server/PXEngine/user_osh_wrappers:/app/DataStage/InformationServer/Server/PXEngine/osh_wrappers:/app/DataStage/InformationServer/Server/PXEngine/bin:/app/DataStage/InformationServer/Server/branded_odbc/bin:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/vc60/MT_dllbin:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/bin:/app/DataStage/InformationServer/Server/branded_odbc/bin:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/vc60/MT_dllbin:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/bin:/app/DataStage/home/dsadm/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
following are the settings as copied from Director Event Detail
LD_LIBRARY_PATH=/app/DataStage/InformationServer/Server/Projects/scmdev/buildop:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSParallel:/app/DataStage/InformationServer/Server/PXEngine/user_lib:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/Projects/scmdev/RT_BP17.O:/app/DataStage/InformationServer/Server/branded_odbc/lib:/app/DataStage/InformationServer/Server/DSEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/uvdlls:/app/DataStage/InformationServer/ASBNode/apps/jre/bin:/app/DataStage/InformationServer/ASBNode/apps/jre/bin/classic:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/db/app/oracle/product/10.2/lib32:/lib:/usr/lib:.
LIBPATH=/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/lib32:/app/DataStage/InformationServer/Server/branded_odbc/lib:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/uvdlls:/app/DataStage/InformationServer/ASBNode/apps/jre/bin:/app/DataStage/InformationServer/ASBNode/apps/jre/bin/classic:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/linux-all-x86:/db/app/oracle/product/10.2/lib32:
PATH=/app/DataStage/InformationServer/Server/Projects/scmdev/wrapped:/app/DataStage/InformationServer/Server/Projects/scmdev/buildop:/app/DataStage/InformationServer/Server/Projects/scmdev/RT_BP17.O:/app/DataStage/InformationServer/Server/DSComponents/lib:/app/DataStage/InformationServer/Server/DSComponents/bin:/app/DataStage/InformationServer/Server/DSParallel:/app/DataStage/InformationServer/Server/PXEngine/user_osh_wrappers:/app/DataStage/InformationServer/Server/PXEngine/osh_wrappers:/app/DataStage/InformationServer/Server/PXEngine/bin:/app/DataStage/InformationServer/Server/branded_odbc/bin:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/vc60/MT_dllbin:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/bin:/app/DataStage/InformationServer/Server/branded_odbc/bin:/app/DataStage/InformationServer/ASBNode/lib/cpp:/app/DataStage/InformationServer/ASBNode/apps/proxy/cpp/vc60/MT_dllbin:/app/DataStage/InformationServer/Server/PXEngine/lib:/app/DataStage/InformationServer/Server/DSEngine/bin:/app/DataStage/InformationServer/Server/DSEngine/lib:/db/app/oracle/product/10.2/bin:/app/DataStage/home/dsadm/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.
Following error are captured in Directors Event Detail
FATAL: main_program: PATH search failure:
FATAL: main_program: Could not locate operator definition, wrapper, or Unix command for "db2read"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
WARNING: main_program: Operator db2read does not exist in the registry.
FATAL: main_program: Creation of a step finished with status = FAILED.
I have already pasted the PATH we are using in my previous reply.
Please advice.
Are we missing something in iSeries Box?
FATAL: main_program: PATH search failure:
FATAL: main_program: Could not locate operator definition, wrapper, or Unix command for "db2read"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
WARNING: main_program: Operator db2read does not exist in the registry.
FATAL: main_program: Creation of a step finished with status = FAILED.
I have already pasted the PATH we are using in my previous reply.
Please advice.
Are we missing something in iSeries Box?
-
- Participant
- Posts: 33
- Joined: Sat Jul 02, 2005 2:27 am
- Location: Bangalore