Start of change

+20002   THE specification-source SPECIFICATION IS IGNORED FOR OBJECT object-name

Explanation

An SQL statement includes a specification that was ignored.

specification-source
The source of the specification, either a clause or a bind option.
GBPCACHE clause
The GBPCACHE clause conflicts with the group buffer pool specification GBPCACHE(NO). When the group buffer pool attribute is set to GBPCACHE(NO), the clause can contain only GBPCACHE NONE. The clause is part of one of the following statements:
  • CREATE INDEX
  • ALTER INDEX
  • CREATE TABLESPACE
  • ALTER TABLESPACE
PADDED or NOT PADDED clause
The statement identifies an index that does not have any varying-length character or graphic columns in the index key. The PADDED and NOT PADDED attributes do not apply in this case. The clause is part of one of the following statements:
  • CREATE INDEX
  • ALTER INDEX
USE CURRENTLY COMMITTED clause
The SELECT statement identifies a table that does not support multiple XML versions. The USE CURRENTLY COMMITTED clause requires that the table support multiple XML versions.
ACCESSCONCURRENTRESOLUTION(UseCurrentlyCommitted) bind option
The SELECT statements that are bound in this package identify one or more tables that do not support multiple XML versions. This bind option requires that the tables support multiple XML versions.
object-name
The name of the object.

System action

The statement is processed, but the clause is ignored.

User response

No action is required.
GBPCACHE clause
To use other GBPCACHE options (ALL, CHANGED, or SYSTEM), alter the table space or index to use a group buffer pool that is defined with GBPCACHE(YES).
PADDED or NOT PADDED clause
To prevent future instances of this message, remove the clause from the statement.
USE CURRENTLY COMMITTED clause
To prevent future instances of this message:
  • Avoid using the USE CURRENTLY COMMITTED clause to access non-versioned XML.
  • Convert the table to a table that supports multiple XML versions.
ACCESSCONCURRENTRESOLUTION(UseCurrentlyCommitted)
To prevent future instances of this message:
  • Avoid using this bind option for a plan or package that will access non-versioned XML.
  • Convert the table to a table that supports multiple XML versions.

SQLSTATE

01624

End of change