Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

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

CLVDev102 (Programmer) (OP)
12 Dec 06 18:37
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.   
RoyLatham (MIS)
5 Feb 07 10:01
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.

Roy

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