Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
DB2 Stored procedure logs
This is a discussion on DB2 Stored procedure logs within the DB2 forums, part of the Databases category; Friends and db2 masters! I have one query. I need to record all the errors from db2 stored procedures in a log file. I am not sure whether there is ...
|
|||||||
09-03-2008
|
|||
|
|||
DB2 Stored procedure logs
Friends and db2 masters!
I have one query. I need to record all the errors from db2 stored procedures in a log file. I am not sure whether there is an in-built sp logging facility in db2. ( I understand that error logging in db2 can be found in db2diag.log file . But here, I could find only the database related activities like server startup, execution and shut down logs) My requirement is: I need the following error logs while a sp encounter an error. 1. Error Timestamp 2. Error Description 3. Sp name 4. Table name 4. Sp Operation ( insert/update, delete etc) I appreciate quick help for solving my issue...! 
|
| Sponsored Links |
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Stored Procedure | malathim | Data Warehousing | 4 | 02-18-2008 10:28 AM |
| Reg:Stored Procedure | chakravarthy_info | Data Warehousing | 1 | 02-14-2008 01:07 PM |
| Is possible cursor is using the stored procedure? | srinu.tenali | SQL Server | 1 | 12-31-2007 02:55 AM |
| implementation of stored procedure | sreenivasamurthy | Data Warehousing | 0 | 06-20-2007 09:59 AM |
All times are GMT -4. The time now is 12:27 AM.
