The administrative tool

The Informix® 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.