Re: IFS text file versus CLOB field

Hello Greg,

Am 24.07.2020 um 22:39 schrieb Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>:

Seeking opinions on which of these methods is most "efficient" in the use of space category...

I am storing about 33K of ZPL data in a text file on the IFS.
I am also storing the same ZPL data in a DB2 table (along with a few other character and numeric fields).
The field is defined as ZPLII CLOB(65535) NOT NULL DEFAULT ''

IBM i IFS objects always were allocated in blocks of data. In V4R5, this was 64KiB and apparently changed somewhen. When looking at files in V7R2, it's 8KiB. I'm positively surprised! Less block size means less wasted space, but increased size of data structures for managing these additional blocks. If you have a lot of very small files with less than 1KiB in size, up to 7 KiB of space are overhead and not useable anymore for other files.

Anyway, purely seen with "space" in sight, it's likely that storage in QSYS.LIB database files is more efficient. Yet, also QSYS.LIB works with blocks, so your mileage may vary.

:wq! PoC

PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc