News

SAP Documentation

posted 30 Aug 2016, 23:58 by Fabien Reygrobellet   [ updated 3 Sep 2016, 08:10 ]

New Features in ASE 15.7 from QuickStart Guide

posted 28 Sep 2011, 07:14 by Fabien Reygrobellet   [ updated 28 Sep 2011, 11:05 ]

Global variables

@@kernelmode
@@lastkpgendate
@@lwpid
@@nextkpgendate
@@optlevel
@@ospid
@@plwpid
@@remotestate

Functions

cache_usage
create_locator
current_bigdatetime
current_bigtime
dol_downgrade_check
is_singleusermode
locator_literal
locator_valid
lprofile_id
lprofile_name
return_lob
setdata
show_cached_plan_in_xml
show_dynamic_params_in_xml
xact_connmigrate_check
xact_owner_instance

xmlextract
xmlparse
xmlrepresentation
xmltest
xmlvalidate

Commands

alter database ... compression , lob_compression, inrow_lob_length
alter database ... log off ... = size from ... to ...

alter login
alter login profile

alter ... modify owner

alter table ... compressed
alter table ... add lob

alter  thread pool

create database ... compression, lob_compression, inrow_lob_length

create login
create login profile

create table ... compression, lob_compression

create thread pool

dbcc forget_xact

deallocate locator

drop login
drop login profile

dump database ... with shrink_log

merge

select ... into ... compression, lob_compression

set builtin_date_strings
set compression
set send_locator
set show_transformed_sql
set statement_cache

truncate lob

Procedures

-- sp_addlogin

sp_merge_dup_inline_default
sp_monitor_server
sp_opt_querystats
sp_securityprofile
sp_showoptstats

System Tables

syscacheinfo
syscachepoolinfo
syspoolinfo
monDeviceSpaceUsage
monIOController
monLockTimeout
monRepLogActivity
monRepScanners
monRepScannersTotalTime
monRepSenders
monSQLRepActivity
monSQLRepMisses
monTableCompression
monTask
monThread
monThreadPool
monWorkQueue

New Features Bulletin Open Server™ 15.7 and SDK 15.7

posted 22 Sep 2011, 23:05 by Fabien Reygrobellet

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc20155.1570/html/OS_SDK_nf/title.htm

Notes:

- Unsupported platforms:
    Open Server and SDK do not support HP-UX PA-RISC and Mac OS.

- In Adaptive Server 15.7, the maximum offset of a variable-length column for a data-only-locked (DOL) row has been expanded to 32767 bytes, which allows an Adaptive Server configured with a logical-page size greater than 8K to support wide, variable-length, DOL rows.

- Bulk-Library and bcp handling of nonmaterialized columns
    Bulk-Library is enhanced to handle nonmaterialized columns in Adaptive Server 15.7. With this enhancement, you can only use Bulk-Library and bcp version 15.7 and later to bulk-copy-in data into Adaptive Server tables that are altered and contain nonmaterialized columns. Adaptive Server will raise an error when earlier versions of bcp are used to bulk-copy-in data into nonmaterialized columns.


New features in ASE 15.7

posted 13 Sep 2011, 12:36 by Fabien Reygrobellet

ASE 15.7 key features include:

Management of Large Datasets

  • Compression— allows large databases to be stored more compactly and reduces I/O times to ensure high performance on even the largest databases.
  • Reduced Query Latency— helps better handle large data sets, especially those which use dynamic SQL for interactive data retrieval.
  • Replication Performance—increases the performance of Sybase’s industry-leading transaction replication and syncing technology.
  • Enhancements for Parallel Hardware —improves optimization of multi-core/multi-threaded CPU architectures to get the maximum performance out of today’s latest processors

Simplified Administration

  • Online Operations—increases data availability while allowing data to be optimized for application performance.
  • Extended Diagnostics—allows DBAs to quickly pin-point performance bottlenecks and speed customer support requests.
  • Strong Password Encryption—protects the database from external intrusion and hacking
  • Single Sign-on & Login Profiles—makes it easier to manage large numbers of users and simplifies end-user access to the system

Ease of Application Development

  • Efficient Management of Large Objects—inline management of large objects as well as enhanced application development features such as large objects as parameters to stored procedures.
  • Enhanced Application Language Capabilities—many improved TransactSQL&™ language features to increase productivity of application developers as well as support for a variety of popular languages such as Python, PHP and Perl.
  • An Enterprise-Class DB for ISV applications —enhanced business-critical performance for ISV applications out of the box, enabling ISVs to easily write and port their applications to ASE 15.7.

Why You’ll Want to Upgrade to ASE 15.7 ?

posted 8 Sep 2011, 22:14 by Fabien Reygrobellet   [ updated 13 Sep 2011, 12:35 ]


The features fit into a few broad categories:

1. Dealing with large data sets. This includes better management of large objects, as well as enhancements to operational, storage, and data management tasks. With the costs of today’s high-end SANs, data compression may pay for the whole project.

2. Performance and scalability. New features here include better management of dynamic queries (I know that one is going to make friends) as well as a variety of ways to compress data, and better kernel integration for parallel processing performance.

3. More ease of maintenance. ASE 15.7 supports fully recoverable DDL commands such as select into, alter table, and reorg rebuild. In addition, you can now shrink log space, diagnostic support has taken a major step forward, and alter table statements can now be performed without copying data (how about that for speed of internal application upgrades?).

4. Application and developer productivity, including a variety of transact-sql enhancements.

5. Security, including object ownership changing, login profiles, and single sign-on

Sybase

Contact

posted 19 Aug 2011, 01:33 by Fabien Reygrobellet   [ updated 19 Aug 2011, 13:38 ]

email any comments and suggestions to: sybase@reygrobellet.com

And please, click on "+1" Google button !! 

New Article: use of VBoxManage Tool

posted 3 Aug 2011, 04:40 by Fabien Reygrobellet   [ updated 19 Aug 2011, 01:36 ]

New Article: VirtualBox 4.1 New Features

posted 31 Jul 2011, 07:18 by Fabien Reygrobellet

New Article: New Features of BCP and ISQL Tools

posted 31 Jul 2011, 03:02 by Fabien Reygrobellet   [ updated 31 Jul 2011, 03:19 ]

Important unknown new features in ISQL, for example :
- command line history,
- pipe, redirect output,
- error status,
- etc.
 

1-10 of 13