DB2 Server for VSE & VM: Database Services Utility

UNLOAD and RELOAD PACKAGE Considerations

To obtain the best performance when using the UNLOAD PACKAGE command and the RELOAD PACKAGE command, consider doing the following:

• Unload or reload large numbers of packages in your system's off-peak usage time or with single user mode.
• If you are unloading or reloading packages with multiple user mode, use blocking (by ensuring that the Database Services Utility was initialized with the BLOCK option).

These actions improve performance by preventing interruptions by other users.

PROGRAM is a synonym for PACKAGE. Therefore, UNLOAD or RELOAD PROGRAM, and UNLOAD or RELOAD PACKAGE are equivalent commands.

When unloading or reloading a modifiable package, an exclusive lock is held on the catalog table SYSACCESS. This may cause a performance deterioration for other users wanting to run the exclusively locked package.

See the DB2 Server for VSE & VM Database Administration manual for further information on locking.