Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 916
  • Last Modified:

Record not added. Member NCIRCPP is full

Hi there,

When I do a wrkactjob I see a job with a message that says: "Record not added. Member NCIRCPP is full". I can then choose to either ignore, increment by 1 or by any other amount 1- 9999.

What does this mean? Has my object ran out of space? How can I check which files are close to being "full"?

Thanks,
J.
0
jacovanderberg
Asked:
jacovanderberg
  • 3
  • 3
1 Solution
 
jacovanderbergAuthor Commented:
Hi,

The platform is an AS400 (iSeries) with a DB2 database.
0
 
shalomcCommented:
Hey,
You will have to dump the list of members in the files using the following syntax:

DSPFD FILE(libname/filename) TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(worklib/overflowmb)
(the library can be *LIBL and the file name can be generic, if you know what I mean).

Then, use your favorite reporting tool like QRY400, or a PC based one if you like, and look for the following records:

select * from worklib.overflowmb where (mbrcdc * 0.90) < (mbnrcd+mbndtr)

replace 0.90 with your own ratio.

ShalomC
0
 
shalomcCommented:
Also, consider changing the critical tables' record capacity to a meaningful number.
Try the CHGPF command, you will see the allocated records parameter.

ShalomC
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
jacovanderbergAuthor Commented:
Hi ,

Thanks for all the feedback so far. I do have very little knowledge about the AS400 and DB2, but will try your suggestions and let you know which one worked best for me. Shalomc, when you say "changing the critical tables' record capacity to a meaningful number", what do you mean?/How will I change it?

Thanks,
J.
0
 
shalomcCommented:
I recommend setting the records limit on high volume transaction files to be *NOMAX.
The way to set this limit on a particular file is by the Change Physical File command, like this:

CHGPF FILE(library/file) SIZE(*NOMAX)

Of course, to be really sure what files to select, how to predefine the file size and whether to preallocate disk space or not, you need a professional to look over your AS400 and your application.


ShalomC
0
 
jacovanderbergAuthor Commented:
Thank you for your valuable input.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now