RE: Subsystem and memory pools

Rob,

1) How much do you use?

Keep in memory (KEEPINMEM)

Specifies whether the data for a file member should be brought into
a main storage pool by the SQL Query Engine (SQE) when the data is
used in the query to improve the performance.

2) Do you use Set Object Access (SETOBJACC)?

The Set Object Access (SETOBJACC) command temporarily changes the
speed of access to an object by bringing the object into a main
storage pool or purging it from all main storage pools. An object
can be kept main storage resident by selecting a pool for the object
that has available space and does not have jobs associated with it.
Repeated use of the command can cause a set of objects to be
resident in a main storage pool.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Friday, December 15, 2017 11:13 AM
To: Midrange Systems Technical Discussion
Subject: RE: Subsystem and memory pools

You have to define a "thing".
If I run program XXX123 in batch and interactive will it bring two copies into memory?
If I have a file defined with KEEPINMEM(*YES) then is it brought into memory once, once for each pool, once for each subsystem, once for each job?

See also:
Note: The Query Options File (QAQQINI) parameter MEMORY_POOL_PREFERENCE can be used to specify the preferred main storage pool that should be used.


Rob Berendt