Search found 297 matches

by jhmckeever
Mon Nov 12, 2012 12:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: JOIN STAGE takes hell lot of time
Replies: 6
Views: 4543

Hi Kumarjit,

I suspect the reason you're seeing the delay is because Your data is being sorted on Address_ID before it can be joined. For this reason it's likely that a runtime sort operator has been inserted into your OSH. Take a look at your OSH in Directory to see evidence of this.

J.
by jhmckeever
Thu Nov 08, 2012 5:01 pm
Forum:
Topic: Workbench Query Runtime Parameters
Replies: 2
Views: 1408

Thanks for the confirmation Ernie.
by jhmckeever
Thu Nov 08, 2012 12:31 am
Forum:
Topic: Workbench Query Runtime Parameters
Replies: 2
Views: 1408

Workbench Query Runtime Parameters

Does anyone know how to define/execute a metadata workbench query with a runtime parameter? I'm exeucing mine using istool, but it's rather limited if I have to redfine it using the GUI for a change in parameters. Thoughts?

Thanks - John.
by jhmckeever
Thu Nov 08, 2012 12:29 am
Forum:
Topic: Workbench Query with istool
Replies: 1
Views: 3658

Workbench Query with istool

Hi, I've created a query in Metadata Workbench called "Modified Jobs" and plan to execute it from the command line: istool workbench query -queryname "Modified Jobs" -domain MyDomain -username MyUsername -password MyPasswd -filename C:\QueryOutput.csv -help I get the following er...
by jhmckeever
Thu Nov 08, 2012 12:19 am
Forum: General
Topic: Import a .pjb file using istool command
Replies: 15
Views: 16969

1. Can you post the istool command you're using?

2. We can assume you've checked and that the file /tmp/filename.pjb actually exists?
by jhmckeever
Tue Oct 23, 2012 6:59 pm
Forum: General
Topic: Information Server version 9.1
Replies: 18
Views: 14236

Vincent McBurney has produced an excellent post summarising what's new in version 9.1 on his blog:

http://it.toolbox.com/blogs/infosphere/ ... 2012-53350
by jhmckeever
Tue Jun 05, 2012 6:49 pm
Forum: General
Topic: Datastage Director Log in Milseconds
Replies: 2
Views: 1855

Perhaps you could use the operations console to understand your response times (depending upon your version of datastage).

http://www.youtube.com/watch?v=37MLml__TkQ

John.
by jhmckeever
Tue Apr 10, 2012 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Checking Composite Operator
Replies: 3
Views: 2541

The wrapDescribeOperator method is called to ask the operator to describe its inputs and outputs to the execution framework, which it's somehow failing to do. Is your metadata defined correctly? Does the relevant stage have all of its input and output links? Are there any other error messages to hel...
by jhmckeever
Tue Apr 10, 2012 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Constraint
Replies: 4
Views: 5248

To apply one constraint AND another constraint you should use an AND clause between the conditions! :-)
by jhmckeever
Tue Apr 10, 2012 7:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Custom Operator Property/Column Conditions
Replies: 1
Views: 1608

Custom Operator Property/Column Conditions

Hi All, I'm developing a custom operator in C++ and have the library working fine. My problem comes when defining the operator in DataStage by using the dialog you get when defining a new Stage Type. I have a problem specifying "conditions" values in the following contexts: 1. When I want ...
by jhmckeever
Wed Mar 28, 2012 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Buildup error
Replies: 3
Views: 2988

The actual complaint seems to be that the compiler doesn't know how to apply the '*' operator to your operands.

What types are they?
by jhmckeever
Wed Feb 29, 2012 9:12 pm
Forum: General
Topic: Unable to connect to Datastage server using Client tools
Replies: 1
Views: 3791

If the client and server can communicate over http(s) but your clients aren't connecting then the first difference to note is the port used.

Can you confirm this port isn't being blocked by a firewall rule?

J.
by jhmckeever
Mon Oct 17, 2011 12:36 am
Forum: General
Topic: Using WebSphere HTTP Server
Replies: 1
Views: 1099

For anyone following this thread I received a response from IBM that this approach contravenes the licencing agreement.

I achieved the same thing by installing Apache alongside Information Server.
by jhmckeever
Mon Sep 26, 2011 4:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Plz help me in this senario
Replies: 1
Views: 1447

Based on the values in your sample output you could simply funnel the rows and sort them alphabetically, although I suspect your ACTUAL requirement to be a little more subtle than that.
by jhmckeever
Wed Sep 14, 2011 12:19 am
Forum: General
Topic: Using WebSphere HTTP Server
Replies: 1
Views: 1099

Using WebSphere HTTP Server

Hi, Is is possible to use Information Server's bundled WebSphere server to serve HTML pages generated by DataStage? We've got a number of jobs which generate HTML content and would like to be able to view these files immediately using the supplied HTTP server. Is this possible? If so, can anyone pro...