sqadm init-db(1)

sqadm init-db - Initialize PC-lint Plus View database schema

sqadm init-db [-C] [--create-database] [--create-user] [--if-not-exists] [--section name] [-S dir] [--jdbc-url url] [--jdbc-user user]

This command initializes PC-lint Plus View database objects. It is called automatically when installing PC-lint Plus View and should usually not be used after that.

Defaults parameters are taken from the standalone.xml configuration file, but most of them can be overridden on the command line for advanced use cases.

The sqadm init-db command shall be executed on a stopped PC-lint Plus View server, but a running database.

-C, --clean

Clean (drop) database objects before recreating them.

This option is used in conjunction with --create-database (resp. --create-user) to drop the database (resp. the user) before recreating it. It is ignored otherwise.

--create-database

Create the database (PostgreSQL only).

--create-user

Create the database user.

--if-not-exists

Do not create objects when they already exist.

--section name

Only create the named section (pre-data, data, post-data or none).

This option can be specified more than once to select multiple sections. The default is to restore all sections.

-S, --sql-dir dir

Directory with SQL scripts to create schema.

--jdbc-url url

Database URL of the form jdbc:subprotocol:subname.

--jdbc-user user

Database username.