Question: what is npages in db2?
Answer: NPAGES Total number of pages on which rows of the partition appear. NACTIVE Number of active pages in the partition. For Segmented TS presumedly NACTIVE excludes inactive pages belonging to DROPPED Tables, plus the following.