Changing Database Space Attributes Using changeda

The changeda -s option allows you to change attribute values for a database space.

To change database space attributes

At a Landmark command prompt, type

changeda -s [attribute=value] [OPTIONS] dataarea space ...

where the default data area attributes that can be changed are:

Attribute Value
dbtype

The following are valid values to indicate the type of database used for this database space:

  • empty

  • msf2008 and msf2016,

  • oracle

  • proxy
dbname This is the same as a section name in the db.cfg file. If you do not provide a value, the value defaults from your entry for dbtype.
tablespace

The location (table space) where the database files are stored.
indexspace

The location where your index files are stored.
lobspace

A valid large object space name.
schema A valid schema name for a database table.
isview

Enter no if this table is a Infor Landmark Technology database table that should be processed normally by the Lawson system.

Enter yes if this table is

  • a view of a non-Lawson table

    or

  • an Infor Lawson System Foundation-format table treated as a view in the Infor Landmark Technology database

    or

  • a table that you wish to manually reorganize using a method other than the Lndmark database tools (such as the database reorganization utilities or dbmaint)

Note: 

Landmark utilities such as the database reorganization utilities or dbmaint do not attempt to create or reorganize isview tables.
sqltype

Specify the type of SQL code to generate. Enter one of the following:

  • s3classic

    Generated SQL is compatible with Infor Lawson System Foundation naming standards.

  • landmark

    Generated SQL maps SQL names in upper or lower case, as appropriate for the database.

  • foreign

    Generated SQL uses the name exactly as specified in the LPL business class definition.
supplementalindexes

Set to yes or no, depending on whether you want to use supplemental indexes.

Setting Up Supplemental Indexes
charset The character set name.
ddloptions The ddloptions attribute enables you to include a string with valid DDL statements. This replaces the functionality formerly provided by LAW_DBA_TABLES.
copy Use copy to copy the attributes from another space and apply them to the space you are modifying with changeda.
oracle_lobcache

A value of yes sets the LOB storage to CACHE, a value of no sets the LOB storage to NOCACHE, and a value of audit will use CACHE for AuditLog and EffectiveDatedLog only.

New data areas are created with a value of audit so that audit logs are cached by default but all other LOBs are not cached. Existing data areas will maintain their current behavior where LOBs are not cached.
oracle_lobcompression Use no, low, medium, or high to set the level of compression to use when storing LOB files.

Other values in the command syntax are:

Entry Description
dataarea The data area to change space attributes for.
space

The database space to change attributes for.

Note: 

If the space does not already exist, the utility will create it and apply the specified attribute values.
-v displayoptions

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace