REORG TABLE sales AND INDEXES ALL;

RUNSTATS ON TABLE sales AND INDEXES ALL;

REORG TABLE sales INPLACE;

REORG INDEXES ALL FOR TABLE sales;

RUNSTATS ON TABLE salesAND INDEXES ALL;

RUNSTATS ON TABLE sales AND INDEXES ALL;

REORGCHK ON TABLE sales;

RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

1

2

3

4

As the db2 instance owner (db2inst1) execute the command:

exportDB2_FMP_COMM_HEAPSZ=256000

Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000

As the db2 instance owner (db2inst1) execute the command:

db2set –i DB2_FMP_COMM_HEAPSZ=256000

As the db2 instance owner (db2inst1)execute the command:

db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000