Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: backup - how to find the optimal values selected

    DB2 LUW - currently supported versions (9.x)

    Code:
    WITH num-buff BUFFERS BUFFER buffer-size PARALLELISM n
    In a backup command, unless the above values are specified, DB2 decides optimal values.

    Is there a way to know the values chosen by DB2 for backup that is currently running ?


    Cheers

    Sathyaram
    Last edited by sathyaram_s; 04-05-10 at 19:37.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You should see them in the db2diag.log with diaglevel 4

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Bella, Thanks .

    I assume sqluxGetAvailableHeapPages gets util_heap_sz (which in my case is configured as 5000) value ?

    I was hoping the output of db2pd might have this info.


    2010-04-05-18.59.06.041805-240 E2089G486 LEVEL: Info
    PID : 15666 TID : 2929716128 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-6040 APPID: *LOCAL.db2inst1.100405225906
    AUTHID : DB2INST1
    EDUID : 460 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:507
    DATA #1 : <preformatted>
    Autonomic backup/restore - using parallelism = 4.

    2010-04-05-18.59.06.042365-240 E2576G510 LEVEL: Info
    PID : 15666 TID : 2929716128 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-6040 APPID: *LOCAL.db2inst1.100405225906
    AUTHID : DB2INST1
    EDUID : 460 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:618
    DATA #1 : <preformatted>
    Autonomic BAR - heap consumption.
    Targetting (50&#37 - 2480 of 4960 pages.

    2010-04-05-18.59.06.042524-240 E3087G499 LEVEL: Info
    PID : 15666 TID : 2929716128 PROC : db2sysc
    INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
    APPHDL : 0-6040 APPID: *LOCAL.db2inst1.100405225906
    AUTHID : DB2INST1
    EDUID : 460 EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:869
    DATA #1 : <preformatted>
    Autonomic backup - tuning enabled.
    Using buffer size = 577, number = 4.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by db2girl View Post
    You should see them in the db2diag.log with diaglevel 4
    I do see mine with diaglevel 3

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by sathyaram_s View Post

    I assume sqluxGetAvailableHeapPages gets util_heap_sz (which in my case is configured as 5000) value ?
    I think it looks at the available util_heap_sz which in your case is most of it.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by DBFinder View Post
    I do see mine with diaglevel 3
    My apology, I found there was a code change to have this info dumped at diaglevel 3 instead of diaglvel 4. It looks like it went into v9.1 fp7, v9.5 fp4 and v9.7 GA.

Posting Permissions

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