JR44759: CAPTURE HANGS AND DISPLAYS ASN0057E WITH ERROR "28" IF THERE IS NOT ENOUGH AVAILABLE SPACE TO WRITE A SPILLED ROW

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Capture hangs and displays ASN0057E with error "28" if there is
    not enough available space in the file system to write a spilled
    row. Capture displays "quickCell::freeCell()- ERROR!! :BAD
    numCellsUsed detected!!  PRINTCELLS (quickCell::freeCell() :BAD
    numCellsUsed!!) : (threadId=1029) cellSize=176, blockSize=8192,
    cellsPerBlock=46, nextFree=1118c8e78, firstBlock=1124fda30,
    numBlocks=375, numCellsUsed=-1, numCellsFree=17251] and damages
    it's memory.
    

Local fix

Problem summary

  • Capture termination frees transaction rows from memory. Capture
    hangs after it attempts to free the rows that it already
    spilled and freed.
    

Problem conclusion

  • Capture termination will free only those rows that have not
    already been spilled and freed.
    .
    This fix will be available in DB2 LUW V9.7 FP8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR44759

  • Reported component name

    WS SQL-REPLIC L

  • Reported component ID

    5724N9802

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-13

  • Closed date

    2012-11-13

  • Last modified date

    2012-11-13

  • 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

    WS SQL-REPLIC L

  • Fixed component ID

    5724N9802

Applicable component levels

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Replication Server
SQL replication

Software version:

9.7

Reference #:

JR44759

Modified date:

2012-11-13

Translate my page

Machine Translation

Content navigation