Step 5. Customize the Install (requires DBA privileges)
This step is optional. Please read the instructions below and decide whether you want to configure database-specific settings before the install.
Note: If you change any files listed here, make a copy of the original with the extension .original. Make a copy of your changed file with the extension .changes. This will allow your changes to be reapplied after an upgrade or EPC installation.
Change the default and temporary tablespace (in x_dbmenv.dat)
By default, LANSA tables will go into the tablespace USERS, which by default is quite small. You may wish to increase the size of this tablespace, or create a new tablespace for LANSA. If you choose the latter option, alter the settings used to create the users in $LANSAXROOT/x_lansa/source/crlansa.ora.
You should copy any changes you make here into $LANSAXROOT/x_lansa/x_dbmenv.dat. Adjust the following line (under the heading ORACLE - Linux Platforms):
CMD_CREATE_COLLECTION=CREATE USER >C< IDENTIFIED BY >C< DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS
Change the tablespace settings (via X_RUNSQL_XXX environment variables)
LANSA's table creation utility, runsql, creates tables and indexes with ORACLE-specific column types, but without database-specific settings; for example, tablespace, initial extent size, and so on.
If you wish to append database-specific settings to all CREATE TABLE and CREATE INDEX statements issued by LANSA, set the environment variables X_RUNSQL_CREATE_TABLE and X_RUNSQL_CREATE_INDEX in the LANSA owner's login script. Please refer to The RUNSQL Utility in the for full details such as, which environment variable affects primary key indexes.