Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    51

    Unanswered: User Temporary Tablespace

    Ok, what's the trick?

    To use DECLARED TEMPORARY TABLES, the USER (whoever that might be) needs to be able to access some Temporary Tablespace.

    So I went to the control center and used the wizard to create some. Even with the permissions for my currently logged in db2admin. The same guy who owns the schema for my stored procedure.

    But my stored procedure complains that it can't find a tablespace assigned to db2admin with 4096k of space.

    Now I know I'm there as db2admin and he owns the schema, and the tablespace I created has got some basic large space to spare.

    So what's the trick?

    Thanks,

    Kimball

  2. #2
    Join Date
    Aug 2004
    Posts
    51

    To myself

    This is what I've found so far:

    DECLARE GLOBAL TEMPORARY TABLE SLDETAIL
    (
    structure varchar(3),
    entry varchar(6),
    sequencer decimal(3),
    amount decimal,
    risk decimal
    ) not logged on commit preserve rows IN USER_TEMP_TABLES;

    doesn't work, even though it is part of the syntax.

    DB2 asks for the properly qualified reference to USER_TEMP_TABLES, but I cant' figure out what that is.

    also, the docs say to 'issue this statement' before running the create proc:

    CREATE USER TEMPORARY TABLESPACE ts1
    MANAGED BY SYSTEM USING ('ts1file');

    so it's still running (3min) I don't know what it's doing... actually it's a 90% at 5 minutes.

    What I need to do is create a 'permanent' temporary user tablespace to be used by all the users logging into db2 to run this stored proc.

    any help out there? I'm dyin here...

    Thanks,

    Kimball

  3. #3
    Join Date
    Jul 2004
    Posts
    65

    Talking

    Hi Kimball:

    I solve that problem...let me know if you still need help.

    Cheers...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •