SQL - SQLCODE's - Códigos positivos - +806


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode +806

   
 
  • Causa
    • BIND ISOLATION LEVEL RR CONFLICTS WITH TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND LOCKMAX 0

      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