Purpose of Query
The purpose of this query is to check a database and determine its type (management, central, local).
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| CSS | |
Query for CSS
SELECT
CASE PACKAGE_NAME
WHEN 'BASE_LOCAL'
THEN 'Local'
WHEN 'ADG_FULL_CENTRAL'
THEN 'Central'
WHEN 'PMC_MAIN'
THEN 'Management'
ELSE 'P'
END AS DATABASETYPE,
VERSION
FROM SYS_PACKAGE_VERSION
WHERE PACKAGE_NAME IN ('BASE_LOCAL' ,
'ADG_FULL_CENTRAL',
'PMC_MAIN')
Query result example
"Central";"8.0.0.1"
Query result interpretation
The query will determine if the databases is a local central or management database and provide that information in the first column and then provide the version in the second column.
Notes/comments
Related Pages
