sp_pciconfig

Note: Do not use sp_pciconfig to change arguments or directives unless instructed to do so by SAP Product Support.

Syntax

sp_pciconfig {	disable { directive | argument } |
	enable { directive | argument } |
	list { list_type [, formatted ] | units | units, units_type[, formatted ] } |
	report { directive[, formatted ] |
		directive, args[, formatted ] |
		argument[, formatted ] } |
	update { number_arg, old_value new_value } }

Parameters

disable – disables the specified directive or argument.
directive – is the name of any valid directive.
argument – is the name of any valid argument.
enable – enables a specified directive or argument.
list – lists groups of related arguments as, for example, sp_pciconfig "list", "directive" or sp_pceiconfig "list", "enabled". Also, lists all arguments of a specific type as, for example, sp_pciconfig "list", "units", "switch".
list_type – specifies a type of list. Values are:
- directives – list of directives
- enabled – list of enabled arguments
- disabled – list of disabled arguments
- argnames – list of argument names
formatted – specifies that displayed list is to be formatted for readability.
Note: In formatted reports, the process of improving readability may result in the truncation of wide columns. In addition, column headings may be overridden and may not match the actual table column name. Do not format reports if the output is parsed or potential data truncation is not acceptable.
units – when used with list, generates a list of units_type currently in use.
report – creates a report based on arguments supplied. Usually used to generate a report for an argument to see its current value and whether or not it is enabled. Can also be used to generate a report for a directive or its arguments.
directive – specifies all arguments within a specified directive.
update – modifies the numeric value of arguments where units = number. Cannot be used with arguments where units = switch.
number_arg – is an argument of units = number.
old_value – is the current value for number_arg_name.
new_value – is a new value for number_arg_name.

Usage

Enabling and disabling a directive works like a toggle. When a directive is:

Enabled – the SAP ASE server uses the configured value (enabled or disabled) of each argument. This is the value stored in sybpcidb.
Disabled – the SAP ASE server disregards the configured value (enabled or disabled) of each argument and treats all arguments of the directive as disabled, although the base value of each argument is retained in sybpcidb.

Arguments can be individually enabled or disabled. Arguments for sp_pciconfig directives are of these types:

switch – these arguments turn a feature on or off. For example, if the argument for logging is enabled, a log file is generated; if the argument for logging is disabled, no log file is generated.
string – these arguments are for strings and numbers, which are treated like strings. Enabling a string argument ensures that the SAP ASE server uses the configured value. Disabling a string argument means that the SAP ASE server ignores the configured value and uses the default value. The configured and default values may be the same or different.

Configuration Directives for sp_pciconfig
Directive	Description
PCI_BRIDGE_X_OPT	The PCI Bridge configuration parameters
PCI_BRIDGE_LOGOPT	The plug-in diagserver report facility
PCI_BRIDGE_INSTR	The PCI Bridge instrumentation settings

PCI_BRIDGE_X_OPT Arguments
Argument	Units Type	Default Value	Default State	Description
pci_xopt_maxthreads	number	1056	Enabled	Maximum available PCI Bridge PLB-controlled threads.
pci_xopt_event_scheduling	number	0	Enabled	Default PCI Bridge scheduling.
pci_xopt_failover_engine	number	-1	Enabled	Default engine to which a slot should fail over.
pci_xopt_runtime_alloc_escape	number	1	Enabled	Allow runtime escapes on memory allocation requests above PC Bridge maximum memory allocation unit.
pci_xopt_slotring_cycle	number	-1	Enabled	Disable PCI Bridge slotring washing.
pci_xopt_slotring_wash_th	number	76	Enabled	Default PCI Bridge slotring washing threshold percentage.

PCI_BRIDGE_LOGOPT Arguments
Argument	Units Type	Default Value	Default State	Description
pci_logopt_asehi	switch	None	Disabled	PCI Bridge ASE host interface dispath logging.
pci_logopt_jst	switch	None	Disabled	PCI Bridge Job Scheduler task dispatch logging.
pci_logopt_jvm	switch	None	Disabled	PCI Bridge JVM dispatch logging.
pci_logopt_omni	switch	None	Disabled	PCI Bridge OMNI dispatch logging.
pci_logopt_pci	switch	None	Disabled	Generic PCI Bridge logging (probe [pci/pca]).
pci_logopt_runtime	switch	None	Disabled	PCI Bridge runtime dispatch logging.
pci_logopt_xml	switch	None	Disabled	PCI Bridge XML dispatch logging.

PCI_BRIDGE_INSTR Arguments
Argument	Units Type	Default Value	Default State	Description
BRIDGE	number	1	Disabled	Forces full instrumentation (noisy).
CELL	number	1	Disabled	Forces all CELL synchronization to Report.
JAVA	number	1	Disabled	Forces all Java-related entries to Report.
JCS	number	1	Disabled	Forces all JCS entries to Report.
JDBC	number	1	Disabled	Forces all JDBC entries to Report.
JVMHOST	number	1	Disabled	Forces all ASE JVM host API entries to Report.
JVMJNI	number	1	Disabled	Forces all JVM JNI external extries to Report.
PCIS	number	1	Disabled	Forces all PCI Service code to Report.
PLB	number	1	Disabled	Forces all PLB code to Report.
SLOTRING	number	1	Disabled	Forces all “slot-ring” code to Report.
SYNC	number	1	Disabled	Forces all SYNChronization code to Report.
TPM	number	1	Disabled	Forces all TPM code to Report.
fetch_classdata	number	1	Enabled	Forces all fetch_classdata hits to Report.
pcis_service	number	2	Disabled	Forces all pcis_service hits to Freeze.

Permissions

The permission checks for sp_pciconfig differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage server configuration` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect