DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 490 matches
Author Message
 Topic: Connecting to Hadoop from FileConnector
rkashyap

Replies: 1
Views: 136

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Aug 12, 2017 3:17 pm   Subject: Connecting to Hadoop from FileConnector
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication
DataStage 11.501; Patches applied: Datadirect JDBC Driver for Hive(JR56156) and Hive Connector(JR56097).

We are trying to use File Connector stage for connecting to Cloudera Hadoop server. Connecti ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
rkashyap

Replies: 4
Views: 661

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 09, 2017 8:39 am   Subject: Hive Connector Stage and isjdbc.config file set up
The new problem now is that the performance of the Hive connector stage is pathetic. Opened a case with IBM.. will give all the details if I hear anything positive
What did IBM suggest? Did it help?
 Topic: Azure SQL connectivity from DataStage.
rkashyap

Replies: 1
Views: 382

PostForum: General   Posted: Sat Apr 29, 2017 12:52 pm   Subject: Azure SQL connectivity from DataStage.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication.
Connection to Azure SQL database from DataStage using JDBC with following connection string works ok:jdbc:ibm:sqlserver://azrdevstore.database.windows.net:1433;database=AZR_DEV;Encrypt ...
 Topic: AIX vs Linux DataStage performance
rkashyap

Replies: 4
Views: 582

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 27, 2017 5:28 pm   Subject: AIX vs Linux DataStage performance
Another criteria to think about is availability of features and support.

There are variations in DataStage features based on operating system e.g. BDFS was initially launched only for linux and ab ...
Workaround Reported
 Topic: SFDC sparse lookup with upstream Transformer.
rkashyap

Replies: 2
Views: 576

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Apr 22, 2017 7:06 am   Subject: SFDC sparse lookup with upstream Transformer.
IBM has informed us ... We should prioritize the patch JR47138 implementation based on the work effort since its not a simple fix and might need some design changes so, it might be considered for the ...
Resolved
 Topic: Duration for installation of IS11.5
rkashyap

Replies: 6
Views: 536

PostForum: General   Posted: Sat Apr 22, 2017 6:21 am   Subject: Re: Duration for installation of IS11.5
I meant the duration of the installation of entire IS with most pre-requisites are taken care (though there seems to be a lot)
Installation/configuration of DataStage involves four steps.
1. Instal ...
Resolved
 Topic: Duration for installation of IS11.5
rkashyap

Replies: 6
Views: 536

PostForum: General   Posted: Thu Apr 20, 2017 7:43 am   Subject: Re: Duration for installation of IS11.5
What will be the topology?

By installation do you mean length of the entire projects or simply installation of software (after all the prerequisites are done)?
 Topic: Column Import Stage - Carriage return in free-text field
rkashyap

Replies: 2
Views: 293

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 05, 2017 1:27 pm   Subject: Column Import Stage - Carriage return in free-text field
Carriage return => Char(13). Can you try running following derivation on FREE_TEXT_FIELD in the transformer.Ereplace(in_rec.FREE_TEXT_FIELD, Char(13) ," ",0,1)
 Topic: Write Mode : Delete and Insert fails
rkashyap

Replies: 2
Views: 288

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 05, 2017 12:50 pm   Subject: Write Mode : Delete and Insert fails
Could there be multiple records with same key values in incoming data?

What are values of 'Auto Commit mode', 'Array size', 'Transaction record count'?

Test after changing array size to 1.
Resolved
 Topic: Pivoting Question
rkashyap

Replies: 10
Views: 652

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 05, 2017 8:13 am   Subject: Pivoting Question
What is your source?
 Topic: Frequent DataStage Designer Hang/Freeze
rkashyap

Replies: 5
Views: 619

PostForum: General   Posted: Fri Mar 31, 2017 7:17 am   Subject: Frequent DataStage Designer Hang/Freeze
What is the RAM allocation on the client machine? Are DataStage Prod and Dev server located in same Data center?
 Topic: Parallel startup failed
rkashyap

Replies: 3
Views: 430

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 31, 2017 6:45 am   Subject: Re: Parallel startup failed
Text statesLook for error messages in the preceding output.
What are the error messages in the preceding output?
Resolved
 Topic: Finding out XMETA database type
rkashyap

Replies: 4
Views: 402

PostForum: General   Posted: Thu Mar 30, 2017 1:46 pm   Subject: Finding out XMETA database type
You can also look in database.properties file. Location of this file varies by version, it may be ... /opt/IBM/InformationServer/ASBServer/bin/sql/ or /opt/IBM/InformationServer/ASBServer/conf/.
 Topic: Where to Get the Full Summary of Sequence
rkashyap

Replies: 4
Views: 346

PostForum: General   Posted: Wed Mar 29, 2017 8:20 pm   Subject: Where to Get the Full Summary of Sequence
Monitoring data captured in DSODB can be CaptureLog=IIS-DSTAGE-RUN-I-0019/Summary of sequence run
Required data will be in JOBRUNLOG table.
 Topic: Load Azure Redis Cache using DataStage
rkashyap

Replies: 0
Views: 213

PostForum: General   Posted: Tue Mar 28, 2017 10:37 am   Subject: Load Azure Redis Cache using DataStage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication
Can you please share your thoughts/experiences on loading Azure Redis Cache using DataStage.
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours