HP 3PAR StoreServ 7200 2-node HP 3PAR Policy Server Installation and Setup Gui - Page 9

Essentials for Working with HSQL Database

Get HP 3PAR StoreServ 7200 2-node PDF manuals and user guides View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals

Page 9 highlights

Figure 2 Three assets under HP 3PAR Policy Server management Essentials for Working with HSQL Database The HSQL database server provides a standalone, open source, Java-based relational database to store and manage the Policy Server configurations. For more information about HSQLDB v2.2, refer to the documentation list at http://www.hsqldb.org/doc/2.0. This section provides the basic information you need before using the HSQL database with HP 3PAR Policy Server. HP 3PAR Policy Server uses the "file:" type of catalog (database), which stores data in file system files. For example, the database named "myHP3PS" consists of the following files: File name myHP3PS.properties myHP3PS.script myHP3PS.log myHP3PS.data myHP3PS.backup Contains Configuration property/value pairs for the database. Definition of tables and other database objects, and data for non-cached tables. Recent changes to the database. This file is removed during a normal shutdown of the database. If the database does not shut down normally, this file is saved and used at the next startup to redo the changes. Data for cached tables. For some catalogs, this file may not be present. A compressed copy of the last known consistent state of the data file. Note that for some catalogs, this file may not be present. You will be directed to install the database using the Policy Server installation program. The installation program configures the database server for use with Policy Server and creates all the tables for the Policy Server database. The installer can also install the HSQL database server as a service and start the database immediately after installation. For all new installations, HP recommends that you allow the installation program to perform these tasks. CAUTION: During normal operations, you may see files with the file name extension ".new" after shutting down the database. These files are temporary, created by the database engine at shutdown. The engine renames these files to those in the table above. NEVER delete these files. The database engine removes them at the next startup. If you see a data file with the file name extension ".old" (for example, myaps.data.xxx.old), you can delete the file. Security 9

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
Figure 2 Three assets under HP 3PAR Policy Server management
Essentials for Working with HSQL Database
The HSQL database server provides a standalone, open source, Java-based relational database
to store and manage the Policy Server configurations. For more information about HSQLDB v2.2,
refer to the documentation list at
h
t
tp://w
w
w
.hs
qldb
.o
r
g/doc/2
.
0
. This section provides the basic
information you need before using the HSQL database with HP 3PAR Policy Server.
HP 3PAR Policy Server uses the "file:" type of catalog (database), which stores data in file system
files. For example, the database named "myHP3PS" consists of the following files:
Contains
File name
Configuration property/value pairs for the database.
myHP3PS.properties
Definition of tables and other database objects, and data for non-cached tables.
myHP3PS.script
Recent changes to the database. This file is removed during a normal shutdown of the database.
If the database does not shut down normally, this file is saved and used at the next startup to
redo the changes.
myHP3PS.log
Data for cached tables. For some catalogs, this file may not be present.
myHP3PS.data
A compressed copy of the last known consistent state of the data file. Note that for some
catalogs, this file may not be present.
myHP3PS.backup
You will be directed to install the database using the Policy Server installation program. The
installation program configures the database server for use with Policy Server and creates all the
tables for the Policy Server database. The installer can also install the HSQL database server as a
service and start the database immediately after installation. For all new installations, HP
recommends that you allow the installation program to perform these tasks.
CAUTION:
During normal operations, you may see files with the file name extension “.new” after
shutting down the database. These files are temporary, created by the database engine at shutdown.
The engine renames these files to those in the table above. NEVER delete these files. The database
engine removes them at the next startup. If you see a data file with the file name extension “.old”
(for example, myaps.data.xxx.old), you can delete the file.
Security
9