Applications that access databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance tuning and management is one of the biggest demands on the DBA’s time. When asked what is the single most important or stressful aspect of their job, DBAs typically respond “assuring optimal performance.” Indeed, a recent Forrester Research survey indicates that “performance and troubleshooting” tops the list of most challenging DBA tasks.But when you are dealing with data in a...
Wednesday, 29 August 2012
Wednesday, 15 August 2012
Don’t Forget About DB2 Session Variables
Posted on 17:52 by Unknown
Session variables, set by DB2 or by the user, offer another way to provide additional information to applications. Session variables are set by DB2, and are accessible to application programs and end users. By accessing session variables, an application program can determine many aspects of its environment and the DB2 features in effect.There are a plethora of session variables available to the DB2 programmer as outlined in the accompanying table. Table 1. DB2 Session Variables. Session Variable Description APPLICATION_ENCODING_SCHEME...
Subscribe to:
Posts (Atom)
