SQL Queries - CAST Central Base - SQL Queries on Transactions - How to retrieve the list of transactions for a snapshot

Purpose of Query

To retrieve the list of transaction for a snapshot.

Applicable CAST Version

Applicable RDBMS

List of transactions

This query on the central will provide a list of transactions ( replace <snapshot_id> with appropriate snapshot_id). The below query will provide the list of ALL transactions (empty+non-empty)

Select * from dss_object_info where snapshot_id= <snapshot_id> and object_type_id=30002;

Query Result

2;99;30002;0
2;83;30002;0
2;89;30002;0
2;86;30002;0
2;115;30002;0

To get the list of all non-empty transactions, please execute the below query:

Select object_id 
from dss_object_info doi
join dss_link_info dli
 on doi.snapshot_id = dli.snapshot_id
 and dli.link_type_id = 11004
 and dli.previous_object_id = doi.object_id
where doi.snapshot_id= <snapshot_id> 
and object_type_id=30002

Query Result

106
90
107
88
113
95
87
101

Notes/comments

The appropriate snapshot_id can be obtained by running the below query on the central:

select * from dss_snapshots

Related Pages