Catatan Sang Pelupa
Catatan Catatan kecil, buat sang pelupa :D
Kamis, 10 Oktober 2013
script SAP DB2 restore
#!/bin/sh
echo "Starting Proses Restoring"
date
echo ""
/db2/db2dxp/sqllib/adm/db2stop force
/db2/db2dxp/sqllib/adm/db2start
hari=`date|awk '{print $1}'`
echo "Hari ini "$hari
if [ $hari = Mon ]; then
days=sabtu
else
if [ $hari = Tue ]; then
days=senin
else
if [ $hari = Wed ]; then
days=selasa
else
if [ $hari = Thu ]; then
days=rabu
else
if [ $hari = Fri ]; then
days=kamis
else
if [ $hari = Sat ]; then
days=jumat
fi
fi
fi
fi
fi
fi
echo "Convert " $hari " --> "$days
echo "Restore database DXP hari "$days
date
echo ""
cd /tmp
/db2/db2dxp/db2_software/bin/db2 deactivate db DXP
/db2/db2dxp/db2_software/bin/db2 restore database DXP from /sapiso/SAPPRO/db2/backup/$days REPLACE EXISTING
/db2/db2dxp/db2_software/bin/db2 rollforward db DXP query status
echo "Extract log database DXP"
date
echo ""
cd /sapiso/SAPPRO/db2/backup/$days
tar -xvf backuplog$days.tar
mv S*.LOG /db2/DXP/log_dir
echo "Restore log database DXP"
date
echo ""
/db2/db2dxp/db2_software/bin/db2 "rollforward db DXP to end of logs and complete overflow log path ('/db2/DXP/log_dir')"
/db2/db2dxp/db2_software/bin/db2 activate db DXP
/db2/db2dxp/db2_software/bin/db2 rollforward db DXP query status
echo " Restore Completed"
date
echo ""
cd /db2/DXP/log_dir
rm S*LOG
Senin, 01 November 2010
Setting Procuve switch VLAN
vlan 1
name "DEFAULT_VLAN"
untagged 1
ip address 10.10.10.10 255.255.255.0
no untagged 2-49
exit
vlan 20
name "VLAN2"
untagged 2-10
no ip address
tagged 50
exit
vlan 30
name "VLAN3"
untagged 11-12
no ip address
tagged 50
exi
name "DEFAULT_VLAN"
untagged 1
ip address 10.10.10.10 255.255.255.0
no untagged 2-49
exit
vlan 20
name "VLAN2"
untagged 2-10
no ip address
tagged 50
exit
vlan 30
name "VLAN3"
untagged 11-12
no ip address
tagged 50
exi
Langganan:
Postingan (Atom)