Re: SAVLIB/RSTLIB and external stored procedures -- MIDRANGE-L

I've done that test. I've found that all SQL procedures are "restored"
(i.e. added to SYSPROCS) to the library being restored to, but any external
procedures are only restored if the object pointed to by the EXTERNAL
clause is in the library being restored to. I didn't test a scenario where
the EXTERNAL clause doesn't specify a library (which should then use *LIBL)
as we always specify the library qualifier there.

I am now in the process of moving all my external procedures into the
LIVEPGM library and adding the LIVEPGM library to the data connections used
by the website. We are still undecided about the SQL stored procedures
because they are database objects and belong in the database, but the
system actually creates programs for SQL procedures which then causes a
difference of opinions every time it is mentioned.

Thanks to everyone for their help.

-Paul.

On 5 January 2017 at 14:25, Rob Berendt <rob@xxxxxxxxx> wrote:

I believe that IBM alters the internals on what is actually saved to media
(tape, save files, etc) to get the information from the system catalogs
also for things like stored procedures, etc. And the restore also handles
this.
Now some people are reporting interesting results. Like perhaps it's not
working as they believe it should.

I'm not questioning whether how they believe is good, bad or indifferent.
I'm just explaining my belief as to how save/restore handles this.

If I had more time I might try creating a small library with a stored
procedure in it.

Remember, the adepts would use the internals of save files to undelete
rows in tables. So there should be some way of seeing this stuff.

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: "Mark Murphy/STAR BASE Consulting Inc." <mmurphy@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/05/2017 08:50 AM
Subject: Re: SAVLIB/RSTLIB and external stored procedures
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

Does SAVLIB/RSTLIB save and restore other dependent objects that exist in
another library than the one you are saving/restoring? The only thing
CREATE PROCEDURE LIVEFIL/... stores in LIVEFIL is a record in an SQL
CATALOG. The stored procedure is in LIVEPGM. I tend to store my database
objects all together whether they are program objects or file objects or
something else. External stored procedures are a different animal though.
Those are a weird hybrid. May want to include LIVEPGM in your
SAVLIB/RSTLIB.

Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx

-----Paul Bailey <PabloMotte+Midrange@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>
Date: 01/04/2017 08:42AM
Subject: Re: SAVLIB/RSTLIB and external stored procedures

We're just starting with using stored procedures and are getting worried
that we'd have to maintain a list of stored procedures that need to be
manually re-created in a Disaster Recovery situation. Surely SAVLIB/RSTLIB
should be able to handle this by itself?.

On 4 January 2017 at 11:35, DrFranken <midrange@xxxxxxxxxxxx> wrote:

We ran into the same thing with a migration recently. It does not

restore

them as desired. In our case it was one time and the developer said:

There

are three, I'll recreate them. We did not investigate further.

- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 1/4/2017 6:08 AM, Paul Bailey wrote:

Hi,

Does SAVLIB save external stored procedures? And does RSTLIB restore

them

to a different library?

I have a procedure created with:

CREATE PROCEDURE LIVEFIL/GETNEWCLAIMNUMBER(OUT REFERENCE INTEGER )

LANGUAGE RPGLE NOT DETERMINISTIC NO SQL EXTERNAL NAME

LIVEPGM/TR1406 PARAMETER STYLE GENERAL

Every night I save library LIVEFIL out to a tape. Much later in the

night

I
also restore LIVEFIL from that tape into library CLAIMFIL (after
completely
removing the older CLAIMFIL). Every morning the above procedure does

not

exist in CLAIMFIL. LIVEFIL and CLAIMFIL are not "schema", just plain
libraries.

With backup procedures of other DBMSs (e.g. MariaDB) all procedure and
table definitions are saved with the data backups, and on restore to a

new

database anything missing is recreated automatically.

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

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

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

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

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