+2Hi,
I hope this would be a quick and easy question. Is there any report that show me the list of jobs pruned in a data aging task in a specific time?
I read this topic and be able to view what is to be pruned, but what was pruned yesterday by example?
Thanks
Best answer by Mike Struening RETIRED
Hi
We do not have that ability to show this in a report. However, Inside the SQL table called JMJobDataStats and a column that references "agedBy" and depending what code is displayed, translates to how the job was aged.
The AGED_BY flags for the agedBy column in archChunk, archChunkMapping, archFileCopy and JMJobDataStats tables.
CVA_AGED_BY_RULES 512
CVA_AGED_BY_PRUNE_JOB 1024
CVA_AGED_BY_DEL_ARCHFILE 2048
CVA_AGED_BY_DEL_CONTENT 4096
CVA_AGED_BY_OVERWRITE 8192
CVA_AGED_BY_KILL_FAIL 16384
CVA_AGED_BY_SPOOL_AGING 32768
CVA_AGED_BY_WATER_MARK 65536
CVA_AGED_BY_RECOPY_MEDIA 131072
CVA_AGED_BY_UTILITY 262144
CVA_AGED_BY_DANGLING 524288
CVA_AGED_BY_DEL_APP 1048576
CVA_AGED_BY_CLEANJOBCOPYWITHOUTAF 2097152
CVA_AGED_BY_SILOPRUNING 4194304
CVA_AGED_BY_EXTERNALPRUNING 8388608
CVA_AGED_BY_SNAPPRUNING 16777216
CVA_AGED_BY_CLEAN_AGED_MEDIA 33554432
CVA_AGED_BY_TAPE_IMPORT 67108864
CVA_AGED_BY_MEDIA_REFRESHING 134217728
CVA_AGED_BY_DEL_POLICY_COPY 268435456
CVA_AGED_BY_FOREIGN_JOB_DISCOVERY 536870912
CVA_UNAGED_JOB 1073741824
CVA_AGED_BY_DEL_INVALID_CHUNKS 2147483648
CVA_AGED_BY_TRANSITIVE_COPY_SRC_DEL 4294967296
CVA_AGED_BY_INDEX_PRUNING 8589934592
CVA_AGED_BY_AUXCOPY 17179869184
CVA_AGED_BY_COMBINEDSTREAM 34359738368
CVA_AGED_BY_RECOPY 68719476736
CVA_AGED_BY_EDGE_SYNTHFULL 137438953472
Let me know if that helps!
+23Hi
We do not have that ability to show this in a report. However, Inside the SQL table called JMJobDataStats and a column that references "agedBy" and depending what code is displayed, translates to how the job was aged.
The AGED_BY flags for the agedBy column in archChunk, archChunkMapping, archFileCopy and JMJobDataStats tables.
CVA_AGED_BY_RULES 512
CVA_AGED_BY_PRUNE_JOB 1024
CVA_AGED_BY_DEL_ARCHFILE 2048
CVA_AGED_BY_DEL_CONTENT 4096
CVA_AGED_BY_OVERWRITE 8192
CVA_AGED_BY_KILL_FAIL 16384
CVA_AGED_BY_SPOOL_AGING 32768
CVA_AGED_BY_WATER_MARK 65536
CVA_AGED_BY_RECOPY_MEDIA 131072
CVA_AGED_BY_UTILITY 262144
CVA_AGED_BY_DANGLING 524288
CVA_AGED_BY_DEL_APP 1048576
CVA_AGED_BY_CLEANJOBCOPYWITHOUTAF 2097152
CVA_AGED_BY_SILOPRUNING 4194304
CVA_AGED_BY_EXTERNALPRUNING 8388608
CVA_AGED_BY_SNAPPRUNING 16777216
CVA_AGED_BY_CLEAN_AGED_MEDIA 33554432
CVA_AGED_BY_TAPE_IMPORT 67108864
CVA_AGED_BY_MEDIA_REFRESHING 134217728
CVA_AGED_BY_DEL_POLICY_COPY 268435456
CVA_AGED_BY_FOREIGN_JOB_DISCOVERY 536870912
CVA_UNAGED_JOB 1073741824
CVA_AGED_BY_DEL_INVALID_CHUNKS 2147483648
CVA_AGED_BY_TRANSITIVE_COPY_SRC_DEL 4294967296
CVA_AGED_BY_INDEX_PRUNING 8589934592
CVA_AGED_BY_AUXCOPY 17179869184
CVA_AGED_BY_COMBINEDSTREAM 34359738368
CVA_AGED_BY_RECOPY 68719476736
CVA_AGED_BY_EDGE_SYNTHFULL 137438953472
Let me know if that helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
