Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
-p returns the number of pages and page size can be anything from 4k to 32k. If you know the "typical" page size you could estimate the factor. Databases with BLU Acceleration have most data in 32k pages, most OLTP databases have 8k pages these days.
I assume this DB2 LUW. There was a related (but not the same) question with some background in the answer stackoverflow.com/questions/28586896/… Would the value of SQLUDMSTABLESPACEDATA (returned from "-p" option of db2ckbkp) help to estimate the size?
What kind of data is it? Is it relational? Do you need to read it once or more often from disk? Is it modified on disk? Any security considerations? ....?
