Re: Steps to manually create ITM and Warehous Database in DB2

Hi Robert

    Thanks for your reply, I am looking for something similar to the
following ( from SCCD manual installation ), which is useful as I actually
know all the individual fine tune parameters. Is there anything of such ?

db2 create db 'maxdb75' ALIAS 'maxdb75' using codeset UTF-8 territory US
pagesize 32 K db2 connect to 'maxdb75' db2 GRANT DBADM ON DATABASE TO USER
db2admin (windows only) db2 GRANT SECADM ON DATABASE TO USER db2admin
(windows only) db2 connect reset

db2 update db cfg for maxdb75 using SELF_TUNING_MEM ON
db2 update db cfg for maxdb75 using APP_CTL_HEAP_SZ 16384 DEFERRED
db2 update db cfg for maxdb75 using APPLHEAPSZ 2048 AUTOMATIC DEFERRED
db2 update db cfg for maxdb75 using AUTO_MAINT ON DEFERRED
db2 update db cfg for maxdb75 using AUTO_TBL_MAINT ON DEFERRED

Thanks in advance
Robert

On Wed, Jan 30, 2013 at 2:15 PM, Robert Barron <[email protected]> wrote:

> Is this what you mean?
>
> Schema Publication Tool
>
> http://pic.dhe.ibm.com/infocenter/tivihelp/v15r1/topic/com.ibm.itm.doc_6.2.3fp1/itm623FP1_install435.htm?path=3_0_3_0_8_1#sqlgen
>
> Robert Barron
> Enterprise Management Specialist - IBM Israel
>
> <http://classicarete.blogspot.com>
>
>
> On Wed, Jan 30, 2013 at 7:47 AM, robertkgp Koh <[email protected]>wrote:
>
>> Hi Team,
>>
>>    Does anyone ever come across any documentation describing the command
>> on the creation of ITM and Warhous database in db2?
>>
>> Thank in advance
>> Robert
>>
>> _______________________________________________
>> TME10 mailing list
>> [email protected]
>> Unsubscribe:[email protected]
>>
>>
>
> _______________________________________________
> TME10 mailing list
> [email protected]
> Unsubscribe:[email protected]
>
>

_______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]