DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2504 matches
Author Message
 Topic: Connector Migration Tool
qt_ky

Replies: 2
Views: 65

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 26, 2017 7:12 am   Subject: Connector Migration Tool
It looks like the doc is trying to say:

1) IF your jobs contain certain old stage types that have been removed from 11.5, THEN you must run the tool against the older version's project.

2) The t ...
 Topic: How to find when the DataStage Project was last used
qt_ky

Replies: 2
Views: 63

PostForum: General   Posted: Fri Apr 21, 2017 6:59 am   Subject: How to find when the DataStage Project was last used
Remove everyone's project access then wait. Wink
Resolved
 Topic: REST Response Contains Slash Appended to All Elements
qt_ky

Replies: 10
Views: 257

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Tue Apr 18, 2017 9:35 am   Subject: REST Response Contains Slash Appended to All Elements
I'm on version 11.3.1.2 using REST 2.0. It is a bit cumbersome to have to manually piece together the URL. Glad you discovered the resolution!
 Topic: Rebuiding DataStage job from the DataStage Project folder
qt_ky

Replies: 5
Views: 99

PostForum: General   Posted: Tue Apr 18, 2017 9:31 am   Subject: Rebuiding DataStage job from the DataStage Project folder
I doubt it, but I don't know. The "syncproject" script might be worth a try. Search on it.
Resolved
 Topic: REST Response Contains Slash Appended to All Elements
qt_ky

Replies: 10
Views: 257

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Mon Apr 17, 2017 7:37 am   Subject: REST Response Contains Slash Appended to All Elements
Sounds like the folder stage might be causing it. Try a simpler test job: ISD Input --> Transformer --> ISD Output.
 Topic: Etl logic
qt_ky

Replies: 5
Views: 157

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 17, 2017 7:34 am   Subject: Etl logic
How do you know which description is correct?
Resolved
 Topic: REST Response Contains Slash Appended to All Elements
qt_ky

Replies: 10
Views: 257

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Mon Apr 17, 2017 7:30 am   Subject: REST Response Contains Slash Appended to All Elements
I do not think that is normal. I have a few REST & JSON ISD applications running with the ISD Output stage. When I test them via the URL with a web browser, I do not see any escaped characters in ...
 Topic: Teradata Connector Bulk Load Issue
qt_ky

Replies: 5
Views: 215

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 12, 2017 6:52 am   Subject: Teradata Connector Bulk Load Issue
Try job 1 Oracle to Data Set and job 2 Data Set to Teradata with bulk load.
Resolved
 Topic: Execute Command activity Orchadmin dump single value output
qt_ky

Replies: 3
Views: 124

PostForum: General   Posted: Fri Apr 07, 2017 6:23 am   Subject: Execute Command activity Orchadmin dump single value output
To suppress the noise, redirect standard error to /dev/null so that you are left with only the standard output.

$APT_ORCHHOME/bin/orchadmin dump /.../.../xx.ds 2>/dev/null

Here is a page abou ...
Workaround Reported
 Topic: How to remove items from IGC published catalog
qt_ky

Replies: 3
Views: 229

PostForum: MetaData and IBM MetaData Workbench   Posted: Wed Apr 05, 2017 8:23 am   Subject: How to remove items from IGC published catalog
Thank you for your responses.

Well, I am somewhat surprised there is no quick and easy path. I do need to leave workflow enabled and do not want to lose history.

"Mark for deletion" upon publish ...
Resolved
 Topic: Execute Command activity Orchadmin dump single value output
qt_ky

Replies: 3
Views: 124

PostForum: General   Posted: Wed Apr 05, 2017 6:07 am   Subject: Execute Command activity Orchadmin dump single value output
What kind of value are you expecting the orchadmin dump to return? Have you tried using the grep command on the output?
Workaround Reported
 Topic: How to remove items from IGC published catalog
qt_ky

Replies: 3
Views: 229

PostForum: MetaData and IBM MetaData Workbench   Posted: Fri Mar 31, 2017 11:58 am   Subject: How to remove items from IGC published catalog
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.3.1.2
We have a couple of categories containing 70+ terms, all of which need to be removed from the catalog, retained, and put back into draft mode for future revisions. The revisions would not be made in t ...
 Topic: Run GROOM using Netezza DataStage connector
qt_ky

Replies: 1
Views: 151

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Mar 30, 2017 6:49 am   Subject: Run GROOM using Netezza DataStage connector
I have run into similar errors with DB2, in that the before/after SQL of the connector stage is really only expecting standard SQL statements and blows up on any database-specific commands that aren't ...
 Topic: Detect Datastage Server is healthy
qt_ky

Replies: 1
Views: 93

PostForum: General   Posted: Thu Mar 30, 2017 6:42 am   Subject: Detect Datastage Server is healthy
There are a number of processes. Go to the Launchpad web page and open the Operations Console. It has a dashboard that is great for monitoring the server health. It also lists several important server ...
Resolved
 Topic: Finding out XMETA database type
qt_ky

Replies: 4
Views: 174

PostForum: General   Posted: Thu Mar 30, 2017 6:40 am   Subject: Finding out XMETA database type
Look on your server under the install path, /opt/IBM/Information Server, or similar path depending on your installation.

Find the files Version.xml or response.txt. Run grep -i on either file with ...
 

 Jump to:   



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