参考官方文档: DB2信息中心中的解释
提到的
ALLOW READ ACCESSLoad will lock the target table in a share mode. The table state will be set to both Load In Progress and Read Access. Readers can access the non-delta portion of the data while the table is being load. In other words, data that existed before the start of the load will be accessible by readers to the table, data that is being loaded is not available until the load is complete.
LOAD FROM file.del OF DEL MESSAGES file.msg INSERT INTO table_name ALLOW READ ACCESS
在LOAD期间可以访问表中的原有数(即非增量数据),增量导入数据在执行LOAD期间不可以访问。
收起