Why the table spaces specified in "EXCLUDE TABLESPACE dbname.tsname" statements are NOT being excluded from BMC AMI Reorg for Db2 processing? REORG TABLESPACE VS1001DB.% RTS COPYDDN (LP) REORG TABLESPACE VS1002DB.% RTS COPYDDN (LP) REORG TABLESPACE VS1009DB.% RTS COPYDDN (LP) EXCLUDE TABLESPACE VS1001DB.TS000005 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1001DB.TS001027 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1001DB.TSA00145 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1001DB.TS000145 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1001DB.TS000146 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1001DB.TS000149 <-- Why did AMI Reorg not excluding this table space? EXCLUDE TABLESPACE VS1002DB.TS000134 <-- Why did AMI Reorg not excluding this table space? |
When you specify a group of table spaces to reorganize, you can refine that list of table spaces by using the EXCLUDE TABLESPACE option. Basically, the EXCLUDE is part of the REORG syntax and needs to be inline with that REORG statement just like the specification for the object names. In this particular example, you have multiple REORG statements but the EXCLUDE statements are only after the last REORG statement. So the EXCLUDE in this case will only apply to the REORG statement for VS1009DB which explains why VS1001DB and VS1002DB tablespaces are not being excluded. The following example will allow BMC AMI Reorg for Db2 to exclude the table spaces specified in the EXCLUDE statements: ... REORG TABLESPACE VS1001DB.% RTS COPYDDN (LP) EXCLUDE TABLESPACE VS1001DB.TS000005 EXCLUDE TABLESPACE VS1001DB.TS001027 EXCLUDE TABLESPACE VS1001DB.TSA00145 EXCLUDE TABLESPACE VS1001DB.TS000145 EXCLUDE TABLESPACE VS1001DB.TS000146 EXCLUDE TABLESPACE VS1001DB.TS000149 REORG TABLESPACE VS1002DB.% RTS COPYDDN (LP) EXCLUDE TABLESPACE VS1002DB.TS000134 REORG TABLESPACE VS1009DB.% RTS COPYDDN (LP) ... |