DSXchange

There is a video on how to install it. The DSJobReportDbDriver job runs a job called DSJobReportDb. This job does all the work. You can change this to meet your needs. It writes row counts to hashed files and tables. You can delete one or the other just to get it working. DSJobReportDbDriver has a p...

The max length of an ODBC record is controlled also in the ODBC setup. There are several good posts about this.

Why are you JobHandle = DSAttachJob(AfterJob, DSJ.ERRNONE) I would do this at the end. You are still attached to DSJ.ME. I have had issues attaching to multiple jobs. As a comment, I hate this way of getting row counts. IBM consults do this a lot. First of all you slow down your job stream b...

If you save the metadata for the column names in the link for the dataset then there is a routine in my downloads on my tips page to estimate disk space based on the length on records saved in DataStage. The source code is included so you can tweak the calculations. I think I used 80% of a varchar l...

A friend of mine Preston wrote a Perl script to strip out the shared containers and all the dependent objects. He based it on a script called dsx_split.pl or something close to that posted on this forum. We took the DataStageBackup.bat script on my tips page and turned it into DataStageMigrate.bat. ...

Need to pass it unencrypted.

du - disk usage

There is FastTrack which can generate jobs. I have a poor man's version of the same. It takes a sample DSX and changes by replacing source and target columns. It assumes a fixed number of lookups.

This is kind of a poor mans reporting tool. These all show the SQL but that is an option to leave the SQL off and just show the results.

Here is what the reports look like:

http://www.duke-consulting.com/Download ... esAll.html
http://www.duke-consulting.com/Download ... nces1.html
http://www.duke-consulting.com/Download ... Size2.html
http://www.duke-consulting.com/Download ... leRpt.html
http://www.duke-consulting.com/Download ... m_Log.html
http://www.duke-consulting.com/Download ... 50506.html

This is all part of EtlStats. If you install it then it can run any of these SQL commands against DS_JOBS or whatever repository tables and send the results to any email address. The report is a nicely formatted html document attached to the email. It can run any SQL statement against any ODBC conne...

If you are using 7.5 or above then email has attachments. Earlier versions need to use blat.exe or some UNIX commands to do the attachments. EtlStats has a routine included to show you how to do it in either UNIX or DOS. The UNIX diff command can show what has changed. If you can do your diff in SQL...

You need system level stats to see what is happening at the server level as well. Are you paging? How much RAM do you have? How much is being used? Is your database on the same server? Are you out of disk space or scratch space when you crash? Lots of things can cause this. Answer Arnd's question th...

I do not use V8 yet so I have not converted it. Maybe someone else has.

There are a lot of posters whose primary language is not English. Keep asking questions. Keep trying to improve and we will gladly help fill in the gaps in your English as well as your DataStage skills.