DSXchange

what do you mean by slow? how long does it take for your server to import to a virtual dataset? is your sequential file created/exist in a filesystem that spans multiple disks ? make sure your scratch disk is not in the same filesystem as your sequential files. no point tuning anything in DS when yo...

you can always get the evaluation copy of the software from our friends in IBM,install it and have a play.
i'd still strongly recommend attending the training course because some of the fundamentals are best learnt in class.

just check in those stages where you have zeros count whether you are using RCP , that may cause stats not showing up. I have that in my jobs too and those stages will show zero count but downstream because i don't use RCP counts appear. just a thot. i may be way off the mark here.

try not using "*" but define what columns ,also include the ; at the end of your sql statement.

what is the source of your data ? is that an Excel spreadsheet or a database? perhaps the formatting could be pushed back to the source to get it a a string which can be easily converted using StringToTimestamp.
just a thot.

I also agree that vmware is not for a production ETL server. It is fantastic for maintaining portable training and evaluation environments. On a Windows server your RAM and CPU power gets divided between the host and the vmware session so you never really get 100% of the resources on the box for yo...

Hi, My requirement is to truncate a table and then load data. I tried using Write Mode=Truncate and Write Method=Load. It gave the following error and the job got aborted. Indexes on table 'xxx' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes...

dvpawankumar wrote:I designed a job in datastage Designer.I want to run this job in Unix.Please tell me the steps what are the basic things i have to follow to do this.

you can also try using the Scheduler in DS Director and once the job has been scheduled, edit the cron entry which can be used to run the jobs.

Hi,

Is there a way to add months to a date in a PX job ? I can do that quite easily in the database e.g in Db2 date('2004-01-05') + 1 month

but I rather not code it in the database if I can do that in the job.

Thanks,

JS

Hi All, I am not able to use LOAD Method in my job.....It is showing following error message DB2 Load Binary Error SQLCODE=-3025 SQL3025N A parameter specifying a filename or path is not valid Failed opening fifo /dstage/Ascential/datastage/scretch/ordb21531966fb686b1c after 90 seconds no such devi...