Search found 76 matches

by krishna81
Wed Mar 15, 2017 9:05 am
Forum:
Topic: Import Stored procedure into IMAM/ IGC
Replies: 4
Views: 7481

Thank you both for your posts, The answer form leandrohmvieira question is i am still in the stage to come up with proper syntax as i still in confused state trying to understand how to leverage these options and put them in place. My understanding based on eostic message is i can still use Extended...
by krishna81
Fri Mar 10, 2017 2:55 pm
Forum:
Topic: Import Stored procedure into IMAM/ IGC
Replies: 4
Views: 7481

Import Stored procedure into IMAM/ IGC

Dear DsXchange Members, I am currently using information server suite 11.5 version and trying to establish lineage between a stored procedure and ETL jobs(Source tables--->Stored procedure --->Staging Table(Loaded by Sp) --->ETL(Reads staging table and loads into target table)---Target table) . for ...
by krishna81
Thu Jul 16, 2015 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unstructured data not working in 11.3
Replies: 6
Views: 5713

Thank you guys for trying to help me.
i figured out issue lied in LD_LIBRARY_PATH after i added below line it worked.

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:`dirname $DSHOME`/biginsights/IHC/c++/Linux-amd64-64/lib:$ISHOME/jdk/jre/lib/amd64/j9vm:$ISHOME/jdk/jre/lib/amd64;
export LD_LIBRARY_PATH

Thanks
by krishna81
Thu Jul 16, 2015 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unstructured data not working in 11.3
Replies: 6
Views: 5713

Yes, see the below entries LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/l...
by krishna81
Thu Jul 16, 2015 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unstructured data not working in 11.3
Replies: 6
Views: 5713

Unstructured data not working in 11.3

we recently moved from 9.7 to 11.3 . The job which reads excel file works in old version but throwing error in 11.3 any idea? Unstructured_Data_0: Error loading connector library libccapijni.so. libjvm.so: cannot open shared object file: No such file or directory (CC_LoadedConnector::loadLibrary, fi...
by krishna81
Wed Nov 12, 2014 3:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Assembly Editor Time Out CDIUI4615E
Replies: 4
Views: 5121

Never mind, issue is resolved .

Work around is add a line of datastage server Host entry in Client machine Host file

<IP ADDRESS> <DS HOSTNAME>
by krishna81
Wed Oct 15, 2014 8:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Assembly Editor Time Out CDIUI4615E
Replies: 4
Views: 5121

Re: XML Assembly Editor Time Out CDIUI4615E

CDIUI4615E The session with server 'http://<hostname>:9080' has expired. Please restart the Assembly Editor application. Server status code is 408.


Shiva,

Was the above problem resolved?If so can you explain how you nail down.

Appreciate in advance

Thanks
Krishna
by krishna81
Thu Oct 27, 2011 7:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Different results on multiple nodes
Replies: 1
Views: 2141

Different results on multiple nodes

When I am running a job on single node the data and no.of records I am getting are perfect , but when running the same job on 4 (or Multi) nodes, it is acting weird. The no.of records I am getting is different(more than no.of records from source). Have a join stage and filtering data with a constrai...
by krishna81
Thu Dec 30, 2010 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Breaking a column's value into multiple rows
Replies: 4
Views: 3583

Parallel 8.1

I have the same situation but don't know the max values .Is there any alternate approach .Please advice if Any custom stage code for this scenario.


Thanks
by krishna81
Tue Sep 14, 2010 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance data job_ident
Replies: 0
Views: 1779

Performance data job_ident

Can any one please post what is the Job_ident represent/stands in performance data file <?xml version="1.0" encoding="UTF-8" ?> <performance_output version="1.1" date="20100914 13:37:31" framework_revision="IBM WebSphere DataStage Enterprise Edition 8.1.0...
by krishna81
Tue Aug 17, 2010 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC SQL Server Driver]Communication link failure
Replies: 1
Views: 3290

ODBC SQL Server Driver]Communication link failure

Hi, DS job was throwed fatel error but still reported a return code of 1. please see the below error. Event type:Fatal Message ID:IIS-DSEE-TDOD-00007 Message: APT_CombinedOperatorController(2),0: [DataDirect][ODBC SQL Server Driver][libssclient22]Timeout Expired. [DataDirect][ODBC SQL Server Driver]...
by krishna81
Fri Mar 12, 2010 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to read file through complex flat file stage
Replies: 11
Views: 8223

Here my source is MQ.Because of this i am writing data using Seq file stage and later using CFF to read the same.
The reason i am using CFF is the data iis in hexa and variable length.

Still i am wondering the Record Delimiter String property is not there in CFF stage as Ray mentioned above.
by krishna81
Fri Mar 12, 2010 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to read file through complex flat file stage
Replies: 11
Views: 8223

Yes There is specific reason why i am using CFF stage.I have to split the date based on my record type.

For chulett C is Complex
by krishna81
Fri Mar 12, 2010 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to read file through complex flat file stage
Replies: 11
Views: 8223

I did not see Record delimiter string property in CFF stage.We are using 8.0.1 verson.
by krishna81
Thu Mar 11, 2010 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to read file through complex flat file stage
Replies: 11
Views: 8223

Unable to read file through complex flat file stage

Hi Folks,

How can we read file by giving more than one string as a Record delimiter in CFF stage.

Here is My job flow

Mq --->Seq(Here i am creating file with ~~ as record delimiter)

Reading above file using CFF
CFF --->Peek


Thanks
Krish