请问用SETOBJACC将表或程序装载到内存中的问题？~~~~~~~

Question

请问用SETOBJACC将表或程序装载到内存中的问题？~~~~~~~

请问装载后，如果将硬盘上的表或程序更改，比如删掉或重新编译，可以执行成功吗？
还是必须首先把他们从内存中清除掉再更改呢？

已经装载过的，再装载一次会报错吗？

怎么查看内存中已经装载了哪些表或程序？

Answer 1

本帖最后由 tomroom 于 2010-09-13 16:34 编辑

关心 如果该OBJ 是表，需要更改其中记录会发生怎样情况 。ibm  infornation center文档没有说明
IBM 说setOBJACC 之后update 会被handle
1.3 How Things Work with SETOBJACC and CLRPOOL 1  There will be few, if any, database reads once the file has been preloaded using SETOBJACC . Database writes will still be handled the same way. Database writes are usually done asynchronously to the user's job by system output tasks. Because database reads are processed much faster once a file is preloaded, database writes will be done more frequently by a program that is also doing updates, adds, or deletes. This might cause occasional overrun of the system output tasks, resulting in more database writes being done synchronously rather than asynchronously to the user's job. Therefore, the job might not perform as well as expected. However, the job will still be faster when using SETOBJACC .

Answer 2

本帖最后由 tomroom 于 2010-09-13 16:33 编辑

关注你测试结果,网上相关文档如下：
1） IBM :http://www-01.ibm.com/support/do ... ddb86256d6c0069907f
2) QINQZHOU 之前帖子 http://www.chinaunix.net/jh/10/413779.html
3)  BLOCK使用         http://chinaunix.net/jh/10/508533.html