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

Mais Artigos sobre IBM Connections IBM Connections