Kbase 16109: Performance problems on record locks with AS/400 DS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2003 |
|
Solution ID: 16109
GOAL:
Performance problems on record locks with AS/400 DS
FACT(s) (Environment):
Progress AS400 Dataserver
FIX:
When experiencing performance problems on the AS/400 transactions, specially when record locking is involved, check the lock time values of the physical files.
Run the command DSPFD library/file and search the parameters:
Maximum file wait time
Maximum record wait time
These parameters indicate the time in seconds that a process will wait if a lock is encountered before reporting its no availability. When Progress creates a file assigns *IMMED to both parameters, but files created from DDS scripts might content other values.
To change the parameters use CHGPF command.