Determining work load / hardware resource demands
Posted: Tue Oct 26, 2010 3:17 pm
Hello,
We are a relatively small DataStage shop (about 10 - 12 users) and we (our team) use DataStage, QualityStage and Information Analyzer to do their work for Business Intelligence. There are other non-BI related DataStage jobs that are running in Development, Test and Production environments. Needless to say, the jobs being quite complicated, we are very frequently stepping on each other toes with regards to the resources etc.
This brings me to the question (actually it is bothering us as a team):
How are people in other shops determining their work load/hardware resource demands from a DataStage point of view?
I understand that a lot of factors need to be factored in such as, data partitioning, sorts, number of joins/lookups, transform(er)s.
Is there are good way to determine the work load on the CPU and space (dasd)? Like a utility/software or such...?
Please advise. If you would like any additional details, I would be glad to provide them to the best of my knowledge.
*Edited this post to have visual clarity for the questions*
We are a relatively small DataStage shop (about 10 - 12 users) and we (our team) use DataStage, QualityStage and Information Analyzer to do their work for Business Intelligence. There are other non-BI related DataStage jobs that are running in Development, Test and Production environments. Needless to say, the jobs being quite complicated, we are very frequently stepping on each other toes with regards to the resources etc.
This brings me to the question (actually it is bothering us as a team):
![Question :?:](./images/smilies/icon_question.gif)
I understand that a lot of factors need to be factored in such as, data partitioning, sorts, number of joins/lookups, transform(er)s.
![Question :?:](./images/smilies/icon_question.gif)
Please advise. If you would like any additional details, I would be glad to provide them to the best of my knowledge.
*Edited this post to have visual clarity for the questions*