Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2011
    Posts
    8

    Unanswered: What is the best way or difference

    One of the IBM's product has a create command for database with 8K info and table space with 32 k.

    Is both suppose to have 32 K ?

    or is it ok?

    which is best way ?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It would help if you give more information. What DB2 product? What OS? The statement you are using. etc.


    Andy

  3. #3
    Join Date
    Nov 2011
    Posts
    8
    Thanks For quick response.
    IBM Process Server is product ( it has multiple databases ( some are 32 K some are 8K)) on AIX 6.1 DB2 9.5 FP4

    CREATE DATABASE XXXX AUTOMATIC STORAGE YES ON /data01 USING CODESET UTF-8 TERRITORY US PAGESIZE 8 K

    CREATE LARGE TABLESPACE XXXX PAGESIZE 32 K MANAGED BY DATABASE USING (FILE '/data01/XXXXX/OBSRTS' 512M)
    AUTORESIZE YES
    EXTENTSIZE 32
    PREFETCHSIZE AUTOMATIC
    INCREASESIZE 512 M
    MAXSIZE NONE
    BUFFERPOOL BP32k ;
    Last edited by edoo.okati; 12-14-11 at 16:01.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The 8K on the database create statement is for the system info and default size. The pagesize on the create tablespace is for that tablespace only. There is no problem doing this.

    Andy

  5. #5
    Join Date
    Nov 2011
    Posts
    8
    Thank you so much.

  6. #6
    Join Date
    Nov 2011
    Posts
    8
    I would like to all 32k. is it recommended ?

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you don't create a 8K tablespace, then your tables may go to USERSPACE1 which is created by DB2 when database is created.

    db2 list tablespaces show detail
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  8. #8
    Join Date
    Nov 2011
    Posts
    8
    Except Temp syscatalog,

    I have three table spaces

    USERSPACE1, DATA_TS, IDX_TS

    All two of them are 32k (DATA_TS, IDX_TS) USERSPACE1 is 8K.



    I would like to have database size is also 32k and along with it all three table spaces are 32k ( 2 of the already 32 K)

  9. #9
    Join Date
    Jan 2010
    Posts
    335
    CREATE DATABASE XXXX AUTOMATIC STORAGE YES ON /data01 USING CODESET UTF-8 TERRITORY US PAGESIZE 32 K
    ???

Posting Permissions

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