Can anyone help me with the SQL query or table name where I can see the DDB generation i.e. DDB V4 or V5.
I don't believe there is a value you can query.
It is a combination of factors which tells you if you have V4 or v5.
Can you check the deduplication engine for V10 or v11?
if v11 then check the properties of the ddb, is garbage collection on?
Is it a transactional ddb?
Hi wstbackup,
there is actually a version to query, but it doesn’t really help you as it is all version 4. This is because from a software perspective there is no difference in version number between what we (CV-internally) call v4 and v5. As Jos already explained, the difference is all about the additional options available for “v5” DDBs, which are stored as extended flags in the CommServe database. But these can also be easily checked in the Java GUI (properties of the DDB → Garbage Collection / Pruning Logs enabled or not). You may enable Garbage Collection, and the GUI will deny if the DDB still has the old format.
Hope this helps.
There used to be a report available on CV Cloud named “DDB Conversion Tracker” which queries DDB details and allows you to estimate if a DDB is already using the new (compacted) format which is a prerequisite for Garbage Collection and/or Pruning Log usage, but that report is not publically available anymore. You may open a Support incident to ask for that report as I assume it was just removed from public repository, but it should still be available via our Support.
Regards,
Markus
There is the DDB Dashboard from cloud or webconsole with private metrics that will show you if garbage collection is enabled in one easy to view list.
https://cloud.commvault.com/webconsole/softwarestore/#!/135/664/17874
It doesn’t directly say it’s version but it makes it much quicker to identify who doesn’t currently have garbage collection on, indicating that it’s not v5.
Regards,
Sean
Okay, so in one of our recent case with Support - we accidently came upon this discussion and the technician said this - “ Garbage Collection was initially advertised as V5, but (as far as the database is concerned internally) garbage collection is V4. Horizontal Scaling is technically V5. “
So what are the features other than Garbage Collection & Horizontal Scaling to ensure I am on the most optimized & advanced DDB?
Hi wstbackup,
so, if you are able to enable Garbage Collection and Horizontal Scaling on your DDBs, you should be on the latest and greatest DDB version.
Regards,
Markus
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.