HI-U-RBA Vs DATASIZE

Bharath Nunepalli

HI-U-RBA Vs DATASIZE

Hi all,

My requirement is to get the used size of a Table. I can get that in 2 ways.

 1. Run LISTCAT, and look out for HI-U-RBA

I’m not aware of any pre-requisites.

2. Check for DATASIZE in SYSTABLESPACESTATS

The pre-requisite is REORG should have been done at least once on TS for externalizing the RTS.


I would like to know your opinion/suggestion about HI-U-RBA Vs DATASIZE discussion.

Which one do you think is a better way to get used size?


Bharath Nunepalli,

Senior DB2 DBA.

Daniel Luksetich

HI-U-RBA Vs DATASIZE
(in response to Bharath Nunepalli)
HI-U-RBA tells you the formatted size of the dataset. DATASIZE tells you the total amount of space that rows occupy. So, in short DATASIZE considers free space, and HI-U-RBA does not. Running REORG to “correct” RTS information may help suspect statistics in an RTS table.

Dan



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 12 for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Bharath Nunepalli <[login to unmask email]>
Sent: Monday, July 27, 2020 9:06 AM
To: [login to unmask email]
Subject: [DB2-L] - HI-U-RBA Vs DATASIZE



Hi all,

My requirement is to get the used size of a Table. I can get that in 2 ways.

1. Run LISTCAT, and look out for HI-U-RBA

I’m not aware of any pre-requisites.

2. Check for DATASIZE in SYSTABLESPACESTATS

The pre-requisite is REORG should have been done at least once on TS for externalizing the RTS.


I would like to know your opinion/suggestion about HI-U-RBA Vs DATASIZE discussion.

Which one do you think is a better way to get used size?



Bharath Nunepalli,

Senior DB2 DBA.



-----End Original Message-----

Attachments

  • image001.png (9.6k)
  • image002.png (14k)
  • image003.png (10.4k)
  • image004.png (11.7k)
  • image005.png (13.7k)
  • image006.png (13.1k)
  • image007.png (14.2k)
  • image008.png (7.5k)

Bharath Nunepalli

RE: HI-U-RBA Vs DATASIZE
(in response to Daniel Luksetich)

Dan,
Thanks for the response.

 

Apparently, HI-U-RBA provides the accurate used size as it doesn't consider free space.

Is that correct?

 

Bharath Nunepalli,

Senior DB2 DBA.

Daniel Luksetich

HI-U-RBA Vs DATASIZE
(in response to Bharath Nunepalli)
Well, it depends upon your interpretation of accurate. If all the rows have been deleted HI-U-RBA doesn’t change, but DATASIZE does.

Dan



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 12 for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Bharath Nunepalli <[login to unmask email]>
Sent: Monday, July 27, 2020 9:31 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: HI-U-RBA Vs DATASIZE



Dan,
Thanks for the response.



Apparently, HI-U-RBA provides the accurate used size as it doesn't consider free space.

Is that correct?



Bharath Nunepalli,

Senior DB2 DBA.



-----End Original Message-----

Attachments

  • image001.png (9.6k)
  • image002.png (14k)
  • image003.png (10.4k)
  • image004.png (11.7k)
  • image005.png (13.7k)
  • image006.png (13.1k)
  • image007.png (14.2k)
  • image008.png (7.5k)

Bharath Nunepalli

RE: HI-U-RBA Vs DATASIZE
(in response to Daniel Luksetich)

OK. Thanks Dan.