Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    5

    Question Unanswered: "AUTOMATIC STORAGE" support for CREATE DATABASE in DB2 8.1?

    Hello DB2 users,

    Command "CREATE DATABASE ABCD AUTOMATIC STORAGE YES USING CODESET IBM-1252 TERRITORY US COLLATE USING SYSTEM PAGESIZE 4096" is not working with DB2 version 8" where as it is working well with DB2 V9.7 UDB.
    Can anyone advise on whether 'AUTOMATIC STORAGE ON' and 'PAGESIZE 4096' are supported with DB2 V 8 UDB or not?

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Why don't you check the Command Reference manual for V8 to see the create database syntax?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Automatic Storage was introduced in 8.2.2(iirc). check your fix level and then the doc.

    Cheers
    Sathy
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2009
    Posts
    5
    Thanks for the reply. Got the answer

Posting Permissions

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