sp_pciconfig

Manages the Java PCI Bridge. Enables or disables arguments and directives, changes configuration values, and reports configuration values.

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

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.

SettingDescription
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:

InformationValues
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

Related reference
sp_jreconfig