This article describes the steps needed to provide information needed for setting up evolveIT for 2E requirements gathering.
1. Create a save file of the 2E model library.
Model Library (use SAVLIB command and save to V7R3M0 if your system is V7R4M0 or higher).
Normally the model library has mdl at the end of the library name. XYZMDL is a sample.
2. Create a save file of the 2E generation library source files.
Use SAVOBJ command to save only the source files and save to V7R3M0.
Normally the GEN library has GEN at the end of the library name XYZGEN.
3. Create a save file of Source Files that are outside of the model but are used by the Model application. (Optional)
There might be source files not in the 2E generation library that contain program source that is called by 2E generated functions. These source files that are outside of the model need to be included so we have a full path of all called objects.
Use SAVOBJ command to save the file YDSNMNU file. Normally, this is found in the 2E GEN library.
Menu file YDSNMNU (if 2E menus are used). If 2E menus are not used, please request guidance
5. Create a file of the scheduled jobs. (Optional)
If the system has scheduled jobs (using WRKJOBSCDE) we will need the schedule entries. If another scheduling process is used (such as Robot/SCHEDULE) please advise.
For WRKJOBSCH you can run this SQL and create a file with the data.
SELECT DISTINCT SCHEDULED_JOB_NAME, STATUS, COMMAND_STRING
FROM QSYS2.SCHEDULED_JOB_INFO
ORDER BY SCDJOBNAME;
For Advanced Job Scheduler you can use this SQL and create a file with the data.
SELECT DISTINCT CM4JOB, CM4CMDEXT
FROM QUSRIJS/QAIJS4CM
WHERE CM4CMDEXT > ''
Order by CM4JOB;
6. Create a file with the record counts of production files. (Optional)
Record counts for data files in your production library. You can use the SQL below and send the data to a table.
SELECT substr(TABLE_SCHEMA,1,10) as Library,
substr(TABLE_NAME,1,10) as Table, NUMBER_ROWS FROM qsys2/SYSTSTAT
WHERE TABLE_SCHEMA = 'PRODDATALIB'
(where 'PRODDATALIB' is the name of your production data library/)
7. Send all data gathered in the prior steps.
Please send the SQL tables as CSV or EXCEL files zipped.
The save files all need to be saved to V7R3M0 if you are at V7R4M0 or greater.