Multithreading of Java-Based Routines
In DB2 UDB v7.2, Java routines were run in fenced mode by most customers and independent software vendor applications enabled for DB2 UDB. The process-based model is expensive not only from a startup perspective, but also from a memory and operation system dispatch perspective.
In DB2 UDB v8.1.2, routines (stored procedures, user-defined functions, and methods) are now implemented using a thread-based model that results in a dramatic performance increase for database servers running numerous routines. This allows resource sharing of the Java virtual machine (JVM) for Java routines and reduces the amount of context switching in general for users that run large numbers of fenced-mode routines.
Routines that ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
