Results 1 to 4 of 4

Thread: same Logpath

  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Unanswered: same Logpath

    if i run db2 list active databases

    Database name = UAT
    Applications connected currently = 2
    Database path = E:\DB2\NODE0000\SQL00001\

    Database name = PHOENIX
    Applications connected currently = 3
    Database path = E:\DB2\NODE0000\SQL00002\

    however the active logs are getting created for both the DB's at
    E:\DB2\NODE0000\SQL00001\SQLOGDIR

    why its happening so?
    no one changed the logpath for any DB
    few days back i move both DB's from different servers(32 bit V8.2.7) and restored them on this new server(64 bit V9.1.2).
    Ideally logs should be getting created in the respective SQLOGDIR folders......
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    What does the newlogpath db configuration parameter say for these 2 databases?
    mota

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    nothing was set as newlogpath for both DB's
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Sep 2003
    Posts
    237
    What do database configuration parameters say about "Changed path to log files" and "Path to log files"; when you restore it gets the configuration from the backup; that may be the problem .
    mota

Posting Permissions

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