DB2 Unable to force the backup connection processing method

When the database is backed up online, conflicts with load and ALTER TABLE < table name > ACTIVATE not logged initially with EMPTY table cause both operations to be suspended. In the MIS system, the database is often large (TB level is very common), backup time often spend a few hours, or even more than 1 days. When we are in urgent need of both of these operations, kill the backup, the general steps are as follows:

# 1 backup connection found [[Email protected] bin]$ DB2 list applications show Detail|grep-iback#2 Force off backup connection " Force Application (+)"db20000i theForce  Application command completed successfully. Db21024i  is and isn't being effective immediately.

And then sometimes we do a few successive backups that still can't kill, and we can use another way:

#Find process ID of client application[[Email protected] bin]$ DB2 get snapshot forApplication Agentid 55|Less application snapshotapplication handle= 55Application Status=Connect completedstatus Change Time=Not collectedapplication code page= 1208Application Country/region Code =0DUOW Correlation Token= *local.db2inst1.150104134326Application Name=db2bpapplication ID= *local.db2inst1.150104134326Sequence Number= 00001TP Monitor Client User ID=TP Monitor Client workstation name=TP Monitor client application name=TP Monitor Client Accounting string=Connection request start timestamp= 2015-01-04 21:43:26.408291Connect Request Completion timestamp= 2015-01-04 21:43:28.310947Application Idle time=Not collectedconnect Authorization ID=db2inst1client Login ID=db2inst1configuration Nname of the client=limtclient Database Manager product ID=sql10010process ID of client application= 4153#here is the BP process number to findPlatform of client application =LINUXAMD64 Communication Protocol of the client=Local Client#This process is db2bp[Email protected] bin]$ Ps-ef|grep 4153Db2inst14153 1 0 21:28 pts/0 00:00:00/home/db2inst1/sqllib/bin/db2bp 3796a502 5Adb2inst14961 3796 0 21:46 pts/0 00:00:00 grep 4153[[email protected] bin]$ kill-9 4153#this time again check the backup connection disappears

This approach is also generally appropriate for the Force C program's Embedded SQL program

DB2 Unable to force the backup connection processing method