DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 504 matches
Author Message
 Topic: Two Source Match Stage, long running job and fails at last
rkashyap

Replies: 4
Views: 115

PostForum: IBM QualityStage   Posted: Fri Feb 16, 2018 10:21 am   Subject: Two Source Match Stage, long running job and fails at last
Is the job using bounded length varchars in the data? If yes, then setting the [url=https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvr ...
Resolved
 Topic: RCP not working for Salesforce Server Package stage
rkashyap

Replies: 6
Views: 2816

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 16, 2018 10:08 am   Subject: RCP not working for Salesforce Server Package stage
SFDC stage (still) does not supports RCP. You may submit a [url=https://www.ibm.com/developerworks/rfe]Request for Enhancement for this.
Workaround Reported
 Topic: Multiple records based on value in column
rkashyap

Replies: 9
Views: 151

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Feb 16, 2018 9:57 am   Subject: Multiple records based on value in column
Another option could be leveraging Unix ... invoke following command in either External Source stage or using Filter option of Sequential file stage
awk 'BEGIN {FS="|";RS="\n" ...
 Topic: Webinar vNext
rkashyap

Replies: 8
Views: 479

PostForum: General   Posted: Tue Dec 19, 2017 8:09 am   Subject: Re: Webinar vNext
Eric, Thanks.

Does anyone have any updates on when the next version of Information Server will be released?
Per [url=https://www-01.ibm.com/common/ssi/rep_ca/7/649/ENUSA17-0877/ENUSA17-0877.PDF]IB ...
 Topic: Webinar vNext
rkashyap

Replies: 8
Views: 479

PostForum: General   Posted: Thu Dec 14, 2017 5:15 pm   Subject: Webinar vNext
There will also be another webinar next Tuesday. Are you getting the email invitations?
How did you signup for the webinar?
Resolved
 Topic: Balanced Optimizer missing / unavailable
rkashyap

Replies: 11
Views: 1105

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 14, 2017 4:30 pm   Subject: Balanced Optimizer missing / unavailable
Post initial installation, Balanced optimization can be <IS_install_path>/ASBServer/iisAdmin.sh -set -key com.ibm.iis.datastage.license.feature.BAL_OPT -value 1
Workaround Reported
 Topic: Detecting IBM's kinit failure
rkashyap

Replies: 2
Views: 585

PostForum: General   Posted: Fri Sep 29, 2017 2:51 pm   Subject: Detecting IBM's kinit failure
Thank you. IBM's kinit gives RC of "0" with bad syntax also, though default kinit works ok ...
$ /opt/IBM/InformationServer/jdk/jre/bin/kinit -~ oij
com.ibm.security.krb5.KrbException, status code& ...
Workaround Reported
 Topic: Detecting IBM's kinit failure
rkashyap

Replies: 2
Views: 585

PostForum: General   Posted: Fri Sep 29, 2017 9:31 am   Subject: Detecting IBM's kinit failure
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication
IBM's latest JDK is installed on DataStage server.

IBM's kinit is being used to generate kerberos ticket. This command generates a ticket for a limited time period and subsequently it needs to be r ...
 Topic: Reading Double quotes in CSV file
rkashyap

Replies: 7
Views: 1180

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 08, 2017 2:08 pm   Subject: Re: Reading Double quotes in CSV file
I have tried reading using sequential file stage(Delimited as comma and Quotes as None), its not able to read 4 column.
Craig, You have a point about embedded double quotes ... though with solution m ...
 Topic: Reading Double quotes in CSV file
rkashyap

Replies: 7
Views: 1180

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 08, 2017 12:48 pm   Subject: Reading Double quotes in CSV file
You can leverage Unix's capabilities to meet this requirement as given below:

In Seq file stage's properties1. Set value of FILTER tonawk -F\" 'BEGIN{OFS=FS;} {for(i=1;i< ...
Resolved
 Topic: List of jobs uses a specific parameter
rkashyap

Replies: 4
Views: 898

PostForum: General   Posted: Fri Sep 08, 2017 7:53 am   Subject: List of jobs uses a specific parameter
If you are using Operations Console, then following query will give desired results ...
SELECT distinct X.ProjectName, X.FOLDERPATH, X.JobName, P.PARAMNAME, P.PARAMVALUE
FROM DSODB.JOBRUN R ...
 Topic: YTD BASED ON THE MONTH NUMBER
rkashyap

Replies: 7
Views: 1374

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 30, 2017 7:02 am   Subject: YTD BASED ON THE MONTH NUMBER
This can be achieved by use of transformer stage variables:

Note: In the job, either run Sort and Transformer stages in Sequential mode or hash by FsclYr.

1. Sort incoming data by FsclYr, MthNum ...
Resolved
 Topic: Connecting to Hadoop from FileConnector
rkashyap

Replies: 3
Views: 1370

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 29, 2017 10:50 am   Subject: Connecting to Hadoop from FileConnector
Thank you. Failure was due to convergence of two issues:
1. Bad Keytab. Cloudera admin recreated the keytab file for this.

2. Kerberos ticket was generated using knit from "/usr/sbin/". Ticket had ...
 Topic: LookUp Stage with just REJECT link
rkashyap

Replies: 3
Views: 1106

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 29, 2017 10:38 am   Subject: LookUp Stage with just REJECT link
Please see response below preceded by "=>".

Is it normal that lookup does not support only the reject link ?
=> Yes.

May be in that case, is it better i write the sql query in the oracle ...
Resolved
 Topic: Connecting to Hadoop from FileConnector
rkashyap

Replies: 3
Views: 1370

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Aug 12, 2017 3:17 pm   Subject: Connecting to Hadoop from FileConnector
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication
DataStage 11.501; Patches applied: Datadirect JDBC Driver for Hive(JR56156) and Hive Connector(JR56097).

We are trying to use File Connector stage for connecting to Cloudera Hadoop server. Connecti ...
 

 Jump to:   



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