Configure the database server

If the SECURITY=PASSWORD setting is specified in the Informix® JDBC client, the SPWDCSM csm option must be enabled on the Informix database server. Otherwise, an error is returned during connection.

To use the SPWDCSM csm server option, which supports password encryption on the database server, you must configure the servers sqlhosts server name option. After this option is set on the server, only clients using the SECURITY=PASSWORD setting can connect to that server name.