Kbase P76633: How to check whether an AI extent status is EMPTY, BUSY, FULL, LOCKED?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2007 |
|
Status: Verified
GOAL:
How to check whether an AI extent status is EMPTY, BUSY, FULL, LOCKED?
FIX:
The only way to determine whether an AI extent is EMPTY, BUSY, FULL, LOCKED is to run rfutil aimage list. E.g.
For all ai extents status:
rfutil <dbname> -C aimage list
or specifically for the first FULL extent:
rfutil <dbname> -C aimage full
Typically, this is used to return the full extent for manual archiving followed by emptying this extent. Below is an example of how this might be scripted.
## chkaiext.sh : Check AI extent status
rfutil /dbname -C aimage list
echo $?
USED=`rfutil /dbname -C aimage list | grep Start: | grep -v N\/A | wc -l | awk '{print $1}'`
EMPTY=`rfutil /dbname -C aimage list | grep Empty | wc -l | awk '{print $1}'`
LOCKED=`rfutil /dbname -C aimage list | grep LOCKED | wc -l | awk '{print $1}'`
echo "$? ${USED} ${EMPTY} ${LOCKED}" > /tmp/ckaiext.out