Results 1 to 2 of 2

Thread: Update Cfg

  1. #1
    Join Date
    Feb 2005
    Posts
    118

    Unanswered: Update Cfg

    I am using UDB DB2 ver 7.2 for Windows 2000. I have a few databases in my instances (say db1, db2,db3).
    lets say I want to resize the log file for db1, so I say
    update db cfg for db1 using logfilsiz 1000
    now for the new logsiz value to take effect, i used the following command
    db2stop force
    db2start

    the problem with this approach is that all connections to db2 and db3 are impacted as well.
    Is there a cleaner way to doing this, esp when there are connections to other databases ?

    thanks.
    Anil

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    No guarantees, but...

    Try disconnecting all applications to the one database (not stopping the entire instance). This should deactivate the database. If you explicitly activated the database, then you will need to explicitly deactivate it (Command Reference). When the first connection is made to the database it will be activated, and the new log file size should take effect.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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