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

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 -4701
   
 
  • Causa
    • THE NUMBER OF PARTITIONS, OR THE COMBINATION OF THE NUMBER OF TABLE SPACE PARTITIONS AND THE CORRESPONDING LENGTH OF THE PARTITIONING LIMIT KEY EXCEEDS THE SYSTEM LIMIT;
      OR THE COMBINATION OF THE NUMBER OF TABLE SPACE PARTITIONS EXCEEDS THE MAXPARTITIONS FOR PARTITION BY GROWTH TABLE SPACE.

      The intended operation would exceed permitted limits.

      • If an ALTER TABLE or CREATE INDEX statement was used to change or create limit keys, the length of the partitioning limit key exceeds the allowed maximum.
      • If an ALTER TABLE statement was used to add partitions, the maximum number of partitions already exist.
      • If an ALTER TABLE statement was used to add partitions to the table space, the total number of table space partitions exceeded the number of partitions that are specified on the MAXPARTITIONS clause for partition-by-growth table spaces.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Correct the problem and reissue the statement.
      Adding or changing limit keys
      Decrease the size of limit key or the number of table space partitions to satisfy the constraint.
      Adding partitions
      For non-large table spaces, the limit is 8, 16, 32, or 64, depending on the initial definition.
      For large table spaces, see the information about limits in Db2® for z/OS®.
      Adding partitions to a partition-by-growth table space
      Increase the number of table space partitions by increasing the value of MAXPARTITIONS to satisfy the constraint.
    SQLSTATE: 54054
© Copyright IBM Corp.