snippetMinor
How can I know my database version?
Viewed 0 times
canknowversiondatabasehow
Problem
I need to know what is my database version.
I'm using DB2 V9.7 on linux 64 bits.
I'm connected to a database and i need to know if it is 32 or 64 bits.
Can someone help me?
I'm using DB2 V9.7 on linux 64 bits.
I'm connected to a database and i need to know if it is 32 or 64 bits.
Can someone help me?
Solution
If you follow this link there are several ways.
One of them shows you the architecture.
From that page:
One of them shows you the architecture.
From that page:
$ db2level
DB21085I Instance "db2inst5" uses "64" bits and DB2 code release "SQL09071"
with level identifier "08020107".
Informational tokens are "DB2 v9.7.0.1", "s091114", "IP23034", and Fix Pack "1".
Product is installed at "/opt/ibm/db2/V9.7".Code Snippets
$ db2level
DB21085I Instance "db2inst5" uses "64" bits and DB2 code release "SQL09071"
with level identifier "08020107".
Informational tokens are "DB2 v9.7.0.1", "s091114", "IP23034", and Fix Pack "1".
Product is installed at "/opt/ibm/db2/V9.7".Context
StackExchange Database Administrators Q#98779, answer score: 3
Revisions (0)
No revisions yet.