SQL Queries - CAST Central Base - Queries on snapshots - How to check the status of a snapshot

Purpose of Query

The query will result the status of a snapshot

Applicable in CAST Version

Applicable RDBMS

Query for CSS

Check the value of the column ‘SNAPSHOT_STATUS’.

The values of this column could be 0 or 1 or 2. Their description is as under

If SNAPSHOT_STATUS = 0, then the snapshot is empty.

If SNAPSHOT_STATUS = 1, then the snapshot is in progress.

If SNAPSHOT_STATUS = 2, then shapshot has been run and is consolidated successfully.

So if the value of the SNAPSHOT_STATUS is other than 2, then it has not consolidated sucessfully.

Select * From DSS_SNAPSHOTS order by 1

Query result example

-1;-1;“2016-03-16 00:00:00”;3;“Computed on 201603161134”;"";“2016-03-16 11:39:15.176”;“2016-03-16 11:39:16.014”;"";0;0;0
1;3;“2016-03-09 00:00:00”;3;“Computed on 201603091112”;"";“2016-03-09 11:16:35.346”;“2016-03-09 11:15:56.692”;“2016-03-09 11:17:04.896”;2;0;1
1;3;“2016-03-09 00:00:00”;3;“Computed on 201603091112”;"";“2016-03-09 11:16:35.346”;“2016-03-09 11:15:56.692”;“2016-03-09 11:17:04.896”;2;0;1
2;1501;“2016-03-14 00:00:00”;3;“Computed on 201603141221”;"";“2016-03-14 12:24:32.979”;“2016-03-14 12:24:00.306”;“2016-03-14 12:25:12.098”;2;0;2
2;1501;“2016-03-14 00:00:00”;3;“Computed on 201603141221”;"";“2016-03-14 12:24:32.979”;“2016-03-14 12:24:00.306”;“2016-03-14 12:25:12.098”;2;0;2

Query result interpretation

This query will give the information on the snapshot status

Query for Oracle

Same as CSS2

Query result example

Query result interpretation

Query for SQL server

Same as CSS2

Query result example

Query result interpretation

Notes/comments

Related Pages