RE: Savlib problem too many member

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Can the following be related to this? It is from 
InfoCenter for V5R3 - Systems Management, Maximum capacities subtopic.

A database file object consists of one or more 
internal objects. A maximum of approximately 
500,000 related internal objects can be saved in 
a single save operation. One internal object is 
saved for each database file object, along with 
the following additional internal objects:

- If the physical file is not keyed, add 1 internal object per member.
- If the physical file is keyed, add 2 internal objects per member.
- If the physical file has unique or referential 
constraints, add 1 internal object per constraint.
- If the physical file has triggers, add 1 internal object for the file.
- If the physical or logical file has column 
level authorities, add 1 internal object for the file.
- If you use ACCPTH(*YES) on the save command, 
add 1 internal object for each logical file in the save request.

Vern

At 06:59 AM 4/10/2007, you wrote:


> If it's source, the simplest solution is splitting it up.  If it's a
> database library, someone has to validate the necessity of keeping it as
> one library.  If you are at a real limit, then you either have some
> (possibly severe) application modifications to make, or need to contact IBM
> indicating that you have hit a system limit.
>
> It would be better if the message were more specific, but some limits are
> so complex that they don't lend themselves to be fully described in one
> message.  However a reference to where the limit might be better documented
> would not be out of order.
>
> Al
>
> Al Barsa, Jr.
> Barsa Consulting Group, LLC
>
> 400>390
>
> "i" comes before "p", "x" and "z"
> e gads
>
> Our system's had more names than Elizabeth Taylor!
>
> 914-251-1234
> 914-251-9406 fax
>
> http://www.barsaconsulting.com
> http://www.taatool.com
> http://www.as400connection.com
>
>
>
>
>              "Jan Rockstedt"
>              <jan.rockstedt@av
>              inova.se>                                                  To
>              Sent by:                  "Midrange Systems Technical
>              midrange-l-bounce         Discussion"
>              s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>
>                                                                         cc
>
>              04/10/2007 07:52                                      Subject
>              AM                        RE: Savlib problem too many member
>
>
>              Please respond to
>              Midrange Systems
>                  Technical
>                 Discussion
>              <midrange-l@midra
>                  nge.com>
>
>
>
>
>
>
> Thanks Al,
>
> Yes the library is "out of control" ....
> Only 138 pf object in the library, but a lot of members is the files.
> Problem to run a save 21 also. :-(
>
>
> Mvh / Regards
> Jan Rockstedt
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Barsa
> Sent: Tuesday, April 10, 2007 1:37 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Savlib problem too many member
>
>
> The text for CPF375E doesn't specifically say how many members for the Save
> Library (SAVLIB) command is too many.  There is a limit of 32767 members in
> a single file, but there is apparently also a SAVLIB (the save of an entire
> library, presumably a collection of too many members made up of multiple
> database files), but the message text doesn't give specifics.  Keep in mind
> that a logical file can also have members.  It strikes me that this is
> an"out of control" library, and either needs to be split up, or use other
> techniques for source storage.
>
> If anyone has more detail, please chime in.
>
> Al
>
> Al Barsa, Jr.
> Barsa Consulting Group, LLC
>
> 400>390
>
> "i" comes before "p", "x" and "z"
> e gads
>
> Our system's had more names than Elizabeth Taylor!
>
> 914-251-1234
> 914-251-9406 fax
>
> http://www.barsaconsulting.com
> http://www.taatool.com
> http://www.as400connection.com
>
>
>
>
>              "Jan Rockstedt"
>              <jan.rockstedt@av
>              inova.se>                                                  To
>              Sent by:                  "Midrange Systems Technical
>              midrange-l-bounce         Discussion"
>              s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>
>                                                                         cc
>
>              04/10/2007 04:34                                      Subject
>              AM                        Savlib problem too many member
>
>
>              Please respond to
>              Midrange Systems
>                  Technical
>                 Discussion
>              <midrange-l@midra
>                  nge.com>
>
>
>
>
>
>
> Hi all,
>
> We have problem to run savlib.
> There too many members for a file "CPF375E"
>
> 0019.01              SAVLIB     LIB(edilib) +
>
> 0019.03                           DEV(TAP02) VOL(*MONTED)
> +
> 0019.04                           EXPDATE(*PERM) ENDOPT(*UNLOAD)
> +
> 0019.05                           CLEAR(*ALL) SAVACT(*SYSDFN)
> +
> 0019.06                           SAVACTWAIT(10)
> ACCPTH(*YES)
>
> Any suggestion for the problem?
>
> Mvh / Regards
> Jan Rockstedt
>
>
> +46 - 40 - 668 07 45
> jan.rockstedt@xxxxxxxxxx
>
> IBM Certified Specialist -  System i5 Administrator Avinova AB Spångatan 37
> B
> 211 53  Malmö Sweden
> Tel  +46-40-668 07 40
> Fax +46-40-668 07 55
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
> or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.