I have a requirement to read the pzPVStream column from a stand-alone Java application. When I researched a bit about this, I got to know the contents of the column are compressed befored stored into database. Does pega has a detailed documentation of what compression format or algorithm is used? Or is there any Java Public APIs available to extract the individual properties from this column?
Thanks mahesh86, as your answer helped me to decompress the the pzPVStream column. From the link you shared, it is evident that the pega uses the DeflaterOutputStream class of JDK to compress the data. So, I decompressed the data using the corresponding Inflater class of JDK.
Some additional details to consider if anyone wants to decompress the pzPVStream data using Java. The Inflater object should be created with nowrap argument set to true. The compressed bytes seem to start from the 11th byte of the pzPVStream blob. So, the Inflater object should be given input from the 11th byte of the blob bytes.
Also, BIX package also seem to be a viable solustion. Thanks for everyone who brought it up. But with my current requirements, I have to prefer a solution which does not use BIX package.