Upgrades the ACDB.
If you are using a database other than Adaptive Server
Enterprise, you must create the ACDB schema before you upgrade the
ACDB—see createschema. For Adaptive Server
Enterprise, the schema is created automatically.
upgradedb --enkfile file_name [--database_type sybase_ase | sybase_asa | oracle] [--entldb_jdbc_admin_password jdbcPassword] [--entldb_jdbc_admin_username jdbcUsername] [--entldb_jdbc_driver jdbcDriver] [--entldb_jdbc_url jdbcURL] [--entldbreader_username readerUsername] [--jdbc_admin_password password] [--jdbc_admin_username user_name] [--jdbc_driver driverName] [--jdbc_url jdbcURL] [--psoname psoName] [--psouid psoUID] [--random_seed randomSeed] [--security_properties_file propsFile] [--sybase_asa_servicename service_name]
Argument |
Datatype |
Default value |
Description |
|---|---|---|---|
* enkfile |
string |
Encryption key file name; must be readable. |
|
database_type |
choice |
sybase_ase |
The database type. This value is used to determine the default values for the jdbc_url and jdbc_driver arguments.Acceptable values are:
|
entldb_jdbc_admin_password |
string |
Use only when upgrading from an Enterprise Security version 2.5.2 database. Password for the user specified by entldb_jdbc_admin_username. |
|
entldb_jdbc_admin_username |
string |
sa |
Use only when upgrading from an Enterprise Security version 2.5.2 database. User name for connecting to the ACDB. This user must have read and write privileges on the ACDB. |
entldb_jdbc_driver |
string |
com.sybase.jdbc2.jdbc.SybDriver |
Use only when upgrading from an Enterprise Security version 2.5.2 database. JDBC driver to use when connecting to the ACDB. |
entldb_jdbc_url |
string |
jdbc:sybase:Tds:host: 5000/acdb |
Use only when upgrading from an Enterprise Security version 2.5.2 database. JDBC URL to use when connecting to the ACDB. |
entldbreader_username |
string |
entldbreader |
ENTLDB reader login; use only when upgrading from an Enterprise Security version 2.0 database. |
jdbc_admin_password |
string |
Password for the user specified by jdbc_admin_username. |
|
jdbc_admin_username |
string |
sa |
User name for connecting to the database for administrative purposes (creating databases, tables, and so on). |
jdbc_driver |
Java class name |
Depends on the value of database_type; for sybase_ase: com.sybase.jdbc2.jdbc.SybDriver |
JDBC driver to use when connecting to the database. |
jdbc_url |
string |
Depends on the value of database_type; for sybase_ase: jdbc:sybase:Tds:host: 5000/acdb |
JDBC URL to use when connecting to the database. |
psoname |
string |
Portal Security Officer |
Name of the Security Officer. |
psouid |
string |
pso |
Security Officer’s user ID. |
random_seed |
integer |
An integer to use as a random seed. |
|
security_properties_file |
string |
The path and file name of the security.properties file; must be readable. This value is required only when upgrading from Enterprise Security version 2.5.2. |
|
sybase_asa_servicename |
string |
acdb |
The SERVICENAME connection property to use when connecting to a Sybase ASA database. |
Return value |
Indicates |
|---|---|
0 |
The command ran successfully; the result is true/success. |
1 |
The command failed. |
This command line example upgrades the ACDB using the encryption key file /work/Sybase/Security/.enk:
securetool upgradedb --enkfile /work/Sybase/Security/.enk
