SAP Basis Tech Supports

Symptom

You want to reset the default DEFINE NO parameter for an installation, system copy or Unicode conversion. This Note describes how you can change the default and force DEFINE YES for table spaces and indexes.
It is only valid if you are running on DB2 server V8.1.5 or if your SAP Basis release is 7.0*. For SAP release 7.10 running on DB2 server V9.1.5 you can only change index DEFINE default settings by applying this Note. For table spaces you need to set DB2 zPARM IMPDSDEF to YES.
Other terms

DB2 DEFINE DDLDB2.TPL IMPDSDEF

Solution

Open the file DDLDB2.TPL on your export DVD or on your system export. If you are performing an installation, mount the export DVD 1 read-write. The DDLDB2.TPL is located at:
/ABAP/DB/DDLDB2.TPL for system copies and exports/DATA_UNITS/EXPORT_1/DB/DDLDB2.TPL for ERP installations/EXP1/DB/DDLDB2.TPL for Netweaver installations
Change all DEFINE &define& strings that are part of the ddl
templates to DEFINE YES for the required templates.
The following templates are used:
crepky and creind: create SAP indexes on 7.0*. On 7.1* this template is used if you are running on DB2 server V8.1.5.cpkuts and cinuts: create SAP indexs on 7.1* if DB2 server version is V9.1.5cretsp: create non-lob table spaces on 7.0*. On 7.1* this template is used if you are running on DB2 server V8.1.5.
Save the file DDLDB2.TPL.
To check your configuration change for CREATE TABLESPCE statements, select checkbox “Verify CREATE TABLESPACE Statements” in SAPinst custom mode. Check CREATE TABLESPACE ddl statements in tblspace.sql_* in sapinst installation duirectory.