System Tables

Adaptive Server 15.7 ESD #2 contains changed system tables.

Changed System Tables
System Table Column Added Description
sysattributes
  • object_cinfo2
  • object_datetime
  • Provides a character description for the object
  • Provides the date and time for the object
  • The SP object_type stores options related to RSA key-pair regeneration and LR object_type, which stores options related to login profiles
sysobjects type Adds the
  • RS – indicates a precomputed result set
  • PP – indicates the predicate of a privilege
sysprotects
  • pred_id
  • protstatus
  • Object ID of predicated privileg
  • One of:
    • PROT_PREDICATED – indicates that the privilege (or denial) is predicated
    • PROT_ROW_FILTER – indicates that the predicate is a where clause
Object ID of predicated privileg
The datatypes for these columns in these tables have changed from int to unsigned int:
Columns That Changed From in To unsigned int
Table Column
sysusages
  • lstart
  • size
  • unreservedpgs
sysaltusages
  • lstart
  • size
syspartitions
  • firstpage
  • rootpage
  • dataoampage
  • indoampage
systabstats
  • leafcnt
  • pagecnt
  • emptypgcnt
  • warmcachepgcnt
  • unusedcnt
  • oampgct
syslocks page
syslogshold page
systhresholds free_space