Results 1 to 2 of 2

Thread: Sql0647n

  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Unanswered: Sql0647n

    From a client machine I am trying to creater Bufferpools of 32 KB page sizes and then I am restarting my database . After RESTART when I try to create Tablespaces of 32 KB page size in those bufferpools , it throws an error SQL0647N, The Bufferpool is not active.

    I searched Google and the resolution specified is stopping and restarting the Database but even this is not working . The command DB2SET DB_DEFAULTBP = 32 , is not taken as valid .

    Pls help me urgently with this , if possible . DB2 UDB V7.2

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    Try the following sequence:
    - CREATE BUFFERPOOL...
    - TERMINATE
    - RESTART DATABASE...
    - CREATE TABLESPACE...

    HTH.
    Rodney Krick

Posting Permissions

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