spid_instance_id

(Cluster environments only) Returns the instance ID on which the specified process ID (spid) is running.

Syntax

spid_instance_id(spid_value)

Parameters

spid_value – the spid number for which you are requesting the instance ID.

Examples

Example 1 – Returns the ID of the instance that is running process ID number 27:
```
select spid_instance_id(27)
```

Usage

If you do not include a spid value, spid_instance_id returns NULL.
If you enter an invalid or nonexisting process ID value, spid_instance_id returns NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute spid_instance_id.

Parent topic: Transact-SQL Functions

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com