DB2 unload and insert OR update

sandiptcs · New User Joined: 29 Nov 2006 Posts: 19 Location: amsterdam

Hi

Is it possible to insert or update a DB2 table when the DB2 unload is in progress. What kind of a lock does DB2 imposes on a table in such a case

Also what is meant by DB2 region up or DB2 region down . Does it have to have anything to do with online and batch

Thanks

wanderer · Posted: Tue Jul 03, 2007 11:59 pm

Yes, it is possible if SHRLEVEL being used is CHANGE. Also isolation UR helps here too.

DB2 is a subsystem in the mainframe system. When it is up, there are some product programs that keep running all the time. If Db2 is down then no DB2 related activity can be done neither online nor batch if they use DB2.

dick scherrer · Posted: Wed Jul 04, 2007 12:36 am

Hello,

If you permit an unload to run at the same time updates may be processed, your unload will be useless for other than testing - it will not have content that is reliable.