IBM Support

How to create a manual Search 360 job with the Microsoft SQL Server Agent

Troubleshooting


Problem

In some cases it will not be possible to create Search 360 jobs using the IBM i2 iBase Index Service Configuration Tool due to the server being in a cluster. In those circumstances a job can be created directly in Microsoft SQL Server Agent in the SQL Server Management tool.

Symptom

The following error message will appear if the database is in a cluster:

Failed to connect to SQL Server due to the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Cause

This has been identified as a product defect under APAR PO04730

Environment

The SQL Server database is in cluster configuration.

Resolving The Problem

In order to create a job manually in Microsoft SQL Server Management Studio the following steps need to be completed:

  1. Expand the SQL Server Agent for the relevant SQL Server instance



  2. Right-click on "Jobs" and select "New Job". A dialog called "New Job" will open.



  3. Choose any name and leave the owner. A description can be entered if desired, but it is not needed.
  4. Under "Select a page" go to Steps.
  5. Select "New..." at the bottom to add a new step.



  6. Enter a name.
  7. Change the "Type" to "Operating system (CmdExec)". Add the command line argument as made in (reference creating command line argument). It should have the following format:

    X:\Program Files (x86)\i2 iBase 8\i2.iBase.SearchIndexerExe.exe /iBaseDBName "DatabaseName" /ServerName "Servername" 

  8. Press OK.
  9. Go to Schedule and select "New...". This should open the scheduling dialog.



  10. Enter a name for the schedule and then choose an appropriate schedule.
  11. Press OK.
  12. Press OK again.

A job will have now been created that runs the Search 360 indexer on the specified database on the schedule specified above.

[{"Product":{"code":"SSXW43","label":"i2 iBase"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.9;8.9.1;8.9.11;8.9.5","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21701015

Page Feedback