Results 1 to 2 of 2

Thread: Dwcrtldb ?

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Dwcrtldb ?

    Hai ,

    I am having a server with 3 databases .My application server(IBM) is running on another server.Two more databases are created -the WAS and DWCTRLDB.I think the WAS is the Websphere Application Server repository database .What is the DWCTRLDB?

    When allocating Memory usage I am allocating 70% of my system memory for Db2 alone.

    One of the 3 databases are bigger and more accessed.

    So how can i divide the memory available for db2.
    How much % of mem should i allocate for the WAS and DWcrtlDB databases.

    Thanks,

    Regards,

    micky

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Dwcrtldb ?

    It's data warehouse contorl database, you might have picked it in the options list when installing the db2 product. If you don't need it you can drop it.

    dollar

    Originally posted by mickykt
    Hai ,

    I am having a server with 3 databases .My application server(IBM) is running on another server.Two more databases are created -the WAS and DWCTRLDB.I think the WAS is the Websphere Application Server repository database .What is the DWCTRLDB?

    When allocating Memory usage I am allocating 70% of my system memory for Db2 alone.

    One of the 3 databases are bigger and more accessed.

    So how can i divide the memory available for db2.
    How much % of mem should i allocate for the WAS and DWcrtlDB databases.

    Thanks,

    Regards,

    micky

Posting Permissions

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