Ansicht
Dokumentation

SQL7917 - Access plan not updated. ( OS/400 )

BAL Application Log Documentation   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL7917
Access plan not updated.

Message Long Text :

Cause . . . . . : The query optimizer rebuilt the access plan for this statement, but the program could not be updated. Another job may be running the program. The program cannot be updated with the new access plan until a job can obtain an exclusive lock on the program. The exclusive lock cannot be obtained if another job is running the program, if the job does not have proper authority to the program, or if the program is currently being saved. The query will still run, but access plan rebuilds will continue to occur until the program is updated.
Recovery . . . : See previous messages from the query optimizer to determine why the access plan has been rebuilt. To ensure that the program gets updated with the new access plan, run the program when no other active jobs are using it.

Message File : QSQLMSG
Library Message File : QSYS2924


General Data in Customer Master   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3206 Date: 20240509 Time: 192639     sap01-206 ( 3 ms )