Number of projects on a single server.

poorna_76 · Post by **poorna_76** » Thu May 25, 2006 9:49 am

Regarding the use of multiple projects, I understand that some company's have put as many as 9000 jobs in a single project with a limit of 5000 in Unix. I've also been told they've used as many as 80 projects. (Limit of 75 on Unix)
Based on these stats, technical constraints with having many projects or jobs in a single project don't seem to be an issue.

Any suggestions or comments regarding when to create a new project? What guidelines have been used to make this determination?

Steve Neuerman

I_Server_Whale · Post by **I_Server_Whale** » Thu May 25, 2006 9:57 am

Hi Steve,

Determining when to create a new project varies from site to site. Although, at the current site, whenever they take up a new intiative, they create a new project. Also, projects can be created based on the subject areas of the organisation.

May be you could get an expert opinion from our gurus. They always do an excellent job providing their valuable pieces of information. Thanks Gurus!

Thanks,
Naveen.

kduke · Post by **kduke** » Thu May 25, 2006 4:20 pm

My rule of thumb is create a new project if none of the new jobs need to be run by the existing jobs. It almost always means this is a totally unrelated subject area.

Remind me not to work on this project. 9000 jobs has to be brutal in the Director.

ray.wurlod · Post by **ray.wurlod** » Thu May 25, 2006 4:22 pm

Prior to version 6.0 DataStage was licensed per project, so it was an expensive undertaking to add more projects than were licensed.

Since version 6.0 DataStage is licensed per CPU so there is no limit to the number of projects. (This may not be the case: an enterprise licence limits to 999 CPUs - there may be some other ridiculously high limit to the number of projects, but it's definitely not as low as 75.)

Not sure what the rules will be for Hawk, but there's nothing apparent in the current licensing mechanism to limit the number of projects. Typically you have development, test (maybe x2) and production for each main subject area, plus one or a few "sandpit" or training projects that can be deleted when no longer required.