Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2

    Answered: db2 registry variable

    Hi,

    Is there a way to know if registry variable was set when and is it taken effect ? .

    One of the server CPU utilization is high close to 70 - 80 %

    db2pd -edus interval=50 top=10

    show db2pclnr using more USR (s)

    db2set -all show below registry variable was set

    [i] DB2_USE_ALTERNATE_PAGE_CLEANING=ON

    -------------------------------------------------

    Apart from looking at profile.env file modified date, is there way to say the parameter has taken effect ? .

    regds
    paul

  2. Best Answer
    Posted by mark.bb

    "Hi,

    This information can be obtained from the db2diag.log if the corresponding records are still there.
    Use the following query.
    Code:
    select timestamp, fullrec
    from table(PD_GET_DIAG_HIST (null, null, null
    , current timestamp - 5 day -- from the known timestamp from the db2diag.log
    --, null -- from the beginning of the db2diag.log
    , null
    ))
    where 
       (function='db2set_main' and fullrec like '%DB2\_USE\_ALTERNATE\_PAGE\_CLEANING%' escape '\')
    or (function='DB2StartMain')
    order by timestamp desc
    This registry variable is not online, which means that the instance must be restarted to take an effect."


  3. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Hi,

    This information can be obtained from the db2diag.log if the corresponding records are still there.
    Use the following query.
    Code:
    select timestamp, fullrec
    from table(PD_GET_DIAG_HIST (null, null, null
    , current timestamp - 5 day -- from the known timestamp from the db2diag.log
    --, null -- from the beginning of the db2diag.log
    , null
    ))
    where 
       (function='db2set_main' and fullrec like '%DB2\_USE\_ALTERNATE\_PAGE\_CLEANING%' escape '\')
    or (function='DB2StartMain')
    order by timestamp desc
    This registry variable is not online, which means that the instance must be restarted to take an effect.
    Regards,
    Mark.

Posting Permissions

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