This procedure describes how to create a history environment on an IBM Power Systems (System i, iSeries, AS/400) server running IBM i (OS/400, i5/OS) to retain the Robot Reports 7 report history from another IBM i server. This history environment is designed for accessing report history only—you cannot process reports in this environment.

Disclaimer: HelpSystems does not support the history environment, including any issues in your normal Robot Reports environment that might result from implementing a history environment.

Before You Begin

  • To create a history environment, you must be at the following release/modification level for Robot Reports: R07M32.

  • The person creating the history environment must be signed on with QSECOFR authority.

  • The interface to Robot Save is not supported in the history environment. Verify that your system setup for the history library does not use Robot Save.

  • The library list structure is crucial for the history library. You must use the library names specified in this document.

  • In these instructions, the source system refers to the system containing the history you want to retain; the target system refers to the system where the history will be retained.

    • The IBM i level of the target system must be the same or higher than the level of the source system for the report restorations to work correctly.

    • If you store your archive history on tape or a optical device on the source system, you must have a compatible tape or optical device on the target system.

    • To view reports on the target system, you must have a copy of the RBTSYSLIB library and the Robot Reports library (NEWREPLIB) that you create during the procedure.

On the Source System

Read and review the following instructions completely before starting. Execute all of the commands from a command line.

  1. Execute the following command:

    REPARCHIVE(EXPIRED)

  2. If you use disk for short term storage, execute the following command:

    REPARCHIVE(SHORTTERM)

    Note: Wait for these archives to finish completely.

  3. Enter the following command to rename the RBTREPLIB library to NEWREPLIB:

    RNMOBJ OBJ(RBTREPLIB) OBJTYPE(*LIB) NEWOBJ(NEWREPLIB)

  4. Execute the following command to point the history environment to the short-term library:

    CHGDTAARA DTAARA (NEWREPLIB/REPDFT (97 10)) VALUE(HSTSHTRMLB)

  5. Execute the following command to point the history environment to the long-term library:

    CHGDTAARA DTAARA (NEWREPLIB/REPDFT (349 10)) VALUE(HSTSHTRMLB)

  6. Edit the commands in NEWREPLIB so that their production library is NEWREPLIB instead of RBTREPLIB.

    1. Enter the following command:

      WRKCMD CMD(NEWREPLIB/*ALL)

    2. When the Work with Commands panel displays, enter a 2 next to all of the commands displayed in the list (you may have to page down one or more times).

    3. On the command line, enter the following command:

      PRDLIB(NEWREPLIB)

    4. Press Enter to update all of the commands.

  7. Enter the following commands to list and change the job descriptions whose library lists should use NEWREPLIB instead of RBTREPLIB:

    1. Enter the following command to display the list of job descriptions that need to be changed:

      WRKOBJ OBJ(NEWREPLIB/*ALL) OBJTYPE(*JOBD)

    2. Prompt and execute the following command for each job description listed in step 7a above to change the job description library from RBTREPLIB to NEWREPLIB.

      CHGJOBD JOBD (NEWREPLIB/jobname) INLLIBL (QTEMP QGPL NEWREPLIB)

      where: jobname is a name of a job description from the list displayed in step 7a above.

  8. Execute the following command to create a new library called REPHSTSYS:

    CRTLIB LIB(REPHSTSYS) TEXT ('Robot REPORTS Syslib for History')

  9. Execute the following command to duplicate the data area needed to point to the new history environment.

    CRTDUPOBJ OBJ(RSLDFT) FROMLIB(RBTSYSLIB) OBJTYPE(*DTAARA) TOLIB(REPHSTSYS)

  10. Execute the following command to set the library list properly so that we can modify the copy of the data area to point to your history environment.

    CH SYSLIBL REPHSTSYS

    Important: In your history environment, the REPHSTSYS library must be at the top of the system library list.

  11. Execute the following command to display the Product Libraries panel that you can use to modify Robot Reports information:

    CALL RSL018

  12. On the Product Libraries panel, replace RBTREPLIB with NEWREPLIB in the Reports Pgm Lib and Reports Data Lib fields.

    Important: Do not change anything else on this panel.

  13. Press Enter and F3 to exit.

  14. Execute the following command to rename the REPSHTRMLB library to HSTSHTRMLB:

    RNMOBJ OBJ(REPSHTRMLB) OBJTYPE(*LIB) NEWOBJ(HSTSHTRMLB)

  15. You should have a save file from HelpSystems called REPHSTSAVF. This file contains objects to replace the objects in the NEWREPLIB library.

    Important: Before restoring the new objects, make sure that you have renamed the original objects and saved them in the NEWREPLIB library.

    1. Enter the following command to display the save file that you received from HelpSystems and write down the name of the objects:

      DSPSAVF FILE(yourlibname/REPHSTSAVF)

      where: yourlibnameis the library where you placed the save file from HelpSystems.

    2. For each object in the save file, enter the following command to rename the object. In this example, we rename the program object REP768 as REP768org (for original).

      RNMOBJ OBJ(REP768) OBJTYPE(*PGM) NEWOBJ(REP768ORG)

    3. After you rename the objects, enter the following command to restore the objects in the save file to NEWREPLIB:

      RSTOBJ OBJ(*ALL) SAVLIB(REPFIX7) DEV(*SAVF) SAVF(yourlibname/REPHSTSAVF) RSTLIB(NEWREPLIB)

      where: YOURLIBNAME is the library where you placed the save file from HelpSystems.

  16. Save the NEWREPLIB, REPHSTSYS, and HSTSHTRMLB libraries to save files or tapes. Later, you will restore them on the target system.

On the Target System

Read and review the following instructions completely before starting. Execute all of the commands from a command line.

  1. Restore the three libraries—NEWREPLIB, REPHSTSYS, and HSTSHTRMLB—that you saved on save file(s) or tape(s) from the source system .

  2. Create a simple CL program interface to the history environment to help your users. For this interface, verify that the following conditions are true:

    1. Verify that the REPHSTSYS library is listed ahead of the RBTSYSLIB library in the system library list.

    2. Enter the following command to add the NEWREPLIB library to the user portion of the library list:

      ADDLIBLE NEWREPLIB

    3. Test your interface program and verify that the library RBTREPLIB is replaced by NEWREPLIB in the library list.

  3. Enter the following command to create the HSTLNTRMLB library for restoring reports:

    CRTLIB LIB(HSTLNTRMLB) TEXT ('Robot REPORTS LONGTERM LIBRARY FOR HISTORY')

After You Are Done

After you have set up your history environment, execute the following command at regular intervals on the target system to keep the environment cleaned up. This command submits a job (REPDLTMON) that automatically cleans up the history library (NEWREPLIB) as reports expire:

REPARCHIVE EXPIRED

Notes:

  • If you run other REPARCHIVE options, you will have problems when you try to restore reports.

  • You may notice two REPDLTMON jobs running on your target system. One job is for the history library; the other is for your normal Robot Reports environment.

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: March 08, 2018