Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    2

    Question Unanswered: dump tran command

    Call me dumb ! but I can't get around this issue !!!

    I have a database fragment that has used all of it's allocated memory space. When doing normal housekeeping duties, we use the 'dump tran' command to do a clear out. For some reason, when I process this command it will not remove the 0(zero) byte file, (using the 'dump tran **** with truncate_only' or 'no_log')

    This is an extract of the issue:

    vill_dat 750.0 MB

    Feb 03, 1999
    select into/bulkcopy, allow nulls by default


    device_fragments size usage free kbytes
    ------------------------------ ------------- -------------------- -----------
    sybdata1 100.0 MB data only 102400
    sybdata1 150.0 MB data only 99856
    sybdata2 100.0 MB data only 102400
    sybdata2 150.0 MB data only 129296
    sybindex1 30.0 MB data only 30720
    sybindex1 50.0 MB data only 26848
    sybindex2 10.0 MB data only 9392
    sybindex2 30.0 MB data only 0
    sybindex2 50.0 MB data only 32
    syblogs 30.0 MB log only 30688
    syblogs 50.0 MB log only 51200

    Can anyone shed any light on this please.......

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya Spooky,

    I'm pretty sure you are trying to say that DUMP TRAN did not clear the from device sybindex2.

    What is on this device? Is this a data or a log device?
    DUMP TRAN only clears from log devices.

    If this is a log device, then check syslogshold system table in your database if there are any open transactions running at the time DUMP TRAN was run.

    Cheers
    Willy

  3. #3
    Join Date
    May 2003
    Posts
    2

    Thumbs up

    Originally posted by willy_and_the_ci
    Hiya Spooky,

    I'm pretty sure you are trying to say that DUMP TRAN did not clear the from device sybindex2.

    What is on this device? Is this a data or a log device?
    DUMP TRAN only clears from log devices.

    If this is a log device, then check syslogshold system table in your database if there are any open transactions running at the time DUMP TRAN was run.

    Cheers
    Willy
    Thanks Willy,

    but with me being a total numpty in the Sybase area...
    can you help with the syntax of the SYSLOGSHOLD command - sorry !!

Posting Permissions

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