database

mcs_suman · Post by **mcs_suman** » Thu Feb 28, 2008 2:01 am

does data stage has internal database

ArndW · Post by **ArndW** » Thu Feb 28, 2008 2:04 am

DataStage Server - yes
DataStage PX/EE - no

mcs_suman · Post by **mcs_suman** » Thu Feb 28, 2008 2:08 am

ArndW wrote:DataStage Server - yes
DataStage PX/EE - no ...

ARNDW could you explain me about this.how or where does data stage server maintains this.

ArndW · Post by **ArndW** » Thu Feb 28, 2008 2:28 am

DataStage server is written based on a database which is very much like IBM UniVerse. They used to be the same system but have now been developed indendantly. The database is a Pick postrelational one and you can use your favorite web search tool to find thousands of pages discussing this.

AmeyJoshi14 · Post by **AmeyJoshi14** » Thu Feb 28, 2008 4:06 am

ArndW wrote:DataStage Server - yes
DataStage PX/EE - no ...

But i can query the UV database even though i am using Datastage PX/EE.

So it is not good practise to query UV Database (almost daily)?..since i am using a UV query to find the jobnames which are using specific table..
Thanks in Advance!

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 4:18 am

Query is harmless but beware that, once you move to version 8.x, the repository will be DB2, Oracle or SQL Server.

dspxlearn · Post by **dspxlearn** » Thu Feb 28, 2008 3:39 pm

I guess most likely it would be DB2; as it is also an IBM product.