Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: bad page problem

    I am trying to migrate data from ids 7.23 to IDS 7.31 using high performance loader for the larger tables. One table has a bad page which only affects 4 records. I have identified the rowid's of the last good record before the inconsistency, and also the rowid of the first good record after it. When I extract the data using rowid (to avoid the bad page) I find that I get a successful extract BUT with about 4.5 million records missing from the 29 million total [they are not in the bad page]. I can see these records within the ERP application but cannot select them within dbaccess or HPL (.
    Is it possible for records to exist in a table without a valid rowid?
    I am using the ERP application to copy missing records to a parallel, consistent table as a very slow last resort.


  2. #2
    Join Date
    Jan 2003

    Exclamation Distributed query


    Maybe you can put the old and new server in a network
    and perform a distributed query

    database newdb@newserver;

    insert into table
    select * from olddb@oldserver:table;

    Make sure the user you are doing this with on the newserver is trusted on the oldserver.

    Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts