DB2 instances in SDLC

[tekedge]

Hi,

I am the dba maintaining db2(8.2) databases in an AIX(5.3) environment. We follow the SDLC process for promoting code changes through different regions like Development,Tes t ..Production for every release.
Recently I have been asked about the possibility of maintaining multiple releases parallely and how it could be done from the DB2 perspective. Each release shd be independent of the other. Does anybody here have a similar scenario requirement. What would be the best approach to do this? Multiple schemas , multiple databases or partitions?

Thx,

[sushanth bobby]

Tekedge,

It depends upon the project requests, i guess. If each PR accesses different(datab ases or tables), then each release will be independent of other.

Sushanth