Date:         Mon, 5 Jun 1995 10:29:50 EDT
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         "Nicholas A.Rawlings"
Subject:      Re: Switching between shared and local DB

A good NOMAD customer (maybe that's redundant) in Atlanta uses the
following method to advantage. When they want to report "locally"
without bringing the server down and without worrying about the
age-old problem of reading a disk someone else is writing to, they
connect to the server the old, standard, way
   DATABASE BIGSTUFF OWNER RALPH;
Then, using selective DBCLEAR, they DBCLEAR all but a single
"tracking"  master, which they use to log activity of the overall
application. With this single "thread" to the server, they LOCK that
one master. Then, with code like Bill Ryan's, they link and access the
server's disk, issue a DBADD BIGSTUFF without the OWNER spec.
They run their LIST and then UNLOCK. TRANS is used around the DBADD
and the call to the LIST proc, which, by the way, runs prescanned.

A caution: obviously, LOCKs slow other users, so don't choose this
path lightly. On the other hand, a slow LISTer can slow all other
users as well.
back to index