DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
The ALLOW READ ACCESS parameter of the LOAD command is deprecated and might be removed in later releases. The SQLU_ALLOW_READ_ACCESS value for the iAccessLevel parameter of the db2LoadIn data structure is also deprecated.
In addition, the specification of ALLOW READ ACCESS as a load option with the COPY_USE_LOAD parameter value is deprecated in the ADMIN_MOVE_TABLE procedure.
The ALLOW READ ACCESS parameter provides read access to data that exists in a table before starting of the load operation on that table. The data that is being loaded is not available until the load is complete.
Starting with DB2® Version 10.1, the ingest utility (sometimes referred to as continuous data ingest, or CDI) is a high-speed client-side utility that streams data from files and pipes into tables. It provides data currency and availability because it can move large amounts of data without locking the target table. It commits transactions based on elapsed time or number of rows. Therefore, data becomes accessible as soon as it is committed. For all these reasons, the ingest utility is better suited to allow data concurrency and availability than the LOAD command with the ALLOW READ ACCESS parameter.
Start using the ingest utility before the ALLOW READ ACCESS parameter of the LOAD command becomes discontinued. In addition, you can use the ingest utility in command scripts.