Ebasso: Criou a página com "Run the following SQL commands to check database version of applications. = Procedure = db2 connect to OPNACT db2 select DBSCHEMAVER from ACTIVITIES.OA_SCHEMA db2 con..."

2018-11-29T17:51:58Z

Criou a página com "Run the following SQL commands to check database version of applications. = Procedure = db2 connect to OPNACT db2 select DBSCHEMAVER from ACTIVITIES.OA_SCHEMA db2 con..."

New page

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]]

IBM Connections: Checking Database Version of Applications - Revision history

Ebasso: Criou a página com "Run the following SQL commands to check database version of applications. = Procedure = db2 connect to OPNACT db2 select DBSCHEMAVER from ACTIVITIES.OA_SCHEMA db2 con..."