IBM Support

WISS error during the onbar backup with ISM

Troubleshooting


Problem

Solution for WISS error during the onbar backup with ISM.

Symptom

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
                   /nsr/res/nsrla.res
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

Cause

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:

      ism_shutdown

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

      mv nsr_home_directory/index/server_name/db  
      nsr_home_directory/index/server_name/db.old

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

        server_name
          The name of your Backup server.

      Example:

      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:

      ism_startup


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

      nsrck -c client_name

        client_name
          The machine name where ISM installed.

WARNING

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

UID

swg21109108

Page Feedback