DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 205 matches
Author Message
 Topic: ESX VMware backups
thompsonp

Replies: 1
Views: 207

PostForum: General   Posted: Tue Apr 09, 2019 2:12 pm   Subject: ESX VMware backups
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.5.0.2 on RHEL 7.2
Our company standard for VMs is for daily incremental snapshot backups and full weekly backups but we are seeing intermittent job failures when the backup runs.
Jobs either abort or hang.

The v11. ...
 Topic: Unable to start ORCHESTRATE network connection
thompsonp

Replies: 2
Views: 470

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: 470

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: 556

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: 1726

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: 1726

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: 1018

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: 1018

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: 1018

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: 539

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:

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

Replies: 11
Views: 5413

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: 548

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: 848

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: 885

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: 1231

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 ...
 

 Jump to:   



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