Physical Reads and Logical Reads

On the DSPFD listing, what is the difference between Physical Reads and Logical Reads?

I need to count how may times the file has been accessed. There are no logicals over this file and the file is always accessed by the key on the physical.

Logical Reads is the number of Logical I/O requests made by DB2 for the physical file (or table). Physical Reads is the actual number of Physical I/O operations performed to satisfy the Logical I/O requests. DB2 might have done a logical I/O request, but there's no physical I/O operation performed because that part of the file was already in memory.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on iSeries SQL commands and statements

read-only memory (ROM) Read-only memory, or ROM, is a type of computer storage containing non-volatile, permanent data that, normally, can only be read, not written to.

read-only Read-only is a file attribute which only allows a user to view a file, restricting any writing to the file.

How to read a STATSPACK report Part of our "How do I do that in Oracle?" series, this tip explains in detail how to read and understand a STATSPACK report.

Granting read and write and read-only access I am using Oracle (9i) Client and I have created a database. I want to create users and give read and write access to the contents in the database for myself but only read access to other users. How could I do this?

Reading between the HIPAA guidelines HIPAA legislation explains 'what' needs to be done to achieve compliance; but it fails to spell out 'how'. Learn 'how' to stay HIPAA compliant when sending work overseas.

Too many buffer reads What is the root cause of high buffer gets if there is no table full scan?

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Physical Reads and Logical Reads

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Kent Milligan

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Microsoft quantum development turns toward hardware

Top 5 options for Linux certifications

New hardware, use cases shape server benchmarking needs

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.