Finding out XMETA database type

[mouthou]

Hi All,

Is there anyway to find out on which DB the XMETA repository is running like Oracle, DB2 etc? Appreciate even if there is any clue.

Thanks

[qt_ky]

Look on your server under the install path, /opt/IBM/Information Server, or similar path depending on your installation.

Find the files Version.xml or response.txt. Run grep -i on either file with "xmeta.db.type".

You can also run ISA Lite general health check and search on the same string.

[rkashyap]

You can also look in database.properties file. Location of this file varies by version, it may be ... /opt/IBM/InformationServer/ASBServer/bin/sql/ or /opt/IBM/InformationServer/ASBServer/conf/.

[mouthou]

With the search on all the folders/files suggested above, there seems a clue in version.xml with an entry as below and nowhere else has the reference of the exact XMETA db type for 8.7

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

Thanks for the responses. Knowing that XMETA is run on few supported DBs, curious to know what DB was picked when Datasage was installed.

[chulett]

So... DB2. Marking this as resolved but feel free to open back up if you still have any questions.