User Profile

Collapse

Profile Sidebar

Collapse
heartwork
heartwork
Last Activity: Jan 11 '12, 12:05 PM
Joined: Jan 11 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • heartwork
    replied to Create schema
    in DB2
    I noticed some information can be gathered from SYSCAT.SCHEMATA
    See more | Go to post

      Leave a comment:

    • heartwork
      started a topic Create schema
      in DB2

      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-'
      >--+--------------------------+----><...
      See more | Go to post
      No activity results to display
      Show More
      Working...