DSXchange

FYI To All.

The scheduler does support multiple instances of the same job being schedule for the same day. You need to be in the "schedule" display. At that point you can "add" again the same job and tell it to start at a different time.

Regards,

Allen

Hi Guys, I hope Im not breaking any rules for the list here, but Im looking for references where DataStage has been used in the banking sector specifically working with Globus systems and the "Bank Master" systems. If anybody knows if sites where DataStage was/is used in these environments wont you ...

Hi Ramesh, Default oracle sends 1 rows at a time. Check both the jobs has the same array size. Change the Array size from 1 to 1000 and see the difference. Thanks Siva ----- Original Message ----- From: "ramesh pothuru" To: Sent: Friday, December 20, 2002 9:48 PM Subject: performance issue! > Hi, > ...

Vicki, We have a job which does exactly this. We pass parameters which nominate the date and time that we wish it to stop and how often it is to run a nominated job (ie, how many minutes from start to start) It is all done with basic code in job control. To make life easier, convert the finish date ...

1. Are the rows in one file approximately 1336/370 times the size of the rows in the other file? Rows/sec is a meaningless indicator for comparing throughput unless the rows are identically sized and being processed identically. 2. Are the jobs run one after the other or at the same time, or at wide...

Hi Everyone, I have one job in two projects . My permissions on both projects are same. The directories are set up with same permissions. When I try to reset a job in one project, It throws error as: Error running job Status code = -2 DSJE_BADSTATE On other project I dont get any error. Im using com...

Great... last on the port list but at the head of the wagon train. Heres what Ive found out so far and for me its mostly bad news. As suspected and previously reported, using an 8i Client and the OCI8 plugin, I can happily access both 8i and 9i databases. However, I cannot use the new 9i plugin as i...

Are you loading them into different tables (number of columns, date types, etc.)? Are the tables using the same tablespace? If so, there can be many reasons why they would load at a different rate: 1. Indexes 2. Logging: Table, Tablespace, Instance, etc. 3. Number of constraints ramesh pothuru cc: S...

If your DS server is on unix, then create a shell program that makes use of Command line options. Using this approach you can schedule, monitor, notify, check for exit status, check for error log ... and many more things. best of luck. -----Original Message----- From: Shearer, Donald (CRTUSW) [mailt...

Vicki, Another option would be to create a routine which would control the iteration. -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: Friday, December 20, 2002 8:37 AM To: datastage-users@oliver.com Subject: RE: Looping a job Vicki You could do it in job control. Create...

Hi,

I would like to connect to load data from flat files to db2 tables.
How to connect to db2 database from Datastage?


Thanks
Ramesh

Vicki You could do it in job control. Create a job that runs this job in a loop. Thanks Kim. Kim Duke DsWebMon - Control DataStage from the web www.duke-consulting.com -----Original Message----- From: Victoria.A.Oliver-Macklin@gsk.com [mailto:Victoria.A.Oliver-Macklin@gsk.com] Sent: Friday, December...

Hi erwan,

infact the faster one has bigger record length than lesser one.


Thanks
Ramesh

Does anyone know of a way of looping a job continuously? I have a sequence job which calls many other jobs (some of which themselves are sequence jobs). At the moment I have this process running hourly, as I cant guarantee that it will complete in less than one hour. Aside from the fact that it is a...

And also: what is the row length of the flat files. If one is 20 chars and the other is 100, no wonder why one is faster! The same applies for the output tables. Erwan >>> Surendranath.Gujjala@Ingenix.com 12/20 3:55 >>> >From the datastage perspective It could be because of: 1. Complexity of the log...