O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Movement

In order to get data into the DB2 tables, we can perform DML INSERTs; however, for large amounts of data this is not a feasible option. For populating tables with large amounts of data, we need to use the LOAD utility.

For removing data from a DB2 table, we also have the option of doing DML DELETEs, but here again this is not optimal for large amounts of data. We have a couple of options for unloading data: DSNTIAUL, UNLOAD utility, and REORG DISCARD or UNLOAD EXTERNAL.

Load Utility

The LOAD utility is used to load one or more tables of a table space. This utility loads records into the tables and builds or extends any indexes defined on them. If the table space already contains data, you can choose whether you want to add the new ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required