|
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..."
*** 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: SAVLIB/RSTLIB and external stored procedures (Paul Roy)
2. RE: SAVLIB/RSTLIB and external stored procedures (Rob Berendt)
3. *** ADMIN: A tip about shortening links (David Gibbs)
4. Re: SAVLIB/RSTLIB and external stored procedures (Paul Bailey)
5. Re: Web Forms to PDF (was AFP-To-PDF) (Richard Schoen)
6. Programatically retrieve CHGTCPDMN DNS address entries (Troy Hyde)
7. Re: Programatically retrieve CHGTCPDMN DNS address entries
(Bryan Dietz)
---------- Forwarded message ----------
From: Paul Roy <paul.roy@xxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Wed, 4 Jan 2017 14:36:58 +0100
Subject: Re: SAVLIB/RSTLIB and external stored procedures
Here are IBM recommendations
http://www-01.ibm.com/support/docview.wss?uid=nas8N1016731
Paul
---------- Forwarded message ----------
From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Wed, 4 Jan 2017 08:37:47 -0500
Subject: RE: SAVLIB/RSTLIB and external stored procedures
This is how you find your list of stored procedures, functions, routines,
etc:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/
db2/rbafzcatalogtbls.htm
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_
73/db2/rbafzcatalogodbc.htm?view=kc
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_
73/db2/rbafzcatalogans.htm?view=kc
There are columns in them which should indicate "external stored
procedures".
Also, get the latest version of "Run SQL Scripts".
Look at the "Insert from Examples".
Drop down "DB2 for i Services".
See "Compare SYSROUTINE across two IBM i partitions"?
How cool is that!
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: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 01/04/2017 08:05 AM
Subject: RE: SAVLIB/RSTLIB and external stored procedures
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Paul,
I do a similar Save of libraries and restore to libraries on a different
LPAR.
I haven't run into the stored procedure issue, but the Xlib LF issue.
In order for the Xlib LF to restore correctly, I have to restore to the
same library name, and rename the libraries afterwards.
Did you ever try restoring to the same library?
I'd like to know more about the external stored procedure issue.
We don't use them, but our primary 3rd party product does, I think.
1) How can you identify if you have "external stored procedures"?
2) What object type are they?
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim
Oberholtzer
Sent: Wednesday, January 04, 2017 7:52 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SAVLIB/RSTLIB and external stored procedures
Rob is correct about the system catalogs being your friend, and sure call
it in, but I highly doubt you're going to get the responses you expect.
Stored procedures have been a problem with Save/Restore for some time and
are the chief source of pain in migrations and HA environments. I tell
all of my customers to have a plan to recreate stored procedures as part
of the DR plan, and usually have special procedures for them in an HA
environment.
Due to the way PowerHA does things it normally does not have an issue with
them, nor do a couple of the other vendors but they are still the focal
point of most of the recovery problems
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Wednesday, January 04, 2017 6:41 AM
To: Midrange Systems Technical Discussion
Subject: Re: SAVLIB/RSTLIB and external stored procedures
First, I would test this.
Second, I would open a ticket if it didn't work.
Third, I would eschew manual lists and I would look at the system catalog
to create an automated list on a periodic basis. SYSPROCS, SYSFUNCS, etc.
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 Bailey <PabloMotte+Midrange@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/04/2017 07:37 AM
Subject: Re: SAVLIB/RSTLIB and external stored procedures
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
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 notrestore
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.them
- 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
nightto 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
notI
also restore LIVEFIL from that tape into library CLAIMFIL (after
completely
removing the older CLAIMFIL). Every morning the above procedure does
newexist 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
listdatabase anything missing is recreated automatically.This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
-Paul.
--
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
--
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
---------- Forwarded message ----------
From: David Gibbs <david@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Cc:
Date: Wed, 4 Jan 2017 07:40:21 -0600
Subject: *** ADMIN: A tip about shortening links
Folks:
I just noticed that, if you use the bit.ly link shortening service, and
enter an IBM.COM URL ... the generated URL is in the http://ibm.co domain.
If you're going to post a long URL, consider using bit.ly to shorten it
so it doesn't risk getting cut off.
david
--
David Gibbs
midrange.com
IBM i on Power Systems: For when you can't afford to be out of business!
I'm riding a metric century (100 km / 65 miles) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting http://lsteml.diabetessucks.net. My goal is $6000 but any
amount is appreciated.
See where I get my donations from ... visit http://lsteml.diabetessucks.ne
t/map for an interactive map (it's a geeky thing).
I may have diabetes, but diabetes doesn't have me!
---------- Forwarded message ----------
From: Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Wed, 4 Jan 2017 14:26:54 +0000
Subject: Re: SAVLIB/RSTLIB and external stored procedures
Uuurgh! Thanks Paul. I can't believe I missed that. Your Google-Fu must be
greater than mine... It tells me that the program objects should also be in
the data library, which goes against everything I ever learned, but I guess
needs must.
-Paul.
On 4 January 2017 at 13:36, Paul Roy <paul.roy@xxxxxxx> wrote:
Here are IBM recommendationslist
http://www-01.ibm.com/support/docview.wss?uid=nas8N1016731
Paul
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
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
---------- Forwarded message ----------
From: Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Wed, 4 Jan 2017 14:29:35 +0000
Subject: Re: Web Forms to PDF (was AFP-To-PDF)
Yep, if you're attempting to teach people, provide code samples that can
be downloaded, compiled and incorporated. This is the new age of open
source (public domain).
With WebForms it's not public domain code. PDF filling is part of the
product.
When I speak of iText samples I will be adding a couple of iText samples
to an existing presentation that provides source for creating CL commands
that wrap around Java to do various PDF related tasks.
Well the year is off to a cold start. -8 here in MN today. Yeesh.
Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
------------------------------
message: 2
date: Tue, 3 Jan 2017 16:46:07 -0700
from: Nathan Andelin <nandelin@xxxxxxxxx>
subject: Re: Web Forms to PDF (was AFP-To-PDF)
Thanks, I'll take a look.
Since you asked here's a couple of relevant Webex replay URLs:
5 Reasons To Stop Filling Out Forms By Hand
https://www.helpsystems.com/resources/on-demand-webinars/
5-reasons-stop-filling-out-forms-hand
Pssst... It's Time to Cut Ties with Your Outdated Forms Technology
https://www.helpsystems.com/resources/on-demand-webinars/
pssst%E2%80%A6-it%E2%80%99s-time-cut-ties-your-outdated-forms-technolo
gy
In regards to writing it myself I did. Fillable PDFs from captured
data are an integral part of our WebForms product.
I thought we were talking about writing a complete solution and putting it
in the public domain. Isn't that what you were asking for?
I did actually advocate learning a little Java and iText as well. Not too
hard. I'll probably add some iText Java samples to my Common
Presentation on building CL commands with Java so people have a
complete installable, compilable source example.
See above.
And..."Show me the money" is from Jerry McGuire. If I have to explain
it.....well you know :-)
I've never seen the movie. But a Google search pulls up the following:
https://www.youtube.com/watch?v=1-mOKMq19zU
I agree the parody fits this discussion. You're playing the role of the
athlete.
---------- Forwarded message ----------
From: Troy Hyde <troy.hyde@xxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Cc:
Date: Wed, 4 Jan 2017 07:30:54 -0700
Subject: Programatically retrieve CHGTCPDMN DNS address entries
Our company assists nearly 250 clients in managing their IBM i servers. The
clients' OS levels range from V6R1 to V7R2.
One of our IT managers has found that a lot of the servers have 4.2.2.2 as
one of their DNS entries in CHGTCPDMN which has started to cause them some
trouble. When it is found, one of our techs will manually correct the DNS
setting.
Rather than manually connecting to each server and checking CHGTCPDMN
individually, I was hoping to programatically list the current settings so
we can determine which clients have 4.2.2.2. However, I have been unable to
find any method to do so.
Can anyone suggest a service program and/or function that shows the current
DNS settings?
Thanks,
T
TROY HYDE, Upgrades and Standards Manager
FLEX : 800 262 3539
Troy.Hyde@xxxxxxxxxxx
Confidentiality Notice: This communication and any associated attachments
is intended only for the person or entity to which it is addressed and may
contain information that is privileged, confidential or otherwise protected
from disclosure. Dissemination, distribution or copying of this
communication and any accompanying attached information by anyone other
than the intended recipient(s), or an employee or agent acting on behalf of
the intended recipient, is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
message, and then delete it from your computer.
---------- Forwarded message ----------
From: Bryan Dietz <bdietz400@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
Date: Wed, 4 Jan 2017 09:44:42 -0500
Subject: Re: Programatically retrieve CHGTCPDMN DNS address entries
the API QtocRtvTCPA will do it
http://ibm.co/2iI4DA9
For Domain Name System (DNS) information in addition to the TCP/IPv4 stack
status, use format TCPA0300.
A google search will revel several examples.
Bryan
Troy Hyde wrote on 1/4/2017 9:30 AM:
Our company assists nearly 250 clients in managing their IBM i servers.
The
clients' OS levels range from V6R1 to V7R2.
One of our IT managers has found that a lot of the servers have 4.2.2.2 as
one of their DNS entries in CHGTCPDMN which has started to cause them some
trouble. When it is found, one of our techs will manually correct the DNS
setting.
Rather than manually connecting to each server and checking CHGTCPDMN
individually, I was hoping to programatically list the current settings so
we can determine which clients have 4.2.2.2. However, I have been unable
to
find any method to do so.
Can anyone suggest a service program and/or function that shows the
current
DNS settings?
Thanks,
T
TROY HYDE, Upgrades and Standards Manager
FLEX : 800 262 3539
Troy.Hyde@xxxxxxxxxxx
Confidentiality Notice: This communication and any associated attachments
is intended only for the person or entity to which it is addressed and may
contain information that is privileged, confidential or otherwise
protected
from disclosure. Dissemination, distribution or copying of this
communication and any accompanying attached information by anyone other
than the intended recipient(s), or an employee or agent acting on behalf
of
the intended recipient, is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
message, and then delete it from your computer.
--
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.
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 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.
midrange.com
