How to Gather Information About Read/Write Errors

The commands to create a procedure called sp_diskblock, which translates a Sybase virtual disk and block number into the corresponding Sybase device, database, and logical page number, are shown below. Use sp_diskblock to gather information about read or write errors that Adaptive Server might encounter. Refer to “Read/Write Error” for more information.

sp_diskblock collects information from the system tables of the Adaptive Server on which it is executed; therefore, you must execute it on the Adaptive Server that has the read/write error.

WARNING! The sp_diskblock stored procedure is provided for your information-it is not supported at this time.