(Gerd Kaluzinski) The procedures sysdbopen() and sysdbclose() can help database administrators set environments to activate user tracing, handle short-lasting locks on data records or change the reading behavior of sessions. This article shows how to create a sysdbopen() procedure that can dynamical
Other News
Microsoft Goes After Big Data In a new Way
5-Year Anniversary Show – See how it all started… Stephen Wynkoop and producer Josh Harrison on the show today – with a look back at 5 years of SSWUG TV. Bloopers, how it was done, some funny moments and even a fact-check. This one is one not to miss! [Watch the Show] Featured Article(s) Data Quality Starts with Proper Data […]
Usability Test Subject Selection
New, 5-Year Anniversary Show – See how it all started… Stephen Wynkoop and producer Josh Harrison on the show today – with a look back at 5 years of SSWUG TV. Bloopers, how it was done, some funny moments and even a fact-check. This one is one not to miss! [Watch the Show] Last Show: SSWUG TV – Interview with […]
Documentation Code Snippets
(Vadim Tropashko) Code templates/snippets is one of modern IDE facilities accelerating programming. Some time ago I used to complain about cumbersome main() function signature in Java which escaped my limited memorization abilities until learning that there is convenient code template offered by cod
Parallel Downgrade
(Randolf Geist) There are many reasons why a parallel execution might not run with the expected degree of parallelism (DOP), beginning with running out of parallel slaves (PARALLEL_MAX_SERVERS or PROCESSES reached), PARALLEL_ADAPTIVE_MULTI_USER, downgrades at execution time via the Resource Manager,
DB2 Migration to DB2 10: Another Three More Items to Ensure your DB2 Performance
(Dave Beulke) As everyone gets ready for the DB2 migration to Version 10 there are many things that need to get done to start implementing the system and application enhancements.
The Rewards of ‘Expertise’
(Troy Coleman) I’ve published articles and presented at IDUG conferences worldwide for many years, and every so often I’m asked how I got into writing and speaking.
Uh, uh… extending mysqlnd: monitoring and statement redirection
(Ulf Wendel) Uh, uh… about a year ago Mayflower OpenSource Labs released the mysqlnd user handler plugin (PECL/mysqlnd_uh). The extension lets you extend and replace mysqlnd internal function calls with PHP.
Develop an Apache HttpClient client for Android to a JAX-RS web service
(Deepak Vohra) Create JAX-RS web service access with the Apache HttpClient library. Jersey, a reference implementation for JAX-RS, simplifies development of RESTful web services in the Java™ environment. Android is a popular smartphone and this article shows you how to create a JAX-RS client for And
Auto DOP and calibrate_io
(Rajeev Ramdas Thottathil) I was posed the following question by a colleague recently. I am using auto DOP in 11gr2 and I am setting parallel_degree_threshold=12. But when i execute my query, my query is still running with a parallelism of 48 (ie it seems to be ignoring my setting for parallel_degr