Topic
  • 5 replies
  • Latest Post - ‏2012-04-29T17:39:02Z by SystemAdmin
SystemAdmin
SystemAdmin
1143 Posts

Pinned topic Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

‏2012-04-25T17:00:54Z |
How can I uninstall ol_informix1170 cleanly, I dont want to install as ol_informix1170_1 since restore wont work.

Scenario:
I have configured ontape backups and it is working fine. Now I have to test restore scenario on another machine - dont want to wait till this system crashes to know what it takes to restore :)

So I copied L0, L1, L2 physical backup files and also the logical files (after L0) on another server and renamed the backup files according to this machine server name and hostname. I realized that restore (ontape -r) wont work if the editions are different. Original server is IDS 11.70.FC3IE and where I am trying to restore is IDS 11.70.FC4W1. OS is same, both are 64 bit machines, IDS versions are same, isn't a minor edition difference supposed to be compatible! Someone please push this for enhancement.

Anyways, so I uninstalled IDS from the new machine to match the edition. Now when I go to install it is installing on ol_informix1170_1 which I dont want. Because this will create a different directory structure and restore will fail.

I deleted the Informix installation directory and also deleted entries from windows registry, still when I start a new install it is trying to install to ol_informix1170_1. Where else do I need to clean the entries for an old ol_informix1170 installation?

OS is Windows Server 2008.
Updated on 2012-04-29T17:39:02Z at 2012-04-29T17:39:02Z by SystemAdmin
  • andreasl
    andreasl
    372 Posts

    Re: Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

    ‏2012-04-26T06:20:07Z  
    Hi,

    if I'm reading this right there should be no need to "uninstall" ol_informix1170.

    What you install or un-install is the database server software while ol_informix1170 (or its *_1 counterpart) rather refer to a configured database server instance.
    Ideally you'd just install the new (right) version and omit creating a new server instance, then your existing ol_informix1170 should just continue to be usable - with the new software binaries.

    Now that you've already deleted, from file system and registry, you should be free to do what you want - and old remaining registry contents hopefully just would be re-used and aren't in your way.

    Btw. ontape backups aren't sensitive at all to which server they originate from or are restored to, both with regards to host and to db server name - only the server version must match (I'm not sure how closely).

    HTH,
    Andreas
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

    ‏2012-04-26T06:40:36Z  
    • andreasl
    • ‏2012-04-26T06:20:07Z
    Hi,

    if I'm reading this right there should be no need to "uninstall" ol_informix1170.

    What you install or un-install is the database server software while ol_informix1170 (or its *_1 counterpart) rather refer to a configured database server instance.
    Ideally you'd just install the new (right) version and omit creating a new server instance, then your existing ol_informix1170 should just continue to be usable - with the new software binaries.

    Now that you've already deleted, from file system and registry, you should be free to do what you want - and old remaining registry contents hopefully just would be re-used and aren't in your way.

    Btw. ontape backups aren't sensitive at all to which server they originate from or are restored to, both with regards to host and to db server name - only the server version must match (I'm not sure how closely).

    HTH,
    Andreas
    There was an entry for "ol_informix1170" in services file at this location:
    C:\Windows\System32\drivers\etc\services

    We deleted this entry and installation was fine on "ol_informix1170"

    Now when I run ontape -r, I am getting this error:

    Physical restore failed - ONCONFIG ROOTPATH: 'E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000' differs from archive: 'e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000'
    Correct ONCONFIG before restoring this archive.

    Oh, I have found "ontape -r" very very sensitive to the location of the folder, same drive, same short name (PROGRA~1), we had to struggle a lot because of this. And now we are getting this error since case of "E:" looks different. What is the way out of this?
  • andreasl
    andreasl
    372 Posts

    Re: Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

    ‏2012-04-26T07:01:58Z  
    There was an entry for "ol_informix1170" in services file at this location:
    C:\Windows\System32\drivers\etc\services

    We deleted this entry and installation was fine on "ol_informix1170"

    Now when I run ontape -r, I am getting this error:

    Physical restore failed - ONCONFIG ROOTPATH: 'E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000' differs from archive: 'e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000'
    Correct ONCONFIG before restoring this archive.

    Oh, I have found "ontape -r" very very sensitive to the location of the folder, same drive, same short name (PROGRA~1), we had to struggle a lot because of this. And now we are getting this error since case of "E:" looks different. What is the way out of this?
    I'd assume renamed restore can help you out of this. Look at ontape's -rename option, e.g. here.
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

    ‏2012-04-26T09:15:10Z  
    • andreasl
    • ‏2012-04-26T07:01:58Z
    I'd assume renamed restore can help you out of this. Look at ontape's -rename option, e.g. here.
    I created a file to rename the dbspaces but now ontape got hanged, there was no activity on the CPU for 15 mins.

    I created the listfile.txt like it is listed below. I typed the command onstat –d on both servers and it was showing offset to be 0 for all the dbsapces. Hence in listfile.txt all offsets are 0 for both old and new dbsapces, hope this should be fine?

    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\plogdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\plogdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\llogdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\llogdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\datadbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\datadbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\sbspace.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\sbspace.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\tempdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\tempdbs.000 0

    Then I fired the command. Please find attached the output of that command.
    ontape -r -rename -f listfile.txt

    what do I do next :(
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: Uninstall ol_informix1170 cleanly, dont want to install ol_informix1170_1

    ‏2012-04-29T17:39:02Z  
    I created a file to rename the dbspaces but now ontape got hanged, there was no activity on the CPU for 15 mins.

    I created the listfile.txt like it is listed below. I typed the command onstat –d on both servers and it was showing offset to be 0 for all the dbsapces. Hence in listfile.txt all offsets are 0 for both old and new dbsapces, hope this should be fine?

    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\rootdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\plogdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\plogdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\llogdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\llogdbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\datadbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\datadbs.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\sbspace.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\sbspace.000 0
    e:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\tempdbs.000 0 E:\PROGRA~1\IBM\Informix\11.70\OL_INF~1\dbspaces\tempdbs.000 0

    Then I fired the command. Please find attached the output of that command.
    ontape -r -rename -f listfile.txt

    what do I do next :(
    onstat -mr revealed more secrets ...

    09:08:43 Warning: stat() failed for chunk file E:/Program Files/IBM/Informix/11.70/ol_informix1170/dbspaces/tempdbs1.000
    09:08:43 Warning: stat() failed for chunk file E:\Program Files\IBM\Informix\11.70\ol_informix1170\dbspaces\llogdbs.100
    09:08:43 oninit: Fatal error in shared memory initialization
    09:08:43 IBM Informix Dynamic Server Stopped.

    IDS did not start after that, I uninstalled and installed IDS.

    Now I had to add two more chunks:
    onspaces -c -d tempdbs1 -p "E:/Program Files/IBM/Informix/11.70/ol_informix1170/dbspaces"/tempdbs1.000 -s 1024000 -o 0
    onspaces -a logdbs -p "E:\Program Files\IBM\Informix\11.70\ol_informix1170\dbspaces\llogdbs.100" -o 0 -s 455500

    Created logical log spaces and chunks
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900
    onparams -a -d logdbs -s 64900

    Issued this command again now and restore worked fine :) Phew!!!

    ontape -r -rename -f listfile.txt