Question & Answer
Question
How do I configure an additional instance of Informix Dynamic Server with NoSQL support?
Answer
It may be desirable to have for example, both production and development/QA instances of IDS with NoSQL support enabled. The initial instance must be created during the installation. Additional instances can be created with the following steps:
- Make the necessary sqlhosts file changes and if applicable /etc/services entries.
- Make a copy of either the sqlhosts file to the new file or just make a second copy of the entries within the file. Modify the entries appropriately.
- Make the necessary changes to the /etc/services file.
- Create a new onconfig file and make the appropriate changes to it including new DBSERVERNAME and DBSERVERALIASES values from step #1. A good practice is to copy the first instance's onconfig file and make changes.
- Modify the environment:
- Change INFORMIXSERVER to be the value of DBSERVERNAME set in the previous steps.
- Change ONCONFIG to the name configured in step #2.
- Change INFORMIXSQLHOSTS if a new sqlhosts file was created in step #1.
- A new NoSQL scheduler initialization file must be created in $INFORMIXDIR/etc/sysadmin. This file is used at instance initialization (oninit -i) to set up NoSQL. It follows this naming convention: sch_init_<DBSERVERNAME>.sql. This must be changed accordingly to configure another instance with NoSQL support. Copy this file to a new file with the appropriate DBSERVERNAME value and make the following changes to it:
- LET json_listener = <filename>:
- <filename> defaults to "jsonListener.properties"
- Copy the original file to a new file with a different name and set the new name (<filename>) here.
- See step #5 below for configuration changes in this file.
- EXECUTE FUNCTION ifx_setup_system(<chunk_storage_path>):
- <chunk_storage_path> defaults to $INFORMIXDIR/storage
- Change this to a new storage directory that you created for the new instance.
- Make a copy of the jsonListener.properties file and change the following:
- listener.port=#: set the port number that the new JSON listener process(es) will use for incoming requests
- Localhost:#: set to the port number of the "lo_..." DBSERVERNAME connection
- INFORMIXSERVER=?: set to "lo_..." DBSERVERNAME connection
- Finally, initialize the instance with "oninit -i."
Related Information
[{"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":"12.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21652363