How to increase the max width of page size

[Bastien]

We have a rather large table with approx 200 fields for our application...currently porting from mysql to db2.

How can we increase the page size for the table? We are having problems creating the table.

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[gregsimpson]

Bastien,

go back to where you created the tablespace for the table to sit on. It is there that you defined the pagesize.

Cheers
Greg

 

[Bastien]

When I try to create tablespace, there is a problem with container. It keep saying:

The container "/home/apis1" already exists.

Explanation:

Each table space container must be unique.

User Response:

Specify a file name or directory that does not currently exists on the system.

And at the end when I create the tablespace with 8k bufferpool, it didn't go through and showed me some rules of container. I think that's the place I should focus. BTW, any quick clue to pick up a valid container for a table space?

Thanks,



Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[gregsimpson]

Bastien,

as the message suggest you can't create two tablespaces in exactly the ame place. Create another directory under home and try and define it there.

Cheers
Greg

 

[rbod]

Once a tablespace is created with a particular page size, it canNOT be altered.
Check the page size of all your tablespaces.
>db2 list tablespaces show detail
look for "Page size (bytes)"
The page size can be 4k,8k,16k or 32k.

For the tablespace container information, get the "Tablespace ID" from "list tablespaces show detail" command and then run the following command :
>db2 list tablespace containers for <tblspc_id> show detail

Also, when you try to create a tablespace with a particular pagesize, you need to have a Bufferpool with that particular pagesize already existing.

Adding a container to the tablespace will not help if it is not the right page size. When you are creating a table, specify the tablespace with the right page size.
create table table_name(....) IN TBLSPC_NAME