syscompdicts_full

The syscompdicts_full table and the syscompdicts view provide information on all compression dictionaries. The only difference between the table and the view is that, for security purposes, the view does not contain the dict_dictionary column.

Only user informix can retrieve information from the syscompdicts_full table. The syscompdicts view is not restricted to user informix.

The following table shows the information that the syscompdicts_full table and the syscompdicts view provide for each compression dictionary.

Table 1. Compression Dictionary Information
Column	Type	Description
dict_partnum	integer	Partition number to which the compression dictionary applies
dict_code_version	integer	Version of the code that is creating the compression dictionary `1` is the first version.
dict_dbsnum	integer	Number of the dbspace that the dictionary resides in
dict_create_timestamp	integer	Timestamp that shows when the dictionary was created
dict_create_loguniqid	integer	Unique ID for the logical log that was active when the dictionary was created
dict_create_logpos	integer	Position within the logical log when the dictionary was created
dict_drop_timestamp	integer	Timestamp that shows when the dictionary was dropped.
dict_drop_loguniqid	integer	Unique ID for the logical log that was created when the dictionary was dropped.
dict_drop_logpos	integer	Position within the logical log when the dictionary was dropped.
dict_dictionary	byte	Compression dictionary binary object This column is not included in the syscompdicts view.

Sample syscompdicts information

A row of information in the syscompdicts view could displays columns containing this information:

dict_partnum        1048939
dict_code_version   1
dict_dbsnum         1
dict_create_times+  1231357656
dict_create_logun+  11
dict_create_logpos  1695768
dict_drop_timesta+  0
dict_drop_loguniq+  0
dict_drop_logpos    0

You can use an UNLOAD statement to unload the compression dictionary to a compression dictionary file, as follows:

UNLOAD TO 'compression_dictionary_file'
   SELECT * FROM sysmaster:syscompdicts_full;