Syntax for newdb.pl

OSCommand
Windowsnewdb.pl –dbase dbname@ODBC_DSN
Linuxnewdb.pl –dbase dbname@SID
SwitchDescription

Windows: dbname@ODBC_DSN

—or—

Linux: dbname@SID

Required: dbname

The name of the new Contenta database; that is, the database to be created.

Optional: ODBC_DSN (Windows)

The ODBC data source name. If not specified, the default is used—as defined in the registry for XYV_PDM_ODBC_DSN

Optional: SID (Linux)

The system identifier. If not specified, the default is used—as defined in the registry for XYV_PDM_DATABASE_SID

-metadata mdpathname

Optional

Where mdpathname is the path of the property description or MetaData file with which to create the database.

Default: The MetaData file in the Contenta home directory.

-xyadminpwd

Optional if password is default, manager.

Required if password is not default; see Adding and Changing the Database Passwords.

This is the password for the Oracle or MSSQL database.

-pdmpwd db_passwd

Optional if password is the default, pcmuser.

Required if password is not default; see Adding and Changing the Database Passwords. This is the password for the Contenta database.

The next five switches affect the Solr search engine. You must add the name of your database to the registry value DATABASES_TO_INDEX located under the key XyEnterprise\Contenta Crawler. Next, restart the Solr Server.

-markforindex

Default: database is not marked for index

-solrprotocol http|https

Default: http

-solrserver Solrservername

Solr server name

-solrport Solrserverport

Default: 8983

0 for no port

-solrcollection Solrcollectionname

Solr collection name

Example:

newdb.pl -dbase my_database -solrprotocol http -solrserver my_system -solrcollection collection -markforindex

Oracle Only The following switches are Oracle database switches. If you are using an MSSQL database these switches are not available/not necessary.

-tblspace tblspacename

Optional

Where tblspacename is the name of the tablespace for application data.

Default: As defined in the variable XYV_PDM_TABLESPACE

-tmptblspace tmptblspacename

Optional

Where tmptblspacename is the name of the temporary tablespace.

Default: As defined in the variable XYV_PDM_TMPTBLSPACE

-indxtblspace indxtblspacename

Optional

Where indxtblspacename is the name of the index table space.

Default: As defined in the variable XYV_PDM_INDXTBLESPACE.