DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2778 matches
Author Message
 Topic: Save Scripts
qt_ky

Replies: 2
Views: 25

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jun 22, 2018 5:52 am   Subject: Save Scripts
Is has not changed that I know of. The setting is working the same for us on 11.7 as it did on 8.x, 11.3, and 11.5. I can see over 100 job logs in Director 11.7 in the default IA project. Is the analy ...
 Topic: Database Credentials
qt_ky

Replies: 2
Views: 34

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jun 22, 2018 5:31 am   Subject: Database Credentials
Have you tried following the steps to import the metadata using IMAM? It seems like in 11.3 and 11.5 you had to open up IMAM and start with creating a database connection there.
 Topic: DataStage application is running too slow
qt_ky

Replies: 8
Views: 112

PostForum: General   Posted: Fri Jun 22, 2018 5:08 am   Subject: DataStage application is running too slow
Restarting the server is rarely a good solution. I would call that the "Windows way" and try to avoid the practice, unless there is some known issue that cannot be resolved...

In case you don't kno ...
 Topic: Multiple Input links and Performance
qt_ky

Replies: 2
Views: 100

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 21, 2018 5:52 am   Subject: Multiple Input links and Performance
I personally do not know the answer but I suspect that it would not matter one way or the other. You initial tests show inconsistent results which probably just indicates the common real-world scenari ...
 Topic: DataStage application is running too slow
qt_ky

Replies: 8
Views: 112

PostForum: General   Posted: Thu Jun 21, 2018 5:39 am   Subject: DataStage application is running too slow
Can you narrow down the problem to say more specifically what is running too slow? Is it Server jobs or Parallel jobs? Is it all jobs or just a subset of jobs that read from a particular database, etc ...
 Topic: Heap growth during runLocally()and production run time debug
qt_ky

Replies: 4
Views: 139

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 21, 2018 5:09 am   Subject: Heap growth during runLocally()and production run time debug
If I had a 60 minute window and the job was taking only 5 to 10 minutes, then I may take a quick glance at tuning then quickly move on.

What jumps out to me is that t he job startup times look pret ...
 Topic: Datastage Repository interface errror
qt_ky

Replies: 2
Views: 46

PostForum: General   Posted: Thu Jun 21, 2018 5:01 am   Subject: Datastage Repository interface errror
Upgrade to a version that has the workload manager (WLM) built in. It will protect your engine from overload when someone attempts to start 35 jobs at the same time. Various threshold settings are ava ...
 Topic: Read xml datatype sql server, ODBC connector from datastage
qt_ky

Replies: 5
Views: 81

PostForum: General   Posted: Tue Jun 19, 2018 5:42 am   Subject: Read xml datatype sql server, ODBC connector from datastage
I haven't tried it using DataStage but have had to query a SQL Server column that was named XML and stored XML but I do not recall the data type. It may have been TEXT or a string rather than the XML ...
 Topic: Duplicate Key values in CDC Stage
qt_ky

Replies: 7
Views: 321

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 15, 2018 5:33 am   Subject: Duplicate Key values in CDC Stage
Yes, the Change Capture stage performs change data detection, but watch out... because "CDD" is another IBM product acronym for Change Data Delivery! Shocked
Resolved
 Topic: What's new in 11.7 Fix Pack 1
qt_ky

Replies: 3
Views: 104

PostForum: General   Posted: Fri Jun 15, 2018 5:24 am   Subject: What's new in 11.7 Fix Pack 1
Thank you Vincent for sharing your healthy perspective and Craig for being the ever loyal supporting fan! You might need to get yourself one of those new IBM Cloud accounts to check out all these new ...
 Topic: Duplicate Key values in CDC Stage
qt_ky

Replies: 7
Views: 321

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 14, 2018 5:07 am   Subject: Duplicate Key values in CDC Stage
I agree. It is a common misnomer. Clearly, the Change Capture stage would be abbreviated CC. CDC is different.
Resolved
 Topic: What's new in 11.7 Fix Pack 1
qt_ky

Replies: 3
Views: 104

PostForum: General   Posted: Wed Jun 13, 2018 6:33 am   Subject: What's new in 11.7 Fix Pack 1
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
11.7 Fix Pack 1 is available to download.

Link: [url=http://www-01.ibm.com/support/docview.wss?uid=swg22009615]What's new in 11.7 Fix Pack 1

There are many new features listed by product, includ ...
 Topic: CDC stage in Datastage 11.7
qt_ky

Replies: 10
Views: 894

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 13, 2018 5:31 am   Subject: CDC stage in Datastage 11.7
Correct.

See also: [url=https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.conn.cdc.doc/topics/c_cdc_container.html]IBM InfoSphere Change Data Capture
 Topic: ISD / REST service results limited
qt_ky

Replies: 4
Views: 187

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Jun 12, 2018 8:42 am   Subject: ISD / REST service results limited
Also, if you want to help protect your ISD app and the size of the load on the network, then you can add your own logic into the job design. We did this on a few jobs that were similar in design to wh ...
 Topic: ISD / REST service results limited
qt_ky

Replies: 4
Views: 187

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Jun 12, 2018 8:33 am   Subject: ISD / REST service results limited
The pagination described sounds like it is unwanted behavior. Perhaps it is a defect. I have not run into that myself.

I did run into large requests and results getting truncated back on version 8. ...
 

 Jump to:   



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