View this release bulletin as PDF
Contents
1. 8 1 Reconfiguring from utf8 with external sort order CR 333614 Before Adaptive Server version 12 5 1 the utf8 character set could be used only with the binary sort order However Adaptive Server release 12 5 1 supports non binary sort orders with the utf8 character set If you use utf8 and then configure an external sort order see Table 2 you cannot reconfigure Adaptive Server with another character set without first reverting to the binary sort order with utf8 After reverting to binary sort order which has an ID of 50 you can then safely change to any other character set If you change the character set without first going to the binary sort order with utf8 recovery of the master database hangs and Adaptive Server displays error message 1569 Unable to get a conversion handler for the built in sort function If this occurs you must download and start Adaptive Server version 12 5 1 ESD 1 or later to successfully bring up a server see the Sybase Web site at http www sybase com for information about downloading Adaptive Server ESDs Check with Sybase support for the availability of Adaptive Server version 12 5 1 ESD 1 Alternatively you can re create the master device and load from database dumps Table 2 lists the external sort orders for utf8 and their IDs Table 2 External sort orders Sort order Sort order ID bigsbin i94 cp932bin 192 cyrdict 140 eucjisbn 192 euckscbn 161 gb2. Adaptive Server Enterprise Monitor Server 12 5 1 Monitor Client Library 12 5 1 Historical Server 12 5 1 Software Developer s Kit SDK 12 5 1 ASE Edition which includes the following e Open Client 12 5 1 ASE Edition e Embedded SQL C 12 5 1 ASE Edition Language Modules 12 5 1 jConnect for JDBC 5 5 Java utilities e jisql 2 0 e Ribo 2 0 Sybase Central 4 x 2 3 PC client components The PC client CD includes the following components which can be installed on Windows Software Development Kit SDK 12 5 1 ASE Edition which includes the following e Open Client 12 5 1 ASE Edition e Embedded SQL C 12 5 1 ASE Edition e Embedded SQL Cobol 12 5 1 ASE Edition Open Client Runtime 12 5 1 ODBC 4 2 OLE DB 2 7 jConnect 5 5 and related documentation Java utilities e jisql 2 0 e Ribo 2 0 InfoMaker 9 0 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 3 Special installation instructions e Language Modules 12 5 1 e XA Interface Library for ASE Distributed Data Manager 12 5 1 e Physical Architect 8 0 e SQL Remote 7 0 2 e Monitor Client Library 12 5 1 e PowerDesigner 9 5 2 Note Java Central is installed with PowerDynamo not Adaptive Server The only plug in that comes with Adaptive Server is the Adaptive Server Enterprise plug in for Sybase Central Java Edition 12 5 1 2 4 Operating system updates Adaptive Server version 12 5 1 supports the fo
3. appropriate Sybase product Select the Release Bulletins link Select the Sybase product version from the Release Bulletins list From the list of individual documents select the link to the release bulletin for your platform You can either download the PDF version or browse the document online 2 Product summary Enclosed is Sybase Adaptive Server Enterprise version 12 5 1 Server and client components are distributed on separate CDs For details on system requirements including disk space and RAM see the installation guide for your platform For more information specific to jConnect for JDOBC jisql and Ribo see the jConnect documentation This release bulletin provides the latest information about Adaptive Server and its known problems as well as documentation updates and clarifications 2 1 Installation kit The installation kit includes The server CD for contents list see Server components on page 3 The PC client CD contains software client components to be installed on Windows NT Windows 2000 XP Pro and Windows 2003 computers Release Bulletin for Adaptive Server Enterprise Version 12 5 1 for Linux this document Installation Guide for Adaptive Server Enterprise 12 5 1 for Linux 2 2 Server components The Server CD includes the following components Release Bulletin for Linux Itanium Adaptive Server 12 5 1 2 Product summary Adaptive Server Enterprise Version 12 5 1
4. are no longer allowed in create view statements Workaround To allow dynamic and host variables with this incorrect behavior in create view statements start Adaptive Server with trace flag 108 dataserver dd_master T108 9 Product compatibilities This section lists the Sybase components that are compatible with Adaptive Server Enterprise version 12 5 and later For information about operating system requirements see individual component documentation The following components have been tested for compatibility with Adaptive Server 12 5 and later Release Bulletin for Linux Itanium 15 10 Documentation updates and clarifications Adaptive Server Enterprise Version 12 5 1 e Sybase Character Sets 3 0 e Sybase Central viewer 4 x e jConnect for JDBC 4 5 e jConnect for JDBC 5 5 e Open Server 12 5 e SDK 12 5 e Open ServerConnect CICS IMS MVS 4 0 e Open ClientConnect CICS IMS MVS 4 0 e ODBC Driver for Adaptive Server 12 5 e OLE DB Provider for Adaptive Server 12 5 Note Backup Server 12 5 is compatible with Backup Server 11 9 2 1 and 12 0 Either server can be local or remote Backup Server 12 5 is compatible with versions of Backup Server earlier than 11 9 2 1 only if the Backup Server 12 5 is the remote server 10 Documentation updates and clarifications This section describes changes and additions to the Adaptive Server version 12 5 1 documentation set 10 1 Utility Guide 10 1 1 dataserver
5. recommends that you display the configuration utilities on a local Linux system console or set the DISPLAY value to point to a workstation using another platform such as Microsoft Windows 8 2 4 Display variable set for Exceed TM X When using the server configuration utilities with a DISPLAY variable set to a Microsoft Windows platform using the Exceed TM X Window Server Sybase recommends you use Exceed TM version 6 2 0 0 or later 10 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 8 Known problems 8 3 alter table and triggers with if update clauses CR 199655 If a trigger contains an if update clause data modifications that should fire the trigger that are performed after executing alter table add alter table drop alter table lock or alter table modify may cause errors in column references Triggers on the altered table that use an if update clause in the body of the trigger to reference a column may not fire or may fire incorrectly Workaround After the alter table operation has completed drop and re create all triggers on the altered table Doing so causes the if update clause in the triggers to correctly reference the new columns by their new column offsets so the trigger code executes correctly 8 4 Truncation error using select with power function and numeric argument CR 236723 If you use the select command with the function power and use a numeric argument the result
6. 12 5 1 e add an index to the DOL table which can be used to prevent a table scan or e convert the DOL table to an APL table 10 6 2 Multiple temp databases The information on multiple temdbs was inadvertently included in the Performance and Tuning Guide This information should be in the System Administration Guide and will be moved there on the next update Login bindings to multiple tempdbs In prior versions only a user with the sa role could be bound to a tempdb As of this version of Adaptive Server any user can also be bound to an application at the time of login For example If there is a binding for login user1 and for application isql when user1 logs in with application isq the user1 binding determines the tempdb assigned to the session not the isql binding 11 Technical support Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support If you have any questions about this installation or if you need assistance during the installation process ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area 12 Other sources of information Use the Sybase Getting Started CD the Sybase Technical Library CD and the Technical Library Product Manuals Web site to learn more about your product e The Getting Started CD contains release bulletins and installation guide
7. 13 8 16 Network license daemon support 12 8 17 bcp and abstract data types 14 8 18 Referencing Java data in a nonrecovered database 14 8 19 Configuring connectivity for clients accessing wide data 14 8 20 Handling multibyte character sets during migration 15 8 21 Adaptive Server plug in default character set and language 15 8 22 Dynamic and host variables not allowed in DDL statements 15 9 Product compatibilities 15 10 Documentation updates and clarifications 16 10 1 Utility Guide 16 10 2 Transact SQL User s Guide 19 10 3 Reference Manual Building Blocks 19 10 4 Reference Manual Commands 20 10 5 System Administration Guide 23 10 6 Performance and Tuning Guide 23 11 Technical support 24 12 Other sources of information 24 12 1 Sybase certifications on the Web 25 12 2 Sybase EBFs and software maintenance 26 1 Accessing current release bulletin information A more recent version of this release bulletin may be available on the Web To check for critical product or document information added after the release of the product CD use the Sybase Technical Library Product Manuals Web site 2 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 2 Product summary v Accessing release bulletins at the Technical Library Product Manuals Web site 1 2 3 4 5 Go to Product Manuals at http Avww sybase com support manuals Follow the links to the
8. 21 10 Documentation updates and clarifications Adaptive Server Enterprise Version 12 5 1 Example 1 Suppresses the output of both parameters and the return status TDS token 1 gt set proc_output_params OFF 2 gt go l gt set proc_return_status OFF 2 gt go 1 gt declare x int 2 gt select x 2 3 gt exec sp pout x output 4 gt print Value of x returned from sproc is 1 x 5 gt go 1 row affected Value of x returned from sproc is 3 1 row affected In addition you can also suppress the lines reporting the number of rows affected to generate output with no extra messages using the set nocount on option before running this batch Example 2 Suppresses the output of parameter information l gt create procedure sp pout x int output as select x x 1 2 gt go 1 gt set proc_output_params off 2 gt go 1 gt declare x int 2 gt select x 1 3 gt exec sp pout x output 4 gt print Value of x returned from sproc is 1 x 5 gt go 1 row affected return status 0 Value of x returned from sproc is 2 22 If you do not perform set proc_output_params off the output after return status 0 includes the following Return parameters Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 10 Documentation updates and clarifications 10 5 System Administration Guide CR 322843 In the System Administration Guide Chapter 12 Auditing Table 12 6 Values in eve
9. 2312bn 137 gbpinyinbn 163 rusdict 165 sjisbin 179 SYBASE collate unicode also lists the sort orders and their IDs Release Bulletin for Linux Itanium 9 8 Known problems Adaptive Server Enterprise Version 12 5 1 8 2 Server configuration utilities 8 2 1 srvbuild utility too small to reveal buttons For srvbuild running on the Linux Itanium platform the final screen of srvbuild is too small to display the buttons at the bottom of the screen Workaround To display the buttons for example to exit the program select the bottom edge of the srvbuid window and drags it downward enough to reveal the buttons Once the buttons are displayed srvbuild behaves correctly 8 2 2 Using srvbuild to create servers on raw devices CR 339805 If you use srvbuild to create the master or sybsystemprocs database devices on raw devices on a system running the Linux operating system make sure you have read permissions on the dev rawct file If you do not have read permissions on this file srvbuild issues a message saying Permission denied and will not allow you to create these database devices 8 2 3 Display variable set for Solaris You may find that the server configuration utilities srvbuild dsedit sqlloc sqlupgrade and asecfg cannot be run when the local DISPLAY variable is set to a Solaris workstation If you may see an error from the X11 windowing system that indicates a BadLength error has occurred In this case Sybase
10. Building Blocks 10 3 1 verison_as_integer update In Chapter 3 Global Variables in Reference Manual Building Blocks the definition for version_as_integer states Returns the version of the current release of Adaptive Server as an integer This information should read Returns the number of the last upgrade version of the current release of Adaptive Server as an integer For example version_as_integer returns 12500 if you are running Adaptive Server version 12 5 12 5 0 3 or 12 5 1 Release Bulletin for Linux Itanium 19 10 Documentation updates and clarifications Adaptive Server Enterprise Version 12 5 1 10 3 2 set_appcontext update In the reference page for set_appcontext in Chapter 2 Transact SQL Functions in Reference Manual Building Blocks the parameter for attribute_value is incorrectly stated as being a char 2048 The correct datatype is char 30 and should appear as follows attribute_value is a row that specifies and application attribute value It is saved as the datatype char 30 10 4 Reference Manual Commands 10 4 1 dbcc check parameter Syntax Keywords and options Comments The following description of the dbcc check command should be included in Reference Manual Commands dbcc upgrade_object dbid dbname compiled_object_name view procedure default rule default trigger force check check checks syntax fo
11. Release Bulletin Adaptive Server Enterprise Version 12 5 1 for Linux Itanium Document ID DC20071 01 1251 01 Last revised November 2003 Topic V e Q o 1 Accessing current release bulletin information 2 Product summary 2 1 Installation kit 2 2 Server components 2 3 PC client components 2 4 Operating system updates 3 Special installation instructions 3 1 Known installation issues 4 Special upgrade instructions 4 1 Adaptive Server 12 5 1 backward compatibility 5 Product and platform interoperability 6 New functionality in this version 6 1 sysconfig is not Section 508 compliant 6 2 PowerTransfer 7 SDK compatibility issues 8 Known problems 8 1 Reconfiguring from utf8 with external sort order 8 3 alter table and triggers with if update clauses OO CO CO CO CO CO A AIAJ NY TN TY BY WY W W N pa j 8 4 Truncation error using select with power function and numeric argument em 8 5 SQL derived tables cannot have unnamed columns Copyright 1989 2004 by Sybase Inc All rights reserved Sybase the Sybase logo AccelaTrade ADA Workbench Adaptable Windowing Environment Adaptive Component Architecture Adaptive Server Adaptive Server Any where Adaptive Server Enterprise Adaptive Server Enterprise Monitor Adaptive Server Enterprise Replication Adaptive Server Everywhere Adaptive Server IQ Adaptive War
12. S YBASE_ASE bin to SYBASE SYBASE_OCS bin e certauth e certpk12 e certreq 10 1 5 bep clarification 18 In the section bcp modes in Chapter 3 Using bcp to Transfer Data to and from Adaptive Server in the Utility Guide the definitions of bcp in were reversed and incorrectly stated as bcp in works in one of two modes Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 10 Documentation updates and clarifications e Fast bcp logs each row insert that it makes used for tables that have one or more indexes or triggers e Slow bcp logs only page allocations copying data into tables without indexes or triggers at the fastest speed possible The correct definitions are as follows bcp in works in one of two modes e Slow bcp logs each row insert that it makes used for tables that have one or more indexes or triggers e Fast bcp logs only page allocations copying data into tables without indexes or triggers at the fastest speed possible 10 2 Transact SQL User s Guide In Sorting Query results in Chapter 3 the word aggregates has been dropped from this sentence Adaptive Server does not allow subqueries variables and constant expressions in the order by list A successful example in the following section order by and group by uses the aggregate function avg price in an order by clause order by avg price 10 3 Reference Manual
13. aptive Client Client Server Server Server Replication Replication Replication Adaptive Server 12 5 1 12 0 12 5 1 12 0 Server 12 6 Server 12 5 Server 12 1 Apple Mac OS X N A x N A x N A N A HP Tru64 UNIX 5 x X X X X X X HP HP UX 11 x X X X X X X IBM RS 6000 AIX 4 3 x x x X X X X IBM RS 6000 5 1 X X X X X X Red Hat Enterprise 2 1 N A X N A X X N A Silicon Graphics IRIX N A X N A X X N A Sun Solaris X X X X X X Microsoft Windows X X X X X X Legend e X compatibility e N A incompatibility or the product is not available for that version platform combination Note 1 Open Client Server 12 5 1 is currently scheduled for release in December 2003 and Replication Server 12 6 is currently scheduled for release in November 2003 dates may be subject to change Note 2 12 5 1 is ashelf replacement for the 12 5 versions of Adaptive Server and Open Client Server Therefore the 12 5 version of either product is compatible with 12 5 1 although Sybase strongly recommends that customers upgrade to 12 5 1 as soon as possible Note 3 Even though two or more products may be interoperable features introduced in a newer version of a product are not likely to be supported with older versions of the same or other products For the latest interoperability report on these products see the MySybase Web site at http my sybase com detail id 1026087 Release Bulletin for Linux Itanium 7 6 New functionality in this v
14. checks Please wait If this happens the console from which InstallShield was executed displays a message similar to NFS3 server lt some server gt not responding still trying Workaround kill InstallShield Unmount the inaccessible NFS device Retry the installation 4 Special upgrade instructions This section provides information for upgrading to Adaptive Server version 12 5 1 that is not included or should be corrected in the installation guide 4 1 Adaptive Server 12 5 1 backward compatibility Before using Adaptive Server 12 5 1 features make sure you read the Technote Adaptive Server 12 5 1 Backward Compatibility at the Sybase Web site at http Awww sybse com support techdocs You can to earlier 12 5 x versions of Adaptive Server but to do so you must take the precautions described in the technical note before using any of the new 12 5 1 features 6 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 5 Product and platform interoperability 5 Product and platform interoperability This section shows the interoperability of Adaptive Server Replication Server and Open Client Server OCS products across versions For specific platform or operating system level information see the respective product certification reports at http www sybase com Table 1 Interoperability between Replication Server Open ClientServer and Adaptive Server Open Open Ad
15. clarification 16 In the dataserver reference page in the Utility Guide Example 2 is incorrect It currently reads Example 2 rewrites a corrupt model database dataserver d my_master_ device w model The correct example is Example 2 rewrites a corrupt model database dataserver d d_master w model s server _name Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 10 Documentation updates and clarifications 10 1 2 ddigen update The existing description of the S parameter in ddlgen is e Shost_name port_number specifies the host name or IP address of Adaptive Server as well as its port number Separate host_name and port_number with a colon without spaces before or after it Note You must use the S option because ddigen does not connect to a default server The updated description is as follows e Sserver specifies the name of the Adaptive Server ddlgen looks this name up in the interfaces file or LDAP configuration file If you specify e S host_name port_number ddigen uses the host_name and port_number provided and neither interfaces nor LDAP configuration files are read or parsed e S server I ddigen parses the interfaces file specified at the user location for the server name see the parameter description for more information e S server without specifying an interfaces file ddigen 1 Tries to read the LDAP configuration file f
16. ehouse Anywhere Studio Application Manager AppModeler APT Workbench APT Build APT Edit APT Execute APT FORMS APT Translator APT Library AvantGo AvantGo Application Alerts AvantGo Mobile Delivery AvantGo Mobile Document Viewer AvantGo Mo bile Inspection AvantGo Mobile Marketing Channel AvantGo Mobile Pharma AvantGo Mobile Sales AvantGo Pylon AvantGo Pylon Application Server AvantGo Pylon Conduit AvantGo Pylon PIM Server AvantGo Pylon Pro Backup Server Biz Tracker ClearConnect Client Library Client Services Convoy DM Copernicus Data Pipeline Data Workbench DataArchitect Database Analyzer DataExpress DataServer DataWindow DB Library dbQueue Developers Workbench Direct Connect Anywhere DirectConnect Distribution Director e ADK E Anywhere e Biz Integrator E Whatever EC Gateway ECMAP ECRTP eFulfillment Accelerator Embedded SQL EMS Enter prise Application Studio Enterprise Client Server Enterprise Connect Enterprise Data Studio Enterprise Manager Enterprise SQL Server Manager Enterprise Work Architecture Enterprise Work Designer Enterprise Work Modeler eProcurement Accelerator EWA Financial Fusion Financial Fusion Server Gateway Manager GlobalFIX ImpactNow Industry Warehouse Studio InfoMaker Information Anywhere Information Everywhere InformationConnect InternetBuilder iScript Jaguar CTS jConnect for JDBC Mail Anywhere Studio MainframeConnect Maintenance Express Manage Anywhere Studio M Busin
17. ersion Adaptive Server Enterprise Version 12 5 1 6 New functionality in this version This section describes changed functionality in Adaptive Server version 12 5 1 that is not included in the What s New in Adaptive Server 12 5 1 6 1 sysconfig is not Section 508 compliant syconfig is not Section 508 compliant If you are unable to use sysconfig see the System Administration Guide for alternative methods of configuring Adaptive Server 6 2 PowerTransfer PowerTransfer is an extension to PowerDesigner that allows the transfer of data into Adaptive Server The source database can be any ODBC data source supported by PowerDesigner PowerTransfer uses the Sybase bulk copy mechanism bcp for high performance inserts into Adaptive Server 7 SDK compatibility issues 7 1 Notes for installing version 12 5 1 SDK Sybase will release Open Server 12 5 1 before the end of 2003 at the same time as the SDK 12 5 1 point product If you continue to use your current 12 5 SDK installation be sure to install Adaptive Server 12 5 1 in a separate directory Make sure that your SYBASE and load library path variables for example LD_LIBRARY_PATH on Solaris LIBPATH on IBM AIX or HP Tru64 UNIX and so on point to the older SDK installation directory 8 Known problems This section describes known problems and workarounds for Adaptive Server 8 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 8 Known problems
18. ess Channel M Business Network M Business Server MDI Access Server MDI Database Gateway media splash MetaWorks My AvantGo My AvantGo Media Channel My AvantGo Mobile Marketing MySupport Net Gateway Net Library New Era of Networks ObjectConnect ObjectCycle OmniConnect OmniSQL Access Module OmniSQL Toolkit Open Biz Open Client Open ClientConnect Open Client Server Open Client Server Interfaces Open Gateway Open Server Open ServerConnect Open Solutions Optima Orchestration Studio PB Gen PC APT Execute PC Net Library PocketBuilder Pocket PowerBuilder Power powerstop PowerAMC PowerBuilder PowerBuilder Foundation Class Library PowerDesigner Pow erDimensions PowerDynamo PowerJ PowerScript PowerSite PowerSocket Powersoft PowerStage PowerStudio PowerTips Powersoft Portfolio Powersoft Professional PowerWare Desktop PowerWare Enterprise ProcessAn alyst Rapport Report Workbench Report Execute Replication Agent Replication Driver Replication Server Replication Server Manager Replication Toolkit Resource Manager RW DisplayLib S Designor SDF Secure SQL Server Secure SQL Toolset Security Guardian SKILS smart partners smart parts smart script SQL Advantage SQL Anywhere SQL Anywhere Studio SQL Code Checker SQL Debug SQL Edit SQL Edit TPU SQL Everywhere SQL Modeler SQL Remote SQL Server SQL Server Manager SQL SMART SQL Toolset SQL Server CFT SQL Server DBM SQL Server SNMP SubA gent SQL Statio
19. ier versions of the SySAM license daemons Workaround Sites using the Network License Model should make sure that the central SySAM license daemons are upgraded first 8 17 bcp and abstract data types CR 268302 Adaptive Server allows you to use bcp in to copy data containing Java objects but it performs no load time checking to ensure that the objects are consistent with the classes that are installed in the server Any checking is delayed until the objects are actually accessed by an application To be sure that all objects are compatible with their corresponding classes Sybase recommends that you run a select query to access these objects on the server immediately after they have been copied If there are any incompatibilities they are reported via a Java serialization error 10707 Workaround There is no workaround for this issue 8 18 Referencing Java data in a nonrecovered database CR 274071 Referencing Java data in a database that is not recovered or operational causes a process 0xf000f infected with 11 condition which terminates the database connection Workaround Verify that the database is recovered and available for use by issuing use database database_name 8 19 Configuring connectivity for clients accessing wide data 14 CR 271822 If you are using wide data that is data other than text and image that is greater than 255 bytes and you are using the bulk library APIs make sure you configure
20. is a truncation error Workaround Convert the numeric argument to a float 8 5 SQL derived tables cannot have unnamed columns CR 333873 SQL derived tables cannot have unnamed columns For example select from select sum advance from titles dl causes an error message Workaround Rewrite the query using derived column list or the AS clause For example select from select sum advance from titles d1 al or select from select sum advance as al from titles dl 8 6 Queries containing a select statement with a group by statement CR 333077 Queries containing a select with a group by with a case expression using a local variable may return wrong results Release Bulletin for Linux Itanium 11 8 Known problems Adaptive Server Enterprise Version 12 5 1 Workaround Remove the use of the local variable in group by 8 7 sybmigrate error messages CR 332051 When evoking sybmigrate warning messages display in the log Workaround These messages are harmless and can be ignored 8 8 Errors in queries with derived tables CR 329454 Incorrect results may be returned for a query having more than one derived table with group by aggregates in the derived table expression Workaround Do not run these types of queries 8 9 dump database hangs CR 321366 The dump database command hangs in some situations Workaround Set the pre read packet size in the configuration file Network Communication re
21. llowing operating system e Red Hat Enterprise Linux 2 1 64 bit Itanium with Linux 2 4 18 e 37 kernel For Linux Operating System support see the Technote at http www sybase com detail id 1024194 If your operating system requires patches install them before you install Adaptive Server components 3 Special installation instructions This section provides information for installing Adaptive Server version 12 5 and later that is not included or should be corrected in the installation guide 3 1 Known installation issues This section describes known problems or issues that you may encounter during the installation process Release Bulletin for Linux Itanium 5 4 Special upgrade instructions Adaptive Server Enterprise Version 12 5 1 3 1 1 Installing with Developer s Edition licenses After installation Adaptive Server on an Itanium platform Adaptive Server runs under a Developer s Edition license If you have purchased either the Small Business Edition SBE or Enterprise Edition of Adaptive Server you should have received one or more paper certificates Sybase Software Asset Management Certificate For information about installing Adaptive Server with SySAM see the Sybase Software Asset Management SySAM section of the Installation Guide 3 1 2 InstallShield and inaccessible NFS mounted devices CR 334942 If you have an inaccessible NFS mounted device InstallShield may hang while displaying Performace install
22. mote server pre read packets 10 8 10 SQL Advantage queries hanging CR 327303 Killing a server process associated with a SQL Advantage program does not notify the SQL Advantage client of the process termination Subsequent queries issued by SQL Advantage hang Workaround Do not kill server processes associated with a SQL Advantage program 8 11 Views must have defined column names CR 314976 ANSI requirements specify that a view must have defined column names Workaround You can suppress this requirement by using trace flag 1702 12 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 8 Known problems 8 12 Migrating between single byte and multibyte character sets CR 295842 sybmigrate does not support migration of data from single byte iso_1 roman8 to multibyte utf8 even with Jutf8 Workaround There is no workaround for this issue 8 13 Migration of stored procedures CR 328131 sybmigrate does not migrate stored procedures that have a space character in their name or belong to a procedure group Workaround There is no workaround for this issue 8 14 cis connect timeout and enable SNMP do not work CR 323177 Configuration parameters cis connect timeout and enable SNMP are not currently implemented Workaround Do not use these configuration parameters 8 15 XP Server returns incorrect results CR 280073 On all systems using an extended stored procedure ESP
23. n SQLJ STEP SupportNow S W LEF T Message Format Libraries Sybase Central Sybase Client Server Interfaces Sybase Financial Server Sybase Gateways Sybase MPP Sybase SQL Desktop Sybase SQL Lifecycle Sybase SQL Workgroup Sybase User Workbench SybaseWare Syber Financial SyberAssist SyBooks System 10 System 11 System XI logo SystemTools Tabular Data Stream TotalFix TradeForce Transact SQL Translation Toolkit UltraLite NET UNIBOM Unilib Uninull Unisep Unistring URK Runtime Kit for UniCode Viewer Visual Components VisualSpeller VisualWriter VQL WarehouseArchitect Warehouse Control Center Warehouse Studio Warehouse WORKS Watcom Watcom SQL Watcom SQL Server Web Deployment Kit Web PB Web SQL WebSights WebViewer WorkGroup SQL Server XA Library XA Server and XP Server are trademarks of Sybase Inc 07 03 1 Accessing current release bulletin information Adaptive Server Enterprise Version 12 5 1 Topic Page 8 6 Queries containing a select statement with a group by 11 statement 8 7 sybmigrate error messages 12 8 8 Errors in queries with derived tables 12 8 9 dump database hangs 12 8 10 SQL Advantage queries hanging 12 8 11 Views must have defined column names 12 8 12 Migrating between single byte and multibyte character sets 11 8 13 Migration of stored procedures 13 8 14 cis connect timeout and enable SNMP do not work 13 8 15 XP Server returns incorrect results
24. nt and extrainfo columns is incomplete Table 12 6 should include these lines for the create index entry under Other Information Index name CR 331120 In the System Administration Guide Chapter 26 Checking Database Consistency some size information is incorrect in the Creating the dbccdb database procedure The procedure should read In step 1 output Recommended size for dbccdb is 23MB data 21MB log 2MB In step 3 user input size 4096 size 1024 In step 7 user input use dbccdb go sp_dbcc_createws dbccdb scanseg scan_pubs2 scan 64K sp_dbccvreatews dbccdb textseg text_pubs2 text 64K 10 6 Performance and Tuning Guide 10 6 1 OAM scans on DOL tables OAM pages are used when performing a table scan on a DOL table These OAM pages refer to allocation units which must then be scanned to find the extents on the pages for the table being scanned When the scan is started a list of pages is generated the information in the allocation page Any newly allocated pages produced by another process in this allocation unit are not seen by the scanning process as they were not allocated when the scan began This is due to the way DOL tables are implemented If you want to include the newly allocated pages e use isolation level 3 type of scans select with holdlock or Release Bulletin for Linux Itanium 23 11 Technical support Adaptive Server Enterprise Version
25. owser to Technical Documents at http www sybase com support techdocs Select Products from the navigation bar on the left Select a product name from the product list and click Go Select the Certification Report filter specify a time frame and click Go Click a Certification Report title to display the report v Creating a personalized view of the Sybase Web site including support pages Set up a MySybase profile MySybase is a free service that allows you to create a personalized view of Sybase Web pages 1 2 Point your Web browser to Technical Documents at http www sybase com support techdocs Click MySybase and create a MySybase profile Release Bulletin for Linux Itanium 25 12 Other sources of information Adaptive Server Enterprise Version 12 5 1 12 2 Sybase EBFs and software maintenance 26 v Finding the latest information on EBFs and software maintenance 1 Point your Web browser to the Sybase Support Page at http www sybase com support Select EBFs Maintenance Enter user name and password information if prompted for existing Web accounts or create a new account a free service Select a product Specify a time frame and click Go Click the Info icon to display the EBF Maintenance report or click the product description to download the software Release Bulletin for Linux Itanium
26. r the specified compiled_object in syscomments in the specified database Does not raise errors on occurrences of select e check is used to detect syscomments text corruption which was caused by Adaptive Server defects that occurred before the upgrade This syscomments text corruption is serious because it causes upgrade to fail e If any error is reported by dbcc upgrade_object with check option you must drop and re create the compiled_object 10 4 2 create index clarification 20 The create index reference page in Chapter 1 Commands of Reference Manual Commands incorrectly states that the max_rows_per_page and fillfactor parameters are exclusive max_rows_per_page max_rows_per_page and fillfactor are mutually exclusive Unlike fillfactor the max_rows_per_page value is maintained until it is changed with sp_chgattribute It should read Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 10 Documentation updates and clarifications max_rows_per_page limits the number of rows on data pages and the leaf level pages of indexes Unlike fillfactor the max_rows_per_page value is maintained until it is changed with sp_chgattribute 10 4 3 bcp reference page clarification In the bcp reference page in Chapter 8 Utility Commands Reference of the Reference Manual Commands the description of the b batchsize parameter has been clarified It used to read b batchsize i
27. rom the standard location 2 Ifthe LDAP file does not exist or exists but does not contain an Adaptive Server entry then the interfaces file is parsed at its standard location for the server name 3 If the LDAP file exists then ddigen uses it to search the server name The interfaces file is not parsed and the LDAP configuration file is parsed Release Bulletin for Linux Itanium 17 10 Documentation updates and clarifications Adaptive Server Enterprise Version 12 5 1 Separate host_name and port_number with a colon without spaces before or after it Note You must use the S option because ddigen does not connect to a default server e specifies the interfaces file name and corresponds to SYBASE interfaces for UNIX and SYBASE ini sql ini for Windows Use this optional parameter with S 10 1 3 Omission from sybmigrate The following information was omitted from the symigrate Chapter in the Utility Guide sybmigrate requires allow resource limits to be set to 0 Note If metadata already exists on the target Adaptive Server you cannot migrate server data SYBASE_JRE defines the location of the Java runtime environment This is generally set to SYBASE shared 1_O jre 1_3 in the Adaptive Server release area This environment variable overrides JAVA_HOME SYBASE _JRE defaults to SYBASE shared 1_O jre 1_3 10 1 4 Utilities moved The following three utilities have moved from SYBASE
28. s in PDF format and may also contain other documents or updated information not included on the Technical Library CD It is included with your software To read or print documents on the Getting Started CD you need Adobe Acrobat Reader downloadable at no charge from the Adobe Web site using a link provided on the CD 24 Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 12 Other sources of information The Technical Library CD contains product manuals and is included with your software The DynaText reader included on the Technical Library CD allows you to access technical information about your product in an easy to use format Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting the Technical Library The Technical Library Product Manuals Web site is an HTML version of the Technical Library CD that you can access using a standard Web browser In addition to product manuals you will find links to EBFs Updates Technical Documents Case Management Solved Cases newsgroups and the Sybase Developer Network To access the Technical Library Product Manuals Web site go to Product Manuals at http www sybase com support manuals 12 1 Sybase certifications on the Web Technical documentation at the Sybase Web site is updated frequently v Finding the latest information on product certifications 1 nan A N Point your Web br
29. s the number of rows per batch of data copied default is to copy all the rows in one batch The text now reads b batchsize is the number of rows per batch of data copied By default bcp in copies n rows in one batch where n is equal to the batch size 10 4 4 set command option explicit_transaction_require not supported The set command option explicit_transaction_require is not currently supported and should not appear in the Adaptive Server Reference Guide version 12 5 1 10 4 5 New set parameters proc_output_params and set proc_return_status The following new parameters should be included in the set command reference section of Reference Manual Commands Parameters e proc_output_params controls sending of output parameters that a stored procedure generates back to the client set proc_output_params off suppresses sending the output parameters back to the client The default for this parameter is on e proc_return_status controls sending of a return status TDS token back to the client set proc_return_status off suppresses sending the return status token to the client and isql client does not display the return status 0 message The default for this parameter is on Warning If the client application that executes a procedure relies on the success or failure of the procedure based on the return status then do not use the set proc_return_status off option Release Bulletin for Linux Itanium
30. the connectivity capability for wide data Failure to do so may result in memory corruption Release Bulletin for Linux Itanium Adaptive Server Enterprise Version 12 5 1 9 Product compatibilities 8 20 Handling multibyte character sets during migration CR 271839 If you configure multibyte character sets after migrating data from system catalogs sysattributes and sysxtypes the text columns in these catalogs are inconsistent with the multibyte character sets Workaround Manually run dbcc fix_text on sysattributes and sysxtypes to make the text columns consistent with the multibyte character sets 8 21 Adaptive Server plug in default character set and language CR 270906 The Adaptive Server plug in default character set is iso_1 and the default language is us_english If you are running an Adaptive Server that is using a different language or character set you may encounter compatibility problems Workaround Set the character set and language values in the Adaptive Server plug in Connect dialog so that they correspond to the configuration of the Adaptive Server 8 22 Dynamic and host variables not allowed in DDL statements CR 234217 Dynamic and host variables in create view statements were allowed in earlier versions but worked incorrectly when e create view statements were replicated or e Views containing dynamic and host variables were upgraded from text in the syscomments table Dynamic and host variables
31. with parameters may result in wrong data being send to XP Server Because of this XP Server may return incorrect results This happens when there is no parameter declaration list in the ESP but one or more parameters are supplied at execution time Before CR 280073 all parameters supplied at execution time were sent to the XP Server causing incorrect results CR 280073 fixes this problem by silently ignoring all parameters supplied at execution time when the parameter declaration list is empty This fix does not cause any behavior change when the parameter declaration list in the ESP matches the parameters supplied at execution time If you are using ESPs without a parameter declaration list and you supply parameters at execution time drop and re create the ESP in Adaptive Server Make sure the parameter declaration list in the ESP matches the parameter list supplied at execution time You can use trace flag 523 to revert to pre CR280073 behavior This is a server wide trace flag to be set when you restart Adaptive Server Release Bulletin for Linux Itanium 13 8 Known problems Adaptive Server Enterprise Version 12 5 1 8 16 Network license daemon support Problem Adaptive Server version 12 5 1 has upgraded the SyYSAM daemons and libraries FlexLM to version 8 The SySAM daemons Imgrd and SYBASE are backward compatible however the libraries are not As a result Adaptive Server 12 5 1 cannot check out licenses from earl
Download Pdf Manuals
Related Search