sp_pciconfig

Description

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

NoteDo not use sp_pciconfig to change arguments or directives unless instructed to do so by Sybase Technical 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.

NoteIn 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 will be 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:

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

Permissions

Only a System Administrator can execute sp_pciconfig to change the settings of the PCI subsystem.

Auditing

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

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • 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

See also

Stored procedures sp_jreconfig