logo  
Google
 

DB2 SQL-Error: -670

SQLState: 53041

Short Description: C ONLY A K PAGE BUFFERPOOL CAN BE USED FOR AN INDEX

A buffer pool having a page size other than 4KB was specified in the CREATE INDEX statement. Only 4KB buffer pools (that is, BP0, BP1, and BP2) can be specified for indexes. System action: The statement cannot be executed. The specified index was not created. Programmer response: Correct the statement to specify a 4KB buffer pool. Refer to Chapter 5 of DB2 SQL Reference for information about the syntax of SQL statements.

 <-  BACK TO INDEX