Skip to Content
IBM Db2 for i

SAP on DB2 for i5/OS - Profile Parameters

This page is intended to help you administrating SAP on DB2 for i. It presents an overview about profile parameters that are important for this task.

Configuration

Profile Parameter

Possible Values

Default

From

Description

dbs/db4/rdbname

<rdb>

''

4.6D

Relational database name as displayed by WRKRDBDIRE; only relevant for iASP installations (For more information see SAP Note 568820).

dbs/db4/opticonnect

['1' / '0' ]

'0'

3.1I

Use OptiConnect [y/n]?

dbs/db4/qaqqinilib

<lib>

'QUSRSYS'

4.6D

Library that contains the QAQQINI file. Defaults to QUSRSYS.

dbs/db4/da_cache_size

[ '0' - ??? ]

'100'

3.1I

DB2 for i5/OS SQL DA cache size. Defaults to 100. 0 means the cache is disabled.

dbs/db4/allow_cancel

[ ' ' / '1' ]

' '

6.40

Enables SQL Cancel if set to '1'. Disabled by default.

dbs/db4/max_hostvars

[ '0' - ??? ]

'2000'

4.6D

Max. number of host variables. For more information see SAP Note 805622.

dbs/db4/ntlogonfile

<path>/<file>, (e.g. '\\<host>\saptext\<sid>\profile\NTLOGON.INF' for Win, or '/usr/sap/PRS/SYS/profile/NTLOGON.INF' for Linux)

''

4.6D

Fully qualified name of the file that contains the logon information from NT or Linux

Tracing

Profile Parameter

Possible Values

Default

From

Description

dbs/db4/dbsl_trace

-all -after -before
-trace_level=<level> -hex
-max_data_ln=<len>
-Library_Name=<lib>
SQL_Package_Name=<pkg>
-Statement_Name=<stmt>

' '

6.40

Enables DBSL trace; is dynamic. (For more information see SAP Note 395365)

as4/dbmon/enable

['1', '0']

'1'

(> 4.0)

If set to '1', DB performance data will be collected for transactions such as ST04 and DBACOCKPIT. For more information see SAP Note 1083218.

as4/dbmon/classic

['1', '0']

'1'

4.6C (with patches) / V5R4

If set to '1' or database release is lower than V5R4M0 memory based DB monitor is used. Otherwise the plan cache monitor is used. For more information and details see SAP Note 1083218.

SQL Statement Hints

Profile Parameter

Possible Values

Default

From

Description

dbs/db4/alternate_qaqqinilib

<lib>

' '

4.6D

If set, the SQL statement hint 'ALTERNATE_QAQQINILIB' will cause that for hat particular statement the query attributes will be taken from the QAQQINI file in specified library. For more information see SAP Note 485420.

dbs/db4/single_execution_threshold

[ '0' - ??? ]

'2000'

4.6D

Number of statements that go into one single execution SQL package in R3<sid>Y0000. For more information see SAP Note 481868.

dbs/db4/keep_tmp_SQLpkgs

['1' / '0']

'0'

4.6D

If set to '1', SQL packages in R3<sid>Y0000 will not be deleted at system shutdown. This can help for error analysis. For more information see SAP Note 481868.

dbs/db4/dbsl_tablehint<n>

SAP Note 1109771

n/a

6.40

Possibility to have conditional statement hints. For an explanation and information about the usage see SAP Note 1109771.

dbs/db4/auto_package_overflow

['0', '1']

'0'

4.6D only

Use single_execution mode in case of package overflow. For details see SAP Note 1109573.

Performance

Profile Parameter

Possible Values

Default

From

Description

dbs/db4/nqe_optimize_method

[ 'A' / 'F' / 'O' ]

'O'

3.1I

'F' - First I/O
'A' - All I/O
'O' - All I/O (SQE), First I/O (CQE)
See SAP Note 705888.

dbs/db4/odp_threshold

[ '0' - ??? ]

'800'

3.1I

Number of ODP's to be left open

dbs/db4/odp_commit_threshold

[ '0' - ??? ]

'810'

3.1I

Number of ODP's that should trigger an ODP cleanup at commit

dbs/db4/odp_open_threshold

[ '0' - ??? ]

'850'

3.1I

Number of ODP's that should trigger an ODP cleanup at open

dbs/db4/timeout_retry

[ '0' - ??? ]

'3'

3.1I

Total number of attempts to execute an SQL statement when a table or record is locked (SQL0913). Note that this sets the overall time a database request waits for a table (row) to become available to a maximum of <n> * WAITFILE seconds (<n> * WAITRCD seconds).

dbs/db4/parallel_alter_tables

See SAP Note 960392

n/a

7.0

Possibility to schedule exclusive table locks amongst non-exclusive locks. For syntax and usage see SAP Note 960392. Use with care!

Former Member

No comments