IC76049: DB2 VIEWS CANNOT BE USED ON DB2 9.7 AND TPC 4.2.1.163

4.2.1 Interim Fix 1 (November 2011) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• TPC 4.2.1.163  on Win 2k3
  
  
  Problem with DB2 views, when trying to create some custom
  reports
  using DB2 views and these gave an error.
  
  Gets a pop up message saying:-
  
  DB2 Message
  
  DBAINTRN
  
  com.ibm.db.DateException: A database managed error occurred. :
  [IBM]{CLI Driver][DB2/NT] SQL0811N The result of a scalar
  fullselect,
  SELECT INOT statement, or VALUES INTO statement is nore than one
  row.
  SQLSTATE=21000
  
  
  
  The DB2 views mostly worked, but 4 failed:-
  
  - TPC_GROUP2ENTITY
  - TPC_GROUP2ENTITY_SNAPSHOT
  - TPC_GROUP2ENTITYNESTED
  - TPC_GROUP2ENTITYNESTED_SNAPSHOT
  

Local fix

• Contact support for getting the fix
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC 4.2.1 users using DB2 views to create    *
  *                 custom reports                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• The views have been corrected to avoid this error.  The fix
  for this APAR is targeted for the following maintenance
  package:
  
  | fix pack | 4.2.1-TIV-TPC-FP0003 - target June 2011
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix packs do not represent a formal
  commitment by IBM. The dates are subject to change without
  notice.
  

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:

Fix information

• Fixed component name

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R42A PSY

     UP

• R42L PSY

     UP

• R42W PSY

     UP