DSN1COPY lost data

上周国内某银行发现DSN1COPY后丢了一些page,客户送来了一个image copy里面包含了220个page,但是DSN1COPY只处理了198个page后就成功结束了。

通过DSN1PRNT打出客户送来的image copy后，发现里面有22个duplicate system page, 通过查看Db2官方文档， COPY的时候在指定SYSTEM PAGE YES的时候，可能是会copy两次system/dictionary page的，后来客户做了全方位的验证，证明所有DSN1COPY丢掉的都是这些duplicated system/dictionary page，并不存在丢失数据的情况。

IBM Documentation

SYSTEMPAGES
	Specifies whether the COPY utility puts system pages at the beginning of the image copy data set.
	Although the system pages are located at the beginning of many image copies, this placement is not guaranteed. In many cases, the system pages are not included. For example, incremental copies do not include system pages. This keyword is ignored by FlashCopy.
		YES
			Ensures that any header, dictionary, and version system pages are copied at the beginning of the image copy data set. Dictionary and version system pages can be copied twice. <----COPY可能会拷贝两份DIC/SYSTEM page…
			Selecting YES ensures that the image copy contains the necessary system pages for subsequent UNLOAD utility jobs to correctly format and unload all data rows.
		NO
			Does not ensure that the dictionary and version system pages are copied at the beginning of the image copy data set. The COPY utility copies the pages in the current order, including the header pages.