Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    10

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

    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 !!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

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

    Your will have to create a user temp tablespace ..

    Pl Refer SQL Reference CREATE TABLESPACE Statement

    Sathyaram
    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 !!
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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