DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2626 matches
Author Message
 Topic: Unable to connect to SQL server through DataStage
qt_ky

Replies: 1
Views: 20

PostForum: General   Posted: Fri Oct 20, 2017 6:17 am   Subject: Unable to connect to SQL server through DataStage
There are no other files to configure. Double check that the .odbc.ini entry has correct database name, host name (or IP address), and port number.

Timeout errors usually indicate you are blocked b ...
 Topic: Datastage Loading in Oracle table Speed
qt_ky

Replies: 8
Views: 125

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 1:14 pm   Subject: Datastage Loading in Oracle table Speed
I have an old topic (from a former user account that quit working) on this exact same type of issue that you may find interesting:

http://www.dsxchange.com/viewtopic.php?t=135492
Resolved
 Topic: Regarding istool command in Datastage 11.3 version
qt_ky

Replies: 3
Views: 59

PostForum: General   Posted: Wed Oct 18, 2017 1:07 pm   Subject: Regarding istool command in Datastage 11.3 version
We have automated project exports running the istool.sh script from the directory you mentioned on UNIX servers on both v11.3 and v11.5. We schedule them to run nightly for backup purposes.

I can't ...
 Topic: Ereplace function Missing in Parallel Jobs
qt_ky

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 7:10 am   Subject: Ereplace function Missing in Parallel Jobs
I would recommend contacting Support.
 Topic: While loading into db2 thru ds,Uncommitted data is readable?
qt_ky

Replies: 3
Views: 134

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 16, 2017 7:44 am   Subject: While loading into db2 thru ds,Uncommitted data is readable?
That matches my understanding. My only disclaimer is that I'm not a DB2 DBA.
 Topic: Ereplace function Missing in Parallel Jobs
qt_ky

Replies: 9
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 13, 2017 11:39 am   Subject: Ereplace function Missing in Parallel Jobs
I've been using the built-in parallel function since v11.3. You should see Ereplace and the similar function named Change on the derivation menu under the Function... String category. Are they both mi ...
 Topic: Environment Isolation
qt_ky

Replies: 6
Views: 404

PostForum: General   Posted: Fri Oct 13, 2017 11:31 am   Subject: Environment Isolation
WLM helps protect the DataStage server from overloading, such that a newly run job on an overloaded system is queued instead of running and potentially crashing due to lack of resources, like memory. ...
 Topic: Caught ORCHESTRATE exception error
qt_ky

Replies: 3
Views: 772

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 13, 2017 7:06 am   Subject: Caught ORCHESTRATE exception error
Never encountered it myself. I recommend contacting Support.
 Topic: division into jobs
qt_ky

Replies: 4
Views: 89

PostForum: General   Posted: Fri Oct 13, 2017 7:01 am   Subject: division into jobs
My personal preference generally is to use separate jobs for the sake of restartability. When something goes wrong and some jobs complete but another job aborts, then it can be easier and faster to tr ...
 Topic: While loading into db2 thru ds,Uncommitted data is readable?
qt_ky

Replies: 3
Views: 134

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 13, 2017 6:48 am   Subject: While loading into db2 thru ds,Uncommitted data is readable?
1. The Read uncommitted isolation level description confirms that "other transactions can still read but not modify the uncommitted changes."

2. The Cursor stability isolation level description con ...
 Topic: Read complex structured (segment) type table
qt_ky

Replies: 4
Views: 150

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 12, 2017 3:00 pm   Subject: Read complex structured (segment) type table
Have you tried using the Oracle Connector stage with a user-defined SQL select statement?
 Topic: Losing the null value
qt_ky

Replies: 8
Views: 278

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 12, 2017 7:57 am   Subject: Losing the null value
Correct. It appears that stage variable re-use normally works unless the NULL value is involved.

I am on UNIX for what it may be worth. What I see from a test job in v11.3 and v11.5 is that the sta ...
 Topic: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
qt_ky

Replies: 37
Views: 2601

PostForum: General   Posted: Thu Oct 12, 2017 7:34 am   Subject: Lengthy start up time for 90% of datastage jobs in 11.5.0.2
As indicated by Craig's Knowledge Center link, lowering the pd_npages setting can help performance related to real-time applications that delete files. Here is what command help says about the same se ...
 Topic: Losing the null value
qt_ky

Replies: 8
Views: 278

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 11, 2017 8:02 am   Subject: Losing the null value
Is your svcol22 stage variable self-referencing?

I got similar results on version 11.5 test job using a row generator with 10 rows but never got any warning messages. I used similar logic with a se ...
 Topic: Increase IGC Term Short Description limit
qt_ky

Replies: 3
Views: 124

PostForum: MetaData and IBM MetaData Workbench   Posted: Wed Oct 11, 2017 6:24 am   Subject: Increase IGC Term Short Description limit
Good point! Wink

Thanks for the replies.
 

 Jump to:   



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