Ebasso at 11:49, 13 September 2016

2016-09-13T11:49:16Z

Ebasso: /* Ver também */

2014-08-06T22:45:08Z

Ver também

← Older revision		Revision as of 22:45, 6 August 2014
Line 175:		Line 175:

	[[Category:IBM Connections]]		[[Category:IBM Connections]]
	[[Category:~~Tunning~~ IBM Connections]]		[[Category:Tuning IBM Connections]]

Ebasso at 14:34, 27 February 2014

2014-02-27T14:34:43Z

← Older revision		Revision as of 14:34, 27 February 2014
Line 167:		Line 167:


	== Ver também ==		= Ver também =

	* [[IBM Connections:Reorg Connections Databases]]		* [[IBM Connections:Reorg Connections Databases]]

Ebasso: /* Ver também */

2013-02-04T19:43:23Z

Ver também

← Older revision		Revision as of 19:43, 4 February 2013
Line 174:		Line 174:
	* [[IBM Connections\| Mais Artigos sobre IBM Connections]]		* [[IBM Connections\| Mais Artigos sobre IBM Connections]]

	[[~~Categoria~~: Tunning IBM Connections]]		[[Category:IBM Connections]]
			[[Category:Tunning IBM Connections]]

Ebasso: /* Ver também */

2013-02-04T19:23:47Z

Ver também

← Older revision		Revision as of 19:23, 4 February 2013
Line 174:		Line 174:
	* [[IBM Connections\| Mais Artigos sobre IBM Connections]]		* [[IBM Connections\| Mais Artigos sobre IBM Connections]]

	[[Categoria: Tunning: IBM Connections]]		[[Categoria: Tunning IBM Connections]]

Ebasso: /* Ver também */

2013-02-04T19:23:11Z

Ver também

← Older revision		Revision as of 19:23, 4 February 2013
Line 174:		Line 174:
	* [[IBM Connections\| Mais Artigos sobre IBM Connections]]		* [[IBM Connections\| Mais Artigos sobre IBM Connections]]

	[[Categoria: Tunning\| IBM Connections]]		[[Categoria: Tunning: IBM Connections]]

Ebasso: /* Ver também */

2013-02-04T19:22:29Z

Ver também

← Older revision		Revision as of 19:22, 4 February 2013
Line 174:		Line 174:
	* [[IBM Connections\| Mais Artigos sobre IBM Connections]]		* [[IBM Connections\| Mais Artigos sobre IBM Connections]]

	[[Categoria: Tunning, IBM Connections]]		[[Categoria: Tunning\| IBM Connections]]

Ebasso at 19:22, 4 February 2013

2013-02-04T19:22:10Z

← Older revision		Revision as of 19:22, 4 February 2013
Line 165:		Line 165:

	sh -x reorgWIKISIndex.txt		sh -x reorgWIKISIndex.txt


			== Ver também ==

			* [[IBM Connections:Reorg Connections Databases]]
			* [[IBM Connections:Limpeza de diretórios]]

			* [[IBM Connections\| Mais Artigos sobre IBM Connections]]

			[[Categoria: Tunning, IBM Connections]]

Ebasso: New page: With db2admin ---- db2 connect to PEOPLEDB db2 reorgchk update statistics on table all > resultadoPEOPLEDB.txt db2 terminate echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBTable.txt...

2011-06-28T21:17:15Z

New page: With db2admin ---- db2 connect to PEOPLEDB db2 reorgchk update statistics on table all > resultadoPEOPLEDB.txt db2 terminate echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBTable.txt...

New page

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

IBM Connections:Reorg Connections Databases - Revision history

Ebasso at 11:49, 13 September 2016

Ebasso: /* Ver também */

Ebasso at 14:34, 27 February 2014

Ebasso: /* Ver também */

Ebasso: /* Ver também */

Ebasso: /* Ver também */

Ebasso: /* Ver também */

Ebasso at 19:22, 4 February 2013

Ebasso: New page: With db2admin ---- db2 connect to PEOPLEDB db2 reorgchk update statistics on table all > resultadoPEOPLEDB.txt db2 terminate echo "db2 connect to PEOPLEDB" > reorgPEOPLEDBTable.txt...