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 | ' ' | 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 |
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! |