Can DBMON be used to find if Logical files need to be created after monitoring performance of RPG programs

1160 pts.
Tags:
IBM iSeries
iSeries V6R1
Logical Files
RPGLE Program
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following