Browse Prior Art Database

Utility RAS and Error Handling

IP.com Disclosure Number: IPCOM000034909D
Original Publication Date: 1989-May-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 1 page(s) / 13K

Publishing Venue

IBM

Related People

Buquoi, GH: AUTHOR [+4]

Abstract

A method is described which consistently returns diagnostic and error information to the user. The Database Manager Utilities issue many OS/2 function calls, SQL statements, and call many other Database functions such as 'Start Using Database'. Each of these functions return error information specific to their function. For example, the OS/2 functions calls do not return information consistent with a 'Start Using Database' call. The Utilities do not want to simply 'pass through' return codes from other functions directly back to the user. This could confuse the user and make determining the solution to the error more difficult. For example, the Backup Utility issues a 'Start Using Database' call internally. The user has no knowledge of this. The 'Start Using Database' fails and Backup returns the error directly to the user.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 1 of 1

Utility RAS and Error Handling

A method is described which consistently returns diagnostic and error information to the user. The Database Manager Utilities issue many OS/2 function calls, SQL statements, and call many other Database functions such as 'Start Using Database'. Each of these functions return error information specific to their function. For example, the OS/2 functions calls do not return information consistent with a 'Start Using Database' call. The Utilities do not want to simply 'pass through' return codes from other functions directly back to the user. This could confuse the user and make determining the solution to the error more difficult. For example, the Backup Utility issues a 'Start Using Database' call internally. The user has no knowledge of this. The 'Start Using Database' fails and Backup returns the error directly to the user. The user, not knowing the context in which the error occurred, may not know how to fix the problem. In the event of severe system problems, a way is needed to return to the application as much information as possible about an error so that customer support personnel can aid a user in determining the source of the problem and a solution. The user is required to pass into each of the Utilities an SQLCA data structure, which will contain return code information about the utility. This method extends the use of the SQLCA database structure to provide additional information for OS/2 system errors, SQL errors, and Database Environment errors. Return codes from OS/2 function calls are positive. The Database Manager always returns negative return codes for errors. The Utility returns a single negative return code indicating 'SYSTEM ERROR' to the user in the SQLCODE field of the SQLCA database structure. The Utility stores the return code that it receives from the OS/2 call in the first element of the SQLERRD array (part of the SQLCA data structure). It also stores in this field an indicator of...