IBM Support

IT16937: PURGEALL DOES NOT REMOVE METADATA FROM BPMV_REINDX TABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer reported large backlog of index 19 million bps and
    documents in total and index was failing. It was decided that
    the customer would run PurgeAll.sh to clean the database but
    after doing this they found the index bp was failing with the
    following error :-
    
    ERROR BPMOvingService:getNumToArchive() ->
    ORA-30036: unable to extend segment by 8 in udo tablespace
    'UNDOTBS1'
    
    We found that the problem was the BPMV_REINDX table had
    962231995 rows within it and this is the first thing the index
    job does is to copy this table to BPMV_REIDX_WRK
    

Local fix

  • AC / AC
    
    STRTC 508847
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    PurgeAll.sh failing with the following error :-
    
    ERROR BPMOvingService:getNumToArchive() ->
    ORA-30036: unable to extend segment by 8 in udo tablespace
    'XXXXXX'
    
    This is caused by BPMV_REINDX table not being cleaned up.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided.
    
    Delivered In:
    5020603
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT16937

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-07

  • Closed date

    2016-12-16

  • Last modified date

    2016-12-22

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R526 PSY

       UP

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5"}]

Document Information

Modified date:
26 September 2021