× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



+1

Thanks

On 2018-03-01 10:52, Rob Berendt wrote:

If the number of row consideration is not really a concern then I would
tend to stick with a timestamp column instead. This makes it easier to do
something like

delete from HistoryTable
Where MemberNameColumn < current date - 90 days

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>
Cc: Rob Berendt <rob@xxxxxxxxx>
Date: 03/01/2018 10:40 AM
Subject: Re: Backup of SQL tables and multi-member files
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

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
--
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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.