RE: Sometime you need multiple members in a table. -- MIDRANGE-L

Methinks you could do a CHGPF and change the number of allowed members on it.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon Hamberg
Sent: Thursday, January 17, 2019 8:40 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Sometime you need multiple members in a table.

Hi Brian

+1 on using SYSCOLUMNS and/or SYSINDEXES - whatever the names or other
views - for this.

One caution - there are things in SQL tables that are not supported in
DDS-based PFs - not a probable issue, but it might be. :)

Vern

On 1/17/2019 7:28 AM, Brian Garland via MIDRANGE-L wrote:

I'd suggest creating a tool that uses the system APIs or QSYS2 tables to
get the list of short names and write the DDS and compile it.

You could then add members and use SQL to copy data from the table to the
PF.

I've done similar things in the past and could help with code if needed.

Brian

message: 3
date: Thu, 17 Jan 2019 08:13:39 -0500
from: a4g atl <a4ginatl2@xxxxxxxxx>
subject: Sometime you need multiple members in a table.

I have a situation where I have a table defined. In the past I used PFs.
The table has a long and short name. This prevents me from using CPYF or
CRTDUPOBJ. I have used RUNSQL to do a Create Table ... as (select..) with
no data. This creates a table not a PF, okay.

I need a PF with Multiple members that is identical to the table. I use the
member to store copies of file we send to external systems as an archive.
The member functionality has been great for this and I do not want to have
hundreds of files in the library.

I do not have DDS but I could create DDS but would prefer not to. That
makes it 2 different objects to maintain.

Is there a way to create a PF from a table?

TIA

Darryl Freinkel

On Thu, Jan 17, 2019 at 8:21 AM <midrange-l-request@xxxxxxxxxxxxxxxxxx>
wrote:

Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxxxxxxxx

You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."

*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Re: V7R1 is SAN bootable on Power 914 (Jim Oberholtzer)
2. Re: V7R1 is SAN bootable on Power 914 (Jim Oberholtzer)
3. Sometime you need multiple members in a table. (a4g atl)
4. RE: Sometime you need multiple members in a table. (Rob Berendt)

----------------------------------------------------------------------

message: 1
date: Wed, 16 Jan 2019 20:21:38 -0600
from: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re: V7R1 is SAN bootable on Power 914

How can it be a "completely valid migration path" when IBM does not
support it, has not tested it, etc. etc.. Quite simply, it's not.

That does not mean that it might work, and for non-production workloads
might be an interesting science project, but don't give customers the idea
that it's in any way a supported method, it is not.

V7R1 support is only available with very expensive side support agreements
from IBM, and I would be amazed if they would condone this method.

Jim Oberholtzer
Agile Technology Architects

On Jan 16, 2019, at 3:49 PM, Tsvetan Marinov <tsetso.marinov@xxxxxxxxx>

wrote:

Hi,

It's funny but I was able to also D-mode IPL an LPAR with V7R1 LIC image
and it works fine on the 914 box.

I've even successfully upgraded an LPAR from V7R1 to V7R3 directly on the
Power 914 box. It was funny because I though that the LIC load would fail
in flames.
One thing I haven't try is, to load a V7R1 LPAR from tape on the Power

914

box, but it should work since the V7R1 LIC can be booted from VIOS image.

I think I can say that V7R1 to V7R3 is a completely valid migration path
directly on Power 9.

Regards

On Mon, 31 Dec 2018 at 18:39, Holger Scherer <hs@xxxxxxx> wrote:

There's always a difference between "use it for production" and "we made
it!" :)

Happy new year all!

-h

Am 31.12.2018 um 19:11 schrieb DrFranken <midrange@xxxxxxxxxxxx>:

I can see you dabbling with this as I have done similar in the past. I

am surprised it even boots up, that's truly unexpected. I would never

put

this into production however. 'Unsupported' being the operative word

here.

You will never see a mention from IBM that this works because they have

stated that it is unsupported. That is the only statement you will get

from

IBM. Bet on it!

--
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: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

------------------------------

message: 2
date: Wed, 16 Jan 2019 20:21:38 -0600
from: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
subject: Re: V7R1 is SAN bootable on Power 914

How can it be a "completely valid migration path" when IBM does not
support it, has not tested it, etc. etc.. Quite simply, it's not.

That does not mean that it might work, and for non-production workloads
might be an interesting science project, but don't give customers the idea
that it's in any way a supported method, it is not.

V7R1 support is only available with very expensive side support agreements
from IBM, and I would be amazed if they would condone this method.

Jim Oberholtzer
Agile Technology Architects

On Jan 16, 2019, at 3:49 PM, Tsvetan Marinov <tsetso.marinov@xxxxxxxxx>

wrote:

Hi,

It's funny but I was able to also D-mode IPL an LPAR with V7R1 LIC image
and it works fine on the 914 box.

I've even successfully upgraded an LPAR from V7R1 to V7R3 directly on the
Power 914 box. It was funny because I though that the LIC load would fail
in flames.
One thing I haven't try is, to load a V7R1 LPAR from tape on the Power

914

box, but it should work since the V7R1 LIC can be booted from VIOS image.

I think I can say that V7R1 to V7R3 is a completely valid migration path
directly on Power 9.

Regards

On Mon, 31 Dec 2018 at 18:39, Holger Scherer <hs@xxxxxxx> wrote:

There's always a difference between "use it for production" and "we made
it!" :)

Happy new year all!

-h

Am 31.12.2018 um 19:11 schrieb DrFranken <midrange@xxxxxxxxxxxx>:

I can see you dabbling with this as I have done similar in the past. I

am surprised it even boots up, that's truly unexpected. I would never

put

this into production however. 'Unsupported' being the operative word

here.

You will never see a mention from IBM that this works because they have

stated that it is unsupported. That is the only statement you will get

from

IBM. Bet on it!

--
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: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

------------------------------

message: 3
date: Thu, 17 Jan 2019 08:13:39 -0500
from: a4g atl <a4ginatl2@xxxxxxxxx>
subject: Sometime you need multiple members in a table.

I have a situation where I have a table defined. In the past I used PFs.
The table has a long and short name. This prevents me from using CPYF or
CRTDUPOBJ. I have used RUNSQL to do a Create Table ... as (select..) with
no data. This creates a table not a PF, okay.

I need a PF with Multiple members that is identical to the table. I use the
member to store copies of file we send to external systems as an archive.
The member functionality has been great for this and I do not want to have
hundreds of files in the library.

I do not have DDS but I could create DDS but would prefer not to. That
makes it 2 different objects to maintain.

Is there a way to create a PF from a table?

TIA

Darryl Freinkel

------------------------------

message: 4
date: Thu, 17 Jan 2019 13:21:20 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Sometime you need multiple members in a table.

Yes, it's quite easy but it involves the SPENDMONEY command.
In SQL talk a member is a partition. Hence this is why you can find a
list of all "members" in SYSPARTITIONSTAT.
One difference is that SQL rather picks the partition by some criteria.
For example you can partition your tables by REGION. However, unlike how
people often set up their "members" on a DDS table, you would use a REGION
column also. Back when disk was at a premium it would gag someone to add a
column called REGION when you already knew that by the partition (aka
member) name.
Search for the partition clause in the CREATE TABLE statement in the
Knowledge center.

But, here's where the SPENDMONEY command comes into play. To use
partitioned tables you must purchase and install DB2 Multisystem (make sure
you get the right thing, many people confuse it for another option). If
the cost is roughly the same as for a new P9 loaded with SSD's then you've
got the right product. Even if you plan on only using partitioned tables
on a single system you still need DB2 Multisystem. IBM will not unbundle
partitioned tables out of DB2 Multisystem. I tried with an RFE but it got
shot down.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
Sent: Thursday, January 17, 2019 8:14 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Sometime you need multiple members in a table.

I have a situation where I have a table defined. In the past I used PFs.
The table has a long and short name. This prevents me from using CPYF or
CRTDUPOBJ. I have used RUNSQL to do a Create Table ... as (select..) with
no data. This creates a table not a PF, okay.

I need a PF with Multiple members that is identical to the table. I use
the member to store copies of file we send to external systems as an
archive.
The member functionality has been great for this and I do not want to have
hundreds of files in the library.

I do not have DDS but I could create DDS but would prefer not to. That
makes it 2 different objects to maintain.

Is there a way to create a PF from a table?

TIA

Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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: https://amazon.midrange.com

------------------------------

End of MIDRANGE-L Digest, Vol 18, Issue 91
******************************************