SQL - SQLCODE's - Códigos negativos -497


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 -497

   
 
  • Causa
    • THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE database-name.

      The SQL statement cannot be executed because an internal identifier limit has been exceeded for the database.
      The cause of this error is due to one of the following:
      (1) On a CREATE DATABASE statement, the limit of 65279 DBIDs has been exceeded.
      (2) For all other statements, the limit of 65279 OBIDs has been exceeded for that database.
  • Ação do sistema
    • The SQL statement cannot be executed.
  • Resposta ao Desenvolvedor
    • (1) In the case of a DBID limit being exceeded, DROP all unused databases and issue a COMMIT.
      (2) In the case of an OBID limit being exceeded, DROP all unused objects in the database and issue a COMMIT, specify a different database or run the MODIFY utility to reclaim unused OBIDs.

      SQLSTATE: 54041

© Copyright IBM Corp.