DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 204 matches
Author Message
 Topic: Unable to start ORCHESTRATE network connection
thompsonp

Replies: 2
Views: 182

PostForum: General   Posted: Mon Feb 25, 2019 4:47 am   Subject: Unable to start ORCHESTRATE network connection
Sorry for slow response - been away.

The config file is (names changed):

node "node1"
{
fastname "ServerName"
pools ""
resource disk "/test/datasetdata1/PNTest" {pools ""}
resource ...
 Topic: Unable to start ORCHESTRATE network connection
thompsonp

Replies: 2
Views: 182

PostForum: General   Posted: Wed Feb 06, 2019 8:35 pm   Subject: Unable to start ORCHESTRATE network connection
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.5.0.2 on RHEL 7.2
We are migrating several applications built with DataStage v8.1 to DataStage v11.5.

Each one has its own project on the same RHEL 7.2 server (a VM).
Two small and one large application were migrat ...
 Topic: Nullable Value transforms to 0 while writing to OracleDB
thompsonp

Replies: 2
Views: 379

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 30, 2018 2:37 am   Subject: Nullable Value transforms to 0 while writing to OracleDB
How are you checking the value in the Database?

What happens if you insert a null value into that table / column from outside DataStage?
Resolved
 Topic: Websphere MQ Connector Failing
thompsonp

Replies: 3
Views: 1435

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 15, 2018 7:32 am   Subject: Websphere MQ Connector Failing
Resolved by adding the mqm/lib64 directory to LD_LIBRARY_PATH
Also set MQCHLLIB and MQCHLTAB in dsenv
Resolved
 Topic: Websphere MQ Connector Failing
thompsonp

Replies: 3
Views: 1435

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 19, 2018 4:50 am   Subject: Websphere MQ Connector Failing
Did you resolve this?
I have the same error on a Linux v11.5 installation having moved from v8.1.
 Topic: DSGetStageInfo giving inaccurate results
thompsonp

Replies: 5
Views: 716

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 24, 2018 7:08 am   Subject: DSGetStageInfo giving inaccurate results
The issue went away for a while but has now resurfaced in a test environment.
It's back with IBM support with all kinds of tracing and debugging enabled.
 Topic: DSGetStageInfo giving inaccurate results
thompsonp

Replies: 5
Views: 716

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 17, 2018 7:51 am   Subject: DSGetStageInfo giving inaccurate results
With option DSJ.LINKROWCOUNT the count is returned as a single value.
If I change that to DSJ.INSTROWCOUNT I get a comma separated list of counts for each partition.

Does anyone know what these Da ...
 Topic: DSGetStageInfo giving inaccurate results
thompsonp

Replies: 5
Views: 716

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 16, 2018 8:52 am   Subject: DSGetStageInfo giving inaccurate results
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL 7
Jobs that work as expected on v8.1 have been migrated to v11.5
As part of an after job subroutine the link counts are examined using

DSGetLinkInfo(JobHandle,ThisStage,ThisLink,DSJ.LINKROWCOUNT ...
 Topic: SQL function in update statement using ODBC connector
thompsonp

Replies: 1
Views: 428

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 24, 2018 7:24 am   Subject: SQL function in update statement using ODBC connector
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have a job whose target stage is an ODBC Connector.
It will update one column on a table based on the key field.
However the SQL needs to have a LOWER function applied within the WHERE clause:

...
 Topic: Issue with Dataset performance in RedHat Linux
thompsonp

Replies: 10
Views: 4630

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 9:13 am   Subject: Issue with Dataset performance in RedHat Linux
John - do you have any further details or a case number from IBM that you could share?
 Topic: ulimits and server restarts
thompsonp

Replies: 2
Views: 429

PostForum: General   Posted: Wed May 16, 2018 8:50 am   Subject: ulimits and server restarts
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL 7.2
We have a new v11.5 install and all the recommended kernel settings were supposedly made before the installation.

The server was recently rebooted and we saw a message about increasing the open fil ...
 Topic: Separating Services and Repository tiers from Engine
thompsonp

Replies: 2
Views: 749

PostForum: General   Posted: Thu Jan 18, 2018 5:16 am   Subject: Separating Services and Repository tiers from Engine
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: RHEL
If we start with a basic installation topology where the Services, Repository and Engine tiers are all on the same server, how easy is it to separate the Engine tier from the other two at a later date ...
 Topic: Fork-join with condition
thompsonp

Replies: 1
Views: 784

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jan 17, 2018 9:36 am   Subject: Fork-join with condition
What are you hoping to see in col1 on the output?

If it's just the col1 value from the row that had the last non zero value in col2 then it's straightforward.

Filter out all the rows where col2 ...
 Topic: Intel Kernel design flaw / bug
thompsonp

Replies: 6
Views: 1032

PostForum: General   Posted: Thu Jan 04, 2018 3:37 am   Subject: Intel Kernel design flaw / bug
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Any idea what impact the patches to Linux and Windows to address the Intel cpu flaw will likely have on typical DataStage workloads?

I've been reading that workloads with lots of network and i/o ma ...
 Topic: Webinar vNext
thompsonp

Replies: 8
Views: 1348

PostForum: General   Posted: Wed Dec 13, 2017 8:44 am   Subject: Webinar vNext
Seems not - I've had nothing since the slide deck was sent after the first webinar.
 

 Jump to:   



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