admbarry
Newcomer
- Joined
- Mar 1, 2017
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi everyone,
I'm interested to know if there exists a way of identifying entries in the SUMMARY table when querying via the Tivoli Storage Manager Client (Backup and Archive Client/BA Client), which corresponds to an incremental ID (not necessarily in increments of 1) in a traditional database application.
I've inspected the NUMBER property (https://www.ibm.com/developerworks/.../Tivoli Storage Manager/page/Activity Summary), which hints at being the answer, in that the description for this property is: "The identification number that is associated with the activity", but the values of this property don't seem to be incremental - at least not across different dates, i.e. the value seems to be reset from time to time.
What I'm specifically after is a way of querying Spectrum Protect (TSM) for all summaries which are newer than e.g. SUMMARY.ID 1234, e.g.:
select * from summary where upper(activity) in ('ARCHIVE','BACKUP','RESTORE') and upper(number) >= 1235
And say if the highest ID (number) result of the above query is 2345, I could use this value for my next query, i.e.:
select * from summary where upper(activity) in ('ARCHIVE','BACKUP','RESTORE') and upper(number) >= 2346
My current approach is to use the end_time value, so an hourly query performed at 10:00:00 for summaries which have been added since 09:00:00 could be e.g.:
select * from summary where end_time >= '2017-02-21 09:00:00' and upper(activity) in ('ARCHIVE','BACKUP','RESTORE')
… but the problem with this approach is that sometimes TSM writes the summary for an activity several hours after the activity has ended with the correct end_time, which means that a summary with an end_time of e.g. "2017-02-21 09:50:00" which is written at 10:30:00 will not be included in the results when performing the querying at 11:00:00 for summaries which have been added since 10:00:00, e.g.:
select * from summary where end_time >= '2017-02-21 10:00:00' and upper(activity) in ('ARCHIVE','BACKUP','RESTORE')
Hence, being able to use an ID for a previous query as the offset for a new one, would enable delayed summaries to be included in the results.
So I guess I'm specifically asking:
NB: This is a copy (and slight elaboration) of my post from https://www.ibm.com/developerworks/...topic?id=41fb33d0-ae21-4f42-bd15-501670518aab.
I'm interested to know if there exists a way of identifying entries in the SUMMARY table when querying via the Tivoli Storage Manager Client (Backup and Archive Client/BA Client), which corresponds to an incremental ID (not necessarily in increments of 1) in a traditional database application.
I've inspected the NUMBER property (https://www.ibm.com/developerworks/.../Tivoli Storage Manager/page/Activity Summary), which hints at being the answer, in that the description for this property is: "The identification number that is associated with the activity", but the values of this property don't seem to be incremental - at least not across different dates, i.e. the value seems to be reset from time to time.
What I'm specifically after is a way of querying Spectrum Protect (TSM) for all summaries which are newer than e.g. SUMMARY.ID 1234, e.g.:
select * from summary where upper(activity) in ('ARCHIVE','BACKUP','RESTORE') and upper(number) >= 1235
And say if the highest ID (number) result of the above query is 2345, I could use this value for my next query, i.e.:
select * from summary where upper(activity) in ('ARCHIVE','BACKUP','RESTORE') and upper(number) >= 2346
My current approach is to use the end_time value, so an hourly query performed at 10:00:00 for summaries which have been added since 09:00:00 could be e.g.:
select * from summary where end_time >= '2017-02-21 09:00:00' and upper(activity) in ('ARCHIVE','BACKUP','RESTORE')
… but the problem with this approach is that sometimes TSM writes the summary for an activity several hours after the activity has ended with the correct end_time, which means that a summary with an end_time of e.g. "2017-02-21 09:50:00" which is written at 10:30:00 will not be included in the results when performing the querying at 11:00:00 for summaries which have been added since 10:00:00, e.g.:
select * from summary where end_time >= '2017-02-21 10:00:00' and upper(activity) in ('ARCHIVE','BACKUP','RESTORE')
Hence, being able to use an ID for a previous query as the offset for a new one, would enable delayed summaries to be included in the results.
So I guess I'm specifically asking:
- Is there an incremental identifier for summaries?
- If the "NUMBER" property is the way to go, how reliable is it? E.g. how often does it reset (which seems to be the case).
NB: This is a copy (and slight elaboration) of my post from https://www.ibm.com/developerworks/...topic?id=41fb33d0-ae21-4f42-bd15-501670518aab.