Error When i used "declare global temporary table session.ZZMD00"

thanat · #1 (**permalink**) 04-20-04, 23:01

declare global temporary table session.ZZMD00(
IP_ID INTEGER,
WJXBFS1 DOUBLE)
partitioning key (IP_ID) on commit preserve rows not logged

I Used to run and got this Error
[DB2/6000] SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "BIMICROD" is authorized to use. SQLSTATE=42727

Please Help me !!

sathyaram_s · #2 (**permalink**) 04-21-04, 04:54

Your will have to create a user temp tablespace ..

Pl Refer SQL Reference CREATE TABLESPACE Statement

Sathyaram

Quote:

Originally posted by thanat
declare global temporary table session.ZZMD00(
IP_ID INTEGER,
WJXBFS1 DOUBLE)
partitioning key (IP_ID) on commit preserve rows not logged

I Used to run and got this Error
[DB2/6000] SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "BIMICROD" is authorized to use. SQLSTATE=42727

Please Help me !!

Internet Services

Web Development

Digital Marketing

Consumer Tech