IBM Connections:Reorg Connections Databases

With db2admin

db2 connect to PEOPLEDB db2 reorgchk update statistics on table all > resultadoPEOPLEDB.txt db2 terminate echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBTable.txt cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgPEOPLEDBTable.txt echo "db2 terminate" >> reorgPEOPLEDBTable.txt echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBIndex.txt cat resultadoPEOPLEDB.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgPEOPLEDBIndex.txt echo "db2 terminate" >> reorgPEOPLEDBIndex.txt sh -x reorgPEOPLEDBTable.txt sh -x reorgPEOPLEDBIndex.txt

db2 connect to BLOGS db2 reorgchk update statistics on table all > resultadoBLOGS.txt db2 terminate echo "db2 connect to BLOGS" > reorgBLOGSTable.txt cat resultadoBLOGS.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgBLOGSTable.txt echo "db2 terminate" >> reorgBLOGSTable.txt echo "db2 connect to BLOGS" > reorgBLOGSIndex.txt cat resultadoBLOGS.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgBLOGSIndex.txt echo "db2 terminate" >> reorgBLOGSIndex.txt sh -x reorgBLOGSTable.txt sh -x reorgBLOGSIndex.txt

db2 connect to DOGEAR db2 reorgchk update statistics on table all > resultadoDOGEAR.txt db2 terminate echo "db2 connect to DOGEAR" > reorgDOGEARTable.txt cat resultadoDOGEAR.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgDOGEARTable.txt echo "db2 terminate" >> reorgDOGEARTable.txt echo "db2 connect to DOGEAR" > reorgDOGEARIndex.txt cat resultadoDOGEAR.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgDOGEARIndex.txt echo "db2 terminate" >> reorgDOGEARIndex.txt sh -x reorgDOGEARTable.txt sh -x reorgDOGEARIndex.txt

db2 connect to FILES db2 reorgchk update statistics on table all > resultadoFILES.txt db2 terminate echo "db2 connect to FILES" > reorgFILESTable.txt cat resultadoFILES.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgFILESTable.txt echo "db2 terminate" >> reorgFILESTable.txt echo "db2 connect to FILES" > reorgFILESIndex.txt cat resultadoFILES.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgFILESIndex.txt echo "db2 terminate" >> reorgFILESIndex.txt sh -x reorgFILESTable.txt sh -x reorgFILESIndex.txt

db2 connect to FORUM db2 reorgchk update statistics on table all > resultadoFORUM.txt db2 terminate echo "db2 connect to FORUM" > reorgFORUMTable.txt cat resultadoFORUM.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgFORUMTable.txt echo "db2 terminate" >> reorgFORUMTable.txt echo "db2 connect to FORUM" > reorgFORUMIndex.txt cat resultadoFORUM.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgFORUMIndex.txt echo "db2 terminate" >> reorgFORUMIndex.txt sh -x reorgFORUMTable.txt sh -x reorgFORUMIndex.txt

db2 connect to HOMEPAGE db2 reorgchk update statistics on table all > resultadoHOMEPAGE.txt db2 terminate echo "db2 connect to HOMEPAGE" > reorgHOMEPAGETable.txt cat resultadoHOMEPAGE.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgHOMEPAGETable.txt echo "db2 terminate" >> reorgHOMEPAGETable.txt echo "db2 connect to HOMEPAGE" > reorgHOMEPAGEIndex.txt cat resultadoHOMEPAGE.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgHOMEPAGEIndex.txt echo "db2 terminate" >> reorgHOMEPAGEIndex.txt sh -x reorgHOMEPAGETable.txt sh -x reorgHOMEPAGEIndex.txt

db2 connect to OPNACT db2 reorgchk update statistics on table all > resultadoOPNACT.txt db2 terminate echo "db2 connect to OPNACT" > reorgOPNACTTable.txt cat resultadoOPNACT.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgOPNACTTable.txt echo "db2 terminate" >> reorgOPNACTTable.txt echo "db2 connect to OPNACT" > reorgOPNACTIndex.txt cat resultadoOPNACT.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgOPNACTIndex.txt echo "db2 terminate" >> reorgOPNACTIndex.txt sh -x reorgOPNACTTable.txt sh -x reorgOPNACTIndex.txt

db2 connect to SNCOMM db2 reorgchk update statistics on table all > resultadoSNCOMM.txt db2 terminate echo "db2 connect to SNCOMM" > reorgSNCOMMTable.txt cat resultadoSNCOMM.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgSNCOMMTable.txt echo "db2 terminate" >> reorgSNCOMMTable.txt echo "db2 connect to SNCOMM" > reorgSNCOMMIndex.txt cat resultadoSNCOMM.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgSNCOMMIndex.txt echo "db2 terminate" >> reorgSNCOMMIndex.txt sh -x reorgSNCOMMTable.txt sh -x reorgSNCOMMIndex.txt

db2 connect to WIKIS db2 reorgchk update statistics on table all > resultadoWIKIS.txt db2 terminate echo "db2 connect to WIKIS" > reorgWIKISTable.txt cat resultadoWIKIS.txt | grep Table: | awk -F: '{ print "db2 reorg table" $2 }' >> reorgWIKISTable.txt echo "db2 terminate" >> reorgWIKISTable.txt echo "db2 connect to WIKIS" > reorgWIKISIndex.txt cat resultadoWIKIS.txt | grep Table: | awk -F: '{ print "db2 reorg indexes all for table" $2 }' >> reorgWIKISIndex.txt echo "db2 terminate" >> reorgWIKISIndex.txt sh -x reorgWIKISTable.txt sh -x reorgWIKISIndex.txt