Repository tuning

ramesh_inform · Post by **ramesh_inform** » Tue Jan 29, 2008 5:19 am

What is repository tuning in Datastage?
how do you do that?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 9:22 pm

By leveraging more than 20 years' experience with the database, usually in exchange for a professional fee.

ramesh_inform · Post by **ramesh_inform** » Tue Jan 29, 2008 10:14 pm

ray.wurlod wrote:By leveraging more than 20 years' experience with the database, usually in exchange for a professional fee.

I didnt understand ur concept[:(]

Maveric · Post by **Maveric** » Tue Jan 29, 2008 10:50 pm

Since you said "how do you do that?" Ray says he would do it for you if you pay him for his services.

Ask a more specific question like what the problem is and tell us why do you think tuning the repository would help.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 30, 2008 1:12 am

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.