IBM Support

How to turn off IBM i2 iBase alerting in Microsoft SQL Server

Question & Answer


Question

How do I turn off alerting in a Microsoft SQL Server based installation of IBM i2 iBase from the back-end?

In instances where the Alerting configuration is pointing to a database that no longer exists, you may see the error

"Failed to shutdown the database services"
followed by
"SQL Server Network Interfaces: Error Locating Server/Instance Specified xFFFFFFFF"
OR
"Failed to shutdown the database services:
Named Pipes Provider: Could not open a connection to SQL Server [53]."

 on connecting to the database in iBase Designer.  

Cause

Before changing SQL installations of iBase to for example, new servers, new domains, new IP addresses, it is highly recommended that you turn off both Alerting and Search 360 if you have them on in your iBase database. Should you forget to do this however, it may be useful to be able to switch alerting off in iBase from the back-end, for example if you cannot open iBase Designer because your alerting settings are incorrect.

Answer

The following requires you to have a SQL Server based installation of iBase, and appropriate access to SQL Management Studio, and access to the SQL Server.

To switch off alerting
  1. Open SQL Management Studio and connect to the database.
  2. Find the _Configuration_Text table and change the 'SETTINGS:Alerting' setting in that table from 'Yes' to 'No'
  3. This will then switch Alerting off

If the issue you were having was being unable to open the database in iBase designer you should now be able to get back in again, and have access to change server names, switch alerting back on, and modify it's settings.

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000CiA5AAK","label":"i2 iBase and i2 Analyst's WorkStation->Alerting"}],"ARM Case Number":"TS004581354","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]

Document Information

More support for:
i2 iBase

Component:
i2 iBase and i2 Analyst's WorkStation->Alerting

Software version:
All Version(s)

Operating system(s):
Windows

Document number:
523821

Modified date:
29 September 2021

UID

swg21694356