New Features of Sybase 12.5 echoaix blog)

 

New Functions of Sybase 12.5 versions

Sort by Sybase PPT
New Features of ase12.5.0.3
1. Performance Monitoring System Table
A new set of system performance monitoring system tables. Using the information in these system tables, It is very convenient to analyze the performance of the ASE server. These performance monitoring system tables are also the basis of DB-XRAY work.
In the installation and configuration documents. This is useful.
Ii. Multiple temporary Databases
Allows you
Create a temporary user database outside the database tempdb. The main purpose of using multiple temporary databases is to reduce competition for system tables and log tables in the temporary database.
Iii. External File System
This allows you to access the external file system through SQL, and map data tables to the file directories or files of the external file system by creating a proxy table.
Access the file directory
Access Files
Licenses
Iv. Application of Java and XML in dB
The Adaptive Server provides a Java Runtime Environment to run Java code in the ASE. The Database Server ASE provides a new method to manage and store data and application logic.
In ase, you can use the Java function in the following three methods:
Use the Java class as the SQL data type
Call the Java method in the database
Store and query XML in a database

5. New Enhanced Functions and new functions
Disk resize
Sampling: update statistics
Variable page size
Large column size
Migrate Utility
ALS (asynchronous Log Service)
Server dynamic parameter configuration
Function
Year (date_expression): the middle-aged part of the expression.
Month (date_expression): Part of the month in the expression
Day (date_expression): the portion of the expression in the upper-right corner.
Str_replace (string_expression1, string_expression2,
String_expression3): replace string_expression2 string in string_expression1 with the value of string_expression3.
Left (character_expression, integer_expression): returns the string with the specified number of characters on the left of the string.
Len (string_expression): returns the number of characters (character) of the string. Note that it is not a number of bytes and does not contain an empty delimiter.
Square (numeric_expression): returns the number of partitions.
Newid ([optionflag]): generates a 32-bit or 36-bit (including a break number) readable random string.

6. SQL Debugger
Ase12.5 provides the debug tool sqldbgr in the command line mode, which can be used to track the storage process and triggers in debug mode.

New Functions of ASE 12.5.1
I. Dynamic Data Cache
ASE 12.5.1 can dynamically change the data cache without restarting the ASE server as in previous versions. With the dynamic sp_cacheconfig function, you can immediately release the memory and re-allocate it from. The Dynamic Function of sp_cacheconfig can be used to complete the following tasks:
Create a new data cache
Expand the cache space of existing data
Change the data cache type
Ii. Automatic growth of database space
ASE 12.5.1 provides the function of Automatically increasing database space and database equipment. When the database space is insufficient, the database first expands the space. When the database equipment space is insufficient, the database equipment expands the space. The automatic growth of database space is set through the sp_dbextend storage process.

Iii. Database loading and unloading
The purpose of loading and detaching a database is to move the database from one ASE server to another. In this way, we can use external ASE commands to copy databases, such as Unix Commands DD or FTP. To copy the database in this way, the ASE server is not required to go down.
There are three steps to uninstall and load the database:
Run the unmount command to uninstall the database.
Copy Related Files
Use the mount command to load the database
Use the online database command to make the database on the target ASE server online

Iv. SQL derived table
SQL derived table is generated by nested select statements.
5. New Date and Time Data Types
ASE 12.5.1 adds two new data types to indicate the time and date: Date and Time
Two functions are added for these two data types:
Current_date (): returns the current date
Current_time (): returns the current time
Vi. Task Scheduler
Job Scheduler Component
An internal ASE task: JS task
An external process: JS agent
Sybmgmtdb database and storage process
Predefined Template)
VII. Further compatibility with the extended functions of ms SQL Server
ASE 12.5.1 is more compatible with the extended functions of ms SQL Server, which facilitates the application of ms SQL Server to Sybase ASE.

New Feature of ASE 12.5.2
I. Statement Cache)
The statement cache allows the ASE to save the executed SQL statement text, so that when the ASE server receives a new SQL statement, it can compare it with the SQL statement in the cache, if a matching SQL statement is found, ASE can use the previous execution plan.
2. Data Backup (dump database) Encryption
Iii. Support for large memory in Linux
64 GB memory is supported after PAE technology is used in ia32 Linux.
Versions earlier than ASE 12.5.2 support up to GB of memory.