Professional Web Applications Themes

Horrible Snapshot Performance on V8 - IBM DB2

Howdy, I'm trying to use the new SQL based snapshot functions to get the tablespace containers (SNAPSHOT_CONTAINER). On systems with approximately 1400 tablespaces, the query runs for about 40 minutes before falling over (see below). If I perform the same function using API's, it takes less than a minute and works great. Any ideas why the SQL function is performing so poorly? I'd like to stay in Java, if possible. I'm running on Solaris with FP2, but have seen this same behavior with AIX. Thanks for any help, Adam Here's the error when the SQL finally fails: $ db2 "select ...

  1. #1

    Default Horrible Snapshot Performance on V8

    Howdy,

    I'm trying to use the new SQL based snapshot functions to get the
    tablespace containers (SNAPSHOT_CONTAINER). On systems with
    approximately 1400 tablespaces, the query runs for about 40 minutes
    before falling over (see below). If I perform the same function using
    API's, it takes less than a minute and works great.

    Any ideas why the SQL function is performing so poorly? I'd like to stay
    in Java, if possible. I'm running on Solaris with FP2, but have seen
    this same behavior with AIX.

    Thanks for any help,



    Adam



    Here's the error when the SQL finally fails:

    $ db2 "select * from table(snapshot_container('LARGE', -1)) as b
    ob"

    SNAPSHOT_TIMESTAMP TABLESPACE_ID TABLESPACE_NAME

    CONTAINER_ID CONTAINER_NAME


    CONTAINER_TYPE
    TOTAL_PAGE
    S USABLE_PAGES ACCESSIBLE STRIPE_SET
    -------------------------- --------------------
    --------------------------------
    --------------------------------------------------------------------------------
    ---------------- --------------------
    ------------------------------------------
    --------------------------------------------------------------------------------
    --------------------------------------------------------------------------------
    ------------------------------------------------------ --------------
    ----------
    ---------- -------------------- -------------------- --------------------
    SQL0443N Routine "SYSPROC.SNAPSHOT_CONTAINER" (specific name
    "SNAPSHOT_CONTAINER") has returned an error SQLSTATE with diagnostic text
    "DBA7612". SQLSTATE=38553

    Adam Guest

  2. #2

    Default Re: Horrible Snapshot Performance on V8

    Adam,

    Best bet would be to contact service, I only know a bit about the
    underlying way these were written, but the performance should be 'close'
    to that of the api (they use the api from within a fenced udf, and
    return the data in table format). So something must be failing/looping
    in the underlying udf code.

    Adam wrote: 

    Sean Guest

  3. #3

    Default Re: Horrible Snapshot Performance on V8

    Thanks for the reply. I did some looking around and there is a fix in
    FP3 for a bug which sounds a lot like my problem. I'm downloading the
    fixpack, and keeping my fingers crossed.

    Thanks again,


    Adam


    Sean McKeough wrote: 
    >[/ref]

    Adam Guest

Similar Threads

  1. Font & Line Rendering on Adobe Acrobat Reader 7 is horrible!
    By Olumide in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: October 23rd, 12:50 PM
  2. HORRIBLE problem with text/fonts
    By David_Woolf@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 14th, 05:32 PM
  3. Snapshot of FLV
    By U. Tote in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 16th, 03:51 PM
  4. Horrible Speed issues? Win2k P4 2Ghz Machine
    By bshroyer webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 3
    Last Post: September 26th, 03:22 PM
  5. The horrible truth about Linux libs
    By Dave Uhring in forum Sun Solaris
    Replies: 6
    Last Post: July 28th, 06:33 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