Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

How to set CODESET TERRITORY COLLATION using response file

  • 1.  How to set CODESET TERRITORY COLLATION using response file

    Posted Wed June 24, 2020 10:38 AM

    Hello all,

     

    I am working on automation scripts to create the instance, databases using response file. 

     

    I am unable to find the Parameters for setting CodeSet, Territory and Collation details for the databases.  Can someone please help me on this?.

     

    My response file look like this.

     

    à cust.rsp

     

    * ====================

    * PRODUCT Parameters

    * ====================

    PROD = DB2_SERVER_EDITION

    FILE = /opt/IBM/db2/V11.1.4.5/

    LIC_AGREEMENT = ACCEPT

    INSTALL_TYPE = TYPICAL

    LANG = EN

    * ====================

    * INSTANCE Parameters

    * ====================

    INSTANCE = db2inst1

    db2inst1.NAME = db2inst1

    db2inst1.GROUP_NAME = db2grp

    db2inst1.HOME_DIRECTORY = /home/db2inst1

    db2inst1.PASSWORD = P@ssw0rd

    db2inst1.AUTOSTART = YES

    db2inst1.START_DURING_INSTALL = YES

    db2inst1.SVCENAME = db2c_db2inst1

    db2inst1.INSTANCE_MEMORY = AUTOMATIC

    db2inst1.PORT_NUMBER = 50000

    * ====================

    * DATABASE1 Parameters

    * ====================

    DATABASE = DB1

    DB1.DATABASE_NAME = db2inst1

    DB1.INSTANCE = db2inst1

    DB1.ALIAS = db2inst1

    DB1.LOCATION = LOCAL

    DB1.AUTHENTICATION = SERVER

    DB1.PATH = /db2/data1/

     

    -Ravi


    If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support.


    #Db2


  • 2.  RE: How to set CODESET TERRITORY COLLATION using response file

    Posted Thu June 25, 2020 05:29 AM
    Hi Ravi,

    codeset, territory and collation are database specific parameters. They can only be set during the creation of a new database.

    The above response file is responsible for installing a new database instance, configuring the instance and then and cataloging any existing databases on disk.

    Hence, they cannot be configured, as they are not usable in this context.

    Hope this helps for understanding.

    Cheers

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------

    Original Message