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
Expand all | Collapse all

Trying to recover a 11/50 TC3 32 bits instance

  • 1.  Trying to recover a 11/50 TC3 32 bits instance

    Posted Wed September 06, 2023 12:06 PM

    Hi folks

     

     

    Still struggling with the attempts to recover that customer's full instance ( see my last message about archecker issues)

     

    Making it short, big disaster with my customer's storage. After a few days we remain with 2 possible directions to recover something

     

    1. They could retrieve ontape -s backup files, but each of them does not succeed to be restored because, I think, the first part of ontape -r says that TAPESIZE is 2 Gb although the media's size in 90 Gb ish. When restoring, ontape requests to insert the new tape (I would understand here that after reading 2gb as per said by TAPESIZE, it needs another 'piece'). So basically, the restore fails
    2. They could retrieve chunk files backups ( and there are tons of them because they didn't know that a chunk could be bigger than 2 Gb...)
      Those backups have been done the cold method, i.e IDS shut down. Supposedly, with the right ONCONFIG file, this should restart.
      The problem is that it does not find the root dbspace chunk, although I checked that the chunks files were present on the server.
      Here is the message
      05:52:12  Warning: stat() failed for chunk file Z:\IFMXDATA\ol_opvnt50_rpro_1\rootdbs_dat.000

    05:52:12  Cannot Open Primary Chunk 'Z:\IFMXDATA\ol_opvnt50_rpro_1\rootdbs_dat.000', errno = 2

    05:52:12  oninit: Fatal error in shared memory initialization

    So:

    1. About the missing file:
      I understand that errno = 2 means file not found, but I confirmed the file is there.
      AFAIK, windows does not require specific permissions for the chunks files, like chmod and chown...
      Any Idea ?
    2. About the failing ontape -r I think it does fail because ontape understands the backup media is sliced in 2Gb pieces, although it is not. This 2gb tapesize is written in the backup media, although the onconfig parameter says 0 (unlimited).
      a) should I hit some restriction of the 32 bits version of IDS? Or is this a product defect (I know it's an old version...)
    3. With the 'support tools', would it be possible to write TAPESIZE=0 or whatever convenient value in the backup media file ?
      Any additional ideas ?


    Thanks for your lights

     

    Eric

     

     

    Eric Vercelletto
    Data Management Architect and Owner / Begooden IT Consulting
    KandooERP Founder and CTO
    IBM Champion 2013,2014,2015,2016,2017,2018,2019,2020
    ibm-champion-rgb-130px

    Tel:     +33(0) 298 51 3210
    Mob : +33(0)626 52 50 68
    skype: begooden-it
    Google Hangout: eric.vercelletto@begooden-it.com
    Email:
    eric.vercelletto@begooden-it.com
    www :
    http://www.vercelletto.com
    www  https://kandooerp.org

     

     



  • 2.  RE: Trying to recover a 11/50 TC3 32 bits instance

    Posted Wed September 06, 2023 01:08 PM
    File access rights for the informix User to the location ?
    Informix switches to different account typically, should be the same in Windows 

    Marcus 

    Gesendet von Outlook für Android