- 相關(guān)推薦
腳本中語句整理
一、三個節(jié)點
172.20.130.2 pengqiong pengqiong@123
202.197.234.149 linjin lijin*120384
202.197.234.6 node6work2 nohup sh run.sh
二、腳本投任務(wù)
172.20.130.2中腳本,開頭固定格式如下: #PBS -N MoSi2 #(名稱)
#PBS -l nodes=1:ppn=32
#PBS -j oe
#PBS -q middle
#PBS -l walltime=1000:00:00
cd $PBS_O_WORKDIR
NP=`cat $PBS_NODEFILE|wc -l`
source /public/software/http://emrowgh.com
for i in 0.05 0.07 0.08 0.09 0.1 0.11 0.12 0.13 0.14 0.15
do
cp POSCAR $i/ cd $i/
cat>>INCAR<<! ISPIN=2
!
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh > log cd ..
done
cd /public/home/pengqiong/MoSi2/C11b-stable/7/2/scf/scf/ chmod 777 vasp.pbs
qusb vasp.pbs
for i in NoH H HH
do mkdir $i/
cp INCAR* KPOINTS* $i/ cp POSCAR$i $i/POSCAR
cp POTCAR$i $i/POTCAR
cd $i/
mkdir relax/
cp INCARrelax KPOINTS POTCAR POSCAR relax/
cd relax/
cp INCARrelax INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh cp CONTCAR ../POSCAR
cd ..
cp INCARscf INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh
mkdir dos/
cp INCARdos KPOINTS POTCAR POSCAR CHGCAR dos/
cd dos/
cp INCARdos INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh cd ..
mkdir bands1/
cp INCARbands KPOINTSbands1 POTCAR POSCAR CHGCAR bands1/
cd bands1/
cp KPOINTSbands1 KPOINTS
cp INCARbands INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh cd ..
mkdir bands2/
cp INCARbands KPOINTSbands2 POTCAR POSCAR CHGCAR bands2/
cd bands2/
cp KPOINTSbands2 KPOINTS
cp INCARbands INCAR
《腳本中語句整理》全文內(nèi)容當(dāng)前網(wǎng)頁未完全顯示,剩余內(nèi)容請訪問下一頁查看。
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh cd ..
mkdir bands3/
cp INCARbands KPOINTSbands3 POTCAR POSCAR CHGCAR bands3/
cd bands3/
cp KPOINTSbands3 KPOINTS
cp INCARbands INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh cd ..
cd ..
done
for i in HH H NoH
do
cd $i/
mkdir berry/
cp INCARberry KPOINTSberry POTCAR POSCAR CHGCAR berry/
cd berry/
cp INCARberry INCAR
cp KPINTSberry KPOINTS
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh >logberry cd ..
cd ..
done
for i in 7 8 9 10 11 12 13 14 15 16 17 18 19 20
do
mkdir $i
cp INCAR POTCAR POSCAR $i/
cd $i/ cat>KPOINTS<<! A
0 G
$i $i 1
!
time -p /home/lijin/software/openmpi/openmpi_install/bin/mpirun -np 1 vasp5.3 | dateify.sh >logscf
E=`grep TOTEN OUTCAR | tail -1 | cut -c28-45`
Mag=`grep mag vasp.log | cut -c 70-80` printf " %18.16f %18.16f\n" $E $Mag >>../dat cd ..
done
cp INCARscf INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh>logscf
mkdir dos/
cp INCARdos KPOINTS POTCAR POSCAR CHGCAR dos/
cd dos/
cp INCARdos INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj |/public/software/vasp/date_lj.sh>logdos cd ..
mkdir bands1/
cp INCARbands KPOINTSbands1 POTCAR POSCAR CHGCAR bands1/
cd bands1/
cp KPOINTSbands1 KPOINTS
cp INCARbands INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj|/public/software/vasp/date_lj.sh>logbands1 cd ..
mkdir bands2/
cp INCARbands KPOINTSbands2 POTCAR POSCAR CHGCAR bands2/
《腳本中語句整理》全文內(nèi)容當(dāng)前網(wǎng)頁未完全顯示,剩余內(nèi)容請訪問下一頁查看。
cd bands2/
cp KPOINTSbands2 KPOINTS
cp INCARbands INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj|/public/software/vasp/date_lj.sh>logbands2 cd ..
mkdir bands3/
cp INCARbands KPOINTSbands3 POTCAR POSCAR CHGCAR bands3/
cd bands3/
cp KPOINTSbands3 KPOINTS
cp INCARbands INCAR
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp_lj|/public/software/vasp/date_lj.sh>logbands3
cd ..
cd ..
done
#PBS -N vasp #PBS -l nodes=1:ppn=32
#PBS -j oe
#PBS -q middle
#PBS -l walltime=1000:00:00
cd $PBS_O_WORKDIR
NP=`cat $PBS_NODEFILE|wc -l`
source /public/software/http://emrowgh.com
mpirun -machinefile $PBS_NODEFILE -np $NP --bind-to-core /public/software/vasp/vasp52 >&vasp.log
Ncpu=16
vaspname=vasp5.2
for i in 7 8 9 10 11 12 13 14 15 16
do mkdir $i/
cp INCAR POSCAR POTCAR $i/ cd $i/ cat>>KPOINTS<<!
A 0
G
$i $i 1
0 0 0
!
time -p mpirun -np $Ncpu $vaspname >log
E=`grep TOTEN OUTCAR |tail -1 |cut -c32-42`
Mag=`grep mag= log |tail -1 |cut -c68-85`
echo $i $Mag $E >>../total.dat
cp CONTCAR ../POSCAR$i
cd ..
Done
for i in 13 14 15
do
#-----------no magnetic----------
mkdir NM/
cp INCAR* POSCAR POTCAR NM/
cd NM/
mkdir $i/
cp INCAR* POSCAR POTCAR $i/
cd $i/
cp INCARrelax INCAR cat>KPOINTS<<! A
G
$i $i 1
0.0 0.0 0.0
!
time -p mpirun -np 16 vasp5.2 >logrelax
cp INCARscf INCAR
cp CONTCAR POSCAR
time -p mpirun -np 16 vasp5.2 >logscf
cd ..
cd ..
done
for i in 12 13 14 15
do
#----------Ferro magnetic---------
mkdir FM/
cp INCAR* POTCAR POSCAR FM/
cd FM/
mkdir $i/
cp INCAR* POTCAR POSCAR $i/
cd $i/
cp INCARrelax INCAR
cat>>INCAR<<!
ISPIN=2
!
cat>KPOINTS<<!
A
G
$i $i 1
0.0 0.0 0.0
!
time -p mpirun -np 16 vasp5.2 >logrelax
cp INCARscf INCAR
cat>>INCAR<<!
ISPIN=2
!
cp CONTCAR POSCAR
time -p mpirun -np 16 vasp5.2 >logscf
cd ..
cd ..
done
cd /home/node6work2/PQ/for/5*5/ chmod 777 run.sh
nohup sh run.sh
for n in $(seq 1 8)
do
echo $n
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $n vasp5.3 | dateify.sh
t=`grep "Total CPU" OUTCAR |awk '{print $6}'`
echo $n $t >>test_p.dat
done
for((j=0;j<21;j++))
do for((i=0;i<21;i++))
do jj=`echo "scale=8.8;$j/20"|bc` ii=`echo "scale=8.8;$i/20"|bc`
cat>>KPOINTSber<<!
$ii $jj 0.00000000 1.00 !
done
done
for i in 7 8 9 10 11 12 13 14 15 16 17 18 19 20 do
mkdir $i cp INCAR POTCAR POSCAR $i/
cd $i/
cat>KPOINTS<<!
A
G
$i $i 1
!
time -p /home/lijin/software/openmpi/openmpi_install/bin/mpirun -np 1 vasp5.3 | dateify.sh >logscf E=`grep TOTEN OUTCAR | tail -1 | cut -c28-45`
Mag=`grep mag vasp.log | cut -c 70-80`
printf " %18.16f %18.16f\n" $E $Mag >>../dat
cd ..
done
NCPU=24 vaspname=vasp5.3 for i in NoH H HH
do mkdir $i/
cp INCAR* KPOINTS POTCAR $i/
cp POSCAR$i $i/POSCAR
cp POTCAR$i $i/POTCAR
cd $i/
#--------------------no magnetic------------
mkdir NM/
cp INCAR* KPOINTS* POSCAR POTCAR NM/
cd NM/
cp INCARrelax INCAR
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logrelax cp INCARscf INCAR
cp CONTCAR POSCAR
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logscf cd ..
#----------------Ferro magnetic-------------
mkdir FM/
cp INCAR* KPOINTS POTCAR POSCAR FM/
cd FM/
cp INCARrelax INCAR
cat>>INCAR<<!
ISPIN=2
!
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logrelax cp INCARscf INCAR
cat>>INCAR<<!
ISPIN=2
!
cp CONTCAR POSCAR
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logscf
cd ..
#----------antiferro magnetic--------------- #mkdir AFM/
#cp INCAR* POSCAR KPOINTS POTCAR AM/ #cd AFM/
#cp INCARrelax INCAR
#cat >>INCAR<<!
#ISPIN=2
#MAGMOM=
#/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logrelax #cp INCARscf INCAR
#cp CONTCAR POSCAR
#/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $NCPU $vaspname | dateify.sh >logscf #cd ..
#-----------------------------------
cd .. # exit $i
done
cd /home/lijin/PQ/SMS/2L/
chmod 777 run.sh
./run.sh
mkdir scf/
cp INCARscf scf/INCAR
cp KPOINTSscf scf/KPOINTS
cp POTCAR POSCAR scf/
cd scf/
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $n vasp5.3 | dateify.sh >logscf cd ..
mkdir dos/
cp INCARdos dos/INCAR
cp KPOINTSdos dos/KPOINTS
cp POTCAR POSCAR dos/
cp scf/CHG* WAVECAR dos/
cd dos/
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $n vasp5.3 | dateify.sh >logdos rm CHG* WAVE* vasp*
cd ..
mkdir bands/ cp INCARbands bands/INCAR
cp KPOINTSbands bands/KPOINTS
cp POTCAR POSCAR bands/
cp scf/CHG* WAVECAR bands/
cd bands/
/home/lijin/software/openmpi/openmpi_install/bin/mpirun -np $n vasp5.3 | dateify.sh >logbands rm CHG* WAVE* vasp*
cd ..
#!/bin/sh
for i in 1.1 1.2 1.3 1.4 1.5 1.6 1.7 do
cat>POSCAR<<! Bi2Se3
$i
2.4189942319946462 0.0000000000000002 10.3661241500868702
-1.2094971159973227 2.0949102895767071 10.3661241500868702
-1.2094971159973227 -2.0949102895767071 10.3661241500868702
Se Bi
3 2
Selective dynamics
Direct
0.2204021036629392 0.2204021036629392 0.2204021036629392 T T T
0.7795978963370609 0.7795978963370609 0.7795978963370609 T T T
0.0000000000000000 0.0000000000000000 0.0000000000000000 T T T
0.3959198375051541 0.3959198375051542 0.3959198375051542 T T T
0.6040801624948458 0.6040801624948458 0.6040801624948458 T T T
0.00000000E+00 0.00000000E+00 0.00000000E+00
0.00000000E+00 0.00000000E+00 0.00000000E+00
0.00000000E+00 0.00000000E+00 0.00000000E+00
0.00000000E+00 0.00000000E+00 0.00000000E+00
0.00000000E+00 0.00000000E+00 0.00000000E+00
!
Echo “a=$i angstrom”; vasp
E=`grep “TOTEN” OUTCAR | tail -1 | awk{printf”%12.6f\n”,$5}` E=`grep “volume” OUTCAR | tail -1 | awk{printf”%12.4f\n”,$5}`
M=`grep ”number of electron” OUTCAR | tail -1 | awk {printf”%12.4f\n”,$6}` cp OUTCAR outcar.$i
echo $V $E >>EtVo.dat
Echo $i $E >>SUMMAY
Echo $i $M >>mag
一些常用sql腳本整理2017-04-26 17:32 | #2樓
一些實施和維護人員經(jīng)常遇到的問題,在這稍做整理,希望對大家有所幫助。 注:執(zhí)行這些腳本前,一定要備份數(shù)據(jù)。在測試環(huán)境中測試沒有問題后,方可使用。
1.預(yù)算系統(tǒng)預(yù)制用戶tbadmin刪除,如何恢復(fù)?
首先,建立前臺建立用戶tbadmin,后執(zhí)行以下腳本
update sm_user set cuserid= 'TB_NEW100000000004OP' where user_code='tbadmin' commit
2.5x版本固定資產(chǎn)做變動或者減少的時候,經(jīng)常參照不到,如何處理?
問題原因:已經(jīng)對該卡片做過變更操作,但是沒有確認完成,就有可能造成單據(jù)丟失 解決sql:
通過公司編碼查出公司pk
se-le-ct pk_corp from bd_corp where unitcode='3103' 1082
通過卡片編碼和公司pk.查出卡片pk和變動單pk
se-le-ct pk_card, bill_code from fa_card where card_code='0000000001' and pk_corp='1082' 查出bill_code 為1082V510000000000HR0
通過變動單pk,查詢變動單號
se-le-ct bill_code from fa_log where code='1082V510000000000HR0'
查出bill_code 為0_HG_BD0806180001
根據(jù)以上查詢出結(jié)果,進行修改,刪除變動單垃圾數(shù)據(jù),刪除前要查詢唯一性,及備份相應(yīng)的表
se-le-ct * from fa_altersheet where altersheet_code='HG_BD0806180001' and pk_corp='1082' update fa_altersheet set dr=1 where altersheet_code='HG_BD0806180001' and pk_corp='1082';
se-le-ct * from fa_bill where billcode='HG_BD0806180001' and pk_corp='1082'
update fa_bill set dr=1 where billcode='HG_BD0806180001' and pk_corp='1082';
se-le-ct * from fa_card where bill_code='0_HG_BD0806180001'
update fa_card set bill_code='' where bill_code='0_HG_BD0806180001';
se-le-ct * from fa_log where bill_code='0_HG_BD0806180001'
update fa_log set bill_code='' where bill_code='0_HG_BD0806180001'
3.刪除非現(xiàn)金科目的現(xiàn)金流量輔助信息
執(zhí)行以下sql,注意替換相應(yīng)的賬簿pk
create table ufbf2017071501 as se-le-ct * from gl_cashflowcase where pk_glorgbook = '0001V5100000000013SC' and pk_detail in(
se-le-ct distinct pk_detail from gl_detail,gl_voucher,bd_accsubj where gl_voucher.pk_voucher = gl_detail.pk_voucher and
gl_detail.pk_accsubj = bd_accsubj.pk_accsubj and gl_voucher.pk_glorgbook = '0001V5100000000013SC'
and bd_accsubj.CASHBANKFLAG = 0)
delete from gl_cashflowcase where pk_glorgbook = '0001V5100000000013SC' and pk_detail in(
se-le-ct distinct pk_detail from gl_detail,gl_voucher,bd_accsubj where gl_voucher.pk_voucher = gl_detail.pk_voucher and
gl_detail.pk_accsubj =
'0001V5100000000013SC' bd_accsubj.pk_accsubj and gl_voucher.pk_glorgbook =
and bd_accsubj.CASHBANKFLAG = 0)
4.余額表翻倍
問題原因:有可能是期初執(zhí)行ctrl+alt+t后,沒有馬上重建余額表
一定要先備份數(shù)據(jù)庫
查找有問題的主體賬簿主鍵(pk_glorgbook)
se-le-ct pk_glorgbook from bd_glorgbook where glorgbookcode = ''
執(zhí)行腳本,pk_glorgbook = '' 中寫入有問題的主體賬簿主鍵,注意修改相應(yīng)年度
update gl_detail set debitamount=debitamount/2,creditamount=creditamount/2,
fracdebitamount=fracdebitamount/2,fraccreditamount=fraccreditamount/2,
localdebitamount=localdebitamount/2,localcreditamount=localcreditamount/2,
debitquantity=debitquantity/2,creditquantity=creditquantity/2
where pk_voucher in (se-le-ct pk_voucher from gl_voucher where year = ''
and voucherkind = 2 and pk_glorgbook = '' and dr = 0)
【腳本中語句整理】相關(guān)文章:
flash課件制作常用的腳本語句09-24
校園電影腳本09-24
電影腳本制作09-24
平面拍攝腳本09-24
婚禮攝像腳本09-24
電影腳本寫作09-24
牙膏廣告腳本09-24
宣傳短片腳本09-24