DB2 database on Iseries

75 pts.
Tags:
Database
IBM iSeries
Ho can I get the size of a DB2 data base on a iSeries platform

Answer Wiki

Thanks. We'll let you know when a new response is added.

The DSPOBJD command will give you the size of an object.
You can output that to an OUTFILE and then total it up.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...the size of a DB2 data base... Please clarify what you mean by "data base". Do you want to know the space taken by records in your physical files? Do you want to include deleted records? Do you want to include the sizes of the objects that hold the records? Are indexes and views included? Do you want to include allocated space that isn't used yet? Do you need to know for individual libraries (schemas)? Or do you want all libraries at once? Should system or product libraries be included? Should the size include directories outside of libraries? (DB2 generally doesn't care about directories and streamfiles outside of libraries -- unless your DB2 tables use DataLinks or similar features.) It might be easiest if you describe the business problem that you need to solve. Tom
    125,585 pointsBadges:
    report
  • DanD
    Using opsnav and selecting databases then schemas the size difference from a dsplib *print was equal to programs and source files that had been placed in the lib. So with opsnav you get database objects only and probably more accurate. The grouping was different also by table, index, sqlpkg etc instead of straight alpha sort.
    2,865 pointsBadges:
    report
  • TomLiotta
    ...the size difference from a dsplib *print was... For me for the first library I tried (my *CURLIB), there was no size difference nor object count difference. Everything was included in the size both ways. But there may be differences in iNav versions and in how the size and object count was requested. This iNav is V5R3, though I also tried 6.1 with the same result. I requested size and count info by viewing the Storage tab of the Properties page of the schema. The only other way that seems available is to view the description of each object and manually total things up. Can you give a little more detail? Tom
    125,585 pointsBadges:
    report
  • DanD
    Hi Tom, If you set IFS folder properties under the security tab(at least I think this is the property that turns this on) to "allow object scan" the system will do a real time scan and give you folder size and file count.
    2,865 pointsBadges:
    report
  • DanD
    Oh, never mind I didn't read your post carefully, you already have scan on.
    2,865 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following