Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: Archive log size question

    We have the user exit enabled and are archiving the logs. We are noticing strange behaviour in this as the file size of the primary logs is something quite larger than that of the archive logs.

    DB2 v8 FP2 on AIX 5.1

    For example

    No of Primary Logs is 30
    LOGFILSIZ is 1500

    this is the size of the file that gets archived:

    -rw------- 1 avcpa1 avcpa1 16384 Sep 24 06:17 S0025643.LOG

    But in the primary log location it is much larger, is there some compression taking place in the archiving process?

    Mark

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Archive log size question

    Originally posted by mark_maz
    this is the size of the file that gets archived:

    -rw------- 1 avcpa1 avcpa1 16384 Sep 24 06:17 S0025643.LOG

    But in the primary log location it is much larger, is there some compression taking place in the archiving process?

    Are you by any chance writing the archived logs to tape with hardware compression on? Just a thought...
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    The user exit is writing to disk and there should be compression on the "move" of the files

  4. #4
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150
    There is no compression on as far as I know

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Look into your userexit source code ? That might have an answer ..

    Cheers
    Sathyaram

    Originally posted by mark_maz
    There is no compression on as far as I know
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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