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 ... ?
find repository database
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
find repository database
Karthik
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Re: find repository database
The way you came to know is the BEST waykarthi_gana wrote:In our company we are using DB2 as the repository. I came to know this from the DSADMIN team.
![Wink ;)](./images/smilies/icon_wink.gif)
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
everything is present in Version.xml
something like
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.
something like
Code: Select all
<PersistedVariable encrypted="false" name="xmeta.db.type" persistent="true" readonly="true" value="db2"/>
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)