user temporary tablespace

mark_maz · #1 (**permalink**) 03-17-06, 15:32

I am having problems creating it and I can't see the problems with the syntax (it's friday and St. Patrick's so please excuse the stupid question if it is that simple)

create user temporary tablespace usertempspace managed by system using '/archive/devz/DB2/avcd1/avc/USERTEMPSPACE'

thanks in advance

mark

Marcus_A · #2 (**permalink**) 03-17-06, 18:36

create user temporary tablespace usertempspace PAGESIZE 4 K managed by system using ('/archive/devz/DB2/avcd1/avc/USERTEMPSPACE') BUFFERPOOL IBMDEFAULTBP;

Make sure there are no files on that directory.

Internet Services

Web Development

Digital Marketing

Consumer Tech