Database name in ProcedureExecution_YYYYMM.log
Laurie Thompson
Customer
1) What is your idea? Provide the database name for each procedure in the procedure execution log file.
2) What specific problem are you trying to resolve? When the file C:\Board\Dataset\Log\ProcedureExecution_YYYYMM.log is populated we can see only the procedure name but not the name of the database. This is a problem because our application built using Board will be split into 11 different databases all with the same data model (and the same procedure names) as suggested by Board to get acceptable performance for the application. Having 11 databases with the same data models and procedure names means we'll also need to get the name of the specific database for each procedure we need to look at from the log file.
3) What workaround have you found or used? No workaround has been found. We have to look through all 11 databases to see if its procedure executed correctly or not. This is a time-consuming activity.
4) What is your role in the organisation? I am the Programme Manager for my organisation's Data Programme. We are developing data services for paying customers.
2) What specific problem are you trying to resolve? When the file C:\Board\Dataset\Log\ProcedureExecution_YYYYMM.log is populated we can see only the procedure name but not the name of the database. This is a problem because our application built using Board will be split into 11 different databases all with the same data model (and the same procedure names) as suggested by Board to get acceptable performance for the application. Having 11 databases with the same data models and procedure names means we'll also need to get the name of the specific database for each procedure we need to look at from the log file.
3) What workaround have you found or used? No workaround has been found. We have to look through all 11 databases to see if its procedure executed correctly or not. This is a time-consuming activity.
4) What is your role in the organisation? I am the Programme Manager for my organisation's Data Programme. We are developing data services for paying customers.
6