find repository database

[karthi_gana]

All,

In our company we are using DB2 as the repository. I came to know this from the DSADMIN team. is there any way to find the repository database ? i.e through any command.

say for example, in sybase or sqlserver we can use @@version to know the version details. like that is there any command available to say "hey...your repository database is ORACLE or DB2 or ... ?

[qt_ky]

You can telnet to your unix server and source the db2profile file to set required environment variables then run db2 from the command line. The file will be under the db2 instance owner's home directory and then under the sqllib subdirectory. That might give you a nice, warm, fuzzy feeling.

You could also try connecting to it from a DB2 stage in a DataStage job. The default database name is XMETA, but that's easily changed during installation, so if you're not sure, ask your admin.

[ray.wurlod]

Why do you want to find it?

It is probably better (safer) if it remains "invisible".

[stuartjvnorton]

odbc.ini will tell you what type of DB it's on if you're using a fairly standard name like XMETA but, as Ray said, it's probably better if people stayed well away...

[qt_ky]

The install log may give you a clue there...

[kandyshandy]

In our company we are using DB2 as the repository. I came to know this from the DSADMIN team.

The way you came to know is the BEST way

[priyadarshikunal]

everything is present in Version.xml
something like

Code: Select all

<PersistedVariable encrypted="false" name="xmeta.db.type" persistent="true" readonly="true" value="db2"/>

Also the configuration in present in resources.xml and can be seen through command line as well as from GUI through WAS administrative console not the IIS console.