 Sybase Tips & Tricks by Rob Verschoor | |||
|
|
|
||||||||||||||||||||||||
|
Since version 12.0, some new ASE features are available as licensable options, requiring license keys. Examples are the Java-in-ASE feature in 12.0+ (the ASE_JAVA license key), and the native XML engine in 12.5.1+ (the ASE_XML license key).
To enable a licensable feature, you need to install the corresponding license key in the license file. In most cases, you'll also need to enable a configuration setting: to use Java-in-ASE, the ASE_JAVA key must be installed and the configuration parameter 'enable java' must be set to 1. If you're using licensable options (for example, when you're running the free ASE Developer's Edition), you may find the stored procedure sp_license useful. This procedure displays the status of all licensable options in your ASE server along with the setting of the corresponding configuration parameter. Download & install The stored procedure sp_license can be downloaded here. Install it by downloading the file and executing it with isql (sa_role required). Examples These are some examples of sp_license: 1> sp_license 2> go Current ASE server: TEST1252 (12.5.2/EBF 11948 ESD#1/P/) License Option Description Option Status Cfg.Value(run) --------------- ---------------------------- ----------------- -------------- ASE_SERVER Enterprise Edition Disabled ASE_SBE ASE Small Business Edition Disabled ASE_DEV ASE Developer's Edition Enabled ASE_HA High Availability Enabled Disabled (0) ASE_JAVA Java-in-ASE Enabled Enabled (1) ASE_ASM Advanced Security Mechanisms Enabled Disabled (0) ASE_DTM Distributed Transaction Mgt. Enabled Disabled (0) ASE_EJB Enterprise Java Beans Enabled Disabled (0) ASE_XFS External File Systems Enabled Disabled (0) ASE_EFTS Full text search Disabled Disabled (0) ASE_DIR LDAP pre-12.5.0.2 only ASE_DIRS LDAP Enabled Enabled (1) ASE_XRAY DBXRay Disabled ASE_XML Native XML in ASE Enabled Disabled (0) ASE_WEBSERVICES Webservices in ASE Enabled Disabled (0) ASE_MESSAGING Real-Time Database Services Enabled Enabled (1) (return status = 0) 1> sp_license ASE_XML 2> go Current ASE server: TEST1252 (12.5.2/EBF 11948 ESD#1/P/) License Option Description Option Status Cfg.Value(run) --------------- ---------------------------- ----------------- -------------- ASE_XML Native XML in ASE Enabled Disabled (0) To enable the 'ASE_XML' option, the ASE configuration parameter 'enable xml' must also be enabled. The current run value is 0 (=Disabled) (return status = 0) |
||||||||||||||||||||||||
|
