DSXchange

This is straight out of the script on my tips page.

Do a search for EtlStats.

Someone needs to organize all this into a real FAQ.

Read:

http://www.dsxchange.com/viewtopic.php? ... ight=crc32

I will try to post more details tomorrow. Another tip is your program can have a main() like Ray says. Your routine needs a function to call other than main() but you can have a main() which in this case calls Ereplace(). If you have a main() then you can test it from the UNIX command line. I posted...

Ray is correct. You need to compile your C program. You need to compile it using the same options as DataStage. You can lookup the compiler and options used in the Administrator. I would have to do a search to remember how we did this. When you compile on AIX your file has to end in .C and not .c. T...

Thanks Ray.

Search for EtlStats.

This becomes even more complicated in a cluster or grid. We are trying to figure out which machine a process or partition runs on.

The #'s surround parameter names and their values get substituted at run time. Just like $Project would in a shell script. All jobs run in the project directory. The path to dsjob is because the Projects directory is relative to the DSEngine directory on most DataStage servers. I think you need to g...

For the PX users I have a much improved version of this job and these tables. The ETL_ROW_HIST was aggregated to remove the partitions. We found that row counts at the partition level is valuable to see if a hash partition is unbalanced. We also found that we are RAM bound. The xml contains the proc...

Craig is correct. There is a before job routine which runs the dsjob command. You need to fix the path to make this work in your project. If you are on UNIX then you need ExecSH instead of ExecDOS. You also need to change / to \. This outputs to a XML file below the project in the KimD folder. You c...

Ray is correct. If you load into a view the error shows you that the indexes are not viewable. Certain indexes are required for specific Teradata APIs.

This was a question in the certification test. There were supposedly 2 stages which you can do this on.

You have to call the API's or use dsjob. Multiple instances really makes this hard.

EtlStats has a job which can get this for all jobs in a project except for multiple instances. It is called something like DsJobReportDbDriver. Search for the posts.