Usage Note 9683: New DB2 LIBNAME option to reduce number of concurrent DB2 threads
A new DB2 LIBNAME option has been added that will help in reducing the
total number of concurrent threads to DB2. The new connection option is
UTILCONN_TRANSIENT=YES|NO with the default being NO.
The SAS/Access to DB2 engine creates a utility thread that it uses to
get catalog information, etc. Normally, for performance reasons, this
thread remains open. A new option was added that will close this thread
when it is no longer needed or being used. The end result is that the
total number of DB2 threads will be reduced. The option
UTILCONN_TRANSIENT can be used in conjunction with CONNECTION options
(SHAREDREAD|GLOBALREAD|UNIQUE|SHARED|GLOBAL) to control DB2 threads.
This option was added to support customers who have restrictions on the
total amount of threads to DB2. This becomes especially apparent when
using products that create their own SAS server instance, such as
Enterprise Guide.
As an example, to tell the SAS System to only open and close the utility
thread when needed you can specify a LIBNAME such as the following:
LIBNAME D DB2 SSID=DSNP UTILCONN_TRANSIENT=YES;
This feature is available by installing the Technical Support Hotfix
82BB43.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009683
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2003-11-26 07:56:16 |
| Date Created: | 2003-03-26 13:33:04 |
