Professional Web Applications Themes

Tools Catalog - IBM DB2

I have installed DB2 V8.1 WSE on Linux. Everything worked fine. But when I issued the CREATE TOOLS CATALOG command, it just hung and kept one of the CPUs 100% busy. I had to kill the process. The tablespaces were created but the tables were not. The same thing happened when I try to drop the tools catalog. Anyway I can troubleshoot this? I was able to create the tools catalog on a different Linux box with no problem. It is running V8.1 ESE....

  1. #1

    Default Tools Catalog

    I have installed DB2 V8.1 WSE on Linux. Everything worked fine. But when I
    issued the CREATE TOOLS CATALOG command, it just hung and kept one of the
    CPUs 100% busy. I had to kill the process. The tablespaces were created but
    the tables were not. The same thing happened when I try to drop the tools
    catalog. Anyway I can troubleshoot this?

    I was able to create the tools catalog on a different Linux box with no
    problem. It is running V8.1 ESE.


    Tony Guest

  2. #2

    Default Re: Tools Catalog

    Info on the linux distro, glibc, kernel level etc would help. If you're on Red
    Hat 9, you're in untested waters. Workarounds (unsupported):

    For the java installer and java based tools, setting
    LD_ASSUME_KERNEL=2.2.5 will work with RH9 for non-SMP systems

    DON'T create the tools catalog as part of the install.

    after the install, modify your <instance>/sqllib/userprofile and
    <DAS>/das/userprofile to add the export LD_ASSUME_KERNEL=2.2.5

    then re-start the DAS and instance and create your tools catalog db (if you
    want to).

    This is currently unsupported.

    Tony wrote:
    > I have installed DB2 V8.1 WSE on Linux. Everything worked fine. But when I
    > issued the CREATE TOOLS CATALOG command, it just hung and kept one of the
    > CPUs 100% busy. I had to kill the process. The tablespaces were created but
    > the tables were not. The same thing happened when I try to drop the tools
    > catalog. Anyway I can troubleshoot this?
    >
    > I was able to create the tools catalog on a different Linux box with no
    > problem. It is running V8.1 ESE.
    Blair Kenneth Adamache Guest

  3. #3

    Default Re: Tools Catalog

    Thanks for the reply. Yep, I have tried all that and more. I just found out
    this is actually a Linux specific bug. Now I am trying to work it out with
    IBM support.

    "PM (pm3iinc-nospam)" <Pm3iinc.NoSpamsympatico.ca> wrote in message
    news:IRkMa.3206$eF3.414428news20.bellglobal.com.. .
    > Commit all sessions you have.
    >
    > Get snapshot for locks.
    >
    > Maybe QUIESCE DATABASE {IMMEDIATE | DEFER} [FORCE CONNECTIONS]
    > before you create the tools catalog tables, ...
    >
    > PM
    >
    >

    Tony Guest

  4. #4

    Default Re: Tools Catalog

    I'm having this identical issue under RH 2.1 AS. Has there been any
    progress or solutions to this problem?

    As an additional point of information, the program that is dominating
    the CPU during the tools catalog creation is db2dasstm.

    "Tony" <honkme.not> wrote in message news:<0yoMa.20914$C83.1987371newsread1.prod.itd.e arthlink.net>...
    > Thanks for the reply. Yep, I have tried all that and more. I just found out
    > this is actually a Linux specific bug. Now I am trying to work it out with
    > IBM support.
    >
    > "PM (pm3iinc-nospam)" <Pm3iinc.NoSpamsympatico.ca> wrote in message
    > news:IRkMa.3206$eF3.414428news20.bellglobal.com.. .
    > > Commit all sessions you have.
    > >
    > > Get snapshot for locks.
    > >
    > > Maybe QUIESCE DATABASE {IMMEDIATE | DEFER} [FORCE CONNECTIONS]
    > > before you create the tools catalog tables, ...
    > >
    > > PM
    > >
    > >
    Yoshi Takahashi Guest

  5. #5

    Default Re: Tools Catalog


    I'm having the same problem w/ RedHat 2.1 WS (same kernel as AS). Any
    updates posted here would be most appreciated.

    --
    Posted via [url]http://dbforums.com[/url]
    scott_b Guest

Similar Threads

  1. Article : Security Tools Part -- 2 (.Net FrameWork Tools Series)
    By Namratha Shah \(Nasha\) in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: November 23rd, 04:01 PM
  2. catalog
    By Reza Saheban webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 1
    Last Post: January 29th, 09:52 AM
  3. CD-ROM Catalog
    By Ira in forum Macromedia Director Basics
    Replies: 3
    Last Post: November 27th, 06:23 AM
  4. catalog.xml, any ruby tools?
    By Simon Strandgaard in forum Ruby
    Replies: 2
    Last Post: August 23rd, 10:34 PM
  5. Specify catalog in ASP
    By Roisin in forum ASP
    Replies: 0
    Last Post: July 2nd, 04:47 AM

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