DSXchange

ArndW

(for AIX):
1. /opt/IBM/IIS/WebSphere/AppServer/bin/startServer.sh server1 -username wasadmin -password MySecretPassword

2. /opt/IBM/IIS/InformationServer/ASBNode/bin/NodeAgents.sh start

ArndW

Do you have a link marked as "Reject" in the transform stage?

ArndW

Do you have the hex value of both the EBDIC source and final ASCII characters?

ArndW

I would think that

Code: Select all

String To Date('9999-01-01','%yyyy-%mm-%dd')

will make DS happier.

ArndW

Add those environment parameters to your job and set the values to "true" and "true"

ArndW

If you monitor the progress can you see how the data is going through the sort? Also, replace any WRITE stages to databases with a peek stage temporarily to determine if the slow speed is due to those stages.

ArndW

source the $DSHOME/dsenv script and the libraries will be set up correctly to execute the orchestrate commands.

ArndW

As DSGuru2B has recommended, put in a transform stage and put a constraint "In.REJCOUNT <> 0" going out and place a limit of 1 row on that link, that will trigger the job to abort.

ArndW

add a sort stage before the join to each link where you specify the sort key and add "Don't sort, data previously sorted" so that the join stage does not have to insert a sort operator. You can print out and compare the score with APT_DUMP_SCORE. You could also add APT_NO_SORT_INSERTION so...

ArndW

Fix "Join_12" first. You need to sort the data on exactly the same column(s) as is/are used in the join. Once that warning is gone, see what happens.

ArndW

No real difference for normal MQ use between the two.

ArndW

Is the ODBC driver from Attunity? It might not support concurrent connections.

ArndW

try

Code: Select all

dssh<<eof
pterm case noinvert
SELECT JOBNO FROM DS_JOBS WHERE NAME = 'Test';
QUIT;
eof

Note the switching off of case inversion and the semicolon on the SQL

ArndW

Hello Klaus, long time no see

ArndW

Have you restarted DataStage since making those changes? They won't take effect until you do so.

Search found 15603 matches