RE: ALTER TABLE while it's in use?

["Price, Chris" <chris_price@xxxxxxxxx>]

David,

ALTER TABLE is implemented (to the best of my knowledge) by renaming the old
table (file), creating a new one, then copying the data from old to new. So
the iSeries must get an exclusive lock on the file before the operation can
start.

Chris.

-----Original Message-----
From: David Gibbs [mailto:david@xxxxxxxxxxxx]
Sent: 20 February 2003 14:49
To: java400-l@xxxxxxxxxxxx
Subject: ALTER TABLE while it's in use?


Anyone know if there is a way to configure a JDBC connection, to a DB2 400
database, so that it will allow a table to be altered while it is still in
use?

We've got a multi-user application that is trying to alter a table's
structure while other threads are running selects on it.  When this happens
we are getting SQL0913 errors.

Other databases, MS SQL & the like, allow this.  Can DB2 400 be configured
to do this?

Thanks!

david


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.