which tablespace will be used for a Global Temp table in a Stored Proc

[gbag]

Can anybody pls tell me as '
When you declare a Global Temporary table in a Stored Procedure, in which space it will be created'
I am getting permission error. I feel that I have given permissions to all but still want to find out the difference.

thanks in advance
gbag

 

[sathyarams]

A user temporary tablespace


create user temporary tablespace usertemp1 managed by system using ('/home/db2inst1/containers/usertemp1')

grant usage on usertemp1 to <userid>

HTH

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[gregsimpson]

gbag,

I with Sathyaram with this. It will be the user temporary tablespace. I believe you need SYSADM or DBADM authortiy to execute the DECLARE GLOBAL TEMPORARY TABLE statement.

Cheers
Greg