Have you tried a DB2STOP FORCE?

Dan Luchinski
Database Administrator
ASPCA Knowledge Management Center
University of Illinois Allied Agency
Phone: 217.337.9777 Fax: 217.337.0599 Web: www.aspca.org

"Bob Khosla " <db2udbdba-ezmlmshield-x46719555.[Email address protected]
wrote on 12/26/2007 06:19:56 PM:

> My environment: DB2 UDB v 9.1 on Windows
> I am trying to perform a Cold backup on the TOOLSDB database -- says
that
> the database is "currently in use".
>
> db2 list applications --> shows ths following connections.
These
> are automated tasks, etc ...
>
> Auth Id Application Appl. Application Id DB # of
> Name Handle Name Agents
> -------- -------------- ----------
> -------------------------------------------------------------- --------
> -----
> BKHOSLA javaw.exe 1014 *LOCAL.DB2D001.071226234329 TOOLSDB
1
>
> BKHOSLA db2taskd 1051 *LOCAL.DB2.071226232929 TOOLSDB
> 1
> BKHOSLA db2stmm 1032 *LOCAL.DB2.071226232928 TOOLSDB
> 1
>
> How can I disconnect these tasks? I've tried .... db2 force
application
> (1032) ........... <-- this did not work
> How can I perform a successful Cold backup?
> I have another Database where a Cold backup works perfectly !!
>
>
> CONNECT TO TOOLSDB
> Database Connection Information
> Database server = DB2/NT 9.1.2
> SQL authorization ID = DB2DFNC
> Local database alias = TOOLSDB
>
> QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
> DB20000I The QUIESCE DATABASE command completed successfully.
>
> CONNECT RESET
> DB20000I The SQL command completed successfully.
>
> deactivate db toolsdb
> SQL1495W Deactivate database is successful, however, there is still a
> connection to the database.
>
> BACKUP DATABASE TOOLSDB TO "E:\DB2\TOOLSDB\Cold_Backup" WITH 2 BUFFERS
> BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
> SQL1035N The database is currently in use. SQLSTATE=57019
>
>
>
> Bob Khosla
> Database Administrator
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page