- acquire software
- install software
- connect to software
- test and identify new features
*- file issues to implement new features
already downloaded and not installed yet
database running:
sa | [password]
10.168.11.57:5000
here is a quick list of changes.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DATATYPES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
bigtime A bigtime value includes the hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places.
bigdatetime A bigdatetime value includes the year, month, day, hour, minute, second, and fraction of a second to 6 decimal places.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FUNCTIONS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
db_attr Returns the durability, dml_logging, and template settings for the specified database.
object_attr Reports the table’s current logging mode, depending on the session-specific, table-wide, and database-wide settings.
cache_usage Returns cache usage for the cache to which the specified object is bound, as the percentage of the cache which is currently in use by all objects bound to that cache.
current_bigdatetime Returns a bigdatetime value representing the current date and time with microsecond precision.
current_bigtime Returns a bigtime value representing the current time with microsecond precision.
Changed
datepart Produces the specified datepart argument of the specified date as an integer.
datename Produces the specified datepart as a character string.
datediff Calculates the number of date parts between two specified dates or times.
dateadd Adds an interval to a specified date or time.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM STORED PROCEDURES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
sp_deletesmobj Deletes backup objects from the TSM.
sp_querysmobj Retrieves a list of backup objects from the TSM.
Changed
sp_addsegment Updated to manage space in in-memory databases.
sp_addthreshold Updated to manage space in in-memory databases.
sp_bindcache You cannot bind objects or databases to in-memory storage caches, and you cannot bind an in-memory database or objects in an in-memory database to any cache.
sp_cacheconfig Creates, extends the size of, or drops, an in-memory storage cache.
sp_cachestrategy The prefetch and MRU parameters do not apply to tables and indexes in in-memory databases.
sp_dbextend Automatic database expansion is currently not supported for in-memory databases.
sp_deviceattr The directio and dsync device attributes do not apply to in-memory devices.
sp_downgrade Supports downgrading an Adaptive Server containing in-memory or relaxed-durability databases, or databases using templates or minimal logging.
sp_diskdefault You cannot use sp_diskdefault to specify in-memory devices as a default devices.
sp_dropdevice Drops an in-memory device created from an in-memory storage cache.
sp_dropsegment Updated to manage space in in-memory databases.
sp_dropthreshold Updated to manage space in in-memory databases.
sp_extendsegment Updated to manage space in in-memory databases.
sp_help Reports on properties, such as minimal logging attribute, for a table.
sp_helpcache Displays properties of the in-memory storage cache, the in-memory database created on it, and details of free space on this cache.
sp_helpdb Reports on database properties, such as durability, DML logging level, in-memory or not, use, if any, of a template database, or as a template database.
sp_helpdevice Reports the in-memory device properties created from an in-memory storage cache.
sp_modifythreshold Updated to manage space in in-memory databases.
sp_plan_dbccdb Sets up dbccdb for checkstorage execution in an in-memory database.
sp_poolconfig Large I/O buffer pools are not supported in an in-memory database.
sp_post_xpload Supports cross-platform operations for in-memory databases.
sp_tempdb Supports user-created temporary database groups, login or application bindings to temporary database groups and for in-memory databases.
sp_unbindcache
sp_unbindcache_all You cannot unbind objects in or the in-memory database itself from the host in-memory storage cache.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMANDS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
transfer table
Initiates an incremental table transfer.
A new grant with grant option supports transfer table. It grants a specified user permission to transfer a specified table.
grant transfer table on table_name to user with grant option
Changed
alter database
Syntax added to support changing the durability of a database, the level of DML logging, a database’s template.
alter table
Syntax added to support changing a table’s logging mode for insert, update, and delete (DML) operations.
Syntax added to support transfer table:
set transfer table [on | off]
create database
Syntax added to create in-memory and relaxed-durability databases with durability set to full, no_recovery, or at_shutdown.
Syntax added to specify DML logging level and template database, if any.
create table
Syntax added to specify DML logging level for tables in in-memory databases.
Syntax added to support transfer table:
with transfer table [on | off]
disk init
Syntax added to create in-memory data devices for in-memory databases.
dump database
Syntax added to support the Tivoli Storage Manager (TSM). The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name to "syb_tsm::object_name"
dump database ... compression=
Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
dump transaction
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name to "syb_tsm::object_name"
dump transaction ... compression=
Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
load database
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name"
load transaction
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name"
select into
Syntax added to specify the DML logging level for tables created by selecting into in-memory or relaxed-durability databases.
set
Adds:
* dml_logging parameter for specifying the amount of logging for a session.
* deferred_name_resolution for activating deferred name resolution at the connection level.
* builtin_date_strings number
Values are:
o 0 - if a string is given as an argument to a chronological system function, the server interprets it as a datetime value regardless of its apparent precision. This is the default.
o 1 - makes the server interpret the argument string as bigdatetime. This affects the result of chronological system functions.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CONFIGURATION PARAMETERS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
create procedure: deferred name resolution
Allows you to create procedures using deferred name resolution. Values are:
* 0 – disables deferred name resolution. This is the default.
* 1 – enables deferred name resolution.
builtin date strings
Values are:
* 0 – causes string literals given to a chronological builtin function as an argument to be interpreted as a datetime type.
* 1 – causes string literals given to a chronological builtin function as an argumen
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM TABLES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
spt_TableTransfer
Stores the results from table transfers.
Changed
sysdevices
Lists the in-memory storage cache under the name and phyname columns. In-memory devices do not include a full path to the disk device, instead, they store the name of the cache on which the in-memory device has been created.
sysdatabases
Adds the durability column, which indicates the durability level of the database. The durability column has the int datatype. Its values are:
* 1- full
* 5- at_shutdown
* 6- no_recovery
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
here is a quick list of changes.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DATATYPES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
bigtime A bigtime value includes the hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places.
bigdatetime A bigdatetime value includes the year, month, day, hour, minute, second, and fraction of a second to 6 decimal places.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FUNCTIONS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
db_attr Returns the durability, dml_logging, and template settings for the specified database.
object_attr Reports the table’s current logging mode, depending on the session-specific, table-wide, and database-wide settings.
cache_usage Returns cache usage for the cache to which the specified object is bound, as the percentage of the cache which is currently in use by all objects bound to that cache.
current_bigdatetime Returns a bigdatetime value representing the current date and time with microsecond precision.
current_bigtime Returns a bigtime value representing the current time with microsecond precision.
Changed
datepart Produces the specified datepart argument of the specified date as an integer.
datename Produces the specified datepart as a character string.
datediff Calculates the number of date parts between two specified dates or times.
dateadd Adds an interval to a specified date or time.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM STORED PROCEDURES
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
sp_deletesmobj Deletes backup objects from the TSM.
sp_querysmobj Retrieves a list of backup objects from the TSM.
Changed
sp_addsegment Updated to manage space in in-memory databases.
sp_addthreshold Updated to manage space in in-memory databases.
sp_bindcache You cannot bind objects or databases to in-memory storage caches, and you cannot bind an in-memory database or objects in an in-memory database to any cache.
sp_cacheconfig Creates, extends the size of, or drops, an in-memory storage cache.
sp_cachestrategy The prefetch and MRU parameters do not apply to tables and indexes in in-memory databases.
sp_dbextend Automatic database expansion is currently not supported for in-memory databases.
sp_deviceattr The directio and dsync device attributes do not apply to in-memory devices.
sp_downgrade Supports downgrading an Adaptive Server containing in-memory or relaxed-durability databases, or databases using templates or minimal logging.
sp_diskdefault You cannot use sp_diskdefault to specify in-memory devices as a default devices.
sp_dropdevice Drops an in-memory device created from an in-memory storage cache.
sp_dropsegment Updated to manage space in in-memory databases.
sp_dropthreshold Updated to manage space in in-memory databases.
sp_extendsegment Updated to manage space in in-memory databases.
sp_help Reports on properties, such as minimal logging attribute, for a table.
sp_helpcache Displays properties of the in-memory storage cache, the in-memory database created on it, and details of free space on this cache.
sp_helpdb Reports on database properties, such as durability, DML logging level, in-memory or not, use, if any, of a template database, or as a template database.
sp_helpdevice Reports the in-memory device properties created from an in-memory storage cache.
sp_modifythreshold Updated to manage space in in-memory databases.
sp_plan_dbccdb Sets up dbccdb for checkstorage execution in an in-memory database.
sp_poolconfig Large I/O buffer pools are not supported in an in-memory database.
sp_post_xpload Supports cross-platform operations for in-memory databases.
sp_tempdb Supports user-created temporary database groups, login or application bindings to temporary database groups and for in-memory databases.
sp_unbindcache
sp_unbindcache_all You cannot unbind objects in or the in-memory database itself from the host in-memory storage cache.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMANDS
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
transfer table
Initiates an incremental table transfer.
A new grant with grant option supports transfer table. It grants a specified user permission to transfer a specified table.
grant transfer table on table_name to user with grant option
Changed
alter database
Syntax added to support changing the durability of a database, the level of DML logging, a database’s template.
alter table
Syntax added to support changing a table’s logging mode for insert, update, and delete (DML) operations.
Syntax added to support transfer table:
set transfer table [on | off]
create database
Syntax added to create in-memory and relaxed-durability databases with durability set to full, no_recovery, or at_shutdown.
Syntax added to specify DML logging level and template database, if any.
create table
Syntax added to specify DML logging level for tables in in-memory databases.
Syntax added to support transfer table:
with transfer table [on | off]
disk init
Syntax added to create in-memory data devices for in-memory databases.
dump database
Syntax added to support the Tivoli Storage Manager (TSM). The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name to "syb_tsm::object_name"
dump database ... compression=
Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
dump transaction
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name to "syb_tsm::object_name"
dump transaction ... compression=
Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
load database
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name"
load transaction
Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).
database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name"
select into
Syntax added to specify the DML logging level for tables created by selecting into in-memory or relaxed-durability databases.
set
Adds:
* dml_logging parameter for specifying the amount of logging for a session.
* deferred_name_resolution for activating deferred name resolution at the connection level.
* builtin_date_strings number
Values are:
o 0 - if a string is given as an argument to a chronological system function, the server interprets it as a datetime value regardless of its apparent precision. This is the default.
o 1 - makes the server interpret the argument string as bigdatetime. This affects the result of chronological system functions.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CONFIGURATION PARAMETERS
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
create procedure: deferred name resolution
Allows you to create procedures using deferred name resolution. Values are:
* 0 – disables deferred name resolution. This is the default.
* 1 – enables deferred name resolution.
builtin date strings
Values are:
* 0 – causes string literals given to a chronological builtin function as an argument to be interpreted as a datetime type.
* 1 – causes string literals given to a chronological builtin function as an argumen
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM TABLES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
New
spt_TableTransfer
Stores the results from table transfers.
Changed
sysdevices
Lists the in-memory storage cache under the name and phyname columns. In-memory devices do not include a full path to the disk device, instead, they store the name of the cache on which the in-memory device has been created.
sysdatabases
Adds the durability column, which indicates the durability level of the database. The durability column has the int datatype. Its values are:
* 1- full
* 5- at_shutdown
* 6- no_recovery
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
did an intial pass through and made some changes. there are some issues with the 2 new datatypes and there is a bug filed for it to niels.
did an intial pass through and made some changes. there are some issues with the 2 new datatypes and there is a bug filed for it to niels.
Issue #4771 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
already downloaded and not installed yet