System Tables

Adaptive Server 15.0.3 adds new columns to several system tables.

Table

Changes

sysqueryplans

New columns:
  • dbid, int null

  • qpdate, datetime null

  • sprocid, int null

  • hashkey2,int null

  • key1, int null

  • key2, int null

  • key3, int null

  • key4, int null

Note: These columns are reserved for future use.

sysprocedures

New column qp_setting varbinary(6) null

Note: This column is reserved for future use.

sysprocesses

New column clientport
  • Displays client port numbers for client processes

  • Displays 0 for system processes

  • Datatype: unsigned smallint

sysservers

The column srvnetname has changed from varchar(32) to varchar(255).

See the Reference Manual: Tables.