ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

XCOM Gateway - Create the DB2 Database Separately

book

Article ID: 200581

calendar_today

Updated On:

Products

XCOM Data Transport XCOM Data Transport - Windows XCOM Data Transport - Linux PC XCOM - SUPPORT

Issue/Introduction

Can the DB2 database be created separate from the installation of the Gateway?  Standalone independent of the installation.


Environment

Release : 12.0

Component : CA XCOM DATA TRANSPORT GATEWAY FOR WINDOWS

DB2

Resolution

Yes, you can create the database separately before installing the Gateway.  If the Gateway has already been installed you can create the database without reinstalling the Gateway.
 
DDL scripts for the XCOM Gateway database can be located under "%XCOMWebv12_HOME%\ddl" on Windows or "$XCOMWebv12_HOME/ddl" on Linux. 
 
There will be different subdirectories for each database type and you can use SQL scripts from "DB2_LUW" if you are using DB2 UDB or you can use DB2_zOS if you are using DB2 on zOS. 
 
You need to modify the SQL files to replace "$DB_SCHEMA_OWNER$" with the Database Schema Owner prior to executing the script.
 
The on line documentation says that it requires the following authorities to create the database, create tables, create triggers, create index, select, update, insert, and delete within the database. Refer to Define the Database.

Additional Information

See attached scripts for Gateway and Interface.

Attachments

1601927050034__01102020_124523596_1_gatewayDDLDB2LUW.sql get_app
1601927030443__01102020_124530687_1_InterfaceDDLDB2LUW.sql get_app