Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: Force archive log

    db2 9.5 on windows
    Force archive log but still its there in active path ?

    below are details
    before this i forced the archive logs this is status as log 107 is archived it has only written in 949 pages and next log its writting currently is 108 below is the status

    Logs:
    Current Log Number 108
    Pages Written 0
    Method 1 Archive Status Success
    Method 1 Next Log to Archive 108
    Method 1 First Failure n/a
    Method 2 Archive Status n/a
    Method 2 Next Log to Archive n/a
    Method 2 First Failure n/a

    Address StartLSN State Size Pages Filename
    0x000007FFFD0B6568 0x00001B580000 0x00000000 1000 949 S0000107.LOG
    0x000007FFD4FCEF48 0x00001B968000 0x00000000 1000 1000 S0000108.LOG
    0x000007FFD4FCEE88 0x00001BD50000 0x00000000 1000 1000 S0000109.LOG
    0x000007FFFD0B6728 0x00001C138000 0x00000000 1000 1000 S0000110.LOG
    0x000007FFFD0BB468 0x00001C520000 0x00000000 1000 1000 S0000111.LOG

    -----------
    107 log is there in archived log path, but at this movement its also there in active path,
    -----
    archive log path
    -rwx------+ 1 Administrators None 4104192 Oct 13 12:22 S0000105.LOG
    -rwx------+ 1 Administrators None 4104192 Oct 13 12:22 S0000106.LOG
    -rwx------+ 1 Administrators None 3895296 Oct 13 12:31 S0000107.LOG
    ----------
    active log path
    -rwx------+ 1 Administrators None 4104192 Oct 13 12:31 S0000110.LOG
    -rwx------+ 1 Administrators None 3895296 Oct 13 12:31 S0000107.LOG
    ------------------
    after force archive it should not show me in active path please correct.

    regds
    paul


    regds
    paul

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    thks

    got ur point,

    do u have any of thread which gives idea abt 6 bytes RID, compare to 4 bytes, is reorg on indexes is enough after the conversation, wht if i don't have indexes in the table in that case ??

    regds
    paul

Posting Permissions

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