+2
Hi,
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
View original
+23
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
