Mark,
Here is a script that I use to see what processes are
using the database. You would need to change the
directory paths:
export gtm_dist=/usr/local/gtm
export gtm_log=/usr/local/gtm/log
export gtm_vista=$HOME/OpenVistA_UserData
export gtm_vista_prod=/usr/local/OpenVistA
export gtmgbldir=$gtm_vista_prod/g/mumps.gld
export gtmroutines=".$gtm_dist"
export gtmroutines="$gtm_vista/o($gtm_vista_prod/r
$gtm_vista/r $gtm_dist) $gtm_dist()"
PATH=$PATH:$gtm_dist
export vista_home=$gtm_vista
#-----------------------------
if [ $# -gt 0 ]
then
echo "Starting MUPIP..."
echo "Will try to stop process $1"
$gtm_dist/mupip stop $1
else
echo "-------------------------------- "
echo "Here are current mumps processes"
ps -A | grep mumps
echo "-------------------------------- "
echo " "
echo "To abort one of these, type: "
echo " "
echo "sh mupip XXXX"
echo " "
echo "(where XXXX=process number)"
echo " "
fi
echo " "
echo " "
----------------
I use it like this:
sh mupip
It then lists processes that are using the database.
If I want to abort them, I type
sh mupip 1234
to abort process number 1234
Kevin
--- Mark Street <[EMAIL PROTECTED]> wrote:
> On Monday 07 March 2005 20:01, Bhaskar, KS wrote:
> > Kevin
> > Why do you suspect a database issue rather than an
> application logic issue?
> > In any case, if there is a suspected datbase
> issue, do a mupip integ on
> > it.
>
> OK, interesting. Unfortunately I haven't done my
> homework on journaling.
> mupip integ
> File or Region: /home/vista/2.5/g/mumps.dat
> /home/vista/2.5/g/mumps.dat -> File already open by
> another process.
> Resource temporarily unavailable
> %GTM-I-MUSTANDALONE, Could not get exclusive access
> to /home/vista/2.5/g/mumps.dat
> %GTM-E-INTEGERRS, Database integrity errors
>
> > Also, Mark, if you are powering down your PC, you
> should shut down
> > processes first. Or run journaling. Or both.
>
> I don't power down my servers unless the power goes
> out.
>
> --
> Mark Street, RHCE
> http://www.oswizards.com
> --
> Key fingerprint = 3949 39E4 6317 7C3C 023E 2B1F
> 6FB3 06E7 D109 56C0
> GPG key http://www.oswizards.com/pubkey.asc
>
>
>
-------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT
> Products from real users.
> Discover which products truly live up to the hype.
> Start reading now.
>
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Hardhats-members mailing list
> [email protected]
>
https://lists.sourceforge.net/lists/listinfo/hardhats-members
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
