Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Determent free or used space in each of our DMS table?

Determent free or used space in each of our DMS table?

Determent free or used space in each of our DMS table?

We have been writing COBOL programs for the last 20 years starting with Burroughs which turned into UNISYS. To prevent the problem with the database locking up because of max record, we have a program that goes out and counts the records in each table to determine amount of free and used space per table.  The program runs for about 17 hours.  We are looking for a new method of determining the amount of free or used space in each table.  We are currently on Clearpath MCP Release 6.0.   

RE: Determent free or used space in each of our DMS table?

ClearPath MCP 6.0 is very old. Are you sure that is your level? If it is, I strongly suggest you get up to date.

dbaTools from Stewart DataTech can give you table analysis.
See http://www.dbatools.com/

Also, in your DASDL you could specify automatic population warning and automatic population increase.

With POPULATIONWARN, a waiting entry comes into the mix when a structure is in danger of hitting its current limit. Many DBAs choose 90% as the warning thresh hold.

With POPULATIONINCR, DMSII will just expand the sizes. This can get a little tricky if a container size would need to expand, but it is a good backstop way out.

The DASDL manual has several pages of description on these options.

You can view it online via http://public.support.unisys.com.
(The documentation link is at the bottom of the page, is actually http://public.support.unisys.com/common/epa/documentationlibraries.aspx.)

Contact me directly if you wish.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close