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;

Copyright© 2019 HCL Technologies Limited