SYSDBOPEN: A flexible way to change session behavior in Informix

From the developerWorks archives

Gerd Kaluzinski

Date archived: January 12, 2017 | First published: September 22, 2011

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 dynamically be changed without recreation of the procedure. The benefit is to avoid downtime if session environments have to be adjusted.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=758046
ArticleTitle=SYSDBOPEN: A flexible way to change session behavior in Informix
publish-date=09222011