Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Bangalore
    Posts
    15

    Unanswered: sybase replication server

    Hi ,

    I'm new to Sybase Rep Server and need some clarification. In the admin who, sqm command how are the entries to First Seg:block, Last Seg:block obtained.

    For eg executing admin who, sqm after an interval of 10 mins produced the following outputs. I'd like to know how the values for these to fields change and what is their significance :

    ---> Initial values from admin who, sqm.

    Spid State Info Duplicates Writes Reads Bytes B Writes B Filled B Reads B Cache Save_Integ First Seg.Block Last Seg.Block Next Read Readers Truncs

    11 Awaiting Message 105:1 FSSOLTP.TMW 1662 41053067 43659450 -1499452872 7223760 6684381 7928581 6162561 0:196048 196048.5 196048.5 196048.6.0 1 1


    ---> values after 10 mins

    11 Awaiting Message 105:1 FSSOLTP.TMW 1662 41058993 43665390 -1496848285 7224036 6684446 7928857 6162835 0:196052 196052.16 196052.25 196052.26.0 1 1


    Does this mean that this queue has grown in this time span. Why do the values of both first and last segment change ?

    Thanks a lot !

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97

    Re: sybase replication server

    Originally posted by gregarious
    Hi ,

    I'm new to Sybase Rep Server and need some clarification. In the admin who, sqm command how are the entries to First Seg:block, Last Seg:block obtained.

    For eg executing admin who, sqm after an interval of 10 mins produced the following outputs. I'd like to know how the values for these to fields change and what is their significance :

    ---> Initial values from admin who, sqm.

    Spid State Info Duplicates Writes Reads Bytes B Writes B Filled B Reads B Cache Save_Integ First Seg.Block Last Seg.Block Next Read Readers Truncs

    11 Awaiting Message 105:1 FSSOLTP.TMW 1662 41053067 43659450 -1499452872 7223760 6684381 7928581 6162561 0:196048 196048.5 196048.5 196048.6.0 1 1


    ---> values after 10 mins

    11 Awaiting Message 105:1 FSSOLTP.TMW 1662 41058993 43665390 -1496848285 7224036 6684446 7928857 6162835 0:196052 196052.16 196052.25 196052.26.0 1 1


    Does this mean that this queue has grown in this time span. Why do the values of both first and last segment change ?
    Space used in queues is administered in a similar way
    to ASE's syslogs.

    The last segment and block values move as new data are
    stored in the queue. First, the block advances until the
    segment is full (at block # 64); then, a new segment is
    assigned, and this segment may get the next segment
    number or not.

    The first segment and block contain the oldest data to
    be handled by RepServer. It is a concept similar to the
    truncation point in ASE's syslogs. As data are used, oldest
    blocks and segments are no longer needed and the
    first segment-block marker advances.

    Your first command shown a somewhat empty queue,
    as the first and last markers were the same. The second
    shown a queue with 10 blocks used (from 196052.16 to
    196052.25)

    Regards,
    Mariano Corral

Posting Permissions

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