DSXchange

think you might need a after job routine to execute to gather the stats.

Thanks chulett, you're right I've no previous idea about this feature in DataStage and it's urgent as the client needs such an ETL report and I need to know how to implement first, and how much time it will take. Thanks again. sorry to disappoint you but in this forum nothing is urgent as everyone ...

Have you attended the IBM datastage training? that might be a good start.

Are you using the same account/user to run the job AND from the command line using dsjob? Maybe a user account has restrictions.

Loading large amounts of data and performing lookups/joins are distinct operations meaning you can load large amounts of data with BOTH joins OR lookups. Doesn't matter.

How does your job look like? When you run it using the Stored Procedure stage, all it does is pass the parameters back to the database so in essence it should be the same. I done it before and performance is the same. Has this problem just happened recently? has your job been able to run well in the...

Why don't you substitute the job parameters with EXACTLY how you would run it in TOAD. Also check that you have nothing in your Transformer that is dropping records. Check in your job logs for dropped records.

single node - your job spawn less processes hence uses less memory. configuring more nodes does not equal better unless you have resources in your box.

Hi, If your stored procedures expects parameters then you need to pass these onto the stage. Typically you will need to have input parameters and output parameters. The data type for the parameters must match up to what the stored procedure is expecting. Other than that it's the same as any other st...

RCP merely allows you to propagate columns ; the outcome depends entirely on your job design. You can use RCP in shared containers but you control the results, RCP does not.

Don't think the two jobs are the same. At least internally the parallel job would or may be rehashing the data while the server job wouldn't. If the volume is small then the server job having less repartitioning/rehashing of data will finish quicker. In order to answer this type of question as chule...

Read the Manual - Developers Guide.
May also help if you attend a Datastage course.

The password expiry really depends on how you have setup security for your db2 users.For instance if db2 is using your local OS security then the password expiry is set/changed in say your Windows Administration.
That's how I understand it.

In simple terms the sort stage offers more options but at the end of the day,a sort is a sort.
Have a read of the Developers Guide....it's in there somewhere

As far as I know, you'll need cascading lookups - five of them set to continue if they fail. First one checks for a substring of 7, the next 6, etc. ... Many Thanks chulett for your reply and interest , i've thinked in that but is there is any other method to make it dynamicaly , i'm afraid of any ...