What is repository tuning in Datastage?
how do you do that?
Repository tuning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
Repository tuning
ramesh.n.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A DataStage repository in the version you indicated (7.x) is a schema in a database. It contains a number of tables.
As a generic inquiry, ignoring DataStage, how would you (ramesh_inform) go about tuning a database schema?
Most of the same principles apply to the DataStage repository but, being an embedded database, many of its defaults and configurations are such that attention of a DBA is rarely necessary.
For example, its tables are implemented as dynamic hashed files, which means that table space management is automatic. Yes, this can be optimized, but the cost may not be worth the benefit.
In version 8 and later, with an "open" database for the repository, there may be both more scope and more need for tuning. This really has yet to be determined.
As a generic inquiry, ignoring DataStage, how would you (ramesh_inform) go about tuning a database schema?
Most of the same principles apply to the DataStage repository but, being an embedded database, many of its defaults and configurations are such that attention of a DBA is rarely necessary.
For example, its tables are implemented as dynamic hashed files, which means that table space management is automatic. Yes, this can be optimized, but the cost may not be worth the benefit.
In version 8 and later, with an "open" database for the repository, there may be both more scope and more need for tuning. This really has yet to be determined.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.