Starting and Stopping the CONNX JDBC Server on UNIX
These steps are required after installation and before running any database connections for UNIX systems.
1. Go to the CONNX directory that was created in the installation directory specified during installation of the CONNX UNIX Client. The cnxjdbc executable file resides in that folder.
2. Verify that your data source names (DSNs) are registered correctly.
At the command prompt, enter ./sqlregistry
Select option 1 to view all the current registry settings.
If your DSN is in the list, go to the next step. If your DSN is not in the list, enter CONNX.DSNS.dsn that you want to register
Select option 2 for a string value.
Enter the fully qualified path to the CONNX CDD. The CDD must be located on a UNIX system. Add a semicolon. [optional] Add a DSN comment freeform string. Add a semicolon.
Enter 5 to exit the the /sqlregistry program.
Alternatively, you may utilize the createJDBCDSN utility script to manage your JDBC DSNs.
To list all configured JDBC DSNs: ./createJDBCDSN –I
To add a new DSN to the registry or overwrite an existing DSN entry: ./createJDBCDSN top-level DSN path to CDD comment. If a DSN entry already exists, the user will be prompted before overwriting the old value.
3. At the UNIX terminal session prompt, enter the server command to run the executable as a background process:
./jdbcserver START
This command creates a connxjdbc.log file that contains JDBC Server information, error messages, and status.
To stop the JDBC Server, at the UNIX terminal session prompt, enter the server command to run the executable as a background process: ./jdbcserver STOP
To verify that the JDBC Server is active, at the UNIX terminal session prompt, enter the server command to run the executable as a background process: ./jdbcserver STATUS