Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Setting logarchmeth1 in multinodes

    Hi colleagues,
    I have to configure the parameter logarchmeth1 in some nodes, i have the followind filesystem.
    /db2/xxxx/log_dir/NODE0000
    /db2/xxxx/log_dir/NODE0001
    db2/xxxx/log_dir/NODE00002

    db2nodes.cfg
    0 machine1 0
    1 machine1 1
    2 machine1 2
    I need to save the logs node 0 in FS /db2/xxxx/log_dir/NODE0000, logs node 1 in FS /db2/xxxx/log_dir/NODE0001, etc.

    I execute the followind in every no de.
    export DB2NODE=0
    db2 terminate
    db2 connect to xxxx
    db2 update db cfg using logarchmeth1 disk:/db2/xxxx/log_dir/NODE0000

    export DB2NODE=1
    db2 terminante
    db2 connect to xxxx
    db2 update DB cfg using logarchmeth1 disk:/db2/xxxx/log_dir/NODE0001 and so on
    db2stop
    db2start

    When i execute db2 get DB cfg for xxxx show detail, this is the output
    Logarchmeth1 /db2/xxxx/log_dir/NODE0002/NODE0000
    /db2/xxxx/log_dir/NODE0002/NODE0001
    /db2/xxxx/log_dir/NODE0002/NODE0002

    Al logs are sabe in FS /db2/xxxx/log_dir/NODE0002

    the others FS are empty.

    Somebody can say me because the logs node 0 are not in /db2/xxxx/log_dir/NODE0000, logs node 1 in /db2/xxxx/log dir/NODE0001 and logs node 2 in /db2/xxxx/log_dir/NODE0002?

    Thank you forma advanced.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    UPDATE DB CFG command makes changes on all nodes by default. It doesn't matter which node you're connected to.
    You should issue something like this to achieve what you want:
    Code:
    db2 update DB cfg for xxxx DBPARTITIONNUM 0 using logarchmeth1 disk:/db2/xxxx/log_dir/NODE0000
    db2 update DB cfg for xxxx DBPARTITIONNUM 1 using logarchmeth1 disk:/db2/xxxx/log_dir/NODE0001
    db2 update DB cfg for xxxx DBPARTITIONNUM 2 using logarchmeth1 disk:/db2/xxxx/log_dir/NODE0002
    Alternatively, you can do the same using a single command:
    Code:
    db2_all "\" typeset -Z4 n4=##; db2 update DB cfg for xxxx DBPARTITIONNUM \${n4} using logarchmeth1 disk:/db2/xxxx/log_dir/NODE\${n4}"
    Regards,
    Mark.

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi mark,
    Thank you for your answer

Posting Permissions

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