PI79104: DELETING LARGE RESULTS WITH ORACLE FAILS: UNABLE TO EXTEND UNDO TABLESPACE

Rational Integration Tester Fix Pack 1 (9.1.0.1) for 9.1
Rational Test Virtualization Server Fix Pack 1 (9.1.0.1) for 9.1
Rational Performance Test Server Fix Pack 1 (9.1.0.1) for 9.1

APAR status

• Closed as program error.

Error description

• Attempts to delete results can fail with the following error:
  
  ORA-30036: unable to extend segment by 8 in undo tablespace
  'UNDOTBS2'
  
  The data is deleted in one operation.  This can lead to a large
  amount of storage being required in the undo tablespace to allow
  for the transaction to be aborted.
  It might not be possible to extend the undo tablespace.
  
  WORKAROUNDS:
  
  Increase the undo tablespace.
  
  OR
  
  Delete smaller amounts of data in multiple operations using less
  undo tablespace.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users attempting to delete very large amounts of         *
  * results.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Deleting results could fail as database REDO logs filled up. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to version 9.1.0.1.                                  *
  ****************************************************************
  

Problem conclusion

• Upgrade to version 9.1.0.1.
  The newer IntegrationTesterCmd deletes data in a series of
  smaller tasks.
  This might result in deletions taking longer, but less REDO
  space is required.
  

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

  RATL INTEGRA TE

• Fixed component ID

  5725G79IT

Applicable component levels

• R800 PSN

     UP

• R800 PSY

     UP

• R801 PSN

     UP

• R850 PSN

     UP

• R851 PSN

     UP

• R860 PSN

     UP

• R870 PSN

     UP

• R871 PSN

     UP

• R900 PSN

     UP

• R901 PSN

     UP

• R901 PSY

     UP