IBM Connections: Checking Database Version of Applications

From Wiki
Jump to navigation Jump to search

Run the following SQL commands to check database version of applications.

Procedure

db2 connect to OPNACT
db2 select DBSCHEMAVER from ACTIVITIES.OA_SCHEMA

db2 connect to BLOGS
db2 "select cast(VALUE as VARCHAR(20)) from BLOGS.roller_properties where name='database.schema.version'"

db2 connect to DOGEAR
db2 select DBSCHEMAVER from DOGEAR.DOGEAR_SCHEMA 

db2 connect to SNCOMM
db2 select DBSCHEMAVER from SNCOMM.SNCOMM_SCHEMA

db2 connect to SNCOMM
db2 select DBSCHEMAVER from CALENDAR.CA_SCHEMA

db2 connect to FILES
db2 select SCHEMA_VERSION from "FILES"."PRODUCT"

db2 connect to PNS
db2 select SCHEMA_VERSION from "PNS"."PRODUCT" 

db2 connect to FORUM
db2 select DBSCHEMAVER from FORUM.DF_SCHEMA

db2 connect to HOMEPAGE
db2 select DBSCHEMAVER from HOMEPAGE.HOMEPAGE_SCHEMA

db2 connect to METRICS
db2 select SCHEMA_VERSION from "METRICS"."PRODUCT"

db2 connect to MOBILE
db2 "select cast(VALUE as VARCHAR(20)) from MOBILE.ROLLER_PROPERTIES where NAME='database.schema.version'"

db2 connect to PEOPLEDB
db2 select DBSCHEMAVER from EMPINST.SNPROF_SCHEMA

db2 connect to WIKIS
db2 select SCHEMA_VERSION from "WIKIS"."PRODUCT" 

Ver também

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Connections:_Checking_Database_Version_of_Applications&oldid=4923"