DSXchange

All,

I am taking effor to get the list of all DS_ tables used in datastage. For this, I have gathered the table list from here and summarized the list for future use or keep this as reference for all the new developers (like me).

DS_CONTAINERS
DS_DATATYPES
DS_JOBS
DS_JOBOBJECTS
DS_METADATA
DS_ROUTINES
DS_STAGETYPES
DS_TRANSFORMS

If i missed any table (may be hashed file), add it here!

I'm sure these have been listed before. Did you Search DSXchange?

Add One more Table for Design-Time Information
DS_TEMPnn

Miscellneous Table
DS_AUDIT

could you please tell me where to run these queries?If it is in command prompt in which path i need to run the queries?

Developers don't really need to know about these tables. They seem to be falling into disuse in any case.