Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  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 +20002
THE GBPCACHE SPECIFICATION IS IGNORED, bpname DOESNOTALLOW CACHING

Causa
This message is issued in response to a CREATE or ALTER of a table space or index is which a buffer pool is named that corresponds to a group buffer pool that is defined with GBPCACHE NO. The corresponding group buffer pool is used only for cross-invalidation. It contains no data entries. All reads and writes are from and to DASD.

Ação do sistema
O comando é processado.

Resposta ao Desenvolvedor
If you want to use one of the GBPCACHE options other than NONE, you must alter the table space or index to use a group buffer pool that is defined with GBPCACHE YES.

SQLSTATE: 01624