Professional Web Applications Themes

Running Java UDFs and associated db2fmp processes... - IBM DB2

Paul Reddin wrote: > Hi, > > We have just started running the the DB2 Sample java UDFs (UDFsqlsv) > on > DB2 V8.1(FP2) & Redhat 7.2 AS Linux and are seeing some strange > behaviour? > > 1. If the UDFs are regsitered as defined in the default file > (UDFsCreate.db2 - i.e FENCED THREADSAFE) > when UDFsqlcl is invoked we see > - The first query appears to hang > - though actually there are 3x db2fmp processes each appearing to > consume 100% of CPU. > > 2. If the UDFs are registered as FENCED NOT THREADSAFE, ...

  1. #1

    Default Re: Running Java UDFs and associated db2fmp processes...

    Paul Reddin wrote:
    > Hi,
    >
    > We have just started running the the DB2 Sample java UDFs (UDFsqlsv)
    > on
    > DB2 V8.1(FP2) & Redhat 7.2 AS Linux and are seeing some strange
    > behaviour?
    >
    > 1. If the UDFs are regsitered as defined in the default file
    > (UDFsCreate.db2 - i.e FENCED THREADSAFE)
    > when UDFsqlcl is invoked we see
    > - The first query appears to hang
    > - though actually there are 3x db2fmp processes each appearing to
    > consume 100% of CPU.
    >
    > 2. If the UDFs are registered as FENCED NOT THREADSAFE, UDFsqlcl
    > functions fine.
    >
    > So, it appears the default SAMPLE code isn't threadsafe? or is
    > something else
    > at work here ? e.g running out of a resource ?
    >
    >
    > When we start implementing our own java UDFs they will have to run
    > FENCED THREADSAFE (for performance/memory reasons) so we are a little
    > disturbed
    > that even the samples appear not to function correctly?
    >
    > any insight welcome.
    >
    > Paul.
    Which version of JDK are you using? Sounds like the JVM is trapping
    recursively.

    W Gemini Guest

  2. #2

    Default Re: Running Java UDFs and associated db2fmp processes...

    Hi,

    The version (java -version) we are running is

    java version "1.3.1"
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1)
    Classic VM (build 1.3.1, J2RE 1.3.1 IBM build cxia32131-20020622 (JIT
    enabled: jitc))

    All standard install, i.e Linux 7.2 AS and DB2 V8.1(fp2)

    Thanks.

    Paul.


    W Gemini <wgemininowhere.com> wrote in message news:<lo1Ta.3764$1I5.349187news20.bellglobal.com> ...
    > Which version of JDK are you using? Sounds like the JVM is trapping
    > recursively.
    Paul Reddin Guest

Similar Threads

  1. running processes from a service
    By Serdar C. in forum ASP.NET Web Services
    Replies: 1
    Last Post: December 9th, 03:29 PM
  2. multiple processes running contemporarily!
    By dominant in forum PERL Miscellaneous
    Replies: 3
    Last Post: September 7th, 07:15 PM
  3. Outputting the status while the processes are running
    By T.S.Ravi Shankar in forum PERL Beginners
    Replies: 0
    Last Post: August 26th, 06:05 PM
  4. Running JAVA UDFs with JDK 1.4 - supported/works?
    By Blair Adamache in forum IBM DB2
    Replies: 5
    Last Post: July 22nd, 04:46 PM
  5. Building JAVA UDFs with V8.1 Development Centre ?
    By Paul Reddin in forum IBM DB2
    Replies: 0
    Last Post: July 16th, 03:04 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