-
编辑 删除
Determining whether an object requires reorganization MVS DB2
You must reorganize an object if it is in the REORG-pending (REORP) restrictive status.Also, consider reorganizing an object if it is in an advisory REORG-pending status (AREO* or AREOR) or if analysis shows that reorganization might improve performance. Use the REORG INDEX...
-
编辑 删除
Two samples for runstate
1. To get statistics for a specific column:<br />runstate tablespace chid01r.qchssbat<br /> table(dbuchir.qchtsbat) column(R_INVOICE)<br /> sample 25;<br /><br /><br />2. To run agaist partition 2 of a TS and index：<br />runstate tablepsace chid01r.qchssbat<br />&nbs...
-
编辑 删除
DB2 LOAD 的一些samples from IBM
<h2 class="title sectiontitle" style="margin-top:1em;margin-bottom:0em;color:#000000;font-size:1.17em;font-family:Arial, Helvetica, sans-serif, Verdana, Geneva;line-height:normal;white-space:normal;background-color:#FFFFFF;">1. Loading data from another table in the same system by using a declared...
