Tablespaces are put into backup pending after a load
DB2 sets tablespace as Backup Pending state after loading data into a table in linear logging...
DB2 sets tablespace as Backup Pending state after loading data into a table in linear logging database(that is, logretain or userexit is on), whatever the load is successful or failed. the reason is that the load process will not write log file. from the begin time of loading to the end time of loading, there will be a blank segment in log file, and the rollforward recovery can Not jump over the blank segment to apply the later log file.
so database needs a backup after loading to make sure db2 have recovery capicibility.
it's able to use [COPY YES|NO] or [NONRECOVERABLE] to prevent tablespace go into Backup Pending state. COPY YES will do the backup automatically after loading, and COPY NO and NONRECOVERABLE will give up this backup that means db2 will be not able to recover the database once an serious error occured.
继续阅读 "Tablespaces are put into backup pending after a load" 的剩余内容
