How to find if "full row logging" is enabled on a table

Technote (FAQ)


Question

How to find if full row logging is enabled on a table or not?

Answer

Run :


oncheck -pT <database_name>:<table_name> | more

Tables with full row logging enabled will have the following in the TBLspace Flags description:


    TBLspace flagged for Log Snooping.

Where as, tables without full row logging enabled, will not have this in TBLspace Flags.

Example:

For table "tab_cdc" having full row logging enabled, you see following:

    oncheck -pT test_db:tab_cdc | more

      TBLspace Report for test_db:informix.tab_cdc

          Physical Address         1:1041
          Creation date            04/09/2013 18:43:37
          TBLspace Flags           4000801    Page Locking
                                              TBLspace flagged for Log Snooping
                                              TBLspace use 4 bit bit-maps
          Maximum row size            4
          Number of special columns   0
          ...

    oncheck -pT output for table "tab_cdc" without full row logging enabled:

      oncheck -pT test_db:tab_cdc | more

        TBLspace Report for test_db:informix.tab_cdc

           Physical Address             1:1041
           Creation date                04/09/2013 18:43:37
           TBLspace Flags               8     Page Locking

                                               TBLspace use 4 bit bit-maps
           Maximum row size             4
           Number of special columns    0
           ...

    Rate this page:

    (0 users)Average rating

    Add comments

    Document information


    More support for:

    Informix Servers

    Software version:

    11.1, 11.5, 11.7, 12.1

    Operating system(s):

    AIX, HP-UX, Linux, Solaris, Windows

    Reference #:

    1633883

    Modified date:

    2013-04-11

    Translate my page

    Machine Translation

    Content navigation