DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 2554 matches
Author Message
 Topic: Oracle connector Import Issue
qt_ky

Replies: 1
Views: 35

PostForum: General   Posted: Mon Aug 21, 2017 5:49 am   Subject: Oracle connector Import Issue
See if this helps.

http://www.dsxchange.com/viewtopic.php?t=156190

http://www-01.ibm.com/support/docview.wss?uid=swg1JR49320
 Topic: how to find ODPP libraries to add to LIBPATH in 11.3
qt_ky

Replies: 2
Views: 769

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 17, 2017 8:58 pm   Subject: how to find ODPP libraries to add to LIBPATH in 11.3
I am curious if anyone has ever got this working on any release? We are feeling as if we are the first ones to try...

We have had a PMR open about configuring the Optim Data Privacy Providers on In ...
 Topic: right tool(s) for data classification request
qt_ky

Replies: 5
Views: 106

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Aug 17, 2017 5:40 pm   Subject: right tool(s) for data classification request
It is an IA question right now because "data classification / find PII" is an IA feature that the customer is quite excited about.

Yes, it may be similar to a UNIX security scan function although I ...
 Topic: right tool(s) for data classification request
qt_ky

Replies: 5
Views: 106

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Aug 17, 2017 12:43 pm   Subject: right tool(s) for data classification request
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
We are already licensed for IA and use it for traditional data profiling against relational databases. Recently some interesting questions have arisen.

A customer needs to crawl a large number of s ...
Resolved
 Topic: Match Designer match pass run process failed
qt_ky

Replies: 2
Views: 91

PostForum: IBM QualityStage   Posted: Wed Aug 16, 2017 7:30 am   Subject: Match Designer match pass run process failed
DB2 error given with reason code 10: Invalid data length for output variable. (not sure what it means).

It also looks like it failed to write something to disk. Any chance you are short on disk spa ...
 Topic: Oracle Connector from sequential to partition read fails
qt_ky

Replies: 6
Views: 253

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 15, 2017 2:29 pm   Subject: Oracle Connector from sequential to partition read fails
This is just a guess, but is your number_key column nullable? It would appear from the error message that it fetched a NULL value, which perhaps it would have choked on while performing the modulus fu ...
 Topic: Run-time error '5' Invalid procedure call or argument
qt_ky

Replies: 4
Views: 146

PostForum: General   Posted: Tue Aug 15, 2017 2:11 pm   Subject: Run-time error '5' Invalid procedure call or argument
Check this out.

Run-time error '5' ocurred while trying to connect to a specific DataStage project via Designer and Director clients.
http://www-01.ibm.com/support/docview.wss?uid=swg21967583

I ...
 Topic: XMETA table OMDMODEL_JOBPARAMETER
qt_ky

Replies: 8
Views: 191

PostForum: General   Posted: Tue Aug 15, 2017 7:08 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Yes, I was referring to the iis.client.site.properties file as detailed in this tech note:

Istool command fails with "java.net.SocketTimeoutException: Read timed out"
http://www-01.ibm.com/support ...
 Topic: From Sybase to Netezza: decimal mark error
qt_ky

Replies: 2
Views: 115

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 15, 2017 6:57 am   Subject: From Sybase to Netezza: decimal mark error
You might also want to test Row Generator stage to Peek stage, to remove the database stages and the Sequential File stage as variables.

The "decimal separator" as it is called in the Sequential Fi ...
 Topic: Environment Isolation
qt_ky

Replies: 4
Views: 133

PostForum: General   Posted: Tue Aug 15, 2017 6:36 am   Subject: Environment Isolation
What is your goal of isolation? Is it purely for security reasons?

You can install multiple instances on the same server or logical partition (LPAR) but it definitely makes everything more complica ...
Resolved
 Topic: Question on dsdlockd.config in 11.5.0.2/AIX 7.1
qt_ky

Replies: 2
Views: 64

PostForum: General   Posted: Mon Aug 14, 2017 6:48 am   Subject: Question on dsdlockd.config in 11.5.0.2/AIX 7.1
All I could find was a warning, where "other" refers to the "start" and "timer" settings:

Note: Do not modify the other values of the dslockd.config file unless suggested by IBM.

- quoted from t ...
 Topic: XMETA table OMDMODEL_JOBPARAMETER
qt_ky

Replies: 8
Views: 191

PostForum: General   Posted: Fri Aug 11, 2017 11:36 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Rescheduling jobs has helped stop the bleeding!

We have all the products in enterprise edition installed with all server tiers on one system. Our IGC usage is not yet that mature. I can safely purg ...
 Topic: XMETA table OMDMODEL_JOBPARAMETER
qt_ky

Replies: 8
Views: 191

PostForum: General   Posted: Fri Aug 11, 2017 4:41 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
Thank you Julio for responding. I found that the jobs must be rescheduled to effectively disable generating new OMD xml files. I have confirmed that without recompiling any jobs.

I would mark this ...
 Topic: XMETA table OMDMODEL_JOBPARAMETER
qt_ky

Replies: 8
Views: 191

PostForum: General   Posted: Wed Aug 09, 2017 2:26 pm   Subject: XMETA table OMDMODEL_JOBPARAMETER
I have double-checked that the "Generate operational metadata" setting in Administrator is turned off for each project.

Then I ran the DSOMDMonApp.sh -stop command as suggested.

I immediately fo ...
 Topic: XMETA table OMDMODEL_JOBPARAMETER
qt_ky

Replies: 8
Views: 191

PostForum: General   Posted: Tue Aug 08, 2017 7:38 am   Subject: XMETA table OMDMODEL_JOBPARAMETER
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: version 11.3.1.2
Our XMETA repository has ballooned to 100 GB. We suspect the OMD tables are consuming much of the space. The OMDMODEL_JOBPARAMETER table has over 60 million records.

The "Generate operational metad ...
 

 Jump to:   



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