SYSDBOPEN: A flexible way to change session behavior in Informix

From the developerWorks archives

Gerd Kaluzinski

Date archived: May 13, 2019 | 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 content, steps, or illustrations may have changed.

Zone=Information Management
ArticleTitle=SYSDBOPEN: A flexible way to change session behavior in Informix