db2rbind may cause applications return SQL error -518 or -514
db2scope 310002R9XW Comment (1) Visits (158)
It is recommended to run db2rbind during maintenance time when there is no application connecting to the database.
In case there are applications running while db2rbind is running, you may see the following symptom depending on the timing:
- db2rbind returns lock timeout and fails to bind some packages
- applications may return SQL error -518 (SQL0518N)
- applications may return SQL error -514 (SQL0514N)
The following is an example of application receives error SQLCODE=-518:
Db2 returns SQLCODE -518 as db2rbind has rebound the packages, which corresponds with 3rd condition in the explanation of
the SQL code.
SQL0518N The statement named in the EXECUTE statement is not in a prepared state or is a SELECT or VALUES statement.
The application program tried to EXECUTE a statement that