The BAR GUI does not expand the tablespace list for DB2 instances with lifeLSN

Article:TECH215626  |  Created: 2014-03-07  |  Updated: 2014-03-14  |  Article URL http://www.symantec.com/docs/TECH215626
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



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.


Error



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:
"db2tst",...
"db2prd",...

$ bpubsdb2 -b DB2:db2prd:
"PRD",...

$ bpubsdb2 -b DB2:db2prd:PRD:
"0",...

$ bpubsdb2 -b DB2:db2prd:PRD:0:
"Table Spaces",...

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:"
"SYSCATSPACE",...
"SAPEVENTMON",...
"SAPTOOLS",...

...snip...

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"?>
<Start Iteration="DB2:db2prd:PRD:0:Table%20Spaces:">

...snip...
 <Tablespace>
  <NBU>
   <NAME>SAPEVENTMON</NAME>
   <TOTAL_SIZE>52428800</TOTAL_SIZE>
   <PLUGIN>db2</PLUGIN>
  </NBU>
  <db2>

   ...snip...
   <lifeLSN>&#2;&#23;:\302\255\303\251\302\261</lifeLSN>
   ...snip...


Environment



NetBackup 7.0 - 7.6


Cause



IBM modified the format of the lifeLSN from 6 bytes to 8 bytes and NetBackup needs an update to handle the new format.


Solution



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 (7.6.0.3)

When NetBackup 7.6.0.3 is released, please visit this link for download and README information:
 http://go.symantec.com/nb

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.

References:
More information on this issue is available from IBM at the following link:

DB2 Version 9.7 Upgrade impact for DB2 API changes
 http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.qb.upgrade.doc/doc/r0053467.html


Supplemental Materials

SourceETrack
Value3390394
Description

(primary) Cannot browse DB2 tablespaces for certain instances via the BAR GUI



Article URL http://www.symantec.com/docs/TECH215626


Terms of use for this information are found in Legal Notices