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 component.
- 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
MQ_INSTALLATION_PATH/mqft/web/sql directory
of a
WebSphere® MQ Managed File Transfer Service installation.
Information
about how to use and customize the SQL commands are described in the
comments at the start of the files.
Note: If you are migrating from WebSphere MQ File Transfer Edition V7.0.x to a later
version of WebSphere MQ Managed File Transfer, there
are no changes to the database schema for the Web Gateway. There is
no SQL migration file to run against your database.