Re: MIDRANGE-L Digest, Vol 4, Issue 602

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

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

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

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

Today's Topics:

  1. Re: Removing constraints (Vernon Hamberg)
  2. Re: Who Uses WebSphere Express? (Mark Phippard)
  3. Re: Fw: SAVF from V5R3 to V4R5 (Zvi Kave)
  4. Re: Removing constraints (R Bruce Hoffman)
  5. RE: Who Uses WebSphere Express? (Joe Pluta)
  6. Re: Removing constraints (David Gibbs)
  7. Re: Removing constraints (R Bruce Hoffman)

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

message: 1
date: Sat, 02 Apr 2005 21:37:58 -0600
from: Vernon Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Removing constraints

I think maybe I'm confused - what DDS keyword establishes a primary key?
AFAIK, the key of a PF is not the same thing as the primary key. For one
thing, the primary key has to be unique and the key of a PF does not have
that requirement. And in a DSPFD TYPE(*CST), the key of a PF will not be
listed, unless you've used SQL DDL or ADDPFCST to add it. And in DSPFD
TYPE(*ACCPTH), the PF key is listed with "Constraint type = NONE".

Vern

At 06:32 PM 4/2/2005, you wrote:

Right. But primary key constraints, in a typical iSeries environment are
actually specified in the DDS.

If you are using SQL DDL and specify the primary keys as constraints,
separate from the definition of the table, then, again, you can apply
them from the DDL source. That's just a learned thing.

I'm not implying that there isn't some other underlying problem with the
save and restore, but, with full SQL DDL sources, you should be able to
readily repair any constraint damage caused by the save restore, and
only have to rely on the table data making it back.

Managed DDL sources have everything ordered by drop, create table,
create primary keys, create unique keys, create inversion keys, create
foreign keys, create value constraints. They can then be applied by
range, even in the CA SQL execution utilities.

Question, did you ever resolve if the save was done with ACCPTH(*YES)?

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

message: 2
date: Sat, 2 Apr 2005 22:37:19 -0500
from: Mark Phippard <MarkP@xxxxxxxxxxxxxxx>
subject: Re: Who Uses WebSphere Express?

Joe.

We use it and have for a long time. I think WAS Express is a great product
and with 6.0 it just gets better.

We also sell an iSeries Helpdesk product called ExpressDesk that is largely
built on WAS Express. We do not force our customers to run it on WAS
Express or on iSeries, but the vast majority do so.

A live demo is here, running on WAS Express 5.1 on an OS/400 LPAR on a
model 520.

http://support.softlanding.com/xdesk/

As an ISV, you do not want to sell a product that relies on something that
is going to be difficult for the customer to install or maintain, and
certainly something that is not reliable. We have never had to do anything
other than telephone based support for our customers. All of them have
been able to install WAS Express and our app on their own, with just phone
support from us. The only hard part, and this largely went away with V5R3,
is that if the customer did not already have WAS Express installed, there
are a fair amoint of Group PTF's to apply, which means an IPL. At the same
time, that is the benefit of using an IBM supported product - it actually
has fixes available. Also, the handful of times we have run into weird
issues and had to involve IBM support, the issue was already resolved
quickly, telling me that IBM has a good support organization in place for
this product.

To say WAS Express is not production-ready is libelous.  I did not see the
post, perhaps this person had some legitimate bad experiences.  That does
not mean the product is not top notch.

Mark

_____________________________________________________________________________
Scanned for SoftLanding Systems, Inc. by IBM Email Security Management Services powered by MessageLabs.
_____________________________________________________________________________

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

message: 3
date: Sun, 3 Apr 2005 04:35:54 -0700 (PDT)
from: Zvi Kave <zvikave@xxxxxxxxx>
subject: Re: Fw: SAVF from V5R3 to V4R5

Vernon,

It seems that I am not familiar enough with the virtual optical drive options.
1. You are talking about CD images, but where do I put my desired OS/400 library/ies
in all this procedure ?
Nothing is mentioned about this issue.
2. Can you make it more clear how to read the virtual CD image to normal OS/400
library in lower version (V4R5).

Please help.

Best regards,

Zvi

Zvi Kave <tzvik@xxxxxxxxxx> wrote:

----- Original Message ----- From: "Vernon Hamberg"
To: "Midrange Systems Technical Discussion"
Sent: Friday, April 01, 2005 3:59 PM
Subject: Re: SAVF from V5R3 to V4R5

Sure, here's stab at it. Basically, you create a directory for an image
catalog, then create the image catalog, then add *NEW entries to the image
catalog. Each image catalog entry will have a corresponding file in the
directory you created. These files are ISO-9660 images that can be burnt
to CD or DVD using "Create CD from hard drive image" option - whatever
it's called - in the various burners. Or, in your case, can be FTP'd to
any FTP server - does not need to be iSeries - and then FTP'd back to the
V5R3 box, remounted in an image catalog, and used for restore or whatever.

1. MKDIR '/tmp/optical' (your name will be different, probably) to create
the directory where the image catalog will reside. This is a one-time
operation.

2. CRTIMGCLG MYIMGCLG DIR('/tmp/optical') to make the image catalog in the
directory you created. You only do this once.

3. ADDIMGCLGE IMGCLG(MYCLG) FROMFILE(*NEW) TOFILE(MYFILE01) IMGSIZ(*CD650)
to add a CD-size image entry to the image catalog. The file MYFILE01 will
be in the directory you created. This file can be sent anywhere. Add all
the image entries you need.

4. I think you need to initialize the image entries - INZOPT is the
command to use.

5. WRKIMGCLG is the command to use for doing a lot of this stuff - it
calls WRKIMGCLGE for maintaining the entries. There is not at this time a
really good way to DSPIMGCLG or DSPIMGCLGE, but if you use the file name
for the optical volume ID and use OUTPUT(*PRINT) or *OUTFILE on the saves,
you should have the file names available for automating file transfer.

I've not done the automated part but it seems it should work. For more
information, check out the various image catalog commands at InfoCenter -
WRKIMGCLG, WRKIMGCLGE, LODIMGCLG, ADDIMGCLGE, RMVIMGCLGE, etc. There's
also a good discussion on image catalogs deep in the Linux installation
section of InfoCenter.

HTH
Vern

At 10:03 AM 3/31/2005, you wrote:

Vernon,

Please send few example command lines to explain
how can I transfer AS/400 libraries by the Virtual drive
from V5R3 to V4R5.

Regards,

Zvi

Vernon Hamberg wrote:
Wayne

This can be an all AS/400 solution, too. The virtual optical drive is
really an IFS object the size of a CD (or DVD for that matter). At V5R3
you
can create an image catalog with multiple entries. The save will span
them,
just as it does with tape. Then the corresponding IFS files can be FTP'd
to
your V4R5 system - again, it's just an IFS object - no VRM information in
that object, only in its contents. And you have the extra benefit that you
can burn the images to plastic if you want.

Vern

At 02:41 AM 3/29/2005, you wrote:
>I'm trying to automate this fully so that a nightly job cna be run to >do
>the backup and transfer the files. This pretty much dictates an all
>AS/400 solution.
>
>Bryan Dietz wrote:
>>One other option is to use V5R3 ability to save to a virtual option
>>drive.
>>Then you could use that ISO image to write to a PC's CD drive.
>>this allows you to save multiple libraries to the same virtual optical
>>media.
>>
>>Check the info center:
>>This link should help:
>>http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?i
nfo/rzam4/rzam4virtualuse.htm
>>
>>----------------------------
>>Bryan Dietz
>>Aktion Associates
>>
>>midrange-l-bounces@xxxxxxxxxxxx wrote on 03/28/2005 05:48:42 PM:
>>
>>>Thanks to all who replied. I've run a test by creating a SAVF on the
>>>V4R5 system and FTP'ing the SAVF from the V5R3 system. It appears to
>>>have completed successfully. I'm going to do it with a dummy library
>>>and files to be sure that I can go in the opposite direction and do a
>>>restore back to the V5R3 system. If that doesn't work, I'll pursue >>>the
>>>IFS solution.
>
>
>--
>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.

---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
--
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.

---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

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

message: 4
date: 03 Apr 2005 08:17:10 -0400
from: R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>
subject: Re: Removing constraints

True. I may not have been precise enough in my language there. My fault.

Generally in dealing with iSeries shops, when they say primary key, they
aren't usually refering to a "real" SQL DDL primary key constraint, but
either a logical file's or the physical file's key specification that
they consider to be primary.

No matter. What I was getting at was is this a mixed DDS and SQL DDL
schema/library or completely SQL DDL schema?

In the case of the former, I know that unique keys in physical files are
"consumed" by the process of adding a primary key constraint to the file
if that access path can provide the constraint. What I don't recall is
the "sharing" of access paths if the so called "primary key" is actually
in a logical file when the DDL primary key constraint is applied. (Is it
shared or not?)

And in the case of the completely SQL DDL schema... is it managed by a
tool or at least by a member/file of DDL statements?

Now, as I read back... I dunno... maybe I'm still confusing? <VBG>

On Sat, 2005-04-02 at 22:37, Vernon Hamberg wrote:

I think maybe I'm confused - what DDS keyword establishes a primary key?
AFAIK, the key of a PF is not the same thing as the primary key. For one
thing, the primary key has to be unique and the key of a PF does not have
that requirement. And in a DSPFD TYPE(*CST), the key of a PF will not be
listed, unless you've used SQL DDL or ADDPFCST to add it. And in DSPFD
TYPE(*ACCPTH), the PF key is listed with "Constraint type = NONE".

Vern

At 06:32 PM 4/2/2005, you wrote:
>Right. But primary key constraints, in a typical iSeries environment are
>actually specified in the DDS.
>
>If you are using SQL DDL and specify the primary keys as constraints,
>separate from the definition of the table, then, again, you can apply
>them from the DDL source. That's just a learned thing.
>
>I'm not implying that there isn't some other underlying problem with the
>save and restore, but, with full SQL DDL sources, you should be able to
>readily repair any constraint damage caused by the save restore, and
>only have to rely on the table data making it back.
>
>Managed DDL sources have everything ordered by drop, create table,
>create primary keys, create unique keys, create inversion keys, create
>foreign keys, create value constraints. They can then be applied by
>range, even in the CA SQL execution utilities.
>
>Question, did you ever resolve if the save was done with ACCPTH(*YES)?

--
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde

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

message: 5
date: Sun, 3 Apr 2005 07:26:51 -0500
from: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
subject: RE: Who Uses WebSphere Express?

Thanks, Mark.  That's what I said as well.  This was a vendor of an
RPG-CGI product, and they're up in arms because I said JSP Model II is
architecturally superior to RPG-CGI.  That's not to say that there
aren't business cases where RPG-CGI makes sense, but from a pure
technology standpoint, JSP Model II wins.

The vendor in question insists that RPG-CGI is more scalable than JSP
Model II.  First he said WebSphere won't run on a model 270, and when I
burst his bubble on that, he started with the scalability issue.  He's
also got a user of his product in the forum, and that user already
impugned your statement, saying basically that you're just pitching
WebSphere because your product runs on it.  He says that "among normal
users, not ISVs of WebSphere Express products, WebSphere is a novelty".

In fact, it's been quite an attack on WebSphere in general, which is
exactly what I predicted in my article.  There will be the 100% pure
Java faction and the 100% pure RPG faction, and between them they're
going to try to splinter the market.

But it's impossible to beat the flexibility of a merged architecture,
with a JSP Model II user interface talking to a RPG back end.  You can
go from 100% Pure Java and no RPG, to an extremely thin Java veneer and
nearly 100% RPG, depending on your business requirements.  And your
architecture can even shift with time as you acquire new skill sets.

But there will be diehards.  People who either drank the 100% Pure Java
Koolaid or who are completely Java-phobic.

Joe

From: Mark Phippard

To say WAS Express is not production-ready is libelous. I did not see

the

post, perhaps this person had some legitimate bad experiences. That

does

not mean the product is not top notch.

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

message: 6
date: Sun, 03 Apr 2005 08:03:17 -0500
from: David Gibbs <david@xxxxxxxxxxxx>
subject: Re: Removing constraints

R Bruce Hoffman wrote:

No matter. What I was getting at was is this a mixed DDS and SQL DDL
schema/library or completely SQL DDL schema?

In this case, it's an entirely SQL DDL schema.

And in the case of the completely SQL DDL schema... is it managed by a
tool or at least by a member/file of DDL statements?

The schema is managed by the application.

david

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

message: 7
date: 03 Apr 2005 09:27:59 -0400
from: R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>
subject: Re: Removing constraints

On Sun, 2005-04-03 at 09:03, David Gibbs wrote:

R Bruce Hoffman wrote:
> No matter. What I was getting at was is this a mixed DDS and SQL DDL
> schema/library or completely SQL DDL schema?

In this case, it's an entirely SQL DDL schema.

Ouch!

I'm sorry to be thick here... but now I'm really curious/concerned.

Ok, so after the restore, did/have you done a WRKPFCST? And are the
constraints completely missing or pending?

And maybe I missed this... did you restore to the same library name or a
different library name?

> And in the case of the completely SQL DDL schema... is it managed by a
> tool or at least by a member/file of DDL statements?

The schema is managed by the application.

Still not exactly sure what you mean by this. Do you mean that there is
some "install/update" program included with the application that
creates/modifies the schema? Or is there a separate file/member of DDL
statements that is maintained in the application but can still be
applied through, say, Client Access or RUNSQLSTM?

david

--
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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.

End of MIDRANGE-L Digest, Vol 4, Issue 602
******************************************

--- http://USFamily.Net/dialup.html - $8.25/mo! -- 
http://www.usfamily.net/dsl.html - $19.99/mo! ---