Is there a dedicated administrator connection on DB2?

Posted by Tim Büthe on Server Fault See other posts from Server Fault or by Tim Büthe
Published on 2010-04-19T11:40:31Z Indexed on 2010/04/19 11:43 UTC
Read the original article Hit count: 223

Filed under:

db2

When using Microsoft SQL Server, there is this handy thing called dedicated administrator connection. You can tell the database to drop all connections and not open any new ones, but keep the one you use right now alive for administrative purposes.

Is there a similar feature available for IBM's DB2 UDB?

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More

Developer IT

Is there a dedicated administrator connection on DB2? - Developer IT

Is there a dedicated administrator connection on DB2?

db2

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

Speed-start your Linux App: Using DB2 and the DB2 Control Center

DB2 LUW Security - The DB2 DBA as a Locksmith

Why can't Perl's DBD::DB2 find dbivport.h during installation?

DBI::DBD package not getting installed for Perl?

Categories cloud