Troubleshooting
Problem
Executing a Stored Procedure which contains a single SQL statement is significantly slower then executing the same query as a select statement from a command line.
1) execute "db2 -tvf select.sql"
where select.sql contains: select Executing Stored Procedure significantly slower than executing same query from a Command prompt.
Modified date:
swg22002137 where col1 = 12345;
2) execute "db2 call sp1(12354)"
where sp1 Stored Procedure has one input variable and SQL statement
select
where col1 = ?;
Symptom
Log InLog in to view more of this document
Was this topic helpful?
Document Information
01 May 2025
UID