System Procedure Changes

Sybase IQ version 15.3 includes changes to system procedures.

sp_iqconnection Procedure Changes

The sp_iqconnection system procedure includes a new column:

LSNAME

See these topics in the Sybase IQ documentation:

Reference: Building Blocks, Tables, and Procedures > System Procedures > System Stored Procedures > sp_iqconnection Procedure
Using Sybase IQ Multiplex > Multiplex Reference > System Procedures > sp_iqconnection Procedure

sp_iqcontext Procedure Changes

The sp_iqcontext system procedure column name ConnOrCursor has changed to ThreadType.

The procedure includes a new column:

Attributes

See this topic in the Sybase IQ documentation:

Reference: Building Blocks, Tables, and Procedures > System Procedures > System Stored Procedures > sp_iqcontext Procedure

sp_iqmpxinfo Procedure Changes

The sp_iqmpxinfo system procedure includes new columns:

SYSIQMPXSERVER.private_connection_info
mipc_priv_state
mipc_public_state

In Sybase IQ 15.3, running this procedure from the coordinator returns a row for every node. In earlier versions, it returned a row for the current node only on a secondary node.

See this topic in the Sybase IQ documentation:

Using Sybase IQ Multiplex > Multiplex Reference > System Procedures > sp_iqmpxinfo Procedure