Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

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
    ------------------------------

    #Informix