db2 udb enterprise stage view data

[kavuri]

Hi,
while I am trying to view the data in DB2 UDB enterprise stage, I am getting following error.

##E TOSH 000205 10:40:55(007) <main_program> PATH search failure:
##E TOSH 000000 10:40:55(008) <main_program> Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot load module /medstat/advantage/ascential/Ascential/DataStage/PXEngine/lib/liborchdb2opaix3.so.
0509-150 Dependent module libdb2.a(shr.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /medstat/advantage/ascential/Ascential/DataStage/PXEngine/lib/liborchdb2opaix3.so.
0509-150 Dependent module /medstat/advantage/ascential/Ascential/DataStage/PXEngine/lib/liborchdb2opaix3.so could not be loaded..
##E TOSH 000000 10:40:55(009) <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 TCOS 000029 10:40:55(010) <main_program> Creation of a step finished with status = FAILED.

Can anybody suggest what is the problem.

Thanks in advance.
Kavuri

[ray.wurlod]

Whenever a library can not be found it is probably your shared library search path (environment variable LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH) that is the problem.

[kavuri]

Hi Ray,
I am able to view my client tool administrator. I dont have access to server. Here what I found is "LIBPATH=/usr/lib".
If I want it to work what else do I need to do?
Here I am having my source database is DB2, and my target is sequential file. Can you tell me what are all the settings do I need for proper working of jobs.

Thanks
Kavuri

[kavuri]

Hi,
I had tried based on errors some of the following. I am getting following details when executing in Unix shell prompt.

$ liborchdb2opaix3.so
exec(): 0509-036 Cannot load program liborchdb2opaix3.so because of the following errors:
0509-151 The program does not have an entry point or
the o_snentry field in the auxiliary header is invalid.
0509-194 Examine file headers with the 'dump -ohv' command.
$ exec liborchdb2opaix3.so
There are stopped jobs.


Thanks
Kavuri

[ray.wurlod]

Look in the second event of a job log. All environment variables used by the job process are reported there.

The shared library search path in your client is totally irrelevant to problems encountered by a stage on the server.

[kavuri]

Hi Ray,
Can you plz tell me in which path we get this shared libraries? Are these libraries common to both admin and user of DataStage?
I am unable to figure out where to change all these. Can you tell me in some more detail?

Thanks
Kavuri

[kavuri]

Ok after trying something, I got the following error.

Error executing View Data command:

##E TNDB 000226 11:57:30(000) <DB2_UDB_Enterprise_0> The environment variable DB2INSTANCE is not defined;

and

##E TNDB 000226 11:57:30(000) <DB2_UDB_Enterprise_0> The environment variable DB2INSTANCE is not defined;
this variable must be defined in order to use any DB2 operators.
##E TOPK 000000 11:57:30(004) <_PEEK_IDENT_> Input dataset does not have field: "CONSISTENT_MEMBER_ID".
##E TOPK 000000 11:57:30(005) <_PEEK_IDENT_> Input dataset does not have field: "RENDERING_PROV_ID".
##E TOPK 000000 11:57:30(006) <_PEEK_IDENT_> Input dataset does not have field: "PROFOTHER_SERVICE_ID".
##E TFSR 000019 11:57:30(008) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 11:57:30(015) <main_program> Creation of a step finished with status = FAILED.

i.e I think we need to export db2instance parameter. But where I have to define this one. Can anybody tellme.

Thanks
Kavuri

[ray.wurlod]

You need to put your DB2-specific environment variables into either the dsenv script or into the Administrator client.