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


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

   
 
  • Causa
    • O bufferpool bp-name não pôde ser especificado porque não havia sido ativado.

      The buffer pool specified in a CREATE or ALTER statement for a table space or index (index space) is not activated.

      Table spaces and indexes (index spaces) can only be assigned or reassigned to buffer pools that are currently activated.
  • Ação do sistema
    • The statement cannot be executed.
      The specified table space or index space was not created or altered.
  • Resposta ao Desenvolvedor
    • Verify that the proper buffer pool was specified in the CREATE or ALTER statement.
      Use the -DISPLAY BUFFERPOOL command to display the attributes of the buffer pool and determine if the buffer pool is activated.
      If the buffer pool is not activated, use the -ALTER BUFFERPOOL command to change the VPSIZE from 0 to the desired size.

      SQLSTATE: 57003

© Copyright IBM Corp.