metadata store

[djoni]

I understand 7.5 no longer uses Universe to store metadata. Where does Datastage store its metadata? What format? (RDBMS, file)
Thanks, djoni

[ArndW]

You understood incorrectly, DataStage at 7.5 still uses the UniVerse tables to store metadata.

[ray.wurlod]

Strictly speaking, it doesn't. At version 6, when IBM bought UniVerse (and a heap of other database products) from Informix, Ascential had to change the name of the database to "DataStage Engine". However, the storage mechanism in the Repository is unchanged through to version 7.5.

[track_star]

It will change at version 8.0....you will be able to select where you want to store the repository (from a list of supported DBs, I believe). I wonder which one will be the preferred target???

[Raog]

Djoni,

It uses the universe in 7.5. In the next release Hawk, u can decide on which database you want to store your metadata.

Thx,
Rao.

I understand 7.5 no longer uses Universe to store metadata. Where does Datastage store its metadata? What format? (RDBMS, file)
Thanks, djoni

[track_star]

I don't think there's going to be any "choice" in the matter.....

[ray.wurlod]

The same range of choices that you currently have for MetaStage. This includes DB2, Oracle, Sybase, SQL Server and "UniVerse".

The intention of Hawk is to have a common repository for DataStage, QualityStage, ProfileStage and MetaStage (and AuditStage?).

Should be fun for the hackers!

[track_star]

Eventually they will all be there....my comment was about the initial release (sorry I didn't clarify). It will be a limited list, with DB2 beinig the primary choice.