The administrative tool

The HCL OneDB™ JDBC Driver includes a built-in iterative UDR that is a limited administrative tool, informix.jvpcontrol(). The database server enables the informix.jvpcontrol() UDR when the JVPPROPFILE configuration parameter specifies a starting port number by using the JVP.monitor.port entry.

You start informix.jvpcontrol() with the following syntax: 
EXECUTE FUNCTION informix.jvpcontrol (command lvarchar);
The command can be one of the following forms, where vpid is the virtual processor ID:
  • threads vpid
  • memory vpid

You can use the onstat -g glo command to list the vpid numbers.

The threads vpid option

The threads vpid form lists the threads running on the Java™ VP whose ID is vpid. For example, if command is threads 4, the UDR might return the following output: 
(expression) Thread[informix.jvp.dbapplet.impl.JVPControl#0,
9,informix.jvp.dbapplet.impl.JVPControl#0],UDR=JVPControlUDR(java.lang.String), state = EXECUTE
(expression) Thread[JVP control monitor thread,10,main]
(expression) Thread[main,10,main]
(expression) Thread[SIGQUIT handler,0,system]
(expression) Thread[Finalizer thread,1,system]
5 row(s) retrieved.

The memory vpid option

The memory vpid form lists memory use on the Java VP whose ID is vpid. For example, if command is memory 4, the UDR might return the following output: 
(expression) Memory 16521840 bytes free, 16777208 bytes total
1 row(s) retrieved.