REORG PLUS for DB2 - BMC50205I UNEXPECTED SQL ERROR.  SQLCODE = -904, STMTID = 'SSTRACKING’

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    REORG PLUS for DB2


    COMPONENT:

    REORG PLUS for DB2



    QUESTION:

    Getting message BMC50205I UNEXPECTED SQL ERROR.  SQLCODE = -904, STMTID = 'SSTRACKING’
    Followed by message BMC50199I REORG PLUS PROCESSING CONTINUES
    What is STMTID = 'SSTRACKING’ referring to?
     


    ANSWER:

    SSTRACKING refers to the BMCUTIL.CMN_BMCSSTRACK table. 
    Display the status of the associated tablespace (BMCUTIL.BMCSSTTS) to verify it is in RW status and not in an unavailable status (e.g., COPY PENDING). 
    If in an unavailable status, take whatever action is necessary to put it in RW status.

    NOTE: the BMC50205I message is only informational and will not affect the REORG Plus job as noted in message BMC50199I.
     


    Article Number:

    000188663


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles