Kbase P108322: What locking does DUPPRODB apply to the source database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/08/2005 |
|
Status: Unverified
GOAL:
What locking does DUPPRODB apply to the source database
GOAL:
Is it possible to run other programs while DUPPRODB is running
FACT(s) (Environment):
IBM AS/400 (RISC)
Progress/400 DataServer
FIX:
There are no exclusive locks applied to source database during DUPPRODB. As a result, it is entirely feasible to use other programs against this Dictionary Library provided that they don't lock any records themselves.
DUPPRODB is a CL envelope program that calls certain procedures to copy schema files (P__*) including data and optionally user files. Eventually CRTDUPOBJ and CPYF commands are executed.
When the CRTDUPOBJ command is used (with DATA(*YES)) to create a copy of a file, only the new duplicate file object is seized (similar to an *EXCL lock with no timeout) for the duration of the data copy making access impossible. During the time a CPYF request is run, only the file named on the TOFILE parameter may be locked (similar to an *EXCL lock with no timeout) so that no access is possible. On the other hand the access to the source database library at this time is feasible.