Changes for version 10.00

Version 10.00 contains new sysmaster database tables and new SMI tables.

The version 10.00 sysmaster database contains these new tables:

sysdirectives sysbufpool, a system-monitoring interface (SMI)

The following changes were made to other SMI tables:

  • The sysfragments table contains a Partition column and the Flags column now tells you if the fragmentation scheme has partitions.
  • The sysusers table contains a defrole column.
  • The sysams table contains an am_truncate column.
  • The sysprocedures table contains a rtnparameters column for information about INOUT parameters.
  • The syspaghdr table has a pg_pagesize column.
  • The sysptnhdr table has a pagesize column.
  • The sysptnhdr table has a bpoolindx column that indicates which buffer pool the buffer is in.
  • The sysbufhdr table has a bufsize column, which indicates the buffer page size.
  • The sysdbstab and syschktab tables have pagesize columns.
  • The views syschunks and sysdbspaces tables have a pagesize columns.
  • The views systabinfo table has a ti_pagesize column.
  • The views systabpaghdrs and sysphyspaghdrs tables have pg_pagesize columns.

In addition, tables added to the sysscdr database are removed.


Copyright© 2018 HCL Technologies Limited