AUTOLOAD (JANUS DEFINE parameter)

From m204wiki
Jump to navigation Jump to search

Automatically reload table definitions on an SDS port

AUTOLOAD is a parameter on JANUS DEFINE, which defines and sets characteristics of a Janus port.

This parameter indicates that the incore copy of Janus tables are to be reloaded at the first request subsequent to a table redefinition. This eliminates the need to issue JANUS RELOAD commands to reload table definitions after changes have been made.

AUTOLOAD does have a few disadvantages, however. First, if several table definitions are being changed while SQL requests are being processed on a port, Janus might end up performing the reload process several times where issuing a JANUS RELOAD command at the end of all the changes would result in a single reload. Doing multiple reloads could be a significant expense if the number of JANCAT table definitions is large. The other disadvantage of AUTOLOAD is that the reload doesn't happen until a request arrives on the port. This means that the user issuing the request could encounter a significant delay as the Janus port is reloaded. A JANUS RELOAD command before the request comes in would ensure that the table definitions would already be loaded so no extra delay would be encountered.

Note that it is perfectly valid to issue a JANUS RELOAD command on an AUTOLOAD port.

Valid only for SDS (also known as OMNI or OAS) ports.

See also