Before you can use file spaces you must set up database
tables for the Web Gateway to store file space information in. You
can create these tables in your existing log database, or create a
new database to contain the tables.
About this task
Follow these instructions to create the database tables that
the Web Gateway requires to work with file spaces.
Procedure
- If you do not have database software installed, install
your database software using the documentation for your database.
If JDBC support is an optional component for your database you must
install this database.
- If you do not have a database or you want to use a different
database to the database that is used by the database logger, create
a database using the database tools. The default schema
name is FTEWEB. If you use a schema name other than FTEWEB, you must
edit the provided SQL files, webgateway_db2.sql, webgateway_oracle.sql or webgateway_zos.sql to
reflect this before proceeding to the next step. If you want to create
the Web Gateway tables in the same database as the database logger
tables, the two sets of tables must not have the same schema name.
- Create the required database tables using the database
tools. The files webgateway_db2.sql, webgateway_oracle.sql or webgateway_zos.sql contain
SQL commands you can run to create the tables. The files are in the install_directory/web/sql directory
of a WebSphere® MQ
File Transfer Edition Server installation.
Information
about how to use and customize the SQL commands are described in the
comments at the top of the files.
Note: If you are migrating from V7.0.3 to a later version of WebSphere MQ
File Transfer Edition, there are no changes
to the database schema for the Web Gateway. There is no SQL migration
file to run against your database.