Page 1 of 1

Unable to read data from DB2 Enterprise Edtion Stage

Posted: Wed May 27, 2009 7:35 am
by thepakks
Hi All,

The Db2 db is present on a remote machine. The Db2 client is installed on the machine where datastage server is installed. I am able to successfully import the metadata from DB2.

when I tries to view data from a DB2 Enterprise Edtion Stage, I got following error -

Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass: From: Loading memory archive: Could not find "APT_DB2ReadOperator".

Please Suggest.

Re: Unable to read data from DB2 Enterprise Edtion Stage

Posted: Wed Sep 02, 2009 1:27 am
by bolingo
I have the same problem:
##F IIS-DSEE-TFPM-00279 23:01:24(003) <DB2_UDB_Enterprise_987,0> Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass: From: Loading memory archive: Could not find "APT_DB2ReadOperator".

##E IIS-DSEE-TFPM-00192 23:01:24(003) <node_bdb21> Player 1 terminated unexpectedly.
##E IIS-DSEE-TFPM-00338 22:52:41(005) <main_program> APT_PMsectionLeader(2, bd), plab21yer 1 - Unexpected exit status 1.
##E IIS-DSEE-TFSC-00011 22:52:46(001) <main_program> Step execution finished with status = FAILED. :cry:

Please, it huge on me;
I need help

Posted: Wed Sep 02, 2009 2:17 am
by miwinter
Sounds like an install issue (i.e. missing component) to me. Do you get the same issue using a DB2 API stage?

Posted: Wed Sep 02, 2009 4:19 am
by stefanfrost1
You have to have the px engine library available on the remote db2 machine (and or db2 nodes) and the ability to connect to that machine using rsh or ssh (using remsh.sh in ds-lib) if you wish to use the db2 enterprise stage. Furthermore the os and hardware of those platforms need to match.... The API stage should work if you are able to import metadata...

Ps. There are several posts on px-db2 enterprise connectivity issues on this forum!

Posted: Wed Sep 02, 2009 10:50 am
by odesia
miwinter wrote:Sounds like an install issue (i.e. missing component) to me. Do you get the same issue using a DB2 API stage?
It is OK for DB2 API stage;
It is KO for DB2 Enterprise stage

Helllllp

Posted: Wed Sep 02, 2009 11:04 am
by odesia
stefanfrost1 wrote:You have to have the px engine library available on the remote db2 machine (and or db2 nodes) and the ability to connect to that machine using rsh or ssh (using remsh.sh in ds-lib) if you wish to use the db2 enterprise stage. Furthermore the os and hardware of those platforms need to match.... The API stage should work if you are able to import metadata...

Ps. There are several posts on px-db2 enterprise connectivity issues on this forum!
rsh communication with the remote machine is OK;
I have px engine library in the remote machine as you can see:


remote_machine(/../IBM/InformationServer/Server/PXEngine) # ls -artl lib
total 311520
-rwxrwxr-x 1 dsadmin dstagegroup 18452480 Sep 11 2006 icu240.tar
-rwxrwxr-x 1 dsadmin dstagegroup 8683290 Sep 11 2006 libicudata24.so
-rwxrwxr-x 1 dsadmin dstagegroup 8683290 Sep 11 2006 libicudata24.0.so
-rwxrwxr-x 1 dsadmin dstagegroup 445153 Sep 11 2006 libustdio24.so
-rwxrwxr-x 1 dsadmin dstagegroup 445153 Sep 11 2006 libustdio24.0.so
-rwxrwxr-x 1 dsadmin dstagegroup 3635086 Sep 11 2006 libicuuc24.so
-rwxrwxr-x 1 dsadmin dstagegroup 3635086 Sep 11 2006 libicuuc24.0.so
-rwxrwxr-x 1 dsadmin dstagegroup 108776 Sep 11 2006 libicutoolutil24.so
-rwxrwxr-x 1 dsadmin dstagegroup 108776 Sep 11 2006 libicutoolutil24.0.so
-rwxrwxr-x 1 dsadmin dstagegroup 5533970 Sep 11 2006 libicui18n24.so
-rwxrwxr-x 1 dsadmin dstagegroup 5533970 Sep 11 2006 libicui18n24.0.so
-rwxrwxr-x 1 dsadmin dstagegroup 145065 Mar 14 2008 libicuio32.0.a
-rwxrwxr-x 1 dsadmin dstagegroup 145065 Mar 14 2008 libicuio.a
-rwxrwxr-x 1 dsadmin dstagegroup 124599 Mar 14 2008 libicutu32.0.a
-rwxrwxr-x 1 dsadmin dstagegroup 124599 Mar 14 2008 libicutu.a
-rwxrwxr-x 1 dsadmin dstagegroup 13164333 Mar 14 2008 libicudata32.0.a
-rwxrwxr-x 1 dsadmin dstagegroup 13164333 Mar 14 2008 libicudata.a
-rwxrwxr-x 1 dsadmin dstagegroup 2729257 Mar 14 2008 libicui18n32.0.a
-rwxrwxr-x 1 dsadmin dstagegroup 2729257 Mar 14 2008 libicui18n.a
-rwxrwxr-x 1 dsadmin dstagegroup 2015160 Mar 14 2008 libicuuc32.0.a
-rwxrwxr-x 1 dsadmin dstagegroup 2015160 Mar 14 2008 libicuuc.a
-rwxrwxr-x 1 dsadmin dstagegroup 3073221 Oct 14 2008 liborchcoreaix64.a
-rwxrwxr-x 1 dsadmin dstagegroup 129827 Oct 14 2008 orchmonitor.o
-rwxrwxr-x 1 dsadmin dstagegroup 23575283 Oct 14 2008 liborchaix64.a
-rwxrwxr-x 1 dsadmin dstagegroup 138801 Oct 14 2008 orchcommondb.o
-rwxrwxr-x 1 dsadmin dstagegroup 1947814 Oct 14 2008 liborchoslaix64.a
-rwxrwxr-x 1 dsadmin dstagegroup 3007854 Oct 14 2008 orchbuildop.o
-rwxrwxr-x 1 dsadmin dstagegroup 5510536 Oct 14 2008 orchgeneral.o
-rwxrwxr-x 1 dsadmin dstagegroup 1087530 Oct 14 2008 orchsort.o
-rwxrwxr-x 1 dsadmin dstagegroup 1858469 Oct 14 2008 orchresest.o
-rwxrwxr-x 1 dsadmin dstagegroup 894814 Oct 14 2008 orchfreqdist.o
-rwxrwxr-x 1 dsadmin dstagegroup 2938929 Oct 14 2008 orchstats.o
-rwxrwxr-x 1 dsadmin dstagegroup 40126 Oct 14 2008 orchio64.o
-rwxrwxr-x 1 dsadmin dstagegroup 166282 Oct 14 2008 orchresource.o
-rwxrwxr-x 1 dsadmin dstagegroup 1843569 Oct 14 2008 orchsasop9.o
-rwxrwxr-x 1 dsadmin dstagegroup 6524 Oct 14 2008 cdebug.o
-rwxrwxr-x 1 dsadmin dstagegroup 133410 Oct 14 2008 osh.o
-rwxrwxr-x 1 dsadmin dstagegroup 1109888 Oct 14 2008 librwtool.a
-rwxrwxr-x 1 dsadmin dstagegroup 1887966 Oct 14 2008 libqscommon.a
-rwxrwxr-x 1 dsadmin dstagegroup 1379357 Oct 14 2008 libqsmutils.a
-rwxrwxr-x 1 dsadmin dstagegroup 144741 Oct 14 2008 libqstokenize.a
-rwxrwxr-x 1 dsadmin dstagegroup 276947 Oct 14 2008 libqsundup.a
-rwxrwxr-x 1 dsadmin dstagegroup 171481 Oct 14 2008 libqsrefmatch.a
-rwxrwxr-x 1 dsadmin dstagegroup 377223 Oct 14 2008 libqssurv.a
-rwxrwxr-x 1 dsadmin dstagegroup 567509 Oct 14 2008 libqsstan.a
-rwxrwxr-x 1 dsadmin dstagegroup 449201 Oct 14 2008 libqsinvest.a
-rwxrwxr-x 1 dsadmin dstagegroup 393157 Oct 14 2008 libqssqa.a
-rwxrwxr-x 1 dsadmin dstagegroup 361469 Oct 14 2008 libqsfreq.a
-rwxrwxr-x 1 dsadmin dstagegroup 1323135 Oct 14 2008 libqslegacy.a
-rwxrwxr-x 1 dsadmin dstagegroup 111638 Oct 14 2008 libqsMNS.a
-rwxrwxr-x 1 dsadmin dstagegroup 498272 Oct 14 2008 libqsWaves.a
-rwxrwxr-x 1 dsadmin dstagegroup 4335182 Oct 14 2008 libpxbridgeaix64.so
-rwxrwxr-x 1 dsadmin dstagegroup 8033989 Oct 14 2008 libfcl.so
drwxrwxr-x 14 dsadmin dstagegroup 4096 Jun 25 15:30 ..
drwxrwxr-x 2 dsadmin dstagegroup 4096 Jul 16 17:15 .
lrwxrwxrwx 1 root system 16 Aug 14 16:01 libicui18n32.a -> libicui18n32.0.a
lrwxrwxrwx 1 root system 16 Aug 14 16:01 libicudata32.a -> libicudata32.0.a
lrwxrwxrwx 1 root system 5 Aug 14 16:01 liboshaix64.so -> osh.o
lrwxrwxrwx 1 root system 11 Aug 14 16:01 liborchstatsaix64.so -> orchstats.o
lrwxrwxrwx 1 root system 10 Aug 14 16:01 liborchsortaix64.so -> orchsort.o
lrwxrwxrwx 1 root system 12 Aug 14 16:01 liborchsasop9aix64.so -> orchsasop9.o
lrwxrwxrwx 1 root system 14 Aug 14 16:01 liborchresourceaix64.so -> orchresource.o
lrwxrwxrwx 1 root system 12 Aug 14 16:01 liborchresestaix64.so -> orchresest.o
lrwxrwxrwx 1 root system 13 Aug 14 16:01 liborchmonitoraix64.so -> orchmonitor.o
lrwxrwxrwx 1 root system 10 Aug 14 16:01 liborchio64aix64.so -> orchio64.o
lrwxrwxrwx 1 root system 13 Aug 14 16:01 liborchgeneralaix64.so -> orchgeneral.o
lrwxrwxrwx 1 root system 14 Aug 14 16:01 liborchfreqdistaix64.so -> orchfreqdist.o
lrwxrwxrwx 1 root system 14 Aug 14 16:01 liborchcommondbaix64.so -> orchcommondb.o
lrwxrwxrwx 1 root system 13 Aug 14 16:01 liborchbuildopaix64.so -> orchbuildop.o
lrwxrwxrwx 1 root system 14 Aug 14 16:01 libicuuc32.a -> libicuuc32.0.a
lrwxrwxrwx 1 root system 14 Aug 14 16:01 libicutu32.a -> libicutu32.0.a
lrwxrwxrwx 1 root system 14 Aug 14 16:01 libicuio32.a -> libicuio32.0.a
lrwxrwxrwx 1 root system 8 Aug 14 16:01 libcdebugaix64.so -> cdebug.o
lrwxrwxrwx 1 dsadmin dstagegroup 66 Aug 14 16:01 orchoracle10g.o -> /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle10g.o
lrwxrwxrwx 1 dsadmin dstagegroup 64 Aug 14 16:01 orchoracle.so -> /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.so
lrwxrwxrwx 1 dsadmin dstagegroup 61 Aug 14 16:01 oraoci9.so -> /opt/IBM/InformationServer/Server/DSComponents/bin/oraoci9.so
lrwxrwxrwx 1 dsadmin dstagegroup 54 Aug 14 16:01 libclntsh.so.10.1 -> /u01/app/oracle/product/10.2.0/lib32/libclntsh.so.10.1
lrwxrwxrwx 1 dsadmin dstagegroup 61 Aug 14 16:01 VMdb223.so -> /opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb223.so

Do you have any answer about this^
helllp please :(

Posted: Tue Sep 08, 2009 7:41 am
by fridge
hi - you dont seem to have the orchdb2 operator installed - are u sure db2 was specified when u did the install (I am looking at a v7.5 install so may be different on V8)

You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at install time then wont create the following link correctly

orchdb2op -> orchdb2op8.o

(for a db2 v8 platform)

Posted: Wed Sep 09, 2009 1:05 am
by stefanfrost1
Follow fridge's lead....
You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at install time then wont create the following link correctly

orchdb2op -> orchdb2op8.o

Posted: Sat Sep 12, 2009 8:00 am
by bolingo
fridge wrote:hi - you dont seem to have the orchdb2 operator installed - are u sure db2 was specified when u did the install (I am looking at a v7.5 install so may be different on V8)

You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at install time then wont create the following link correctly

orchdb2op -> orchdb2op8.o

(for a db2 v8 platform)
After creating the link orchdb2op -> orchdb2op8.o in ...../PXEngine/lib; may I have to re-start the engine!!!
Thanks

Posted: Sat Sep 12, 2009 7:54 pm
by ray.wurlod
You shouldn't need to re-start, but it won't hurt to do so.

Posted: Mon Sep 14, 2009 9:17 am
by bolingo
ray.wurlod wrote:You shouldn't need to re-start, but it won't hurt to do so. ...
I restarted but the problem is still here;

helllp