Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2008 @ 08:43:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thank you Joerg and Dave for replying.

Joerg - Could you please send me the sample of the script you spoke. And let me know about the BTQ script. I am not aware of it.

Dave - I am a Abinitio professional. Recently got to debug a project which is connecting to TD DB having a performance issue. Will let you know the info you have asked for once I get it from the TD DBA.

Just for FYI, I will give an overview of What the collect statistics part in the Abinito process is doing in the existing process.

1. In the process there is a component called "Run SQL" component, which is running the following SQL on the TD DB to call a procedure:

     CALL SYSDBA.COLLECT_STATISTICS ('DATABASE/CONTAINER NAME',
            'TABLE NAME','N',' ',RETURN_MSG)

2. "Run SQL" compont is having a log port having the record format as below

       record
     string("|") node;
     string("|") timestamp;
     string("|") component;
     string("|") subcomponent;
     string("|") event_type;
     string("|\n") event_text;
       end;

3. For individual records out of the log port, if the text in "event_text" is containing "Statistics collected for", then the Abinitio process is successful.

4. If "event_text" from the log port not containing "Statistics collected for" then the process fails saying

     "*** Collection of Statistics Failed.  Check Log File for
                Specific Error Message ***"

Thanks & Regards,

-Rit

	<Prev	Next>		<<First	<Prev	Next>	Last>>