Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: log file parameters in partitioned database.

    Hi.

    We have 5 node database using ver 8.1 on aix.5.2
    Are the log related parameter values applicable to one node or all the nodes.

    for example logprimary = 10 means
    10 primary logs will be allocated to one node or altogether 10 primary logs will be allocated. That will be 2 primary logs per node?
    Same goes for log file size,log secondary and newlogpath parameter.

    Thanks in advance
    j

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by jfkuser
    Hi.

    We have 5 node database using ver 8.1 on aix.5.2
    Are the log related parameter values applicable to one node or all the nodes.

    for example logprimary = 10 means
    10 primary logs will be allocated to one node or altogether 10 primary logs will be allocated. That will be 2 primary logs per node?
    Same goes for log file size,log secondary and newlogpath parameter.

    Thanks in advance
    j
    It means 10 at each node.

    You usually want to use db2_all to keep all your partitions' db cfg's in synch, though, it's not typically desirable to have different values on different nodes.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    Technically,In a partitioned enviroment, instance are shared, but database
    has shared nothing architecture.so every thing you do at the node effects only that partition including log files,backup/restore,datafiles,history file, database configuration file.

    regard

    mujeeb

Posting Permissions

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