How to Collect Statistics

chrisjones · Post by **chrisjones** » Thu Nov 09, 2006 3:03 pm

Hi All,
I am loading data into Teradata using Mload Stage,so I want to get the Teradata collect Statistics after the Job ran successfully.

Please let us know your inputs.

pukars4u · Post by **pukars4u** » Thu Nov 09, 2006 3:19 pm

use DSJobReport routine and this will collect all statistics of your Job after it is ran .I think this will solve ur problem

chrisjones · Post by **chrisjones** » Thu Nov 09, 2006 3:22 pm

Thanks for your reply.
We want to collect the Teradata Table statistics not the DS job statistics.

pukars4u wrote:use DSJobReport routine and this will collect all statistics of your Job after it is ran .I think this will solve ur problem

ray.wurlod · Post by **ray.wurlod** » Thu Nov 09, 2006 6:03 pm

How would you collect statistics after a MultiLoad operation not coming from DataStage? Basically what you have to do is either mimic that approach in DataStage - possibly another job - or script it - perhaps invoking that script from DataStage.

chrisjones · Post by **chrisjones** » Thu Nov 09, 2006 7:44 pm

I am using script-After Tab in the Mload Stage to collect Table statistics by CALLing a procedure. The report file says "CALL" Unsupported SQL/RDBMS command.

ray.wurlod wrote:How would you collect statistics after a MultiLoad operation not coming from DataStage? Basically what you have to do is either mimic that approach in DataStage - possibly another job - or script it ...

chulett · Post by **chulett** » Thu Nov 09, 2006 8:04 pm

Can't you script something via a command line utility and run it 'after job'?

nishadkapadia · Post by **nishadkapadia** » Fri Nov 10, 2006 12:39 am

To do collect stats on the table within Teradata , one can call the procedure via Teradata API.

The procedure which is created in Teradata has to be compiled in ANSI mode, since the datastage calls the procedure in ANSI mode only and not in BTET mode.

DSXchange