Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2013
    Posts
    8

    Unanswered: Terminate db2bp Processes for All Logged on Users

    In case of SAP, typically there are two main users for administration purposes - <sid>adm and db2<sid>. Is there a way to force a temination of db2bp for all logged on users before db2stop? Imagine a situation where someone forgots to log off his user session after he run a SQL query and afterwards you want to stop DB2 instance.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated in doc
    force applications
    FORCE APPLICATION command
    or to avoid connections coming in again : quiesce... (syntax in same infocenter)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2013
    Posts
    8
    According to my experience 'db2 force application all' does not terminate db2bp processes.

    I look for an alternative to 'db2 terminate', but for all logged on users.
    Last edited by Kasparek; 01-28-14 at 05:41.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2 terminate has nothing todo with forcing applications
    why would db2 force not force db2bp ?
    how have you seen/noticed this ?
    show an example if any issue
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Sep 2013
    Posts
    8
    According to information in IBM DB2 Information Center:

    DB2 FORCE APPLICATION command - Forces local or remote users or applications off the system to allow for maintenance on a server.
    DB2 QUIT stops the command line processor.
    DB2 TERMINATE also stops the command line processor, but removes the associated back-end process and frees any memory that is being used. It is recommended that a TERMINATE be issued before every STOP DATABASE MANAGER (db2stop) command.

    Practically - in situation two users used DB2 CLP and commands are run in user session for db2sid user:
    52> ps -ef | grep db2bp
    sidadm 9497 1 0 11:12 pts/1 00:00:00 /db2/db2sid/sqllib/bin/db2bp 3050A15718 5 A
    db2sid 10103 1 0 11:13 pts/2 00:00:00 /db2/db2sid/sqllib/bin/db2bp 9586A15720 5 A
    53> db2 force application all
    DB20000I The FORCE APPLICATION command completed successfully.
    DB21024I This command is asynchronous and may not be effective immediately.
    54> ps -ef | grep db2bp
    sidadm 9497 1 0 11:12 pts/1 00:00:00 /db2/db2sid/sqllib/bin/db2bp 3050A15718 5 A
    db2sid 10103 1 0 11:13 pts/2 00:00:00 /db2/db2sid/sqllib/bin/db2bp 9586A15720 5 A
    55> db2 terminate
    DB20000I The TERMINATE command completed successfully.
    56> ps -ef | grep db2bp
    sidadm 9497 1 0 11:12 pts/1 00:00:00 /db2/db2sid/sqllib/bin/db2bp 3050A15718 5 A
    db2sid 11209 9586 0 11:14 pts/2 00:00:00 grep db2bp

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The only way to terminate the DB2 client background processes (db2bp) is to issue the DB2 TERMINATE command at each client or use the OS kill command or its equivalent. Since db2bp runs on clients, there isn't much you can do from the server, unless using local connections.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •