-1

Product: IBM DB2

OS: Windows 2008 R2

I am trying to perform SQL replication on my database, I have created the capture tables, while I am trying to register the tables I got the following error message

[IBM][CLI Driver][DB2/NT64] SQL0289N Unable to allocate new pages in table space "xxxxxxx". SQLSTATE=57011"

Thanks In advance.

Fares M.
  • 1,538
  • 1
  • 17
  • 18
Mian Awais
  • 9
  • 9
  • 1
    Not sure what your question is, but "unable to allocate new pages" means either there's no space on disk to extend the tablespace or the tablespace is full and autoextend is turned off. – mustaccio Apr 01 '17 at 23:31

1 Answers1

0

I suggest you to check the extent size of your tablespace. Run the following command SELECT TBSPACE, OWNER, EXTENTSIZE FROM SYSCAT.TABLESPACES This will give details of EXTENTSIZE of TABLESPACE. You may need to change the extent size depending on your requirements.

An extent is a block of storage within a table space container. It represents the number of pages of data that will be written to a container before writing to the next container. When you create a table space, you can choose the extent size based on your requirements for performance and storage management. See more details here

fabfas
  • 2,200
  • 1
  • 21
  • 21