deciding server or parallel job

sravanthi · Post by **sravanthi** » Fri Jun 29, 2007 7:14 am

hi,

If we are asked to design a job given with a scenario how to decide whether we should go for server job or parallel job?

What are the essentials in considering server or parallel job with respect to both unix or windows platform.

Thanks,
sravanthi

DSguru2B · Post by **DSguru2B** » Fri Jun 29, 2007 7:44 am

The number of records, the size of a single record, what operation needs to be performed on the data, the transformations, the time window for completion; just to name a few.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 29, 2007 7:50 am

If you only have server edition licensed the decision is a no-brainer. Likewise if you've chosen only to license only enterprise edition.

Small jobs - server.
Large jobs - parallel (probably).
Medium jobs - some other factor needed to make the decision.

Nothing quantifiable!

There's a lot of parallelism you can build into server jobs: multi-instance, row buffering, parallel streams, link partitioning, etc., just to muddy the waters. I have one long-standing client processing huge volumes of data with multi-instance server jobs, and quite happy with the performance.

The interface between server jobs and IBM Information Server - how efficiently the conversion occurs at the boundary - might also be a consideration for version 8.0 and beyond.

vnspn · Post by **vnspn** » Fri Jun 29, 2007 2:17 pm

Ray,

The client whom you say of processing huge volumes using Server jobs, what is the approximate volume. Are they processing up to 10 or 15 million?

Thanks.

narasimha · Post by **narasimha** » Fri Jun 29, 2007 3:19 pm

vnspn wrote: The client whom you say of processing huge volumes using Server jobs, what is the approximate volume. Are they processing up to 10 or 15 million?

No issues with Server jobs handling such volumes. The approach/requirement for your processing can give you different results.