Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Unanswered: I am having weired error

    I am db2 9.1 3a fix fack.

    Any db2 command it taking while to excute even
    db2 terminate
    db2 list tablespaces
    db2 connect to dbname

    any thing.

    What could be the issue. New boxes. recently created the databses. No changes yet on db box.

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    My guess: You didn't activate the database explicitly (with the ACTIVATE DB command), so the DB2 client has to activate the DB for the first connection implicitly (and the DB is deactivated again when the last connection disconnects). During activation, DB2 will allocate the primary log files and the various shared memory segments (among other things). This could take a while..
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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