DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 498 matches
Author Message
Workaround Reported
 Topic: Detecting IBM's kinit failure
rkashyap

Replies: 2
Views: 120

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: 120

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: 485

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: 485

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: 313

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: 461

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: 548

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: 465

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: 548

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 ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
rkashyap

Replies: 4
Views: 874

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 09, 2017 8:39 am   Subject: Hive Connector Stage and isjdbc.config file set up
The new problem now is that the performance of the Hive connector stage is pathetic. Opened a case with IBM.. will give all the details if I hear anything positive
What did IBM suggest? Did it help?
 Topic: Azure SQL connectivity from DataStage.
rkashyap

Replies: 1
Views: 506

PostForum: General   Posted: Sat Apr 29, 2017 12:52 pm   Subject: Azure SQL connectivity from DataStage.
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: IIS 11.5 fp1 on RHEL 7; XMETA DB2; LDAP authentication.
Connection to Azure SQL database from DataStage using JDBC with following connection string works ok:jdbc:ibm:sqlserver://azrdevstore.database.windows.net:1433;database=AZR_DEV;Encrypt ...
 Topic: AIX vs Linux DataStage performance
rkashyap

Replies: 4
Views: 674

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 27, 2017 5:28 pm   Subject: AIX vs Linux DataStage performance
Another criteria to think about is availability of features and support.

There are variations in DataStage features based on operating system e.g. BDFS was initially launched only for linux and ab ...
Workaround Reported
 Topic: SFDC sparse lookup with upstream Transformer.
rkashyap

Replies: 2
Views: 642

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Apr 22, 2017 7:06 am   Subject: SFDC sparse lookup with upstream Transformer.
IBM has informed us ... We should prioritize the patch JR47138 implementation based on the work effort since its not a simple fix and might need some design changes so, it might be considered for the ...
Resolved
 Topic: Duration for installation of IS11.5
rkashyap

Replies: 6
Views: 622

PostForum: General   Posted: Sat Apr 22, 2017 6:21 am   Subject: Re: Duration for installation of IS11.5
I meant the duration of the installation of entire IS with most pre-requisites are taken care (though there seems to be a lot)
Installation/configuration of DataStage involves four steps.
1. Instal ...
Resolved
 Topic: Duration for installation of IS11.5
rkashyap

Replies: 6
Views: 622

PostForum: General   Posted: Thu Apr 20, 2017 7:43 am   Subject: Re: Duration for installation of IS11.5
What will be the topology?

By installation do you mean length of the entire projects or simply installation of software (after all the prerequisites are done)?
 

 Jump to:   



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