IBM Support

WISS error during the onbar backup with ISM



Solution for WISS error during the onbar backup with ISM.


Following an operating system crash or the installation of an operating system patch, IBM Informix Storage Manager (ISM) fails to start and the following error appears in the daemon.log:

09/02/02 07:38:18 nsrd: server notice: started
09/02/02 07:38:19 nsrexecd: Can't initialize
                   configuration file
09/02/02 07:38:19 nsrexecd: SYSTEM error, resource
                   file /nsr/res/nsrla.res already
                   in use; check for another copy of
                   this server already running
09/02/02 07:38:19 nsrexecd: error initializing
                   resource file.
09/02/02 07:38:19 nsrmmdbd: error adding btrees to
                   ss (an invalid slot number)
09/02/02 07:38:19 nsrmmdbd: WISS error, an invalid
                   slot number
09/02/02 07:38:19 nsrd: unable to start nsrmmdbd
09/02/02 07:38:19 nsrd: shutting down
09/02/02 07:38:19 nsrd: successful shutdown


Corruption in the INFORMIX Storage Manager (ISM) nsrmmdbd database causes the WISS error.

The following situations can cause corruption in the ISM nsrmmdbd database:

1. ISM process exits without shutting down properly.
2. Power failure to unprotected systems.
3. Hardware failure.
4. Disk crash.
5. Installing an operating system (OS) patch.

Resolving The Problem

Perform the following steps as root to re-build the nsrmmdbd database:

    1. Shut down the ISM server using the following command:


    2. Rename the corrupt client indexes and the media mmvol indexes using the following:

      mv nsr_home_directory/index/server_name/db  

      mv nsr_home_directory/mm/mmvolume  
          The directory name where nsr installed.
          In most cases it will be "/nsr".

          The name of your Backup server.


      The following example uses /nsr as nsr_home_directory, and client as server_name.
        mv /nsr/index/client/db /nsr/index/client/db.old
        mv /nsr/mm/mmvolume /nsr/mm/mmvolume.old

    3. Restart the ISM server using the following command:


    4. Create new empty client indexes using the following command:

      nsrck -c client_name

          The machine name where ISM installed.


Storage volume(s) needs to re-label and mount on appropriate device after run the 'nsrck' command. When re-label a volume, the original data can no longer recoverable.

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.0;11.1;11.5;11.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018