Brian,
You also need to create a new temporary tablespace with a page size of
8k. This is used for sorts, etc.
(Note, you need to keep the current TEMPSPACE1 as well, since your
catalog tablespace will have a 4k pagesize and thus will need a
temporary tablespace with a 4k page size).
Good luck,
Ian Bjorhovde
[EMAIL PROTECTED]
----- Original Message -----
From: "Stewart, Brian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 4:41 PM
Subject: DB2EUG: Tablespace pagesize problems
>
> I have a developer with the following problem:
>
> He tries to create a table with a long row definition and is told by DB2
> that he needs a tablespace with 8K pages. He wants to use the default
> tablespace USERSPACE1. I drop the tablespace andrecreate it with an 8K
> pagesize and assign to it a bufferpool with an 8K pagesize. Now he is able
> to create his table.
>
> Now he tries to create a table with a normal sized row definition in the
> default tablespace from a remote client and DB2 tells him that it cannot
> find a tablespace with a pagesize of "at least" 4K that he has access to
(he
> is connected as the instance owner). He *can* however create the table
> without error when connected to the database from the server side. If he
> uses a 4K tablespace he can create the table from the client side.
>
> Why is it that he can use the default tablespace for both table
definitions
> when connected locally on the server, but cannot create both when
connected
> remotely?
>
> If anybody has any advice, I would be very grateful.
>
> TIA
>
> Brian
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
