You must configure the wire listener by specifying an authorized user and
customizing the wire listener configuration file.
Before you begin
The wire listener JAR file is included in the database server installation at
$INFORMIXDIR/bin/jsonListener.jar.
Procedure
To configure the wire listener for the first time:
-
Choose an authorized user.
An authorized user is required in wire listener connections to the database server. The
authorized user must have access to the databases and tables that are accessed through the wire
listener.
- Optional:
If you want to shard data, grant the user REPLICATION privilege by running the
admin or task SQL administration API command with the
grant admin argument.
For
example:
EXECUTE FUNCTION task('grant admin','userID','replication');
-
Create a wire listener configuration file in $INFORMIXDIR/etc with the
.properties file extension. You can use the
$INFORMIXDIR/etc/jsonListener-example.properties file as a template.
-
Customize the wire listener configuration file to your needs.
To include parameters in the wire listener, uncomment the row and customize the parameter. The
url parameter is required. All other parameters are optional.
Tip: Review the defaults for the following parameters and verify that they are appropriate for your
environment: mongo.api.verion,
authentication.enable, listener.type,
listener.port, and listener.hostName.
- If you are using a Dynamic Host Configuration Protocol
(DHCP) on your IPv6 host, you must verify that the connection information
between JDBC and Informix® is compatible.
For example, you can connect from the IPv6 host through an
IPv4 connection by using the following steps:
- Add a server alias to the DBSERVERALIASES configuration
parameter for the wire listener on the local host.
For
example: lo_informix1210
.
- Add an entry to the sqlhosts file
for the database server alias to the loopback address 127.0.0.1.
For example:
ol_informix1210 onsoctcp 127.0.0.1 9090
- In the wire listener configuration file, update the url entry
with the wire listener alias.
For
example:
url=jdbc:informix-sqli://localhost:9090/sysmaster:
INFORMIXSERVER=ol_informix1210;
What to do next
Start the wire listener.