| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Environment: FOCUS 6.1, VMS 5.4-2, Rdb 4.0
I am getting the following error in a FOCUS procedure when trying
reporting on an Rdb database.
ERROR AT OR NEAR LINE 72 IN PROCEDURE DISK$USERS1:[UWINS.OA]IWTEST.FEX
(FOC206) INSUFFICIENT MEMORY SPACE IS AVAILABLE FOR LOADING PROGRAM
BYPASSING TO END OF COMMAND
The focus user manual (appendix A) says :-
FOC206 ...Define larger storage and retry.
Can anybody explain what needs to be increased.
These are the current process quotas. I have decreased WSEXT from 32000 and
increased ENQLM to 20000 and the report still fails.
Flags:
Primary days: Mon Tue Wed Thu Fri
Secondary days: Sat Sun
No access restrictions
Expiration: 2-FEB-2000 00:00 Pwdminimum: 15 Login Fails: 0
Pwdlifetime: 30 00:00 Pwdchange: 11-MAY-1992 13:53
Last Login: 20-MAY-1992 10:26 (interactive), 20-MAY-1992 07:30 (non-interactive)
Maxjobs: 0 Fillm: 300 Bytlm: 100000
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 150 JTquota: 5000
Prclm: 6 DIOlm: 150 WSdef: 1024
Prio: 4 ASTlm: 160 WSquo: 2048
Queprio: 0 TQElm: 246 WSextent: 16000
CPU: (none) Enqlm: 20000 Pgflquo: 200000
Thanks.
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 513.1 | Increase your WSEXTENT AND WSQUOTA.... | AIMHI::CIONI_L | Thu May 21 1992 12:34 | 20 | |
Here's a view of mine: Maxjobs: 0 Fillm: 250 Bytlm: 120000 Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0 Maxdetach: 0 BIOlm: 150 JTquota: 2048 Prclm: 10 DIOlm: 150 WSdef: 644 Prio: 4 ASTlm: 150 WSquo: 48000 Queprio: 0 TQElm: 100 WSextent: 99000 CPU: (none) Enqlm: 8000 Pgflquo: 141000 Also, with some of the V5 versions of FOCUS, I got the same problem and increasing the WSEXTENT and WSQUOTA didn't help until I had it really high - I called the IBI hotline and they said that there was some sort of an internal buffer limit FOCUS had for something that was the culprit and that they had written a paper patch a while ago in conjunction with a DEC site to cure the problem but I was never able to get a paper patch of it and went with the higher WSquo and WSextent LisaC | |||||
| 513.2 | Wot! no memory! it's a VAX!!! | PEKING::MCSHANEG | Deceptively Co-operative | Fri Jun 05 1992 11:02 | 18 |
Nigel,
I've come across this error many times and in the majority of cases
it's due to a FOCUS restriction on the number of lookup elements in either
an external DECODE table that you may have FILEDEF'd or the same with a
list of test elements.
The easiest way around it is to either define a .MAS for the lookup and
use JOIN or to split the lookup into smaller files and refer to them using
OR's.
Gary.
Gary.
| |||||