DSXchange

There is no transaction handling in teradata enterprise stage compared to oracle stages. enterprise stage will have error tables created, if there is a problem, however it is not the same as transaction handling. As for the deadlock, as ray suggested as well as from the log, it is trying to update t...

Is this one-off thing or a reproducable error. Would you be able to give more detail.

Since made a random job/query to check whether i could reproduce the above , with a simple aggregation of partition by key values, and it does give the statistics as intended.

Has this problem at one of the clients,Alternatvely, one can get the o/p into a sequential file and call multiload via a separate script

Adding a bit to the detailed ans by pratap to the Enterprise stage.The idea of aborting it from Datastage, however does not stop the Insert..Select statement from the ORCH<cookie_id> to the populated/empty table. Only DBA can kill this particular session , however it is beset with performance issues...

Hi,

Are you able to insert into the same table using Fastload on the database?

Teradata Enterprise Stage uses Fastload followed by Insert..Select statement.

Fastload does not support Secondary Indexes in Teradata.

IMHO,
Nishad

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.

Hi,

One can get the job's last and first timestamp and subsquently the log details by passing the above two as parameters. (DSGetLogSummary)
This will give you the last execution details of the job.
One can also get DSGetNewestLogId for the job.

Thanks All. It works fine with DSJ.ERRNONE

P.S had been off for vacatn , so late reply to this .

Hi, I attach a job using DSAttachJob with "ERRWARN" as errormode. Job_Handle = DSAttachJob('xxx_Seq_xxx',DSJ.ERRWARN) If not(Job_Handle) Then Call DSLogInfo(....) Continue End Else.... The problem is that if a job is not runnable then there are warning messages in the individual's job log ...

Thanks it's been resolved.

Hi I have written a simple routine to get Category for all the jobs. The Routine works fine when executed via manager. On attaching a Routine Activity in Sequencer, the sequencer hangs but the routine does complete it's task. The Routine Accepts no arguments and runs on the Entire Project. It writes...

Hi, One can use LinkTypes as suggested. It does work with Active Stages, however if there is a job with Passive stages only, it is not possible using LinkTypes. That is my understanding. The other route which i tried was using Oletypes for ObjectNames, which as everybody had explained how to make me...

Hi, One can do an insert..select statement using the Rank() function. It is correct that the sequence number is allocated in a batch to the various amps, hence should not be a problem while insertion however the possibility of it being discontinuous. One can actually do a rank()+1 function so as to ...

Using Rank() function is better, since sequence number could be discontinous.

Hi,

One can have two sequencers one with A-->B--> etc and another one with P-->Q-->.

Create a master sequence for the two above and dont connect them , so as to make them run in parallel.

This will work,however that is all IMHO.