DB Size in DB2 for i in DB02

[martimmendes]

Hi guys,

     Which will be the correct method to know the real DB size in DB2 for i platform?:

1. Going into space statistics on DB02 and doing a sum of all table sizes?
2. Going into DB02 and do a sum of Tables, Primary keys and Indexes?

My logic says its 2, but it never hurts to confirm.

Thanks in advance for your kind answers.

Best regards,

Martim.

[christoph_ostrop · Accepted solution]

Hi,

you can run on IBM-i command-line these *CMD:

==> RTVDSKINF   or better do a SBMJOB ........

the first one will collect some statistic data and will run a while,

after that has finished .......

==> PRTDSKINF RPTTYPE(*LIB)  

HTH

Christoph

[martimmendes]

Thanks guys!

I'll try the commands out and will inform of the results.

Kind regards,

Martim.

[martimmendes]

Hi guys,

Thanks for the answers!

I still don't have access to AS/400 but i should have by the end of this week.

Shouldn't i take indexes and primary keys in consideration also?

Kind regards,

Martim.

[Former Member]

Hi Martim,

Not Required, As your taking the Whole database size, which includes all Tables, Table indexes Client specific data everything.

If you want to Cross check, go to OS level and find the DB files structure.

May i know what DB ur using.

Thanks

Vamc.

[martimmendes]

Hi Vamsi,

Sure thing, i am using DB2 for i 6.1, i cross-checked your option (which i already did) and db size is around 141GB, and then i compared it including tables, indexes and keys and the size is around 160GB.

Thanks,

Martim.

[Former Member]

Hey martin, It should n`t be that much variation.

Below Screenshot is GUI level,

See here, the DB is 428 gb, at GUI level.

Here if you see 430gb, Variation is 2gb as Transactional Jobs or delta backup.

Hope you this might help you.

Thanks & Regards,

vamc.

[blaw]

Martim,

You can use tcode sm49 to execute the system commands

You can use sm36 to execute the command in background if needed to prevent timeout

I always used the following command for sizing the db Database size in GB 

DSPLIB LIB(R3xxxDATA) OUTPUT(*PRINT)

Regards,

Brian

[Former Member]

Hi Martim,

You can get the whole DB size by navigating to the below

DB02 -> Spaces -> History -> Overview

You get the full details of your database.

Regards,

Vamsi