Histórico da Página

...

• Criando BUFFER POOL

  Bloco de código
  CREATE BUFFERPOOL namebuffer SIZE AUTOMATIC PAGESIZE 8192;

  onde namebuffer é o nome do BUFFER POOL.

• Criando TABLESPACE

  Bloco de código
  CREATE REGULAR TABLESPACE namedata PAGESIZE 8K MANAGED BY DATABASE USING ( FILE 'C:\DB2DATA\DBACCESS_DATA.DAT' 256000 ) BUFFERPOOL namebuffer; CREATE USER TEMPORARY TABLESPACE nametemp PAGESIZE 8K MANAGED BY DATABASE USING ( FILE 'C:\DB2DATA\DBACCESS_TEMP.DAT' 256000 ) BUFFERPOOL namebuffer;

  onde namedata é o nome do REGULAR TABLESPACE, nametemp é o nome do USER TEMPORY TABLESPACE e namebuffer é o nome do BUFFER POOL  -- Utilize o mesmo criado no script de criação do BUFFER POOL .

Links de

...

Referência

• CREATE SCHEMA statement - https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000925.htm

• GRANT statement - https://www.ibm.com/support/knowledgecenter/SSCRJT_5.0.0/com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0000958.html

• CREATE BUFFERPOOL statement - https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000912.html

• CREATE TABLESPACE statement - https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000929.html