---
title: "What’s the COPY Utility Enhancement in DB2 V10"
description: "DB2 is a leading database in the market. The skills of DB2 are more valuable than any other database. Please check latest available jobs."
url: https://srinimf.com/2015/12/11/db2v10-the-best-enhancement-for-copy-utility/
date: 2015-12-11
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/12/pexels-photo-974964.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2 V10"]
tags: ["DB2 new features", "DB2 Tips and Solutions"]
type: post
lang: en
---

# What’s the COPY Utility Enhancement in DB2 V10

DSNZPARM FLASHCOPY_COPY to YES
This setting lets DB2 create a FlashCopy image copy automatically. You do not need COPYDDN specified on your utility control statement.

Related[DB2 Load Utility Essential Features(2 of 2)](https://srinimf.com/2010/06/12/load-utility-db2/)

## **What is the [difference between](https://srinimf.com/2016/06/09/best-5-differences-vsam-files-vs-sequential-files-in-mainframe/) sequential COPY  and FlashCopy**

FlashCopy image copy is useful for making image copies of large DB2 objects; however, using FlashCopy does not mean that you will obtain better performance than sequential image copies with small DB2 objects. For small objects, you may get better performance using a system level backup, which avoids the cost of data set allocations.

Related[13 Phases DB2 Load Utility](https://srinimf.com/2014/12/18/db2-load-utility-executes-in-13-phases/)

Because FlashCopy image copy does not support incremental copies, do not consider FlashCopy image copy as a replacement for incremental image copies. Also consider that, if the hardware does not support FlashCopy, the system uses IDCAMS Repro to copy the data set, in which case the only advantage is that Repro does not impact the DB2 buffer pool.

Related

- [13 Phases DB2 Load Utility](https://srinimf.com/2014/12/18/db2-load-utility-executes-in-13-phases/)DateDecember 18, 2014
- [DB2: Index Rebuilt Error and Resolution](https://srinimf.com/2014/12/16/db2-index-rebuilt-error-and-resolution/)DateDecember 16, 2014
- [DB2 Load Utility Essential Features(2 of 2)](https://srinimf.com/2010/06/12/load-utility-db2/)DateJune 12, 2010

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2015%2F12%2F11%2Fdb2v10-the-best-enhancement-for-copy-utility%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F12%2Fpexels-photo-974964.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=What%27s%20the%20COPY%20Utility%20Enhancement%20in%20DB2%20V10)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/12/11/db2v10-the-best-enhancement-for-copy-utility/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/12/11/db2v10-the-best-enhancement-for-copy-utility/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/12/11/db2v10-the-best-enhancement-for-copy-utility/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/12/11/db2v10-the-best-enhancement-for-copy-utility/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20What%27s%20the%20COPY%20Utility%20Enhancement%20in%20DB2%20V10&body=https%3A%2F%2Fsrinimf.com%2F2015%2F12%2F11%2Fdb2v10-the-best-enhancement-for-copy-utility%2F&share=email)
-

### Like this:

Like Loading…