View source for IBM Connections: Checking Database Version of Applications

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 =

* [[IBM Connections:Reorg Connections Databases]]
* [[IBM Connections:Limpeza de diretórios]]

* Mais Artigos sobre IBM Connections [[IBM Connections]]

[[Category:IBM Connections]]
[[Category:Tuning IBM Connections]]