So create two new tablespaces 1 with a pagesize of 8192 and 1 with a
pagesize of 16384 and grant access to public for them and
even better define those tables in the correct size tablespace.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Harish Reddy V.
"
<db2udbdba-ezmlms To
hield-x56509203.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

12/29/2004 02:26 Subject
AM Requried soluriont --- Very
urgent----Error when migrating from
Oracle 9i to DB2 UDB V8.1










Hi,

We are in the process of migrating tables from Oracle 9i to DB2 using IBM
Migration toolkit. We were able to migrate the 102 tables directly where as
with other 15 tables we are facing the problem as described below .Please
find the error script below.

CREATE TABLE BSS_AI_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE VARCHAR(10),
BRAND VARCHAR(4000), BUDGET DECIMAL(14,6), TONNAGE DECIMAL(12,6), CATEGORY
VARCHAR(4000), BRAND_CODES VARCHAR(4000), ALLOCATED_TO_AREAS VARCHAR(1)
DEFAULT 'B', CAT_CODE VARCHAR(4000), DISCOUNT DECIMAL(10,2) )DB21034E The
command was processed as an SQL statement because it was not a valid
Command Line Processor command. During SQL processing it returned:SQL0286N
A default table space could not be found with a page size of at least
"16384" that authorization ID "SOL2USER" is authorized to use.
SQLSTATE=42727

CREATE TABLE BSS_ADD_WRITEBACK_BDG( CHG_ALLOC_REQ_NO INTEGER NOT NULL,
OPS_PLAN_NO FLOAT NOT NULL, ACT_CODE VARCHAR(10) NOT NULL, CURR_STAGE
SMALLINT DEFAULT 1, CURR_SUB_STAGE SMALLINT DEFAULT 1, CHG_REQ_STATUS
VARCHAR(1) DEFAULT 'P', AUTO_MANUAL VARCHAR(1), APPR_ROLE INTEGER,
ADD_OR_WRITEBACK VARCHAR(1), GSM_OR_RSM VARCHAR(1), REASON VARCHAR(2000),
CREATED_BY INTEGER, CREATED_ON DATE, MODIFIED_ON DATE, MODIFIED_BY INTEGER,
REMARKS VARCHAR(2000) )DB21034E The command was processed as an SQL
statement because it was not a valid Command Line Processor command.
During SQL processing it returned:SQL0286N A default table space could not
be found with a page size of at least "8192" that authorization ID
"SOL2USER" is authorized to use. SQLSTATE=42727

CREATE TABLE BSS_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE VARCHAR(10),
BRAND VARCHAR(4000), BRANCH VARCHAR(50), BUDGET DECIMAL(14,6), TONNAGE
DECIMAL(12,6), CATEGORY VARCHAR(4000), SALES_HIER_NO INTEGER,
ALLOCATED_TO_AREAS VARCHAR(1) DEFAULT 'B', BRAND_CODES VARCHAR(4000),
BRANCH_CODE VARCHAR(10), CAT_CODE VARCHAR(4000), DISCOUNT DECIMAL(10,2)
)DB21034E The command was processed as an SQL statement because it was not
a valid Command Line Processor command. During SQL processing it
returned:SQL0286N A default table space could not be found with a page
size of at least "16384" that authorization ID "SOL2USER" is authorized to
use. SQLSTATE=42727

CREATE TABLE BSS_AI_HIST_ALLOC_SUMMARY( OPS_PLAN_NO FLOAT, ACT_CODE
VARCHAR(10), VERSION SMALLINT, BRAND VARCHAR(4000), BUDGET DECIMAL(14,6),
TONNAGE DECIMAL(12,6), CATEGORY VARCHAR(4000), BRAND_CODES VARCHAR(4000),
ALLOCATED_TO_AREAS VARCHAR(1) DEFAULT 'B', CAT_CODE VARCHAR(4000), DISCOUNT
DECIMAL(10,2) )DB21034E The command was processed as an SQL statement
because it was not a valid Command Line Processor command. During SQL
processing it returned:SQL0286N A default table space could not be found
with a page size of at least "16384" that authorization ID "SOL2USER" is
authorized to use. SQLSTATE=42727

Somebody from this group help us out in resolving the issue.

Thanks in advance

Thanks & Regards,
V.Harish Reddy



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page