IBM i Global

IBM i Global

Connect, learn, share, and engage with IBM Power.

 View Only

IWS Migration Considerations

  • 1.  IWS Migration Considerations

    Posted Thu October 03, 2024 09:05 AM

    My team is looking to Migrate our SPs in IBM i by exposing them in IWS

    • Pure SQL SPs
    • SPs that calls an external RPG program

    I just want to consult your inputs for possible known information base on your experience, an article, or documentation you might be aware of:

    1. Is there a way to debug the RPG PGM exposed as a REST Service as it is being invoked/requested from a client?
    2. I noticed that the first Service Call is always slow 

      eg., For a sequential 3 calls to CustSegmentExtract Service

      1st: 111ms

      2nd:  45ms

      3rd:  43ms

      Is there a way to control and this so that the timing of the first call is almost similar to the succeeding calls ?
    3. From the documentations, I see 2 options in deploying - from the web admin console and from the command line shell script. In terms of automating Service deployment, it looks like the command line shell script is the way to go. Is there any other alternatives to these QSH Shell scripts? I am currently struggling in making the shell scripts work at the moment.
    4. Is there any way on the server side to time the running of one Service processing? Say, configuration to enable more information (that might include the timing of each Service processing) on the logs?
    5. Is my observation correct that RPG as a Rest Service does not Support ResultSet? and the Only way for a Getter SQLRPGLE program with resultset to be exposed as SP and then as a Rest Service?


    ------------------------------
    Del Abalos
    pasay city AL
    63-906-246-7417
    ------------------------------