Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Folks ! Very interesting !

    Hi Folks,

    Please clarify the following :

    1) In DB2 8.1, I have heard of 'IN tablespace_name' , but Is there anything called 'IN DATABASE tablespace_name' ? If so in which version of DB2, this syntax exists ?

    2) How to create a tablespace in prior to a create table statement ?

    3) Is there any keyword 'AUDIT' in DB2 ? If so Please explain the same.

    Eg :

    create table test(sno int) IN DATABASE tablespace1 AUDIT NONE DATA CAPTURE NONE

    Please explain the above if you have come across the syntax.


  2. #2
    Join Date
    May 2003
    That is syntax on DB2 for OS/390 and z/OS. You can download the SQL Reference here:

    Note that a database is a completely different object on mainframe DB2 compared to a database on other DB2 versions.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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