Converting a command to a Database File

135 pts.
Tags:
AS/400 LPAR
Converting Commands
Database Files
LPAR
LPAR Configuration
OS/400 V5R4M5
I was wondering if someone can offer some code or a site that would show some code examples of what I am trying to do on my LPARs. I’ve created a DB file using command CVTWRKSBS so I could create an IBM query over it to see what subsystems are active on the LPAR. However, I want this done on all my LPARs then e-mail the listing to a group or an individual. Is there a way I can poll each LPAR in the network with the job getting submitted from one LPAR and executing that command to all LPARs, then create a single listing rather than separate listings on each LPAR? Also, does the CVT command exist for NETSTAT and WRKSBSJOB commands so I can do the same thing with the listing?

Software/Hardware used:
V5R4M5 System i 570

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Also, does the CVT command exist for... That's a tricky question. We have no way of knowing what commands exist on your system. We already know that you use custom commands since CVTWRKSBS isn't standard. If you want a command that takes NETSTAT or WRKSBSJOB results and populates files with them, you can always write them. That's what someone did for CVTWRKSBS, though its name implies that it might not have been done appropriately. Tom
    125,585 pointsBadges:
    report
  • wpoulin
    Rrbond07, The first thing that comes to my mind is possibly using either the Run Remote Command, RUNRMTCMD, or Submit Remote Command, SBMRMTCMD. Either of these commands would allow you to execute a command on your target LPAR(s). If the file you are updating is a DDM file, that data could actually reside on your source LPAR. Hope this helps, Bill Poulin
    2,480 pointsBadges:
    report
  • Rrbond07
    Thanks Tom and Bill. Yes, the CVTWRKSBS command is a TAA Tool. There is also the CVTUSRJOB that I think I can pull information that I wanted. It just depends on how much code the client will allow me to put on their LPARs.
    135 pointsBadges:
    report
  • TomLiotta
    In general, the system APIs that support retrieving lists of active subsystems, network connections and subsystem jobs don't output to files. They output to user spaces. But looping through the entries in a 'list' user space is done pretty much the same way for each such list; so once you've done one, nearly all others follow the same formula. If there are no custom commands that handle NETSTAT, then code will most likely need to be written no matter what. What exactly does the customer need that can't be viewed through iSeries Navigator already? Tom
    125,585 pointsBadges:
    report
  • Rrbond07
    Well Tom, let me put it this way. I have some operators that do manual system checking throughout their shifts. They currently utiliize commands NETSTAT *CNN, WRKSBSJOB QSYSWRK, WRKSBSJOB QSPL, and WRKSBS on the production LPARS checking to make sure certain jobs/subsystems are running or certain writers are up. Management would like to add additional automation by running these commands-scheduling them as jobs on Help Systems' Scheduler and sending an e-mail to the group(s) showing the result. Takes just as much work as opening an e-mail I know, but management would like to see what I can come up with. It's just more busy work.
    135 pointsBadges:
    report
  • Yorkshireman
    So, You are not really wanting to extract this information - you are wanting to monitor that a given activity is happening? Why not write something to do just that? For management, have it email 'someone' whenever it gets a result - could be that it alerts the operator by email, break message or text message (SMS) if there is something that it needs you to know about (copy to managers too) If it runs from a configuration file of 'stuff to watch for, then it can sit in a sleep loop, wake up, check what's active against its list , and send out suitable info. Crikey - that sounds useful - Wonder if our guys would like one - care to post the code?? :- )
    5,580 pointsBadges:
    report
  • wpoulin
    Rrbond07, Now that we're getting a better picture of what you are trying to accomplish, have you looked at Management Central and its Message Monitoring or possibly using some of the Watch command capabilities ? Just some thoughts as I'm reading thru the discussions. Hope it helps, Bill Poulin
    2,480 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following