Installing and configuring the SDO repository

「服務資料物件 (SDO)」是一個開放式標準,可讓應用程式以統一方式(如資料圖)來處理不同資料來源的資料。 Service integration bus-enabled web services use an SDO repository for storing and serving WSDL definitions. Use this task to create and configure your preferred database to store SDO data, and to install and configure an SDO repository on each server that you plan to use for bus-enabled web services.

Before you begin

Determine the servers or clusters on which to install and configure an SDO repository as described in Planning your bus-enabled web services installation, then add each server or cluster as a member of a bus as described in Configuring the members of a bus.

An SDO repository can work with most database products. For specific information about choosing and configuring your preferred database, consult your database administrator or database product documentation, and read the notes in this topic on database usage.

About this task

To install and configure an SDO repository, complete the following steps:
  • Install your preferred database product.
  • Create a JDBC provider and a data source for your database.
  • Run the installSdoRepository.jacl script one or more times, to install the SDO application on each server and to set the database type that the SDO repository is to use.
For more information about how to do this, first read the following notes on database usage and on the installSdoRepository.jacl script, and then complete the steps for one of these configurations:
Notes on database usage:
  • [AIX Solaris HP-UX Linux Windows][IBM i]For a single server configuration, you can use either your preferred database or the embedded Apache Derby database that is supplied with WebSphere® Application Server. [z/OS]在 z/OS® 環境中,您無法使用內嵌的 Derby 資料庫,因為每次只能有一個程序存取這個資料庫,而在 z/OS 上,即使單一伺服器也能夠執行多個程序。
  • For a network deployment configuration you can use either your preferred database or the supplied Derby database and associated Network Server application. However, be aware of the limitations of Derby Network Server. For example, it does not support transactions.
  • The SDO repository dictates the schema and table names that it uses, so different repositories must use different databases to ensure that they do not access the same data. Use one SDO repository for each cell, so that if you have multiple cells you use multiple databases, one for each cell.
  • [z/OS]DB2® on z/OS does not have the concept of multiple databases. On z/OS systems, each SDO repository must use a different DB2 instance to ensure that different repositories do not access the same data.
  • 利用相關 app_server_root/util/SdoRepository/database_type 目錄中的 Table.ddl 檔,為您偏好的資料庫供應商建立資料庫。 The Table.ddl file describes the database table that is needed by the SDO repository.
  • installSdoRepository.jacl Script 上的 -editBackendId 旗標決定了儲存庫要用的資料庫類型。 後端 ID 決定了與資料庫交談時,應用程式所遵循的特定資料庫規則。 See the associated note on the installSdoRepository.jacl script.
  • Some databases require a user ID that has been granted permissions to access the SDO repository database. Create a user ID for user name SDOREP before you create the tables for Oracle, Sybase, and SQL Server databases. Because of the way these databases handle user names and table names, the user name must be SDOREP to enable the SDO repository to access its table with the fully qualified name SDOREP.BYTESTORE. Make sure that you grant permission for the SDOREP user to read from, and write to, the database.
  • If you use an Informix® database, do not disable logging.
  • The SDO repository does not require XA support. In most cases you can use either an XA or a non-XA data source. However, if your database is Oracle 8 or 9, you must use the Oracle JDBC driver (non-XA) for the SDO repository data source.
  • You might also choose to complete other steps such as creating an index of the primary key to improve database performance. Do not change the schema, table and column names.
  • If you are configuring this SDO repository for use with a cell that contains a mixture of WebSphere Application Server 6.0 版, 6.1 版 and later application servers, you must use a database that is compatible with all these versions.
Notes on the installSdoRepository.jacl script:
  • Use the wsadmin scripting client to run the script.
  • [IBM i]從 Qshell 內執行 Script。
  • Script 提供在 app_server_root/bin 目錄中,其中 app_server_rootWebSphere Application Server 的安裝根目錄。 如果您選擇從另一個目錄執行 wsadmin Scripting 用戶端,請在指令選項上指定 Script 的完整路徑。 比方說,如果要使用預設設定檔以外的設定檔,請切換至 app_server_root/profiles/profile_name/bin 目錄,然後指定下列 Script 路徑:[IBM i]
    wsadmin -f app_server_root/bin/installSdoRepository.jacl
    [AIX Solaris HP-UX Linux Windows][z/OS]
    wsadmin.ext -f app_server_root/bin/installSdoRepository.jacl
    [AIX Solaris HP-UX Linux Windows][z/OS]其中 .ext 是副檔名 .bat(Windows 系統)或 .sh(UNIX、Linux 或 z/OS 系統)。
  • installSdoRepository.jacl Script 上的 -editBackendId 旗標決定了儲存庫要用的資料庫類型。 後端 ID 決定了與資料庫交談時,應用程式所遵循的特定資料庫規則。 To see the full list of available back end ID values, use the -listBackendIds flag:
    wsadmin -f installSdoRepository.jacl -listBackendIds
    All the back end ID values in the list can be used when the SDO repository is installed on one or more WebSphere Application Server 7.0 版或更新版本 application servers. Values marked with (*) cannot be used when the SDO repository is installed on 6.0 版 servers. Values marked with (**) cannot be used when the SDO repository is installed on 6.0 版 or 6.1 版 servers.
  • 如果資料來源已存在,或有先前已毀損或局部安裝的 SDO 儲存庫應用程式,installSdoRepository.jacl Script 就無法完成,且不會儲存配置變更。 In these cases, run the SDO repository uninstall script, fix the problem, then rerun the installSdoRepository.jacl script.
[IBM i][AIX Solaris HP-UX Linux Windows]

Configure the SDO repository for a single server, and to use the embedded Derby database

[z/OS]

Before you begin

[z/OS]在 z/OS 環境中,您無法使用內嵌的 Derby 資料庫,因為每次只能有一個程序存取這個資料庫,而在 z/OS 上,即使單一伺服器也能夠執行多個程序。

About this task

If you are creating a single server configuration and you want to use embedded Derby, you run the installSdoRepository.jacl script with the -createDb switch. This action creates the Derby database and installs the SDO repository.

To configure the SDO repository for a single server and to use the embedded Derby database, complete the following steps:

Procedure

  1. Open a command prompt, then change to the app_server_root/bin directory.
  2. Enter the following command: [IBM i]
    wsadmin -f installSdoRepository.jacl -createDb
    [AIX Solaris HP-UX Linux Windows][z/OS]
    wsadmin.ext -f installSdoRepository.jacl -createDb
    Note: The -createDb flag tells the command to create a default Derby database. If you omit this flag, the command still installs an SDO repository that is configured to use Derby, but the command does not also create the database.

Configure the SDO repository for a single server, and to use a database other than embedded Derby

About this task

If you are creating a single server configuration that uses a database other than embedded Derby, you install your preferred database product, then create a JDBC provider and a data source, then run the installSdoRepository.jacl script twice:
  1. One time to install the SDO application on the application server.
  2. One time to set the database type that the SDO repository is to use.

To configure the SDO repository for a single server and to use a database other than embedded Derby, complete the following steps:

Procedure

  1. 利用相關 app_server_root/util/SdoRepository/database_type 目錄中的 Table.ddl 檔,為您偏好的資料庫供應商建立資料庫。

    如需在 DB2 中建立表格的程序說明,請參閱Recreating database tables from the exported table data definition language。如需相關資訊,請參閱Deploying data access applications

  2. Create a J2C authentication alias.

    這用來搭配下一步所建立的資料來源。 請檢查鑑別別名符合資料庫實例的登入詳細資料,否則,無法建立連線。

  3. Create and configure a JDBC provider and data source.
    請設定下列資料來源內容:
    • 設定鑑別內容來使用上一步驟所建立的鑑別別名。
    • 選取在儲存器管理的持續性 (CMP) 中使用這個資料來源勾選框。
    • 名稱內容設為您選擇的名稱。例如,SDO 儲存庫資料來源
    • JNDI 名稱內容設為完全符合下列值:jdbc/com.ibm.ws.sdo.config/SdoRepository
    • 設定任何本身是所選資料庫必要設定的其他內容。
  4. Optional: Test the data source connection:
    Note: This option does not work in all configurations. The availability of this option depends on the scope at which the data source is defined, and the scope of any WebSphere Application Server variables that are used in the JDBC provider and data source configurations. For more information about testing connections to data sources, see Test connection service.
    1. In the administrative console, navigate to 資源 -> JDBC -> 資料來源.
    2. Select the SDO repository data source.
    3. Click Test connection.
  5. 配置 SDO 儲存庫:
    1. 開啟一個命令提示字元,然後切換至 app_server_root/bin 目錄。
    2. Install the SDO repository application on the server: [IBM i]
      wsadmin -f installSdoRepository.jacl
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl
    3. 設定 SDO 儲存庫要用的資料庫類型:
      [IBM i]
      wsadmin -f installSdoRepository.jacl -editBackendId database_type
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl -editBackendId database_type
      例如: [IBM i]
      wsadmin -f installSdoRepository.jacl -editBackendId DB2UDB_V82
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl -editBackendId DB2UDB_V82

Configure the SDO repository for a network deployment cell

About this task

If you are working in a network deployment environment, you install your preferred database product, then create a JDBC provider and a data source, then run the installSdoRepository.jacl script several times for each cell:
  1. One time to install the SDO application on the deployment manager.
  2. One time to set the database type that the SDO repository is to use.
  3. Several times to install an instance of the SDO application on each server or cluster that you plan to use for one or more of the bus-enabled web services roles.

To configure the SDO repository for a network deployment cell, complete the following steps:

Procedure

  1. 利用相關 app_server_root/util/SdoRepository/database_type 目錄中的 Table.ddl 檔,為您偏好的資料庫供應商建立資料庫。

    如需在 DB2 中建立表格的程序說明,請參閱Recreating database tables from the exported table data definition language。如需相關資訊,請參閱Deploying data access applications

  2. Create the following node-level WebSphere Application Server variables on all affected nodes, including the deployment manager node.
    Note: You can set these variables at either node or cell scope, depending upon your configuration. However for multi-platform nodes you cannot usefully set WAS_INSTALL_ROOT at cell scope, because the nodes have different installation directories.
    1. In the administrative console, navigate to 環境 -> WebSphere 變數 then set the scope to node level.
    2. Check that the WAS_INSTALL_ROOT variable exists, with a value of the root directory for the installation of WebSphere Application Server.
    3. Create a new variable your_database_JDBC_DRIVER_PATH, with a value of the location under which your database JAR files will be stored (in a later step) on each of the host machines within the cell.
  3. Create a J2C authentication alias.

    這用來搭配下一步所建立的資料來源。 請檢查鑑別別名符合資料庫實例的登入詳細資料,否則,無法建立連線。

  4. Create and configure a JDBC provider and data source.
    請設定下列資料來源內容:
    • 設定鑑別內容來使用上一步驟所建立的鑑別別名。
    • 選取在儲存器管理的持續性 (CMP) 中使用這個資料來源勾選框。
    • 名稱內容設為您選擇的名稱。例如,SDO 儲存庫資料來源
    • JNDI 名稱內容設為完全符合下列值:jdbc/com.ibm.ws.sdo.config/SdoRepository
    • 設定任何本身是所選資料庫必要設定的其他內容。
  5. Deploy the database client JAR files on each of the host machines within the cell.

    The JAR files must be deployed to the location given by the your_database_JDBC_DRIVER_PATH variable that you declared in a previous step, otherwise remote nodes will not be able to connect to the SDO repository.

  6. 配置 SDO 儲存庫:
    1. 開啟一個命令提示字元,然後切換至 app_server_root/bin 目錄。
    2. Install the SDO repository application on the deployment manager for this cell: [IBM i]
      wsadmin -f installSdoRepository.jacl deployment_manager_node_name deployment_manager_server_name
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl deployment_manager_node_name deployment_manager_server_name
      for example:[IBM i]
      wsadmin -f installSdoRepository.jacl dmgrNode dmgr
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.sh -f installSdoRepository.jacl dmgrNode dmgr
    3. 設定 SDO 儲存庫要用的資料庫類型:
      [IBM i]
      wsadmin -f installSdoRepository.jacl -editBackendId database_type
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl -editBackendId database_type
      例如: [IBM i]
      wsadmin -f installSdoRepository.jacl -editBackendId DB2UDB_V82
      [AIX Solaris HP-UX Linux Windows][z/OS]
      wsadmin.ext -f installSdoRepository.jacl -editBackendId DB2UDB_V82
    4. Install an instance of the SDO repository on each server or cluster that you plan to use for one or more of the bus-enabled web services roles:
      • For each server that is not part of a cluster, repeat the following command:[IBM i]
        wsadmin -f installSdoRepository.jacl node_name server_name
        [AIX Solaris HP-UX Linux Windows][z/OS]
        wsadmin.ext -f installSdoRepository.jacl node_name server_name
      • For each cluster, repeat the following command:[IBM i]
        wsadmin -f installSdoRepository.jacl -cluster cluster_name
        [AIX Solaris HP-UX Linux Windows][z/OS]
        wsadmin.ext -f installSdoRepository.jacl -cluster cluster_name

指出主題類型的圖示 作業主題



時間戳記圖示 前次更新: July 9, 2016 11:16
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=was-nd-mp&topic=tjw_install_sdo
檔名:tjw_install_sdo.html