DSXchange

Plus there are a number of settings that limit the actual number of jobs being kicked off by the Job Sequencer. I do not have a reference handy to help guide you just yet, but this is tunable. Have you considered using Workload Manager to help manage your resources (available in 9.1+), while throwin...

XMLStreamException is a catch due to an error somewhere else.

We need the complete stack trace (perhaps a review of the prior errors), and a detailed question. Thanks.

-T.J.

They are based on Universe, an ancient (yet very fast) database schema. It is generally not public knowledge.

What are you hoping to achieve here? Perhaps there will be a much more official solution available.

-T.J.

Actually, not quite. The After Job and After Stage queries are typically seen as "do this after we're done." Typically maintenance-level stuff that are not critical, and failures are typically not captured as fatal (it is done at the end of the job's/stage's run). If you are doing somethin...

When checking operator: Schema field CODE in input data set 0 not present in design time Looks like there is a field that have not been properly defined ("CODE") within the source database, leading to a mismatch with the schema definition you made in the stage itself. Please double check ...

Please review the documentation again carefully. For WeekdayFromDate, it expects a Date field, and will return a numeric value. A numeric value is never equal to a string called "Sunday". There is also type conversion functions detailed here: http://www.ibm.com/support/knowledgecenter/?lan...

As for the original issue - for the updated log, the original failure is within Item #27. But usually, the first failure message is just the Orchestrate engine going, "Woah, a player is dying" and usually get fed back to the logging mechanism long before the actual failure is reported. Ite...

ray.wurlod wrote:You might also consult the Message Reference Guide to see whether IIS-DSTAGE-ABAP-E-00746 is there. I'm not currently at a location where version 11.3 manuals are available. ...

http://www.ibm.com/support/knowledgecen ... me?lang=en

You are welcome.

That's because dsadm is generally recognized as the administrator account for the most part. When you start using other accounts, it will still try to use dsadm instead, but the authentication doesn't work. You need to explicitly define your authentication method. If you are concerned with showing y...

Look at this page:

http://www.ibm.com/support/knowledgecen ... ml?lang=en

Particularly: WeekdayFromDate()

-T.J.

Indeed, PX solution have a distinctive different solution than Server solutions.

We need the specific error message, including the Message ID in order to help you.

-T.J.

Heh, this came up in a ticket to me a couple months ago, to find out how many business days there were since the start of the year. I built a simple logic to handle this and gave it to L2 to give to the customer. But for the life of me, I can't seem to find this anymore. Oh well. In a nutshell, you ...

It is possible there may be an issue with the ODBC driver when it is called in parallel. Please contact IBM Support and ask for the latest DataDirect ODBC drivers. (Not sure if FixCentral would provide that.)

The dsjob command serves as an example of how to use the DataStage API. You may as well use dsjob, as it's supported, but my point is that you can create your own. ... That is correct. the DataStage API is there for you to use -- http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg....

General question to the home audience - has this changed at all in the later releases? Nope. Other than changing the supported compiler (which may require that you tweak your makefile), nothing have really changed in this area. BTW, the 11.5 doc: http://www.ibm.com/support/knowledgecenter/SSZJPZ_11...