[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

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

513.0. "FOCUS error 206, Insufficient Core Space" by NEWOA::UWINS (... and then, as if by magic ...) Wed May 20 1992 08:27

	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.RTitleUserPersonal
Name
DateLines
513.1Increase your WSEXTENT AND WSQUOTA....AIMHI::CIONI_LThu May 21 1992 13:3420
  
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.2Wot! no memory! it's a VAX!!!PEKING::MCSHANEGDeceptively Co-operativeFri Jun 05 1992 12:0218
    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.