I think you may have forced yourself off. Try connecting again after the
force, but before the reorg.

-----Original Message-----
From: Manikantan Krishnan
[mailto:db2udbdba-ezmlmshield-x30965598.[Email address protected]
Sent: Thursday, November 18, 2004 8:40 AM
To: LazyDBA Discussion
Subject: Re: Table Space Error






Db2 on Windows 2000. Two databases. Test database has 78 Table records.
Trying to run reorg on the tables.

Command given is :
db2 connect to <dbname>
db2 force application all
db2 reorg table <schema>.<table> use <tablespace>

The above command gives following error :
SQL2216N : SQL error "-1224" while reorganizing the database tables or its
indexes



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


"Attention: This message is intended only for the individual to whom it is
addressed and may contain information that is confidential or privileged. If
you are not the intended recipient, or the employee or person responsible for
delivering it to the intended recipient, you are hereby notified that any
dissemination, distribution, copying or use is strictly prohibited. If you
have received this communication in error, please notify the sender and
destroy or delete this communication immediately."
==============================================================================

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