DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 17 matches
Author Message
Resolved
 Topic: Error in Using File Connector stage
TNZL_BI

Replies: 9
Views: 1086

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 23, 2017 10:46 pm   Subject: Error in Using File Connector stage
Hey All,

I am trying to use the File Connector Stage to put a file on HDFS. I am getting the following issue when I write a file on HDFS

File_Connector_35,0: An exception occurred: java.lang.Exc ...
 Topic: connection issues between hive and datastage 11.3.1
TNZL_BI

Replies: 1
Views: 657

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 23, 2017 3:28 pm   Subject: connection issues between hive and datastage 11.3.1
Yes it is and we have just managed a connection to the Hive database using the ODBC stage and Hive Connector
 Topic: File Connector stage :-Java related errors
TNZL_BI

Replies: 2
Views: 60

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 23, 2017 3:23 pm   Subject: File Connector stage :-Java related errors
Thanks Chulett .

That's what I am also thinking but not sure where to do that from. I checked on the net and on some places it is mentioned to perhaps log on to the websphere and make changes to th ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
TNZL_BI

Replies: 3
Views: 160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 23, 2017 5:02 am   Subject: Hive Connector Stage and isjdbc.config file set up
Hi Chulett

Thanks for your response. This issue is now fixed . I contacted the Hadoop administration team and realized there was some patching activity because of which this issue was cropping.

...
 Topic: File Connector stage :-Java related errors
TNZL_BI

Replies: 2
Views: 60

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 23, 2017 4:00 am   Subject: File Connector stage :-Java related errors
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All ,

I am using a File Connector stage to write to the HDFS ecosystem. I have used the HttpFS method to connect to the HDFS ecosystem. However when I run the Job I am getting a time out error. ...
 Topic: Hadoop Connectivity BDFS : Path of libhdfs.so in datastage
TNZL_BI

Replies: 0
Views: 89

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 9:37 pm   Subject: Hadoop Connectivity BDFS : Path of libhdfs.so in datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I am in the process of using the BDFS to connect to Hadoop . I have gone through the steps and there is one step that states the following

To use the Big Data File stage, you must ensure ...
 Topic: Hive Connector Vs ODBC Connector
TNZL_BI

Replies: 0
Views: 95

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 10, 2017 10:43 pm   Subject: Hive Connector Vs ODBC Connector
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All ,

I have recently developed a job to connect to the Hive database in the Hadoop Ecosystem. Now I have used two methods to connect to the Hive database which are :-

1. ODBC Connector
2. ...
 Topic: Loading data from HDFS file into HIVE table using Datastage
TNZL_BI

Replies: 3
Views: 877

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 10, 2017 6:22 pm   Subject: Loading data from HDFS file into HIVE table using Datastage
Hi , I have been facing a similar issue. I am using the Hive Connector Stage to load / extract data .

However , the speed is dismal . Is there something that we can do to improve the performance of ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
TNZL_BI

Replies: 3
Views: 160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 09, 2017 8:13 pm   Subject: Re: Hive Connector Stage and isjdbc.config file set up
Hi All ,

I have finally managed to connect using the hive connector . I managed to locate the jar file for Hive which was the ISHive.jar file under the ASBNode/lib directory in datastage.

The c ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
TNZL_BI

Replies: 3
Views: 160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Apr 07, 2017 3:30 pm   Subject: Hive Connector Stage and isjdbc.config file set up
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We have recently connected to the Hive database from DataStage using the ODBC Connector Stage. However we are having issues when we are trying to use the Hive Connector stage. I am not exac ...
Workaround Reported
 Topic: SQL Server Data Pull with "dot" in database name
TNZL_BI

Replies: 2
Views: 453

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 11, 2016 3:59 pm   Subject: SQL Server Data Pull with "dot" in database name
Thanks for your suggestion. Our DBA has helped us in creating new database instance and he is populating required tables using a stored proc from orignal database having "dot" in its name.

So this ...
Workaround Reported
 Topic: SQL Server Data Pull with "dot" in database name
TNZL_BI

Replies: 2
Views: 453

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Apr 08, 2016 3:12 pm   Subject: SQL Server Data Pull with "dot" in database name
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi All,
We are on datastage v9.1 and trying to pull data from SQL Server. Connectivity has been established successfully via .odbc.ini and uvconfig.

Target SQL server is hosting five different dat ...
 Topic: Information Server Web Console displaying "<" c
TNZL_BI

Replies: 5
Views: 588

PostForum: General   Posted: Tue Mar 22, 2016 6:47 pm   Subject: Information Server Web Console displaying "<" c
Thanks so far for reponses
We are running IE V.8.07601
Major point I forgot to mention is the Win 2003 server jump host where the IBM clients are installed has access to production and staging dat ...
 Topic: Information Server Web Console displaying "<" c
TNZL_BI

Replies: 5
Views: 588

PostForum: General   Posted: Sun Mar 20, 2016 6:25 pm   Subject: Information Server Web Console displaying "<" c
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Job Type: N/A
OS: Windows 2003 Server : Datastage Clients
OS: Datastage Redhat Enterprise Linux server 5.4

I am getting an error when using these two pages of Web Console .
Other pages are ...
 Topic: Job Searching Facility
TNZL_BI

Replies: 7
Views: 1807

PostForum: General   Posted: Wed Jan 15, 2014 4:49 am   Subject: Can we make this search Case insensitive
Hi all,,, we have used the above routine however we would like to make this case insensitive. Is it possible to change this code slightly ???
 

 Jump to:   



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