Skip to content

How to mount media in Unix

1.Log on to youe UNIX/Linux srever as root or sudo to root.
2.Place the compact disk (CD) in the media tray.
3.Run “ls /media” to check if the media path is cdrom or cdrecorder
4. Mount the disk by running bellow command:
mount /media/cdrom
OR
mount /media/cdrecorder

To unmount just use the command unmount instead of mount.

FATAL 1: 548 : The permitted number of client connections has been exceeded

ERROR:

FATAL 1: 548 : The permitted number of client connections has been exceeded

You will get this error even whe you try to run nz commands:

/nz/kit/log->nzsql
nzsql: FATAL 1: 548 : The permitted number of client connections has
been exceeded

/nz/kit/log->nzstate
Error: DB connect failed: FATAL 1: 548 : The permitted number of
client connections

/nz/kit/log->nzhw -issues
Error: DB connect failed: FATAL 1: 548 : The permitted number of
client connections
You have new mail in /var/spool/mail/nz

/nz/kit/log->nzstate -u admin
Error: DB connect failed: FATAL 1: 548 : The permitted number of
client connections

CAUSE:

This issue happens when maximum allowed connection is reached.
To check the current maximum allowed connections run below command:
/export/home/nz->nzsystem showRegistry | grep maxConnections
startup.maxConnections = 500

Maximum allowed limit is 2000 but cna be configured using system parameter startup.maxConnections in /nz/data/config/system.cfg file. Any update in this file needs nzstop/nzstart for the change to take effect.

RESOLUTION:

As of now (until NPS 7.0.3) the only way to resolve this issue is to either wait for the connections to go away or restart NPS by isusing nzstop and nzstart. Their is no dedicated connection available for ADMIN user to connect in this scenario so you cannot do much to find as why and who is making this many connections. Enhancement# 71319 is in place to get some functionality added to allow ADMIN to connect in this scenario.

Before restrt try to collect below info to open a case with IBM else IBM will just say that system was restrted so we cannot figure out what happened.

Just save this script and run to collect all the details before restart:

echo “Starting diagnostics.sh”
DATE=`date ‘+%Y%m%d%H%M%S’`
OUTLOG=diagnostics${DATE}.log
echo “Starting diagnostics.sh” >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzrev” >> ${OUTLOG}
nzrev >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzstate” >> ${OUTLOG}
nzstate >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzstats” >> ${OUTLOG}
nzstats >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzhw -issues” >> ${OUTLOG}
nzhw -issues >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzds -issues” >> ${OUTLOG}
nzds -issues >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsession” >> ${OUTLOG}
nzsession >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzstats -type query -orient vertical” >> ${OUTLOG}
nzstats -type query -orient vertical >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzstats -type host” >> ${OUTLOG}
nzstats -type host >> ${OUTLOG}
date >> ${OUTLOG}
echo “ps -efw –forest | grep ^nz” >> ${OUTLOG}
ps -efw –forest | grep ^nz >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsql show locks” >> ${OUTLOG}
nzsql -c “show locks” >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa schedqueues -sys” >> ${OUTLOG}
nzsqa schedqueues -sys >> ${OUTLOG}
date >> ${OUTLOG}
echo “select * from _v_group” >> ${OUTLOG}
nzsql -c “select * from _v_group” >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa workrank -sys” >> ${OUTLOG}
nzsqa workrank -sys >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa interactions -sys” >> ${OUTLOG}
nzsqa interactions -sys >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa responders -sys” >> ${OUTLOG}
nzsqa responders -sys >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa transactions -sys” >> ${OUTLOG}
nzsqa transactions -sys >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzstats -type spupartition | grep Swap” >> ${OUTLOG}
nzstats -type spupartition | grep Swap >> ${OUTLOG}
date >> ${OUTLOG}
echo “nzsqa proctbl -all” >> ${OUTLOG}
nzsqa proctbl -all | grep “CPU Util” >> ${OUTLOG}
date >> ${OUTLOG}
echo “Checking Host CPU” >> ${OUTLOG}
top -b -n 1 | head >> ${OUTLOG}
sleep 5
top -b -n 1 | head >> ${OUTLOG}
sleep 5
top -b -n 1 | head >> ${OUTLOG}
date >> ${OUTLOG}
echo “Checking Host Memory” >> ${OUTLOG}
sar -A | grep mem -A 15 >> ${OUTLOG}
date >> ${OUTLOG}
echo “Checking size of system catalogs” >> ${OUTLOG}
du -sh /nz/data.1.0 >> ${OUTLOG}
date >> ${OUTLOG}
tar cvf plans_${DATE}.tar /nz/data/plans
echo “Completed diagnostics.sh” >> ${OUTLOG}
echo “Completed diagnostics.sh”