The table space must be available as a USER TEMPORARY tablespace and its
page size must be large enough to accept the row that your Decalred Temp
Table generates. The user must also have the USE privilege on that
tablespace.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "NG YUNE CHONG"
<db2udbdba-ezmlmshield-x97254180.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, July 31, 2006 7:32 AM
Subject: sql error


>
> Hi,
>
> How to solve below sql error :-
>
> SQL0286N A default table space could not be found with a page size of
> at least "4096" that authorization ID "DB2ADMIN" is authorized to use.
> SQLSTATE=42727.
>
> The problem is when I run stored procedure until DECLARE GLOBAL
> TEMPORARY TABLE.
>
> Thanks,
> Ng
>
>
>
> ---------------------------------------------------------------------
> 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