-23101 Unable to load locale categories

Linux系統下執行.sh文件時，出現以下錯誤：

-23101 Unable to load locale categories

腳本文件功能：unload備份數據.

unload.sh

INFORMIXDIR=/u/inf7.3;export INFORMIXDIR
PATH=$INFORMIXDIR/bin:$PATH;export PATH
INFORMIXSERVER=on_tcp190;export INFORMIXSERVER
ONCONFIG=onconfig.oth;export ONCONFIG
DB_LOCALE=zh_tw.big5;export DB_LOCALE
CLIENT_LOCALE=zh_tw.big5;export CLIENT_LOCALE
SERVER_LOCALE=zh_tw.big5;export SERVER_LOCALE
DBDATE=Y4MD0;export DBDATE
DBCENTURY=C;export DBCENTURY
DBDELIMITER=^A;export DBDELIMITER
PS1=`hostname`'$';export PS1

#############################################################
echo "begin_dbaflag  `date +%Y-%m-%d`  `date +%H:%M:%S`"
cd /exp/backup/backupdata
day=`date +%w`
rm -rf xa*

dbaccess sysmaster <unload to db.txt delimiter "|"
select name from sysdatabases where name not like "sys%"
and name not like "%_bak" and name not like "%_rep"
!

sed 's/|//g' db.txt > db1.txt
cat db1.txt > db.txt
rm -rf db1.txt

if [ -d $day ]
then
rm -rf $day
fi
mkdir $day

cat db.txt |split -l  $PER
ls xa* > tab
cat tab|while read line
do
   sh unload1.sh $line > $line.log  2>&1  &
done
rm -rf tab
echo "end_dbaflag  `date +%Y-%m-%d`  `date +%H:%M:%S`"

分析出錯的原因：腳本中和DB有關的變量有誤造成的。所以我們在撰寫這樣的腳本時一定要使sh文件中的變量同功能帳號下.profile中相應變量保持一致！

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7836221/viewspace-600784/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7836221/viewspace-600784/