Force application for a DB

rahul_s80 · #1 (**permalink**) 08-09-07, 08:08

i was just wondering how to force applications for only a specified DB.
i need DB scripts for BKP to run at night(task centre) ,
but the problem is
db2 force application all
will force connections for other DB's also (which i dont want)
any hints ?

ARWinner · #2 (**permalink**) 08-09-07, 08:23

You could use the following query to generate the script you need:

select 'force application ('||rtrim(char(agent_id))||')' from table(snapshot_appl_info('MyDB',-1)) as x

Andy

grofaty · #3 (**permalink**) 08-09-07, 08:50

ARWinner, this is new in v8.2 if I am not mistaken. I use Windows batch script to do the same task for any kind of database new and old versions - this is one command in one line:

Code:

FOR /F "tokens=3 delims= " %%i IN ('db2 list application for database MyDB ^| find /v "Auth" ^| find /v "--" ^| find /v "Name"') DO db2 force application (%%i)

Note: use your database name instead of MyDB.

rahul_s80, can you write your db2 version and operating system type and version.

Hope this helps,
Grofaty

myprotein · #4 (**permalink**) 08-09-07, 09:14

i think , when you execute "force application xxx" ,you must connect to the very db ,which db you have connected ,then witch db you would force app disconnected.

Marcus_A · #5 (**permalink**) 08-09-07, 09:19

Quote:

Originally Posted by myprotein

i think , when you execute "force application xxx" ,you must connect to the very db ,which db you have connected ,then witch db you would force app disconnected.

You do not have to be connected to the database, but you do need an instance attachment which you would normally get if you logged on as instance owner.