DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations
2022/9/1 2:24:13
本文主要是介绍DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations
https://www.ibm.com/support/pages/db2loadcopynooverride-and-controlling-non-recoverable-load-operations
Question & Answer
Question
This document addresses the question of whether there is a way to restrict users from using NONRECOVERABLE loads. It also describes the usage of the DB2_LOAD_COPY_NO_OVERRIDE registry variable.
Answer
Is there a way to restrict users from using NONRECOVERABLE loads?
No. The DB2_LOAD_COPY_NO_OVERRIDE registry can be set on the server to automatically convert:
- COPY NO Loads to NONRECOVERABLE loads, or
- COPY NO Loads to COPY YES loads.
How to use DB2_LOAD_COPY_NO_OVERRIDE registry variable
The DB2_LOAD_COPY_NO_OVERRIDE can be set on the server as follows:
db2set DB2_LOAD_COPY_NO_OVERRIDE="COPY YES to <path name>"
... where <path name> is a path that the instance owner has permission on.
Here is an example of how the registry variable can be used:
- Create a directory named /TMP/myinstance that the instance owner has write access to.
- Run the following commands:
db2sampl
db2 update db cfg for sample using LOGRETAIN ON
db2 terminate
db2 backup db sample
db2stop
db2set DB2_LOAD_COPY_NO_OVERRIDE="COPY YES to /TMP/myinstance"
db2start
db2 connect to sample
db2 "export to employee.del of del select * from employee"
db2 "load from employee.del of del modified by coldel, replace into employee COPY NO"
You will note that the COPY NO load above gets converted to a COPY YES and the COPY YES load would be placed on /TMP/myinstance.
Note: The registry variable can be set to any valid COPY YES syntax. Refer to the LOAD command for an example of the COPY YES syntax.
Related Information
Miscellaneous variables
LOAD command
这篇关于DB2_LOAD_COPY_NO_OVERRIDE and controlling non-recoverable load operations的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-01巧用 TiCDC Syncpoint 构建银行实时交易和准实时计算一体化架构
- 2024-05-01银行核心背后的落地工程体系丨Oracle - TiDB 数据迁移详解
- 2024-04-26高性能表格工具VTable总体构成-icode9专业技术文章分享
- 2024-04-16软路由代理问题, tg 无法代理问题-icode9专业技术文章分享
- 2024-04-16程序猿用什么锅-icode9专业技术文章分享
- 2024-04-16自建 NAS 的方案-icode9专业技术文章分享
- 2024-04-14ansible 在远程主机上执行脚本,并传入参数-icode9专业技术文章分享
- 2024-04-14ansible 在远程主机上执行脚本,并传入参数, 加上remote_src: yes 配置-icode9专业技术文章分享
- 2024-04-14ansible 检测远程主机的8080端口,如果关闭,则echo 进程已关闭-icode9专业技术文章分享
- 2024-04-14result 成功怎么写-icode9专业技术文章分享