MVSFORUMS.com

[maverick05]

Any idea how mainframe flat file compression works? I believe it compresses the data but not the flat file .Suppose if I want to load this flat file to a Db2 table,do I need to decompress the data flat file again?

How do I differentiate between two files that has normal data and another that has compressed data?

[papadi]

How many places do you intend to ask this. . .

Which are you really working with? A compressed unload or some external compressed flat file?

[maverick05]

well I'm just hoping to get a better answer.I googled compression but didn't get any satisfied answer.I have unloaded a db2 table to a flat file.I'm confused whether I need to decompress the data while loading it back to a another db2 table and whether I can find out any difference by looking at a data of a flat file if it is compreseed or not.

[kolusu]

maverick05,

You are mixing up 2 different issues. A DB2 compression is quite different from Dataset compression.

And as to answer your question it doesn't matter if you unload compressed DB2 table data. You can load as is onto another table without decompressing.

If you want to learn about dataset compression search for "compression" in the following link

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2D4A0/CCONTENTS?

Kolusu

PS: Please do NOT cross post across boards. Pick a board of your choice and wait for at least 8 hours before you post on other boards.

[delta403]

Are you getting any error while loading; Please share.

[maverick05]

nope.Will try and let you know incase of any issues.Just want to get info before I do load

[papadi]

What info are you trying to "get"?

So far it appears that you have considerable misunderstanding/confusion.

If you post more clearly what you are looking for, someone should have answers.
_________________
All the best,

di