Complete Installation and Upgrade Information for Software AG Products : Installing Software AG Products : Creating and Dropping Database Components : Use the Database Component Configurator Command Line Interface : Database Component Configurator Command : Main Parameters
Main Parameters
{-a | --action}action
Action to perform. You can specify the values below.
Value
Action
catalog
Lists existing database components.
create
Creates db_component or the database components for product .
drop
Drops db_component or the database components for product .
recreate
Drops db_component or the database components for product , then creates db_component or the database components for product .
checkEncoding
Checks whether your RDBMS is Unicode-enabled and displays the answer.
{-d | --dbms} {oracle|sqlserver|db2luw}
RDBMS on which to perform action .
{{-c | --component} db_component {-v | --version} db_component_version | {-pr | --product} product {-v | --version} product_release}
One of the following:
*Database component and database component version for which to perform action .
Parameter
Value
db_component
One or more database component codes or names. Use commas to separate multiple codes or names. You can list database component codes and names by specifying -c all with the print action.
db_component_version
The value latest.
*Product database components and product release for which to perform action .
Parameter
Value
product
One or more product codes or names, or ALL. Use commas to separate multiple codes or names. You can see the list of database components for a product by specifying -prl product with the print action.
product_release
The product release or the value latest.
{-l | --url} RDBMS_URL
URL for the RDBMS. For information about options supported by the DataDirect Connect JDBC 5.1 driver used by your products, see the DataDirect Connect documentation, available on the Software AG Documentation website. When working with database components on UNIX systems, you must enclose the URL in double quotes. You can specify the values below.
RDBMS
Sample Format for DataDirect Connect Driver
Oracle

jdbc:wm:oracle://server: {1521|port} ;serviceName=service [;option=value]. ..

For Oracle, if you are going to create storage and the Data Purge database component, you must specify the sysLoginRole connection option on the URL (for example, ;sysLoginRole=sysdba).
SQL Server

jdbc:wm:sqlserver://server: {1433|port} ;databaseName=database [;option=value]...

DB2 for Linux, UNIX, Windows

jdbc:wm:db2://server: {50000|port} ;databaseName=database [;option=value]...

For DB2, if you are going to create database components in a schema other than the default schema for the specified database user, you must specify these connection options in the URL:
;AlternateId=schema;"InitializationString=(SET
CURRENT PATH=current_path,schema)"
AlternateID is the name of the default schema used to qualify unqualified database objects in dynamically prepared SQL statements.
If you are creating Optimize database components (that is, Analysis and ProcessTracker), you must specify schema using all uppercase letters. In addition, you must specify the options CreateDefaultPackage=true, ReplacePackage=true, and DynamicSections=3000. These settings will affect all database components in the same schema or database.
{-u | --user} db_user {-p | - -password} password
Depends on the action you are performing.
Note:  
You can choose to specify this authentication information in the URL, using DataDirect options, instead of in these parameters.
If you are...
Specify these values...
Creating a database user and storage in Oracle or SQL Server
Database user and password to create.
For SQL Server, the user will be created and a default schema named dbo will be assigned to that user.
For Oracle, do not use the SYSTEM user to create the database components in the SYSTEM schema.
Creating a database user and storage in DB2 for LUW
OS user to which to grant permissions.
Performing the checkEncoding action
Existing database user that has create session and create table privileges, and that database user's password.
Performing any other action
Existing database user and password.
[{-au | --admin_user} db_admin_user {-ap | --admin_password} password]
If you are going to create a database user and storage, or drop storage and revoke the database user permissions, database user or operating system user and password that has the necessary database administrator credentials.
Copyright © 2007-2016 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback