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.
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.
Comment