Dictionary Cache

Posted in 2001

Earle A Long — Mon, 15 Jan 2001 17:53:06 -0000 — source: Informix-list mailing list archive (1991-1998)

We have a second virtual memory segment which we would like to free up. No users are currently using this segment but we do have 11 tables out of 773 using in for Dictionary Caching. Is there a way of either removing these tables from the Dictionary Cache or rehashing them to try and get them into the first segment ???? -- Earle A Long (Senior Informix DBA) SINGLEPOINT UK LTD

↪ replying to Earle A Long

Art S. Kagel — Wed, 07 Feb 2001 00:13:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Bounce the engine after setting the DD_ parameters lower. Art S. Kagel Earle A Long wrote: > > We have a second virtual memory segment which we would like to free up. No > users are currently using this segment but we do have 11 tables out of 773 > using in for Dictionary Caching. Is there a way of either removing these > tables from the Dictionary Cache or rehashing them to try and get them into > the first segment ???? > -- > Earle A Long (Senior Informix DBA) > SINGLEPOINT UK LTD

↪ replying to Art S. Kagel

Earle A Long — Mon, 12 Feb 2001 17:56:41 -0000 — source: Informix-list mailing list archive (1991-1998)

The whole point was that I wanted to free the second segment without bouncing the engine. It's not normally a problem cos after a level 0 backup (which creates a new segment) we free it. We had a peculiar set of circumstances which led to the backup being done at 8am with 1000+ users on and the second segment couldn't be freed. As it happens we hobbled along for a few days coaxing the backups along by making sure enough of the shared memory was free in the two segments before kicking it off. Then early one morning we bounced the engine. The DD_ parameters are set to :- DD_HASHMAX 511 DD_HASHSIZE 20 Yours -- Earle A Long (Senior DBA) SinglePoint Limited "Art S. Kagel" <kagel@erols.com> wrote in message news:3A80D966.387A9DA8@erols.com... > Bounce the engine after setting the DD_ parameters lower. > > Art S. Kagel > > Earle A Long wrote: > > > > We have a second virtual memory segment which we would like to free up. No > > users are currently using this segment but we do have 11 tables out of 773 > > using in for Dictionary Caching. Is there a way of either removing these > > tables from the Dictionary Cache or rehashing them to try and get them into > > the first segment ???? > > -- > > Earle A Long (Senior Informix DBA) > > SINGLEPOINT UK LTD >