DSXchange

A lot of these posts are errors within DataStage. You need to call IBM support or email them and open a ticket.

This group can help figure out what is going wrong but this forum is not a substitute for support. Most of us do not like that role. We are designers and builders of data warehouses.

Did you call support?

I have not seen this issue.

Is this Designer? Did you try Manager?

I would call support?

This is a batch job. Not a routine. You will need to disconnect Director from the project to refresh the list of jobs. I in NO way recommend doing this. USE AT YOUR OWN RISK: * ------------------------------------------------------------ * EtlClearInstanceIDs * Decription: * This will clear instance...

Why is this posted twice?

You do not want a single hash file to be both a source and a target because of the way it processes hash files. You can do this in a job but not read transform and write to the same hash file. This is different than write to a hash file and then start reading from it.

Roy is correct to change this into a routine activity would be easy.

Ans = @FALSE
Shell = Arg1
Cmd = 'SH "' : Shell : '"'
execute Cmd capturing OutPut returning RtnValue
Ans = RtnValue

You can add some LogInfo if you want but this is close.

You have to do it after ftp is done. chmod is not a command within the ftp command.

Oh I forgot to mention, there is a job included which will get row counts from the job log. It posts them to a hash file. There is a second job which posts the hash file records to the same tables as the other jobs. This gets row counts about every way but using the API. That is next. I already have...

Download EtlStats and a bunch more jobs and routines for free on my tips page below.

New EtlStats is now available. It uses DSSendMail. So it works on Windows. I am not sure the UNIX version works now. This version uses ODBC. It currently works with SQL Server. So DDL is included for both Oracle and SQL Server. Maybe Vincent will send the DDL for DB2. This is much easier to install....

They are all job control code or what they used to be called batch jobs. Look in job properties.

Srikanth The cache size can only be set to what shmtest command will allow. Beyond that you get these kinds of errors. This command will tell what to set the parameters in uvconfig. You must then do a uvregen. Then you need to stop and restart DataStage. You need to open a ticket with support on thi...

I noticed that you need a space around " \n " for it process correctly. So "\n\n" is ignored by the send mail routine.