New infinity value for NetBackup images affects OpsCenter custom SQL query building
Starting with NetBackup 9.0, the infinity value that is used to indicate that NetBackup images never expire is changed from 2147483647 to 32535212400.
The OpsCenter equivalent of these values is a value of 143667764470000000 for old infinity in NetBackup (2147483647) and a value of 447545052000000000 for new infinity in NetBackup (32535212400).
Infinity Value | NetBackup | OpsCenter | ISO-8601 |
|---|---|---|---|
Old | 2147483647 | 143667764470000000 | 2038-01-19T03:14:07.000Z |
New | 32535212400 | 447545052000000000 | 3000-12-31T23:00:00.000Z |
This change in the infinity value impacts the OpsCenter data collection of NetBackup images. If OpsCenter monitors or reports on NetBackup master servers 9.0 or later, the value that indicates the infinity is now 447545052000000000 - the new infinity value - for the following OpsCenter database columns:
expirationTime, resumeExpiration, tirExpiration from the domain_Image table
expirationTime from the domain_ImageCopy table
expirationTime from the domain_ImageFragment table
requiredExpirationDate from the domain_SLPImage table
If you use any of these database columns in your custom SQL queries with old infinity values (143667764470000000), you need to consider "OR"ing your query with new infinity value (447545052000000000) for NetBackup master servers 9.0 or later.
Note that the old infinity values will remain unchanged for the master servers earlier than 9.0. Therefore, if OpsCenter monitors or reports on master servers earlier than 9.0 only, the infinity value changes do not impact OpsCenter 9.0 or later.
For more information, see the NetBackup OpsCenter Administrator's Guide.