Kbase P26303: Can the DBTool change the SQLWidth while the database is running with users actively connected?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Can the DBTool change the SQLWidth while the database is running with users actively connected?
GOAL:
Does the DBTool require an exclusive schema lock to change SQLWidth?
SYMPTOM(s):
Progress 9.1D06
FIX:
DBTool is available with 9.1D06 or higher. The tool will scan a Progress 9.1D database for instances where the data contained within a table's field exceeds the existing SQLWidth definition. If such occurrences are found, the tool will then correct the offending SQLWidth values.
Unlike changing the SQLWidth via the Progress Data Dictionary, DBTool does not issue a schema lock. Additionally, when changing SQLWidth values via the Progress Data Dictionary (in Multi-user mode), these changes will not be seen by SQL users until the database is restarted. However, when using DBTool, the change(s) will been seen immediately by an SQL user.