Skip to main content

Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

Hy
i usually do like this

SELECT FOF TO LIST
LOOP 
READNEXT KEY FROM LIST ELSE EXIT
READ F.FILE FROM FOF,KEY ELSE CONTINUE
EXECUTE 'SELECT  ':F.FILE<1>:",":F.FILE<2>:","
REPEAT
STOP


Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

The solution as proposed by Alberto works with the following caveats:

  1. It took one hour on our system to complete
  2. It is very CPU intensive

By comparison, a file-save took only 5 minutes and achieved the same objective.  The time taken and CPU intensity are basically irrelevant as this process would take place as a part of the cold-start process at midnight after the VM shuts down, performs a backup and then restarts.

My question therefore becomes: Is there a way to script the file-save process from Linux that will run unattended?

Brian, can you help in this regard?

Vincent


Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

Hi Vincent,

You can perform a 'dummy' save executing this command:

save (fsxy

This will read all your data from disk including anything that is in files that have been dx'ed or dy'ed but it doesn't bother writing it anywhere. 

You could set up a cron job that runs a script like this one:

#!/bin/bash
d3 -r -n pick0 -d "dm dm save (fsxy exit "

That assumes that the DM user and account do not have passwords set.

Cheers.


Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

One question... you reboot your VM everyday ?

if you want when the VM starts you can add to coldstart the step to execute the file-save
and since you just did one before reboot you can use check-account macro that does a dummy save ( all the file-save without the save)
https://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/102/refman/TCL/check_account_macro.htm#reference2651


Hi,

We operate D3/Linux 10.2 in a VM that has 16Gb of RAM assigned to it.

As our database is currently only 6.1 Gb in total, is there anyway to pre or force load the entire database into RAM rather than just waiting on it to be loaded during the normal course of use? 

Vincent

Alberto and Chris,

Thanks a mil... you are both champs.

Vincent