DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 75 matches
Author Message
 Topic: AVI-REST Service
dj

Replies: 1
Views: 534

PostForum: IBM QualityStage   Posted: Thu Jul 20, 2017 8:57 am   Subject: AVI-REST Service
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

We are working on a RealTime Service which calls the AVI stage.

Are there any better ways to increase the response from QS end.

Internally, how does AVI stage parses the files ? Does it p ...
 Topic: ISD Jobs to Finished status
dj

Replies: 2
Views: 715

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Wed Jul 19, 2017 8:36 am   Subject: ISD Jobs to Finished status
Thanks for your reply.

It brings the system down ,that's the issue. It try to creates 100+instances immediately and we have got 3 jobs doing the same.

This test box server is limited here and it ...
 Topic: ISD Jobs to Finished status
dj

Replies: 2
Views: 715

PostForum: IBM® SOA Editions (Formerly RTI Services)   Posted: Wed Jul 19, 2017 7:09 am   Subject: ISD Jobs to Finished status
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

When we deploy the Service,one of the ISD jobs goes to finished status and then it tries to invokes a new instance which again goes to finished status and it iterates the same for multiple ...
 Topic: MDM Initial BIL Jobs
dj

Replies: 0
Views: 996

PostForum: Infosphere Master Data Management   Posted: Thu May 11, 2017 4:38 am   Subject: MDM Initial BIL Jobs
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We were looking at the multiple options for MDM initial load and came across BIL method using datastage.

https://www.ibm.com/support/knowledgecenter/SSWSR9_11.6.0/com.ibm.mdmhs.bil_insta ...
 Topic: AVI Country Validation
dj

Replies: 4
Views: 3206

PostForum: IBM QualityStage   Posted: Wed Nov 23, 2016 8:44 am   Subject: AVI Country Validation
Thanks for your replies.

yes , we are passing street1,street2,city,country,postalcode as separate fields to AVI.

Does AVI do not determine the country code from Reference files based on the inpu ...
 Topic: AVI Country Validation
dj

Replies: 4
Views: 3206

PostForum: IBM QualityStage   Posted: Mon Nov 21, 2016 6:57 am   Subject: AVI Country Validation
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

The country field when passed and AVI -country when selected Output ISO and Country fields behaves differently.

Eg:

Case :1
For a USA record when passed to AVI[USA country selecte ...
 Topic: Chinese Char /UTF-8
dj

Replies: 6
Views: 1948

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 07, 2016 7:50 am   Subject: Chinese Char /UTF-8
Thanks for your replies.

Are there any other issues apart from bytes space b/w UTF-8 /UTF-16?

1) We were able to use UTF-8 for thai and china - both seq file as i/p and o/p.

2) Is there a way ...
 Topic: Chinese Char /UTF-8
dj

Replies: 6
Views: 1948

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 26, 2016 3:35 am   Subject: Chinese Char /UTF-8
I'm looking at the various options of handling the chinese/Thai data.

To get started,selected UTF-8 as it handles multi-byte data.

1)Is it still UTF-8,unicode will not be handle double byte dat ...
 Topic: Chinese Char /UTF-8
dj

Replies: 6
Views: 1948

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 20, 2016 7:59 am   Subject: Chinese Char /UTF-8
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I'm trying to read Chinese file and it fails when CHAR and for VARCHAR it works.

The existing other regions have CHAR and we are trying to minimize the changes in the layout.

The layout i ...
Resolved
 Topic: QS webservice jobs compilation issue
dj

Replies: 7
Views: 2156

PostForum: IBM QualityStage   Posted: Tue Aug 30, 2016 8:28 am   Subject: QS webservice jobs compilation issue
we are working with PMR team to figure out why ther server went down.

After clearing up the tmp and logs files, imported the dsx again and the jobs got compiled.

Thanks.
Resolved
 Topic: QS webservice jobs compilation issue
dj

Replies: 7
Views: 2156

PostForum: IBM QualityStage   Posted: Mon Aug 29, 2016 7:49 am   Subject: QS webservice jobs compilation issue
Thanks for the details.

In addition to the status file overflowed, for the ISD jobs we could also see the /tmp folder getting full.

What are these files? Are there any harm in removing these fil ...
Resolved
 Topic: QS webservice jobs compilation issue
dj

Replies: 7
Views: 2156

PostForum: IBM QualityStage   Posted: Fri Aug 26, 2016 8:25 am   Subject: QS webservice jobs compilation issue
thanks for the replies.

After trying to view the RT Log files which caused the issue, icould only find the below error in all the jobs.

Fatal Error: waitForWriteSignal(): Prematu ...
Resolved
 Topic: QS webservice jobs compilation issue
dj

Replies: 7
Views: 2156

PostForum: IBM QualityStage   Posted: Thu Aug 25, 2016 11:54 am   Subject: QS webservice jobs compilation issue
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

Few of the web service enabled quality jobs which were running fine earlier aborted.
And the compilation failed with below error

> ISD_Address_Standardization - Failed <<
Failed ...
 Topic: Dynamic arrays/or pivot
dj

Replies: 4
Views: 824

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 24, 2016 9:41 am   Subject: Dynamic arrays/or pivot
Thanks for the details.

The column names "name" and "address" are the file field names.File1_name and File2_name.

For the comparision part, even after using column export how to get the fieldnam ...
 Topic: Dynamic arrays/or pivot
dj

Replies: 4
Views: 824

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 22, 2016 1:21 pm   Subject: Dynamic arrays/or pivot
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: for validation reports
Hi All,
We have got requirement to compare 2 datasets and generate reports for the mismatches/ detail records and counts.

And also we are trying to keep it generic for any file metadata.(to enable ...
 

 Jump to:   



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