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