; CreateDB.cfg - controls the database create scripts ; ; Comment line start with ';' ; Property names must be upper case ; No spaces allowed (use double quotes to surround values that contain space) ; ; ; Type of db action to perform ; ; Install - creates a new database ; Upgrade - updates the schema and data to latest level ; NotifyInstall - install the database notification service ; NotifyUnInstall - removes the database notification service ; CatalogDatabase - used for DB2 only. Catalogs remote db locally ; AddOn - used to install additional tables to existing db. ADD_ON_NAME needs to be set. ; Restore - restores a previously backed up db using RESTORE_FILENAME below CMD=Install DATABASE_NAME=BESMgmt ; Following two arguments apply only to SQLServer ; ; Name of Server to install the db ; Local machine can be specified as local ; If port is specific, it will be used as is. ; If blank, the connect will be done without specifying the port SERVER=local MSSQL_PORT= ; ; The userid/password to use to create/update to the database. If not set, then the userid will be ; the user executing this program USERID= PASSWORD= ; ; Everything is logged to DB_InstallV.log but you can also ; get info/error msgs dumped to console by setting this to true ; VERBOSE=false ; ; Database version to create/migrate to ; Format is 3.5, 3.6, 4.0 etc ; If left blank, most recent version will be used VERSION= ; ; Create the database - if true, a create database will be done. Ignored for migration ; CREATE=true ; ; Backup the current database ; BACKUP=false ; ; Drop the existing database. Ignored for migration ; DROP=false ; These settings applies only to DB2 and are used only when creating a new database ; ; The local node name of the remote DB2 Server ; If database is created locally, leave node blank ; DB2 has 8 character limit on node name DB2NODE= ; ; If the DB2NODE value doesn't exist, then the next two settings are needed in order to create the node ; DB2SERVER= DB2PORT= ; These are used by the CatalogDatabase command. Leave DB2LOCAL_DB blank to create local alias name ; the same as remote database name DB2REMOTE_DB= DB2LOCAL_DB= ; ; Stop processing if an error is encountered ; STOP=true ; ; Path to where DBInstallScripts directory lives ; No trailing \ ; SCRIPT_ROOT=. ; ; Load locale specific version of some strings. ; LOCALE= ; ; Load time zone offset ; TIME_ZONE_OFFSET=0 ; ; The name of the add on app to install/upgrade into an existing database. This is ignored if ; the CMD, specified at the top, is not AddOn ; ADD_ON_NAME= ; ; Directory to put create database log file in ; The dir should exist and there is no trailing \ ; LOG_DIR=. ; ; If set, Developer creates a smaller db ; DEVELOPER=false ; ; DBMS ; DBMS=SqlServer ;Owner of the DB2 Schema. If DB2SCHEMA is not present, defaults to BESADMIN ; DB2SCHEMA=BESADMIN ; ; The directory to put the db files into. This directory must exist. ; For SqlServer, default is the same location as the tempdb ; DB_FILE_DIR= ; ; The directory to put the backup file to. This directory must exist. ; Default is the same location as the database file is ; BACKUP_DIR= ; ; The file that is to be restored. ; Only used by the Restore command ; Default backup filename is: ; "\DatabaseNameBKUP.dat" ; ; If more than one backup exists in the file, the most recent one is used for restoring ; RESTORE_FILENAME= ; ; If false, the sql files will be generated but not executed ; GENERATE_EXECUTE=true ; ; Set the BES type ; Valid types are Exchange, Domino, GroupWise, Unite, VS BES_TYPE=Exchange