javaworld

Java Product News (updated June 27, 2003)

Inca X introduces IDE and runtime for Jini 2.0June 27 — The Inca X IDE and Runtime environment for Jini 2.0 allows Jini service developers to write, compile, test, and deploy services within the Inca X environment. The tool comes preconfigured with all core Jini 2.0 services.http://www.incax.com/press-release.htmSystinet enhances WASP ServerJune 27 — Systinet has made available WASP Server for Java, 4.6, a Web services...

databasejournal.com databasejournal.com

Reporting Bad SQL Code in DB2 - Page 2

Describing a Problem The test database ARTIST is a multinode DB2 database, ver. 7.2 on Sun Solaris. It is a multinode DB2 EEE database with 3 nodes. The customer is complaining about a performance problem with the database. The system is very slow and every regular, routine process takes a long time to finish. Let's look at the situation on the system: # top 575 processes: 549 sleeping, 16 running, 1 zombie, 9 on cpu CPU...

databasejournal.com databasejournal.com

Reporting Bad SQL Code in DB2 - Page 3

Finding Top Sessions To find the slow-running SQL, we need to collect and analyze all SQL statements coming into the database, for a period of high system utilization. Previously presented "top" UNIX system commands can be used to identify a period for collecting SQL statements. After the system returns to low CPU utilization, we will stop collecting SQL statistics. Listing applications connected to the database: ...

databasejournal.com databasejournal.com

It All Depends on the CONTEXT: Using Oracle's SYS_CONTEXT Function

During a recent code review of our production databases' stored procedures and packages, I took the time to convert the objects from the deprecated (but still serviceable) USERENV function to its Oracle 9i replacement, SYS_CONTEXT. The conversion was relatively painless, of course, but it also opened up a new world of possibilities for utilizing the functionalities provided by SYS_CONTEXT. Here is a quick summary of how SYS_CONTEXT...

databasejournal.com databasejournal.com

It All Depends on the CONTEXT: Using Oracle's SYS_CONTEXT Function - Page 2

Building Our Own Namespaces The USERENV namespace does store extensive information, but the power of SYS_CONTEXT does not stop there. I can also create secured namespaces and store context in them for retrieval within a session or across the instance. For example, if I create a new namespace via the CREATE CONTEXT command, I can then use SYS_CONTEXT to manage and control access to that namespace. In the example below (executed...