Informix

nested-group-icon.png

DB2

index datakey issue after an onload restore to a similar server 14.10

  • 1.  index datakey issue after an onload restore to a similar server 14.10

    Posted Tue November 24, 2020 06:26 AM
    Hi,

    We have some issue after we restored the database server to our test server with onload utility.
    We get some error from oncheck -cix database.

    Validating indexes for database:ownere.table1...
    Index 1013_4917
    Index fragment partition datadbs in DBspace datadbs
    ERROR: Bad key information in TBLspace description.

    Validating indexes for database:ownere.table2...
    Index namedidx
    Index fragment partition datadbs in DBspace datadbs
    ERROR: Bad key information in TBLspace description.

    We checked the source database with oncheck but we cant found any problem there.
    I have no idea what could cause such an error after restoreing.the database. The database contain lot of fragmented table and the error occurred after the introduction of a large number of table fragmentations. Maybe the fragmantation is the root reason.

    Does anyone have any idea what might be causing this?



    ------------------------------
    Gábor Fekete
    Software Engineer
    Capital Systems
    Budapest
    ------------------------------