I think they want up to the minute because they seem to have some difficulties. But if we do a stored proc, this means the API and the command which creates this list has to run daily?
________________________________
From: "midrange-l-request@xxxxxxxxxxxx" <midrange-l-request@xxxxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Sent: Tuesday, June 11, 2013 12:22 AM
Subject: MIDRANGE-L Digest, Vol 12, Issue 1257
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. All printers and their IP Addresses (Crystal Reports)
2. Re: All printers and their IP Addresses (Alan Campin)
3. Re: All printers and their IP Addresses (Jack Kingsley)
4. Re: QCTL - restricted state (Leif Guldbrand)
5. DLTUSRPRF Fails (Sam_L)
6. RE: All printers and their IP Addresses (Mike Cunningham)
7. Disaster Recovery / Remote Journaling / HA et al (Troy Hyde)
8. Re: Disaster Recovery / Remote Journaling / HA et al (DrFranken)
9. Re: list of open descriptors (Mike Krebs)
----------------------------------------------------------------------
message: 1
date: Mon, 10 Jun 2013 14:49:00 -0700 (PDT)
from: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
subject: All printers and their IP Addresses
HI I was asked if I can product a Crystal Report which will list all of the printers on the AS400 and their IP addresses.
Perhaps it is fine to do this on the AS/400 but I think they want in Crystal for reporting reasons.
I am thinking there must be a command that will list all the printers but will it also have the IP Addre.
THen, if so,? I can move this file to the IFS.
------------------------------
message: 2
date: Mon, 10 Jun 2013 16:13:46 -0600
from: Alan Campin <alan0307d@xxxxxxxxx>
subject: Re: All printers and their IP Addresses
You are getting pretty sophisticated here. The basics are the same as
everything else. Write a stored procedure and have it build the list and
return the list as a result set and have Crystal produce it.
The problem is that you have to use system API's to get the information and
that requires some pretty detailed programming knowledge and knowledge of
system api's. Not for the faint of heart.
On Mon, Jun 10, 2013 at 3:49 PM, Crystal Reports <
crystalcleardecisions@xxxxxxxxx> wrote:
HI I was asked if I can product a Crystal Report which will list all of
the printers on the AS400 and their IP addresses.
Perhaps it is fine to do this on the AS/400 but I think they want in
Crystal for reporting reasons.
I am thinking there must be a command that will list all the printers but
will it also have the IP Addre.
THen, if so, I can move this file to the IFS.
--
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.
------------------------------
message: 3
date: Mon, 10 Jun 2013 18:34:47 -0400
from: Jack Kingsley <iseriesflorida@xxxxxxxxx>
subject: Re: All printers and their IP Addresses
Look for a tool called wrkrmtwtr, I believe it supports outfile. Here is a
link to it.
http://www.code400.com/forum/showthread.php/2103-WRKRMTWTR-work-remote-writers
On Mon, Jun 10, 2013 at 6:13 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
You are getting pretty sophisticated here. The basics are the same as
everything else. Write a stored procedure and have it build the list and
return the list as a result set and have Crystal produce it.
The problem is that you have to use system API's to get the information and
that requires some pretty detailed programming knowledge and knowledge of
system api's. Not for the faint of heart.
On Mon, Jun 10, 2013 at 3:49 PM, Crystal Reports <
crystalcleardecisions@xxxxxxxxx> wrote:
HI I was asked if I can product a Crystal Report which will list all of
the printers on the AS400 and their IP addresses.
Perhaps it is fine to do this on the AS/400 but I think they want in
Crystal for reporting reasons.
I am thinking there must be a command that will list all the printers but
will it also have the IP Addre.
THen, if so, I can move this file to the IFS.
--
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.
------------------------------
message: 4
date: Tue, 11 Jun 2013 01:09:04 +0200
from: "Leif Guldbrand" <Guldbrand@xxxxxxxxxxx>
subject: Re: QCTL - restricted state
Well - it's ok with me :-)
Leif
----- Original Message -----
From: "Alan Campin" <alan0307d@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Monday, June 10, 2013 11:14 PM
Subject: Re: QCTL - restricted state
My solution was to build a startup program tied to a CONSOLEMON user
profile. When you signed on, it just sat and waited for messages to
arrives
from a data queue. I built a database of commands to execute and put the
commands into the job scheduler. The job scheduler would call a command
that would send the message at the correct time and the process would
start. Everything was created at highest authority so no one but the sec
officer or that user profile could make changes. When it was done running
the command it would wait for the next one or do a shutdown and restart if
requested.
This is how we did all the full system backup without an operator.
I still have the source code if you are interested. What I should do is
put
it up on www.think400.dk.
------------------------------
message: 5
date: Mon, 10 Jun 2013 19:47:06 -0400
from: Sam_L <lennon_s_j@xxxxxxxxxxx>
subject: DLTUSRPRF Fails
I had a profile I could not delete today, no matter what I tried. No
object, no locks.
There was thread on this back in June, 2007 and the resolution was to use
DLTUSRPRF USRPRF(xxx) OWNOBJOPT(*CHGOWN yyy)
Yep, it works. But the new owner (yyy) did not inherit any objects. I
guess I will see what happens if we ever need to delete yyy.
Sam
------------------------------
message: 6
date: Tue, 11 Jun 2013 00:56:14 +0000
from: Mike Cunningham <mike.cunningham@xxxxxxx>
subject: RE: All printers and their IP Addresses
Is it critical to get up to the second info on printers? Does the list change very often? Maybe you could split the process and have a job that runs nightly and uses the APIs to pull printer info and writes to a database table. They just point the Crystal report to the database table
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Crystal Reports
Sent: Monday, June 10, 2013 5:49 PM
To: midrange-l@xxxxxxxxxxxx
Subject: All printers and their IP Addresses
HI I was asked if I can product a Crystal Report which will list all of the printers on the AS400 and their IP addresses.
Perhaps it is fine to do this on the AS/400 but I think they want in Crystal for reporting reasons.
I am thinking there must be a command that will list all the printers but will it also have the IP Addre.
THen, if so,? I can move this file to the IFS.
--
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.
------------------------------
message: 7
date: Mon, 10 Jun 2013 20:46:02 -0600
from: "Troy Hyde" <troy.hyde@xxxxxxxxxxx>
subject: Disaster Recovery / Remote Journaling / HA et al
Hey all,
It appears that I may soon be receiving an assignment to begin developing a
home grown disaster recovery system to offer to our clients.
We have a couple of hundred clients around the country that all have their
own servers running V5R3 through V6R1. The recovery plan of most of our
clients is a nightly backup of the data that is transmitted visa secure FTP
to our backup servers. If a disaster occurs, we provide a new server loaded
with their most recent data and program libraries.
Although this has the obvious advantage of being a relatively inexpensive
solution, the data is only as current as the most recent completed backup.
For many of our clients this is sufficient. They are small institutions with
not a large amount of data and a relatively small number of transactions.
However, many are desiring a more robust solution. They (like everyone)
want to minimize data loss and downtime.
I've read a lot of the archives that discuss disaster recovery and high
availability. It seems most of the discussion revolves around support of
Mimix and other like solutions.
At this point my query boils down to this: I'm leaning toward developing a
solution utilizing remote journaling but I don't have a lot of experience
with journals at al let alone remote journaling. Does anyone have any
suggestions as to redbooks, articles, books or training that can get a
couple of my team members up to speed on journaling and other disaster
recover options?
Of course, if anyone feels like I'm heading in the wrong direction, I'd love
to hear that as well. My ego can handle whatever criticisms and direction
anyone is willing to offer.
Thanks,
T
------------------------------
message: 8
date: Mon, 10 Jun 2013 22:55:44 -0400
from: DrFranken <midrange@xxxxxxxxxxxx>
subject: Re: Disaster Recovery / Remote Journaling / HA et al
Likely the correct direction. Remote receivers from your customers to
the same machine that they FTP the backups to. The "Short Course" is
you restore the FTP'd backups and then apply the journals to that
backup, Shazaaam you're current. That is, the sum of the two is a
restore up the most recent journal entry. Note that this is for data
only. You must also handle program changes, password updates, new users,
file creations, device creation or changes, File modifications, system
value changes and other objects as well. Its all about how close to
'right this second' does your recovery have to be. You know the
customers and clearly the applications better than we possibly could so
you may be able to say there will be no program changes for example, we
have to consider those. You may be able to write your own journal apply
program (non-trivial) or leverage one of the commercial products out
there uch as iTera, Mimix, etc.
- Larry "DrFranken" Bolhuis
www.frankeni.com
www.iDevCloud.com
www.iInTheCloud.com
On 6/10/2013 10:46 PM, Troy Hyde wrote:
Hey all,
It appears that I may soon be receiving an assignment to begin developing a
home grown disaster recovery system to offer to our clients.
We have a couple of hundred clients around the country that all have their
own servers running V5R3 through V6R1. The recovery plan of most of our
clients is a nightly backup of the data that is transmitted visa secure FTP
to our backup servers. If a disaster occurs, we provide a new server loaded
with their most recent data and program libraries.
Although this has the obvious advantage of being a relatively inexpensive
solution, the data is only as current as the most recent completed backup.
For many of our clients this is sufficient. They are small institutions with
not a large amount of data and a relatively small number of transactions.
However, many are desiring a more robust solution. They (like everyone)
want to minimize data loss and downtime.
I've read a lot of the archives that discuss disaster recovery and high
availability. It seems most of the discussion revolves around support of
Mimix and other like solutions.
At this point my query boils down to this: I'm leaning toward developing a
solution utilizing remote journaling but I don't have a lot of experience
with journals at al let alone remote journaling. Does anyone have any
suggestions as to redbooks, articles, books or training that can get a
couple of my team members up to speed on journaling and other disaster
recover options?
Of course, if anyone feels like I'm heading in the wrong direction, I'd love
to hear that as well. My ego can handle whatever criticisms and direction
anyone is willing to offer.
Thanks,
T
------------------------------
message: 9
date: Mon, 10 Jun 2013 21:22:02 -0700 (PDT)
from: Mike Krebs <majkrebs@xxxxxxxxx>
subject: Re: list of open descriptors
One more. The document from IBM to find the open descriptors is here:
http://www-912.ibm.com/s_dir/slkbase.NSF/DocNumber/632818677
------------------------------
midrange.com
