database
Posted: Thu Feb 28, 2008 2:01 am
does data stage has internal database
DataStage Server - yes
DataStage PX/EE - no
Page 1 of 1
Posted: Thu Feb 28, 2008 2:04 am
Posted: 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.
Posted: 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.
Posted: 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!
Posted: 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.
Posted: Thu Feb 28, 2008 3:39 pm
I guess most likely it would be DB2; as it is also an IBM product. 