The S lock is on the tblspc. Not on the tables in the tablespace. The S lock prevents any other "chage" type operation against the tblspc. (No restore, alter, ...) but not against the constituents of the table space. Tha is data and online backups allow ypou access to the db and its tables. HTH, Pierre. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 3:37 PM Subject: [DB2EUG] What exactly happens to LOB tablespaces during onlinebackup?
> > > > > Hello, > > This question concerns DB2 V8 FixPak4 for LUW. > > I've read that during an online backup of a long DMS tablespace, it is > locked (possibly with an S lock). However, I notice that while I'm > performing an online backup of that tablespace, I can still insert and view > CLOBS in one of its tables. Just what are the concurrency implications of > an online backup of a long tablespace? > > Thanks, > > Fred > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
