A. Environment Variables : Environment Variables for Ingres Installations : How You Can Set Page Locks
 
Share this page                  
How You Can Set Page Locks
The default number of page locks for the II_ENCODINGS and II_SRCOBJ_ENCODED catalogs is 80. This number should be adequate under most circumstances. In addition, the II_W4GL_LOCKS environment variable lets developers modify the default number of page locks for the encoding table to any value appropriate to the environment. If frames are small or development is taking place in a single-user environment, the value can be lowered.
The following simple Terminal Monitor script can help you evaluate the number of pages used for encoding the various components in your OpenROAD development database. The query provides a list of components and the number of pages needed to store their encoding. The displayed number helps you decide whether you must set the II_W4GL_LOCKS environment variable and what value to assign to it.
/* Terminal Monitor script to find the largest encoded component */
create view w4gl as
select entity_id = encode_object,
          num_pages = count(encode_sequence)
     from ii_encodings
     group by encode_object
     union all
     select entity_id,
     num_pages = count(sequence_no)
     from ii_srcobj_encoded
     group by entity_id
\p\g
select e.entity_name,
     w.entity_id,
     num_pages = sum(w.num_pages)
from w4gl w, ii_entities e
where w.entity_id = e.entity_id
group by entity_name, w.entity_id
order by num_pages
\p\g
drop view w4gl
\p\g
\q