Re: Backup of SQL tables and multi-member files

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

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