IBM Support

Calculate tablespace percent_free_to_max with the oracle extended agent

Technote (troubleshooting)


Oracle Extended agent calculates the attribute of

"Percent_Free_To_Max" incorrectly under this condition

1 < Tablespace Max Size(MB)/Tablespace Allocated Size(MB) < 10.

Resolving the problem

Update the Free Size to the correct value and include the AUTOEXTEND space reflected in the Maximum File Size (MB). Edit file $CANDLEHOME/<arch>/rz/bin/krzsql.xml in the agent installation directory and change these lines

17 round(decode(trunc(b.Kbytes_max/b.Kbytes_alloc, -1), 0, 1,
18 (b.Kbytes_alloc/b.Kbytes_max)*100),2)* 100 PCIMAX,
20 round(decode(trunc(b.Kbytes_max/b.Kbytes_alloc, -1), 0,round(((nvl(a.Kbytes_free,0))/b.Kbytes_alloc)*100,2),
21 ((b.Kbytes_max-b.Kbytes_alloc+nvl(a.Kbytes_free,0))/b.Kbytes_max)*100),2)* 100 PCIFMAX

with these updates:

17 round(decode(trunc(b.Kbytes_max/b.Kbytes_alloc, 0), 0, 1,
18 (b.Kbytes_alloc/b.Kbytes_max)*100),2)* 100 PCIMAX,
20 round(decode(trunc(b.Kbytes_max/b.Kbytes_alloc, 0), 0,round(((nvl(a.Kbytes_free,0))/b.Kbytes_alloc)*100,2),
21 ((b.Kbytes_max-b.Kbytes_alloc+nvl(a.Kbytes_free,0))/b.Kbytes_max)*100),2)* 100 PCIFMAX

and restart the agent.

Product Alias/Synonym


Document information

More support for: Tivoli Composite Application Manager for Applications
ITCAM Extended Agent for Oracle Database 5724V09OR v6.3

Software version: 6.3.1

Operating system(s): AIX, Linux, Solaris, Windows

Reference #: 1601200

Modified date: 18 August 2013