Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

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

    Posted 06/24/20 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 06/25/20 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
    ------------------------------



Related Content