This section contains writeups of common Adaptive Server Enterprise Disk Manager errors.
20
I/O error detected on disk buffer 0x%X for page request %ld, dbid %d.
When you issue dbcc commands such as dbcc checkalloc or dbcc checkdb, Adaptive Server reads a specified number of pages from disk into disk buffers so that consistency checks can be carried out on the pages. Error 9004 is raised when the server attempts a synchronous disk read during dbcc processing, but the request fails with an I/O error.
Check the server error log for similar errors from other operations, such as an 823 error when running a query ("I/O error detected during %S_MSG for %S_BUF.") or sddone errors ("sddone:write error on virtual disk %d"). Refer to the writeups for those errors elsewhere in this manual for more information. Since Adaptive Server reports 9004 and similar errors when its I/O operation gets an unsuccessful return value, these errors can be an early warning of disk problems.
Check your disks as follows:
Note the database ID shown in the 9004 message text.
Identify the affected device(s) using the steps shown in “How to Determine Which Physical Devices a Database is On” in Chapter 2.
Examine the availability and condition of the device(s) using your standard operating system procedures.
See “Checking the Operating System Error Log” in Chapter 2 if you need assistance in locating the system log.
All versions
