Kamis, 10 Oktober 2013

some usefull SAP T-code

Unlock user admin ZIMBRA

su zimbra
 zmprov ma admin@domain.com  zimbraAccountStatus active

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