Professional Web Applications Themes

very slow deletes after tablespace was nearly full (99 %) - IBM DB2

Hi, also after tablespace increasing the deletes are very slow. What are the right way, to boost the performance ? - something like reorg ?? The deletes was faster, until the tablespace wasn't nearly full the first time. Regards Andre...

  1. #1

    Default very slow deletes after tablespace was nearly full (99 %)

    Hi,

    also after tablespace increasing the deletes are very slow.
    What are the right way, to boost the performance ?

    - something like reorg ??


    The deletes was faster, until the tablespace wasn't nearly full the first time.

    Regards
    Andre
    Andre D. Guest

  2. #2

    Default Re: very slow deletes after tablespace was nearly full (99 %)

    Looks like you use v8.x ?

    try to reorg cleanup

    "Andre D." <andre.lspeedi.de> a écrit dans le message de news:
    [email]281ab075.0307090858.3af84fb4posting.google.com[/email]...
    > Hi,
    >
    > also after tablespace increasing the deletes are very slow.
    > What are the right way, to boost the performance ?
    >
    > - something like reorg ??
    >
    >
    > The deletes was faster, until the tablespace wasn't nearly full the first
    time.
    >
    > Regards
    > Andre

    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. Replies: 5
    Last Post: September 9th, 12:42 PM
  2. Slow insert when table is almost "full". IBM Informix call
    By ramesh.vasudevan@verizon.com in forum Informix
    Replies: 0
    Last Post: September 8th, 08:21 PM
  3. Bug?? Synchronize crashes when it deletes
    By edenia webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 29th, 12:46 AM
  4. Replies: 4
    Last Post: January 11th, 09:37 AM
  5. Replies: 11
    Last Post: January 9th, 07:46 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139