The GUI displays all of the DB2 instances and can expand the tablespace list for the pre-9.7 instances, but cannot display the tablespaces for some DB2 9.7 instances.
Scheduled backups are running and continue to be successful.
The BAR GUI uses the bpubsdb2 command to query for the elements to be displayed. In this situation, the command will list the instances and other objects that were displayed successfully in the GUI.
$ /usr/openv/netbackup/bin/bpubsdb2 -b DB2:
$ bpubsdb2 -b DB2:db2prd:
$ bpubsdb2 -b DB2:db2prd:PRD:
$ bpubsdb2 -b DB2:db2prd:PRD:0:
But the command to display the tablespaces does not produce any output; hence the lack of update in the GUI.
$ bpubsdb2 -b "DB2:db2prd:PRD:0:Table Spaces:"
The tablespaces for other instances can be displayed, e.g.:
$ bpubsdb2 -b "DB2:db2tst:TST:0:Table Spaces:"
The interface between bpubsdb2 and DB2 is the nbbrowse command, which shows that the tablespace list that cannot be displayed contains a lifeLSN (Log Sequence Number). Instances without any tablespaces that contain a lifeLSN can be expanded successfully in the GUI:
$ nbbrowse -xmloutput "DB2:db2prd:PRD:0:Table Spaces:"
<?xml version="1.0" encoding="utf-8"?>
IBM modified the format of the lifeLSN from 6 bytes to 8 bytes and NetBackup needs an update to handle the new format.
The change to the format of lifeLSN does not affect backup and restore operations, it only affects the ability to browse table spaces when creating a new NetBackup for DB2 backup or restore template. Backup and restore operations using scripts, command lines, and existing templates are not affected and can continue to be used.
ETA of Fix:
Symantec Corporation has acknowledged that the above-mentioned issue (Etrack 3390394) is present in the current version(s) of the product(s) mentioned in this article. Symantec Corporation is committed to product quality and satisfied customers. This issue was scheduled to be addressed in the following release:
- NetBackup 7.6 Maintenance Update 3 (126.96.36.199)
When NetBackup 188.8.131.52 is released, please visit this link for download and README information:
Please note that Symantec Corporation reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests or introduces new risks to overall code stability. Symantec's plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.
More information on this issue is available from IBM at the following link:
DB2 Version 9.7 Upgrade impact for DB2 API changes
NetBackup 7.0 - 7.6