By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 1 &nbspReply

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

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

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy