Can DBMON be used to find if Logical files need to be created after monitoring performance of RPG programs
Can DBMON be used to find if Logical files need to be created after monitoring performance of RPG programs.
Also need to know exact steps to be taken inorder to use DBMON ie starting dbmon on a program to be monitored and viewing of logical file creation recommendations
Software/Hardware used:
as400, v6r1, rpg programming, dbmon.
Also need to know exact steps to be taken inorder to use DBMON ie starting dbmon on a program to be monitored and viewing of logical file creation recommendations
Software/Hardware used:
as400, v6r1, rpg programming, dbmon.
ASKED:
July 18, 2011 10:43 AM
UPDATED:
March 31, 2012 9:09 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Can DBMON be used to find if Logical files need to be created after monitoring performance of RPG programs.
Yes. The database monitor table can include indication of whether indexes were advised and what key columns were advised. For a general idea of what may be found in the table, use DSPFFD to look at the columns in file QAQQDBMN in library QSYS.
Also need to know exact steps to be taken inorder to use DBMON ie starting dbmon on a program to be monitored and viewing of logical file creation recommendations
There aren’t exact steps. There are general steps.
Run the STRDBMON command to start the monitor. Then run the query or queries that you want information about. Run ENDDBMON to end the monitor.
The table that you created with the STRDBMON command can then be queried to see results. See the Monitoring your queries using Start Database Monitor topic in the Information Center for some details.
Use the documentation to learn steps. Ask questions here when you run into obstacles.
Tom