DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 92 matches
Author Message
 Topic: Writing to Hadoop using Datastage 11.5.2 Parallel Hive
skathaitrooney

Replies: 5
Views: 165

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 22, 2018 6:31 am   Subject: Writing to Hadoop using Datastage 11.5.2 Parallel Hive
Andy, can i ask you a question, are you able to connect to Hive Server2 using ISHive.jar that is shipped with IIS itself?

I also have a kerberos setup. I get this error.
java.sql.SQLException: jd ...
 Topic: Database Credentials
skathaitrooney

Replies: 2
Views: 26

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jun 22, 2018 6:26 am   Subject: Database Credentials
Yeah i also think that you need to import the metadata from your source database via IMAM first. The connection that you specify in IMAM would be used to fetch the data from the source database

And ...
 Topic: Hive Connector to Hortonworks error
skathaitrooney

Replies: 3
Views: 661

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 13, 2018 1:37 am   Subject: Hive Connector to Hortonworks error
Did you manage to solve this problem ?
Resolved
 Topic: istools does not recognise -informationanalyzer option
skathaitrooney

Replies: 11
Views: 2322

PostForum: General   Posted: Wed May 23, 2018 8:20 am   Subject: istools does not recognise -informationanalyzer option
Ok i got it working.

Some jar files under istools/cli/plugins directory related to ia had permission problems. dsadm did not have read and execute permissions on them. I re-configured the permissio ...
Resolved
 Topic: XMETA table OMDMODEL_JOBPARAMETER
skathaitrooney

Replies: 14
Views: 2342

PostForum: General   Posted: Thu Apr 05, 2018 4:57 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Thanks a lot.


I got the same guidelines from Support, we are already on 11.5. The command works like a charm. All OMD cleaned for me. XMETA size dropped from 60 GB to mere 17 GB.
 Topic: Grid APT configuration file
skathaitrooney

Replies: 7
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 04, 2018 6:30 am   Subject: Grid APT configuration file
And that is why they call Paul the DS Guru Smile
Resolved
 Topic: XMETA table OMDMODEL_JOBPARAMETER
skathaitrooney

Replies: 14
Views: 2342

PostForum: General   Posted: Fri Mar 30, 2018 3:26 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Can i ask you which script did you run. Did you manage to purge the OperationalMetadata all at once somehow, xmetaAdmin ? I am really interested in the manual purge process
 Topic: Grid APT configuration file
skathaitrooney

Replies: 7
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 30, 2018 3:08 am   Subject: Grid APT configuration file
If LSF dynamically generates the config file (APT_GRID_ENABLE=YES) then APT_CONFIG_FILE variable is of no use. It is only used when config files are not dynamically generated.

To find out which con ...
 Topic: Metadata Asset Manager - Out of Memory
skathaitrooney

Replies: 0
Views: 305

PostForum: General   Posted: Fri Feb 16, 2018 3:02 am   Subject: Metadata Asset Manager - Out of Memory
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello Experts,

I have this question for a while now, i have not been able to find the answer myself through various sources, hence posting it here with some hope.

How much heap space is really n ...
 Topic: IGC Job design Lineage
skathaitrooney

Replies: 1
Views: 645

PostForum: MetaData and IBM MetaData Workbench   Posted: Fri Jan 19, 2018 7:01 am   Subject: IGC Job design Lineage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello Experts,

Wondering if i can get an insight from the IGC gurus.

I am trying to build lineage for datastage jobs in IGC.
I know i have to upload the environment variables (ProcessEnvVariab ...
Resolved
 Topic: Client requested protocol TLSv1 not enabled or not supported
skathaitrooney

Replies: 9
Views: 1547

PostForum: General   Posted: Thu Nov 23, 2017 2:47 am   Subject: Client requested protocol TLSv1 not enabled or not supported
I performed all the steps mentioned n the IBM tech-note and in the Hierarchial stage passed these Optional Arguments
-Dcom.ibm.jsse2.overrideDefaultTLS=true -Dcom.ibm.jsse2.overrideDefaultProtocol=TL ...
Resolved
 Topic: Hive Connector Stage and isjdbc.config file set up
skathaitrooney

Replies: 5
Views: 2133

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 22, 2017 5:09 am   Subject: Hive Connector Stage and isjdbc.config file set up
Hi TNZL_BI , one qusetion.
Since you are using the driver supplied by IBM (IShive.jar), are you sure the CLASS_NAMES=org.apache.hadoop.hive.jdbc.HiveDriver
and not com.ibm.isf.jdbc.hive.HiveDriver ...
Resolved
 Topic: Client requested protocol TLSv1 not enabled or not supported
skathaitrooney

Replies: 9
Views: 1547

PostForum: General   Posted: Thu Nov 16, 2017 4:26 am   Subject: Client requested protocol TLSv1 not enabled or not supported
Did you manage to resolve it ?
 Topic: You are not authorized to login.You need the Suite User role
skathaitrooney

Replies: 2
Views: 658

PostForum: General   Posted: Wed Nov 08, 2017 4:38 am   Subject: You are not authorized to login.You need the Suite User role
Ray, in the screenshot the dsadm user has both SuiteUser and SuiteAdmin roles.

I have had the same issue once with IIS11.5.

What i did was switch it back to internal registry and re-configure L ...
 Topic: Datastage Job logs for Today's/Yesterday's run
skathaitrooney

Replies: 5
Views: 820

PostForum: General   Posted: Wed Nov 08, 2017 3:33 am   Subject: Datastage Job logs for Today's/Yesterday's run
For DSODB connection information, give your DataStage admins a visit

How to use DSODB:
https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.monitor.doc/topics/queryod ...
 

 Jump to:   



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