How to redirect a REORG to another drive

Question: I’m attempting to complete a REORG on tables and indexes but don’t have enough disk space for the REORG activities? Is it possible to redirect a REORG ? The error message in the dbdiag.log is “ADM6017E The underlying file system is full” Answer: It is possible to redirect the REORG to a TEMPORARY TABLESPCE on another drive , execute the REORG statement and utilise the TEMPORARY TABLESPCE The basic steps to redirect a DB2 REORG to another drive: a) provision another drive with sufficient space. In the example below – it’s X:\reorg_temp b) Create TEMPORARY TABLESPACE . In the... Read more →