MVSFORUMS.com

[Jarek B.]

In my system backups of the same database are sometimes performed by DFSURGU0, and sometimes by DFSUDMP0 tools.

After having read rather heavy books like "Utilities Reference:Database" and "Operations Guide" I still can't grasp the difference between those two tools. Internet isn't helpfull either.

Can anybody explain this in few simple terms? Will appreciate.

[kolusu]

Jarek B.,

(DFSUDMP0) is Database Image Copy Utility whereas DFSURGU0 is HD Reorganization Unload Utility. DFSUDMP0 is used to create an as-is image copy of a database. This output is mostly used as input to the Database Recovery utility.

with HD Reorganization Unload Utility (DFSURGU0) you can

o Unload an HDAM, PHDAM, HIDAM, PHIDAM, PSINDEX, or HISAM database to a sequential data set.

o Generate a data set with prefix information (if logical relationships exist).

o Make structural changes to a HDAM, PHDAM, HIDAM, PHIDAM, or HISAM database.

o Record logical parent, logical twin, and logical child pointer fields,
and the counter fields associated with logical parents in a database.

o Migrate non-HALDB to HALDB and fall back from HALDB.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Jarek B.]

Do you mean that with DFSURGU0 - DFSURGL0 tools I can do some 'editing' of data? like deleting some segments or stuff like this?
In other words they offer much more functionality than DFSUDMP0-DFSURDB0 ?

Thanks.

[Bithead]

Jarek,

DFSUDMP0 is used for creating a backup of the database to create a recovery point in case of failure.

DFSURGU0 is used to re-organize the segments in a database. As segments are inserted, deleted or modified over time, they can become scattered across the underlying datasets. Related segments can become separated which increases the access time. These utilities bring those related segments back together.

There are a number of ways to modify data either by writing programs, using third party tools such as Compuware's FileAid or by using the IBM supplied utility DFSDDLT0.