Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: IDS 9.21 Logical Logging

    We have a select with subselects that are causing a lot of data to be written to the logical logs. When I take out the subselects, the logging activity stops. Does the subselect cause data to be written to logical logs, and how can this be prevented---for example, the no log option when using temp tables?



  2. #2
    Join Date
    Aug 2005
    put your select here.

    But in generally, you can avoid writing to the logical logs by:
    using temp tables with no log option
    using raw tables
    turning off database logging

    ps:select is read only operation...i don't think it is the cause of using logical logs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts