Resolution:
Description:
==========
DB2 follows a pattern where database has some Table spaces and inside the table spaces there are specific schemas which are allocated. So if we want to use a customized table space and customized schema for our operations, how do we generate those scripts (the scripts that have come out from the above indicate "CREATE TABLE TABLENAME")? We want to use something like "CREATE TABLE TABLESPACE.SCHEMA.TABLENAME".

Environment:
===========
TIBCO BusinessEvents 5.1.1
DB2

Resolution:
=========
You can use the follow options to achieve the requirement.

1). For the BE schema user: revoke all tablespace access and give permission to one tablespace:
   revoke use of tablespace &lttablespace-name> from username
   grant use of tablespace &ltTABLESPACE> to user username

2). Add the current schema user statement to the beginning of the scripts:
   set current schema &ltSCHEMA>

3). Run the scripts. All the objects created should goto the desired TABLESPACE for that SCHEMA

Before applying the changes be sure to check with your DBA to evaluate the option.