Power

 View Only

  • 1.  IBM i Spool file

    Posted Mon October 02, 2023 09:26 AM

    Good morning everyone:

    I need help please.

    We have an IBM P9, and we run JDE World.

    I have a series of spool files in my IBM i, and I need to find which programs generated the reports.

    For example, a user runs the report in JDE from a Menu option. That menu option calls a program that generates the report.

    Thanks

    Carlos Irigoyen



    ------------------------------
    Carlos Irigoyen
    Senior Applications Engineer
    Louisiana Legislator Auditor
    Baton Rouge LA
    9542619893
    ------------------------------


  • 2.  RE: IBM i Spool file

    Posted Tue October 03, 2023 01:57 AM
    Edited by Satid Singkorapoom Tue October 03, 2023 01:59 AM

    Dear Carlos

    A spooled file's attributes contain the job name but not the program name that produces it.   But you can insert a text string in spooled file's "User-specified Data" attribute but this requires program code enhancement and it can be a big deal to do.  

    Do you have a programmer team that maintains the codes?  If so, ask them if they use any application development tool in IBM i that keeps metadata of all objects involved in the entire application development effort?   That tool can give you the answer you are seeking. 

    Another choice you can consider is to use IBM i Audit Journaling which can track all spooling actions   Reading this IBM i Technote : Using Auditing to Track Spooling Activity at  https://www.ibm.com/support/pages/using-auditing-track-spooling-activity , I have a hunch that the journal entry contains the program name that produces the spooled file.  This method is free of charge. You just need to invest your time and effort.



    ------------------------------
    Chance favors only the prepared mind.
    -- Louis Pasteur
    ------------------------------
    Satid S.
    ------------------------------

    Original Message


  • 3.  RE: IBM i Spool file

    Posted Tue October 03, 2023 09:43 AM

    Thank you so much Satid.

    I will do the Journeying

    Best

    Carlos




      Better Information, Better Louisiana!
      Carlos Irigoyen
      Senior Applications Developer
      Louisiana Legislative Auditor
      P.O. Box 94397
      Baton Rouge, LA 70804-9397
      Phone: 225-339-3863

    This email message, including any attachments, is for the sole use of the intended recipient. This email may contain confidential and privileged information. If you are not the intended recipient or you think you have received this email in error, please contact the sender by reply email.





    "Satid Singkorapoom via IBM TechXchange Community" ---10/03/2023 12:59:26 AM---Dear Carlos A spooled file's attributes contain the job name but not the program name that produ




    Original Message


  • 4.  RE: IBM i Spool file

    Posted Tue October 03, 2023 02:17 AM
    Edited by Satid Singkorapoom Tue October 03, 2023 02:28 AM

    I try this command from the Technote   DSPJRN JRN(QAUDJRN) RCVRNG(*CURCHAIN) FROMTIME('02/10/2023' '08:00:00') RNCDE(*ALL) ENTTYP(SF) JOB(*ALL) OUTPUT(*PRINT)   and I can see the program name as shown below. 

    You can save the OUTPUT to an *OUTFILE instead and make a simple query to the resulting output file - look for TYPE = 'C' (= spooled file is created)

    ------------------------------
    Chance favors only the prepared mind.
    -- Louis Pasteur
    ------------------------------
    Satid S.
    ------------------------------

    Original Message


  • 5.  RE: IBM i Spool file

    Posted Tue October 03, 2023 09:43 AM

    Thank you!!!




      Better Information, Better Louisiana!
      Carlos Irigoyen
      Senior Applications Developer
      Louisiana Legislative Auditor
      P.O. Box 94397
      Baton Rouge, LA 70804-9397
      Phone: 225-339-3863

    This email message, including any attachments, is for the sole use of the intended recipient. This email may contain confidential and privileged information. If you are not the intended recipient or you think you have received this email in error, please contact the sender by reply email.





    "Satid Singkorapoom via IBM TechXchange Community" ---10/03/2023 01:19:18 AM---I try this command from the Technote   DSPJRN JRN(QAUDJRN) RCVRNG(*CURCHAIN) FROMTIME('02/1




    Original Message


  • 6.  RE: IBM i Spool file

    Posted Tue October 03, 2023 12:31 PM

    See also:

    https://www.ibm.com/docs/en/i/7.5?topic=services-display-journal-table-function



    ------------------------------
    Robert Berendt IBMChampion
    ------------------------------

    Original Message


  • 7.  RE: IBM i Spool file

    Posted Tue October 03, 2023 12:55 PM

    Hi Robert:

    Thank you so !!!

    Best

    Carlos




      Better Information, Better Louisiana!
      Carlos Irigoyen
      Senior Applications Developer
      Louisiana Legislative Auditor
      P.O. Box 94397
      Baton Rouge, LA 70804-9397
      Phone: 225-339-3863

    This email message, including any attachments, is for the sole use of the intended recipient. This email may contain confidential and privileged information. If you are not the intended recipient or you think you have received this email in error, please contact the sender by reply email.





    "Robert Berendt via IBM TechXchange Community" ---10/03/2023 11:34:14 AM---See also: www.ibm.com/docs/en/i/... ------------------------------ Robert Berendt IBMChampion ------




    Original Message