DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 413 matches
Author Message
Resolved
 Topic: Convert space to null
JRodriguez

Replies: 8
Views: 434

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 4:05 pm   Subject: Convert space to null
I wonder if the target database is Oracle by any chance? If yes then by just trimming the source field, without any other logic, the database will take take of setting the target field to null
 Topic: NLS automation
JRodriguez

Replies: 2
Views: 238

PostForum: General   Posted: Wed Apr 25, 2018 6:30 am   Subject: NLS automation
Short answer is not for the project but you could change the NLs to a specific process or interface developed in DS dynamically if that is what you are looking for
Workaround Reported
 Topic: DS events not published on Kafka “InfosphereEvents” topic
JRodriguez

Replies: 1
Views: 277

PostForum: General   Posted: Mon Apr 16, 2018 7:53 am   Subject: DS events not published on Kafka “InfosphereEvents” topic
Ended up submitting an RFE for to see if the feature could be added in the future. If you feel like is a useful feature please vote for this request, the link is listed below

https://www.ibm.com/de ...
Workaround Reported
 Topic: Kafka logs on Service tier
JRodriguez

Replies: 5
Views: 503

PostForum: General   Posted: Thu Mar 29, 2018 10:17 am   Subject: Kafka logs on Service tier
It should be ok to add the new parameter to the configuration manually. My preference is to use the commands provided to do all the maintenance tasks

A Topic is just a stream of records, In the Ka ...
Workaround Reported
 Topic: Kafka logs on Service tier
JRodriguez

Replies: 5
Views: 503

PostForum: General   Posted: Thu Mar 29, 2018 9:13 am   Subject: Kafka logs on Service tier
Two ways come to my mind:

1) change the retention period for events on the topic
$InstallPath/shared-open-source/kafka$ update-config.sh --zookeeper serverName:port --entity-type topics --alter -- ...
 Topic: External Filter - Run in one project, not the other
JRodriguez

Replies: 4
Views: 474

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 29, 2018 8:33 am   Subject: External Filter - Run in one project, not the other
Did you compile the code in Project B after importing the parameterSet??
Workaround Reported
 Topic: DS events not published on Kafka “InfosphereEvents” topic
JRodriguez

Replies: 1
Views: 277

PostForum: General   Posted: Wed Mar 28, 2018 1:05 pm   Subject: DS events not published on Kafka “InfosphereEvents” topic
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Kicking off BPM processes
Hi All,
All Information Server events are published as kafka events in the "InfosphereEvents" topic but DataStage. The events could be consumed with any kafka/Jason client or a command line consumer ...
 Topic: Connecting to Designer/Director from command line
JRodriguez

Replies: 6
Views: 447

PostForum: General   Posted: Wed Mar 28, 2018 6:22 am   Subject: Connecting to Designer/Director from command line
Thanks to both of you.

My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxu ...
 Topic: Connecting to Designer/Director from command line
JRodriguez

Replies: 6
Views: 447

PostForum: General   Posted: Wed Mar 28, 2018 6:22 am   Subject: Connecting to Designer/Director from command line
Thanks to both of you.

My understanding is that dsjob uses a different connection mechanism and the goal is to ensure that a connection via a DS client could be established. We don't have the luxu ...
 Topic: Connecting to Designer/Director from command line
JRodriguez

Replies: 6
Views: 447

PostForum: General   Posted: Tue Mar 27, 2018 6:46 am   Subject: Connecting to Designer/Director from command line
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: For automatic validation purpose
Hello All,
Is there a way to check from command line that a connection could be established from the DataStage clients to Information Server?

We have a validation script to test the health of our ...
Resolved
 Topic: What is ODF and where is it documented?
JRodriguez

Replies: 5
Views: 676

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Feb 08, 2018 6:45 pm   Subject: What is ODF and where is it documented?
IBM Information Server Open Discovery Framework (ODF)
In the latest versions of Information Server IBM added open source services, specifically the Apache Framework (Zookeeper, Kafka,solr) and there ...
Resolved
 Topic: Encrypted connection to SQL Server
JRodriguez

Replies: 5
Views: 1131

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 11, 2018 6:43 am   Subject: Encrypted connection to SQL Server
Try the instructions in below link

http://www-01.ibm.com/support/docview.wss?uid=swg21676239
 Topic: UTF-8 to UTF-16 conversion in Datastage
JRodriguez

Replies: 1
Views: 1111

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 13, 2017 8:56 am   Subject: UTF-8 to UTF-16 conversion in Datastage
Hi Matt,
Internally DataStage parallel jobs use UTF-16 encoding by default regardless of the encoding of sources and targets. It means that internally the data from one stage to the next flows alrea ...
 Topic: "error": "SELF_SIGNED_CERT_IN_CHAIN"
JRodriguez

Replies: 1
Views: 1190

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Wed Oct 25, 2017 5:34 am   Subject: "error": "SELF_SIGNED_CERT_IN_CHAIN"
This is the light version of the procedure. Do your company have a WAS administrator? If yes then ask for help to that group, the procedure is straightforward for a WAS person. If not then just fol ...
Workaround Reported
 Topic: Throttle a DS Parallel job which invokes a Rest Service
JRodriguez

Replies: 3
Views: 928

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 11, 2017 5:28 pm   Subject: Throttle a DS Parallel job which invokes a Rest Service
Well normally we are asked to speed up processes..but it could be done. Here is one way

To the request table add a column to flag the requests records as processed/not processed. Default the value ...
 

 Jump to:   



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