Skip to Content
author's profile photo Former Member
Former Member

Growth Month DB

Hi Gurus..

I have installed 46C SAP with AS/400 and DB OS/400.

with transaction DB02 (Space statistics --> "*" intro --> Month) I look the growth month total of the data base and this shows me 315 GB, but I'm thinking that this value "Total Size(Kbyte)" not is correct,

How I can know the correct growth month of the data base?

Best Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Oct 01, 2006 at 07:13 PM

    Hola Luis,

    If you don't trust the info displayed on DB02 (I can't see why) you can always query your DB directly using SQL commands.

    Regards

    Juan

    Please assign points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 02, 2006 at 07:21 AM

    Hi Luis,

    In DB02 i can see the Total size of the DB and the Free space of the DB left.Hence i calculate in this way.

    <b>(This MonthsTotal DB space - This months free space )</b> - <b>(Lst months Total Size - Last months Free space)</b> divided by (2*1024)

    This would give the DB growth in GB for that Month.

    Is it what u r looking for or am i missing something.

    Br,

    Sri

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.