Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.

SQLCode +806
BIND ISOLATION LEVEL RR CONFLICTS WITH TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND LOCKMAX 0

Causa
he specification of isolation level RR is incompatible with the LOCKSIZE PAGE or LOCKSIZE ROW and LOCKMAX 0 specification for a table space accessed by the application. Table space locking is used to protect the integrity of the application.

Ação do sistema
A valid package/plan is created if no errors are detected. Table space locking is used. RR isolation level is preserved.

Resposta ao Desenvolvedor
If you do not want table space locking, use isolation level UR, CS, or RS.

SQLSTATE: 01553