java stored procedure document debugging info question

Background info: System i V6R1 server, using Java stored procedures
Problem description: In a general java stored procedure I developed, I
eventually generate an SQL query statment, run it on the server, generate
a result set and return it. In order to get the information for debugging
purpose, I created a logging table under a particular schema in the V6R1
server. When the SQL query is generated, I insert this information
together with other relevant information into that logging table. So if
this stored procedure does not run, I can debug it using the logging
table.

My question is, if multiple users login our system, and implicitly use
this stored procedure at the same time (or as a sequential way), how does
the operation of inserting the the query info into the logging table
affect the overall performance of the application? Will it become a
bottleneck as multiple jobs may need to wait to write to the logging
table?

If this design is not very good, how to efficiently document the potential
error information?


Thanks for your time reading and answering my question!

Yan