JR32606: APAR FOR V95FP5 ADMIN FIXES

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• APAR for V95FP5 ADMIN FIXES
  

Local fix

• APAR for V95FP5 ADMIN FIXES
  

Problem summary

• Defect: wsdbu00543056
  User Affected: Q Replication users
  Problem Description: Create capture control tables fail on zOS:
  RC doesn't show the panel where the user can choose the database
  Problem Summary: There are several variants of JDBC app/jcc
  product name the program needs to handle during a test of the
  connection, one of which was not getting recognized.
  Problem Conclusion: All variants of z/OS JDBC app/jcc product
  names are now recognized during connection test/verification.
  
  Defect: wsdbu00541237
  User Affected: SQL Replication users
  Problem Description: Unable to delete member from subscription
  set: SQL Replication
  Problem Summary: Unable to delete a member from a subscription
  set.  On the "Delete Members from Subscription set"  unable to
  display the contents of the member information tab.
  Problem Conclusion: Fixed the initialization of the UI tabs, so
  that the code is not trying to access the member tab that has
  not yet been created.
  
  Defect: wsdbu00538278
  User Affected: Q Replication users
  Problem Description: RC Problem with Mass Q Subscriptions on
  "How should target tables be loaded?"  current default for Load
  Nickname
  Problem Summary: The multiple Q Subscription case should be the
  same as the single subscription case.
  Problem Conclusion: Fixed so that the default for mass Q
  subscriptions should be "do not use nickname" (which aligns with
  the default for doing a single Q subscription).
  
  Defect: wsdbu00540347
  User Affected: Q Replication users
  Problem Description: Issues with Validate expressions panel
  Problem Summary: If using the validate button on an expression
  that should be invalid, there is an validation successful
  message. And, when validating a valid expression, an ASN0777I
  message is displayed when there should be a Validation
  Successful message.
  Problem Conclusion: Fixed the processing of the validate button
  on the expressions dialog available on the mapping columns
  dialog.
  V95FP5 JR32606
  ============
  
  Defect: wsdbu00540345
  User Affected: Q Replication users
  Problem Description: Validate key disabled when editing an
  existing expression
  Problem Summary: When editing an expression the Validate button
  is disabled.
  Problem Conclusion: The Validate button is now enabled only when
  there is text in the expression text box.
  
  Defect: wsdbu00538281
  User Affected: SQL Replication users
  Problem Description: When creating monitor control tables, the
  default file size (5MB) for a table space is too small
  Problem Summary: The default table space size for monitor
  control tables is not large enough where the user may experience
  "SQL0289N Unable to allocate new pages in table space
  'REPLMONTS1'"
  Problem Conclusion: Fix required changing default table space
  size for monitor control tables to 10MB.
  
  Defect: wsdbu00538279
  User Affected: Q Replication users
  Problem Description: ASN0999E error message is displayed when a
  MQ queue manager doesn't exist
  Problem Summary: RC did not handle the case where the MQ queue
  manager was not defined.
  Problem Conclusion: When there are no queue managers defined,
  there will be an appropriate message in a message dialog.
  
  Defect: wsdbu00537926
  User Affected: Q Replication users
  Problem Description: for type 4 connection, both alias and
  (classic) data source name need to be persisted
  Problem Summary: There may be cases when the alias and the data
  source name are not the same (the data source name may be longer
  than the 8 character alias name)
  Problem Conclusion: Don't assume the alias and database source
  name are the same, save both.
  
  Defect: wsdbu00535770
  User Affected: Q Replication users
  Problem Description: When a new user creates an Apply control
  table, RC hangs when trying to determine available schema
  Problem Summary: RC infrequently hangs when assessing available
  schemas for the Apply control table.
  Problem Conclusion: Rewrote the code so that there was no longer
  a problem with an intermittent hang when RC is trying to
  discover available schemas for the Apply control table.
  
  Defect: wsdbu00547308
  User Affected: Q Replication users
  Problem Description: Handle an incomplete Q Subscription when in
  the "Manage Q Subscriptions" dialog
  Problem Summary:
  Problem Conclusion:
  
  
  wsdbu00565265 Stop Ship: Creating incorrect nickname for DONEMSG
  table in ORACLE
  Description:  The Nickname created for the donemsg table is not
  correct.  This is a regression caused from another defect.
  Solution: Fixed the error to create nickname correctly.
  
  wsdbu00546521  retro fit of JCC driver support in V95FP5 from
  COBRA
  Description:  The legacy driver is deprecated and so admin will
  use the JCC driver to connect databases instead of the legacy
  driver
  Solution: Changed the code to use JCC driver.
  
  wsdbu00568010 Create a view on new ibmqrep_donemsg table for
  teradata targets
  Description: There is a performance problem with teradata
  targets with pruning of the donemsg table.
  Solution: Create a view on the donemsg table and the donemsg
  nickname is created on the view.
  
  wsdbu00545794  Oracle targets - Alter statements of CCD nickname
  for IBMSNAP_COMMITSEQ and IBMSNAP_INTENTSEQ are not correct
  Description: Create Q Subscription for oracle target is not
  generating alter statemetns of the columns ibmsnap_commiseq and
  ibmsnap_intentseq if the target is CCD.
  Solution: Generate Alter Nickname statements to alter the
  columns.
  

Problem conclusion

• fixed in this FP
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IC64005 IC64079 IC64104 IC64125

Fix information

• Fixed component name

  WS Q-REPLIC LUW

• Fixed component ID

  5724N9801

Applicable component levels

• R950 PSY

     UP