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.
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