VMS Help  —  RMU72  Using LogMiner for Rdb, Restrictions and Limitations
    The following restrictions exist for the LogMiner for Rdb
    feature:

    o  Temporary tables cannot be extracted. Modifications to
       temporary tables are not written to the after-image journal
       file and, therefore, are not available to LogMiner for Rdb.

    o  Optimized after-image journal files cannot be used as input
       to the LogMiner for Rdb. Information needed by the RMU Unload
       After_Journal command is removed by the optimization process.

    o  Records removed from tables using the SQL TRUNCATE TABLE
       statement are not extracted. The SQL TRUNCATE TABLE statement
       does not journal each individual data record being removed
       from the database.

    o  Records removed by dropping tables using the SQL DROP TABLE
       statement are not extracted. The SQL DROP TABLE statement does
       not journal each individual data record being removed from the
       database.

    o  Tables that use the vertical record partitioning (VRP) feature
       cannot be extracted using LogMiner for Rdb. LogMiner software
       currently does not detect these tables. A future release
       of Oracle Rdb will detect and reject access to vertically
       partitioned tables.

    o  Segmented string data (BLOB) cannot be extracted using
       LogMiner for Rdb. Because the segmented string data is
       related to the base table row by means of a database key,
       there is no convenient way to determine what data to extract.
       Additionally, the data type of an extracted column is changed
       from LIST OF BYTE VARYING to BIGINT. This column contains the
       DBKEY of the original BLOB data. Therefore, the contents of
       this column should be considered unreliable.

    o  COMPUTED BY columns in a table are not extracted. These
       columns are not stored in the after-image journal file.

    o  VARCHAR fields are not space padded in the output file. The
       VARCHAR data type is extracted as a 2-byte count field and a
       fixed-length data field. The 2-byte count field indicates the
       number of valid characters in the fixed-length data field. Any
       additional contents in the data field are unpredictable.

    o  You cannot extract changes to a table when the table
       definition is changed within an after-image journal file.
       Data definition language (DDL) changes to a table are not
       allowed within an .aij file being extracted. All records in an
       .aij file must be the current record version. If you are going
       to perform DDL operations on tables that you wish to extract
       using the LogMiner for Rdb, you should:

       1. Back up your after-image journal files.

       2. Extract the .aij files using the RMU Unload After_Journal
          command.

       3. Make the DDL changes.

    o  Do not use the OpenVMS Alpha High Performance Sort/Merge
       utility (selected by defining the logical name SORTSHR to
       SYS$SHARE:HYPERSORT) when using LogMiner for Rdb. HYPERSORT
       supports only a subset of the library sort routines that
       LogMiner requires. Make sure that the SORTSHR logical name
       is not defined to HYPERSORT.
Close Help