Re: Backup of SQL tables and multi-member files

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

we are also considering just setting up our backup files as
multi-membered flat files and using FMTOPT(*NOCHK).

Paul 

On 2018-03-01 10:22, Paul Therrien wrote:

> Yeah, we are considering the addition of a column to the backup file. 
>
> Paul  
>
> On 2018-03-01 09:53, Rob Berendt wrote:
>
> > Technically multi member (aka partitioned) tables are supported in SQL. 
> > Most people do not do it on IBM i because you have to buy DB2 Multisystem 
> > to get this capability, even on a single system.  And the cost of that is 
> > your first born male child and a sports team of IBM's choosing.
> > If the number of rows does not approach the maximum number of rows per 
> > partition then why not just add a column you would normally use as a 
> > member name?
> > If you do approach system limits then you could do a CHGPF and alter the 
> > maximum number of partitions (aka members).
> >
> > Rob Berendt
> > -- 
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to:  2505 Dekko Drive
> > Garrett, IN 46738
> > Ship to:  Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >
> > From:   Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
> > To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > Date:   03/01/2018 09:39 AM
> > Subject:        Backup of SQL tables and multi-member files
> > Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
> >
> > When we process files in our job streams we frequently create backups of
> > the input files by copying the file to a backup library/file with a new
> > member name incorporating the date. 
> >
> > These backup files are created initially by using CRTDUPOBJ or CPYF over
> > the production file. 
> >
> > Now we have begun creating SQL tables instead of PFs and we are running
> > into the issue that SQL tables cannot be multi-member.  When you
> > CRTDUPOBJ or CPYF CRTF(*YES) from a table the resulting object is a
> > table. 
> >
> > So with this background, I am wondering what strategies people are using
> > for keeping backup copies of files when the base file is an SQL table? 
> >
> > Paul
> > -- 
> > 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related 
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate 
> > link: http://amzn.to/2dEadiD