Created by Unknown User (sse_20162) on Feb 11, 2022
Purpose of Query

The query will result the status of a snapshot

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick) 
CSS2(tick) 
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