Create schema

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • heartwork
    New Member
    • Jan 2012
    • 2

    Create schema

    Hi,

    I need to create a new schema on new systems on DB2 v9.5/9.7 on AIX 64 (no GUI available) and this schema should be identical with an already existing one on other system.
    The statement (not that complex) looks like:
    >>-CREATE SCHEMA------------->
    schema-name
    +-AUTHORIZATION--authorization-name
    '-schema-name--AUTHORIZATION--authorization-name-'
    >--+--------------------------+----><
    '---schema-SQL-statement-+-'

    How can I find how this existing schema was created in the past to use the same statement to create my schema? What commands do I have to use and what system tables I should check?

    Thanks.
  • heartwork
    New Member
    • Jan 2012
    • 2

    #2
    I noticed some information can be gathered from SYSCAT.SCHEMATA

    Comment

    • pritikumari
      Banned
      New Member
      • Jan 2023
      • 23

      #3
      For create a schema

      In Object Explorer, expand the Databases folder.
      Expand the database in which to create the new database schema.
      Right-click the Security folder, point to New, and select Schema.
      In the Schema - New dialog box, on the General page, enter a name for the new schema in the Schema name box.

      Comment

      Working...