Know IDMS? Take the DBA Challenge

Would this be a good question when interviewing an IDMS DBA? Theme — database design: big pages, small records.
An application programmer comes into your office and says, “I am getting an IDMS 1211 return code, but the area is only 60% full.” What’s your course of action?
The answer
This most likely occurs when a page is logically full. With the default database key format of 3 bytes for page number and one byte for line index, the maximum number of records on a page is 255. With a large page size and an area with a lot of small records, it is possible that 255 times the average record size is smaller than the page size. With the maximum number of line indexes met, the page is full even though the Area may be at 60% capacity.
Most DBAs, in a non-emergency situation, will perform an unload and reload of the area after determining the proper page size and number of pages.
- Review your record sizes — determine your average record size for any records that are fixed or compressed.
- Determine space requirements — consider record size, estimated record occurrences, growth factor and reserve space.
- Look for similar problems — if your estimates were off for this Area, review your other Areas and the assumptions behind your page sizes and number of pages.
- Unload / reload — consider an unload and reload of the Area with the proper page size and number of pages.
- Test CV first — don’t wing it; run the process in the test CV first.
- Remember — you’re only as good as your last backup.
More case studies



Take the next step
Ready to retire your legacy 4GL? Schedule a no-cost call to review your source and conversion options.