backup - how to find the optimal values selected

sathyaram_s · #1 (**permalink**) 04-05-10, 18:31

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

db2girl · #2 (**permalink**) 04-05-10, 18:53

You should see them in the db2diag.log with diaglevel 4

sathyaram_s · #3 (**permalink**) 04-05-10, 19:08

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.

Quote:

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.

DBFinder · #4 (**permalink**) 04-05-10, 20:56

Quote:

Originally Posted by db2girl

You should see them in the db2diag.log with diaglevel 4

I do see mine with diaglevel 3

db2girl · #5 (**permalink**) 04-06-10, 00:07

Quote:

Originally Posted by sathyaram_s

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.

db2girl · #6 (**permalink**) 04-06-10, 00:29

Quote:

Originally Posted by DBFinder

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech