You might want to look at the QUIESCE command.

Larry E.

I use a script to do what you describe. As Larry pointed out, check
out QUIESCE. My situation is pretty much what Mark described, so
QUISCE is not an option for me

~/bin]$ cat force_db.sh
#!/bin/sh

db=$1
if [ "x$db" = "x" ]; then
       echo "Usage: force_db.sh <dbname>"
       exit 1
fi

dbname=`echo $db | tr "a-z" "A-Z"`
for a in `db2 list applications | grep " $dbname " | awk '{ print
$3 }'`; do
       db2 -v "force application ($a)"
done

Hello.
You can create a simple udf that uses force application API
(sqlefrce):
---- admin.c ----
#include <sqludf.h>
#include <sqlenv.h >

#ifdef __cplusplus
extern "C"
#endif
void SQL_API_FN force_app(
       SQLUDF_INTEGER *agentid,
       SQLUDF_INTEGER *result,
       SQLUDF_NULLIND *agentid_ind,
       SQLUDF_NULLIND *result_ind,
       SQLUDF_TRAIL_ARGS)
{
 struct sqlca sqlca;
 sqluint32 agentids[1];

 agentids[0] = *agentid;
 sqlefrce(1, &agentids[0], SQL_ASYNCH,&sqlca);
 *result_ind = 0;
 *result = sqlca.sqlcode;
}
---- admin.c end ----

Register it:
---- force_app.sql ---
CREATE FUNCTION force_app (agentid int)
RETURNS int
EXTERNAL NAME 'admin!force_app'
LANGUAGE C
PARAMETER STYLE SQL
DETERMINISTIC
FENCED
NOT NULL CALL
NO SQL
EXTERNAL ACTION
NO FINAL CALL
DISALLOW PARALLEL;
---- force_app.sql end ---

And use it while connected to desired database:
---
select count(force_app(int(agent_id)))
from table(snap_get_appl_info(cast(null as varchar(1)), -2)) s
where appl_id!=application_id()
---

Sincerely,
Mark B.