Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:406722

CR Number:   406722 Product Name:   Organic OLE DB Provider Product Component:   Install Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 ESD#12 13 Oct 2005 Fixed Description ODBC Driver by Sybase: Installing the Driver Meta Data SQL scripts will leave the Adaptive Server with 'allow updates' enabled. Workaround Description  Edit script and change to: sp_configure 'allow updates',0 go print 'Installed sp_version...' go

CR:406830

CR Number:   406830 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2005 Fixed Description OpenSwitch CMON connection to set CS_APPNAME and CS_HOSTNAME.

CR:406880

CR Number:   406880 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#2 31 Jan 2006 Fixed 12.5.1 ESD#12 31 Jan 2006 Fixed Description OLE DB Provider by Sybase: Arithmetic overflow errors encountered using Decimal or Numeric data types in ADO recordset.AddNew or OLE DB IRowsetChange::InsertRow methods.

CR:406944

CR Number:   406944 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2005 Fixed Description In a mutually-aware setup, if a server is in a LOCKED state when a client tries to connect, and the server status is later changed to UP, the clients that were blocking will fail over to the next available server if the command to change the status came from another OpenSwitch.

CR:406946

CR Number:   406946 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2005 Fixed 17 Oct 2005 Duplicate Description During a server failure, if the SVR_FAIL_ACTION script (custom or manual) returns with an exit code of '2', the idle clients connected to this server can be left in a hanging state, when they should be disconnected.

CR:407009

CR Number:   407009 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2000 Original Version:   1.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.15 ESD#2 31 Jan 2006 Fixed Description ADO.NET: Using DTC transactions with non-pooled database connections may cause errors in application.

CR:407036

CR Number:   407036 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2005 Fixed Description If the network of the primary OpenSwitch companion goes down and the primary companion goes down as a result of it, future configuration changes on the secondary companion, such as setting the server status with rp_server_status, are not written to the configuration table on the CFG_STORAGE Adaptive Servers.

CR:407048

CR Number:   407048 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2005 Fixed 25 Oct 2005 Fixed Description If a primary Adaptive Server failure occurs when one companion OpenSwitch is servicing at least one busy client, and another companion is servicing only idle client(s), the user action script (if SVR_FAIL_ACTION is set to CUSTOM or MANUAL) might be executed twice, once on each companion OpenSwitch.

CR:407276

CR Number:   407276 Product Name:   Open Client-Doc Product Component:   Client-Library C Reference Manual Status:   Closed OS:   Unknown Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) Galaxy 23 Dec 2008 Fixed Description Current documentation does not detail how the signal handling of threaded programs is accomplished. The documentation does not detail customer responsibilites or how he is to setup his own signal handling to coexist with Sybase behavior.

CR:407280

CR Number:   407280 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sybase OLEDB: does not support ADODB.Connection.OpenSchema() functions. Workaround Description  Use DataDirect OLE-DB provider.

CR:407294

CR Number:   407294 Product Name:   Open Client Product Component:   blklib Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Want blk_rowxfer, blk_rowxfer_mult and blk_done to return CS_CANCELED if canceled from ct_cancel().

CR:407646

CR Number:   407646 Product Name:   OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Fixed Description OLEDB: Applications may get Socket Closed error when they request and use larger packet sizes than the ASE default. Workaround Description  Configure ASE 'default packet size' to equal that requested by the client.

CR:407680

CR Number:   407680 Product Name:   Open ClientCONNECT for CICS Product Component:   Open ClientCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 07 23 Mar 2006 Fixed Description Connnection Router Transaction still list the 12.5.01 version String

CR:407783

CR Number:   407783 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2012 EOL'd version. Not to be Fixed. Description SP_MDA, COBOL prog SPMDACSP, writing info to temp storage, should be written to Memory

CR:407805

CR Number:   407805 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2005 Fixed 02 Dec 2005 Fixed 16 Feb 2006 Fixed 05 Dec 2005 Fixed 17 Feb 2006 Fixed Description SRVLIB:In srv_dbg_stack(), the return value of the user-provided function is not checked. If the return value is CS_FAIL, the stack trace is terminated.

CR:407845

CR Number:   407845 Product Name:   ODBC Driver Kit Product Component:   ODBC Driver Kit Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Fixed Description ODBC: Money output parameter returns an incorrect value. ASE returns the correct value, but ODBC delivers a huge number.

CR:407931

CR Number:   407931 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   Unknown Original Version:   6.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a jConnection connection attempt is made with a url like: jdbc:sybase:Tds:localhost:5000/pubs2, if the database pubs2 is unavailable a SQLWarning is thrown and not a SQLException. Because the context of the connection is wrong, SQLWarnings often not checked and the circumstances are relatively rare; user sql can fail/hang presenting production problems. Workaround Description  Set the "sqlinitstring=use <database>", on the connection this will throw an exception.

CR:407939

CR Number:   407939 Product Name:   jConnect Product Component:   Ribo Status:   Closed OS:   Solaris Original Version:   6.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2005 Not a Bug Description Ribo does not display the TDS state transition that is recorded in the raw TDS

CR:408233

CR Number:   408233 Product Name:   ODBC Driver Kit Product Component:   ODBC Driver Kit Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Oct 2005 Fixed Description ODBC: When inserting Chinese character data into Sybase database with charset=UTF8 using invalid SQL_TYPE of SQL_LONGVARCHAR, a crash occurred.

CR:408348

CR Number:   408348 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   1.1 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.15 ESD#6 21 Dec 2006 Fixed Description ADO.NET: ExecuteReader(CommandBehavior.SingleRow) does not restrict a result set to a single row. Workaround Description  Use 'set rowcount 1' or 'top' syntax with ASE 12.5.3.

CR:408376

CR Number:   408376 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 02 27 Mar 2006 Fixed Description MFC Server Option for CICS, Date and Time data types missing from sp_jdbc_datatype_info CSP call result

CR:408575

CR Number:   408575 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2013 Fixed Description ODBC Driver by Sybase: A run-time error 40002 is raised when trying to update a row on a Visual Basic 6.0 application using RDO.

CR:408725

CR Number:   408725 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2005 Fixed 22 May 2007 Not a Bug Description SRVLIB: Clients on little-endian hosts (linux, nt386) are not able to connect to open servers on Linux IBM pSeries.

CR:408741

CR Number:   408741 Product Name:   Connectivity Utilities Product Component:   isql Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2007 Fixed 15 Jan 2008 Fixed 09 Jan 2008 Fixed 18 Feb 2008 Fixed Description ISQL: Allow dynamic redirection of query output results to a file (> or append it with >>), or piping them through utility programs. This corresponds to ISUG enhancement request #2801.

CR:408746

CR Number:   408746 Product Name:   Connectivity Utilities Product Component:   isql Status:   Closed OS:   Unknown Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2007 Fixed Description ISQL: This CR adds the --retserverror command line option to isql. When set, isql exits whenever a server error is encountered with a severity >= 11. With this option, when a 'real' server error is received, isql will return '2' to the calling program (shell/command prompt) and write 'Msg[tab][server error nbr.]' to stderr. Target Version  15.0 ESD#10

CR:408759

CR Number:   408759 Product Name:   Connectivity Utilities Product Component:   isql Status:   Open OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for the ability to customize the isql prompt so that it shows the servername: isql -Uusername -Sservername -P SERVERNAME:(1)> SERVERNAME:(2)>

CR:408760

CR Number:   408760 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#3 25 Oct 2006 Fixed Description SP_MDA CSP writes too many records to Temporary Storage on CICS startup.

CR:408892

CR Number:   408892 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   HP-UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2005 Fixed 07 Dec 2005 Fixed 18 Dec 2005 Fixed 12 Jan 2006 Fixed Description DBLIB: A dblib application may hang on HP Itanium or HP PA-RISC platform if the application has more than 32 or 1024 open files respectively. Workaround Description  Open database connections before opening other files.

CR:408906

CR Number:   408906 Product Name:   Open Server Product Component:   srvlib Status:   Open OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Nov 2005 Fixed Description SRVLIB: Clients connecting to Open Server application using Kerberos may hit error: "ct_connect(): network packet layer: external error: There is a protocol packet error. An illegal length was received "

CR:409120

CR Number:   409120 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   all Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2006 Fixed 15 Jun 2006 Fixed 15 Jun 2006 Fixed 16 Jun 2006 Fixed 30 Jun 2006 Fixed 22 Jun 2006 Fixed 22 Jun 2006 Not a Bug 22 Sep 2006 Fixed Description SRVLIB: This implements a new token TDS_DBRPC2. With this implementation a fully qualified rpc name can now be greater than 255 bytes, but the individual component of the rpc name is still limited to 255 bytes

CR:409193

CR Number:   409193 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2006 Duplicate Description Certification of OpenSwitch 12.5.x on Red Hat EL 4.0 (AMD64/EM64T)

CR:409358

CR Number:   409358 Product Name:   OpenSwitch Product Component:   RCM Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Nov 2005 Fixed 20 Jan 2006 Fixed 23 Jan 2006 Fixed Description Existing connections hang if the CMON of Secondary ASE is invalid.

CR:409514

CR Number:   409514 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jan 2006 Fixed Description jConnect: Request to update documentation files installed in $SYBASE/jConnect-6_0/docs directory.

CR:409589

CR Number:   409589 Product Name:   Open Client Product Component:   ctlib Status:   Open OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description CT-Lib: enhance ct_res_info() to return the last error message struct received from the server. Workaround Description  Use inline message handling via ct_diag() or CS_USRERDATA populated by the callback handler. Both of these solutions make for much more complicated application code.

CR:409629

CR Number:   409629 Product Name:   Open ServerCONNECT for IMS and MVS Product Component:   Open ServerCONNECT for IMS/MVS Status:   Closed OS:   MVS IMS Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5 29 Mar 2006 Fixed Description SRYT IMS EBFI0368 is returning the wrong message on an error "33607..SYBASE..CATRPC.REQUESTED MODULE NOT LOADED"

CR:409633

CR Number:   409633 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Jan 2006 Fixed 01 Dec 2005 Fixed 01 Dec 2005 Fixed Description jConnect: The length of table name, column name input arguments in the MDA stored procedures used by the jConnect driver are not long enough to account for names with escape characters like [_].

CR:409766

CR Number:   409766 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#4 16 May 2006 Fixed Description OLE DB Provider by Sybase: Add support for OLE DB Services. These are used for automatic transaction enlistment apart from other uses.

CR:409793

CR Number:   409793 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows Vista Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2009 Fixed 02 Nov 2009 Fixed 02 Nov 2009 Fixed Description OLE DB Provider by Sybase: Cannot install OLE DB meta-data stored procedures if ASE db option "allow nulls by default" is set to true. Workaround Description  The workaround is to turn off 'allow nulls by default' sp_dboption "sybsystemprocs", "allow nulls by default", false -- then run installmaster

CR:409921

CR Number:   409921 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Windows 2000 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2006 Fixed 17 Feb 2006 Fixed Description OpenSwitch crashes on Windows if the environment variable %TMP% has spaces in it. This happens at boot time for Mutually-aware OpenSwitch, or after the first client is connected without mutually-aware but with PING_THREAD set to 1.

CR:414593

CR Number:   414593 Product Name:   Open ClientCONNECT for CICS Product Component:   Open ClientCONNECT Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 02 23 Jan 2006 Fixed Description MFC Client Option for CICS overlays storage when fetching a Nullabe Char with 1 byte of data in the column

CR:414608

CR Number:   414608 Product Name:   Connectivity Utilities Product Component:   bcp Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2013 EOL'd version. Not to be Fixed. Description bcp should allow inserts to tables with timestamp column specifying not null even if the data file to be copied in does not contain data for the timestamp column.

CR:414657

CR Number:   414657 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#2 01 May 2013 Fixed Description ODBC Driver by Sybase: The length of table name, column name input arguments in the MDA stored procedures used by the ODBC Drivers are not long enough to account for names with escape characters like [_].

CR:414693

CR Number:   414693 Product Name:   OpenSwitch Product Component:   RCM Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2006 Fixed 02 Mar 2006 Fixed 20 Mar 2006 Fixed 23 Mar 2006 Fixed 23 Mar 2006 Fixed 12 May 2006 Fixed Description RCM attempts to do the replication switch more than once when a failover situation occurs. The subsequent switch attempts will fail and have no impact on client applications.

CR:414784

CR Number:   414784 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2006 Fixed 21 Mar 2006 Fixed Description In a Mutual Aware Setup with SVR_FAIL_ACTION set to MANUAL, CUSTOM or CUSTOM_MANUAL, if all existing clients on OpenSwitch are idle when a ASE Server fails, and a new client attempts to connect after that but before the existing clients become busy again, the new client is connected to the Secondary ASE data server, but the existing clients hang. Workaround Description  Workaround: You will not run into this problem if you have SVR_FAIL_ACTION set to DEFAULT. If you have SVR_FAIL_ACTION set to CUSTOM, MANUAL or CUSTOM_MANUAL, make sure that there is at least one busy client connected to the OpenSwitch at all times. If not all of your clients are busy all the time, you can create a busy client running in the background by creating a sql script, say busy.sql, with the following content: while (1=1) waitfor delay "00:30" go Run this script through isql in the background as a regular user to OpenSwitch: isql -U<username> -P<password> -S<OpenSwitch_name> -i busy.sql & You should run this on both OpenSwitch companions. The server failure can be detected by the busy client as soon as it occurs, and handled appropriately.

CR:414785

CR Number:   414785 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Windows 2000 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2006 Not reproducible with latest version of the product available as of Resolution Date 05 Sep 2006 Not reproducible with latest version of the product available as of Resolution Date Description If you return with an exit status of 1 from NET_FAIL_ACTION CUSTOM or MANUAL scripts, after the network is successfully restored any changes you make to the pool/server may not get synced with its companion. Workaround Description  To workaround this issue always return an exit status of 0 from the CUSTOM or MANUAL scripts for NET_FAIL_ACTION.

CR:415430

CR Number:   415430 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2006 Presently Not Targeted For Any Future Release Of This Product Description Customer and we need to have Milli Secs in the OSC Tracing written to the CSML

CR:415517

CR Number:   415517 Product Name:   Embedded SQL/COBOL-Doc Product Component:   COBOL Supplement Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Fixed Description Programmer's Supplement missing lower case options for cobpre Workaround Description  Use the 12.5.1 documentation

CR:415556

CR Number:   415556 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2006 Fixed 15 Feb 2006 Fixed Description When the network between OpenSwitch and the primary ASE server breaks, the first client that tries to connect to the primary ASE Server through OpenSwitch can take several minutes to detect the failure, even with PING_THREAD set to 1. Workaround Description  Set the client's login timeout to a high value ( recommended value : 240 seconds or higher ).

CR:415689

CR Number:   415689 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2005 Fixed 01 Jan 2006 Fixed Description When CMP_FAIL_ACTION is set to CUSTOM, MANUAL or CUSTOM_MANUAL, OpenSwitch does not execute the custom or manual script during a network outage between the companions. You can see the following messages about failure to suspend the pools and execute the scripts. manual_action: Executing manual.sh (server=sosw, reason=1006) pool_set_prop_atomic: Failed to preset pool status in companion. coord_suspend: Cannot change status of pool POOL1 to SUSPENDED manual_action: Suspending OpenSwitch failed. do__useraction: Failed to execute the manual script for CMP_FAIL_ACTION. Check the error messages above for reasons of failure. All future changes to the server/pool configuration are prohibited.

CR:415798

CR Number:   415798 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Generic Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2007 Fixed 09 Mar 2006 Fixed Description The problem occurs if we hit a error while force closing a socket during a network failure. The Secondary Companion OpenSwitch's configuration may get out of sync with the Primary Companion OpenSwitch's configuration. Workaround Description  Workaround: Make sure that there is at least one busy client connected to the Primary Companion OpenSwitch at all times. If not all of your clients are busy all the time, you can create a busy client running in the background by creating a sql script, say busy.sql, with the following content: while (1=1) waitfor delay "00:30" go Run this script through isql in the background as a regular user to OpenSwitch: isql -U<username> -P<password> -S<OpenSwitch_name> -i busy.sql & The server failure can be detected by the busy client as soon as it occurs, and handled appropriately.

CR:415891

CR Number:   415891 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT DOC Status:   Closed OS:   MVS Original Version:   12.6.ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 29 Mar 2006 Fixed Description MFC Client Option for CICS 12.6 documentation does not list error message -275 TDS_LICENSE_CHECK_FAIL

CR:415910

CR Number:   415910 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 02 13 Apr 2006 Fixed Description MFC Server Option for CICS, attribute DEFAULT_TXN_ISOLATION row missing from the result of sp_server_info CSP call

CR:416078

CR Number:   416078 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   HP-UX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2005 Fixed 25 Jan 2006 Fixed Description CTLIB: Enable MIT Kerberos 1.4.3 support for HPUX64.

CR:416247

CR Number:   416247 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#6 10 Jan 2007 Fixed Description ODBC Driver by Sybase: Unable to retrieve data from columns of timestamp data type in a ASE 15.0 database.

CR:416248

CR Number:   416248 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#6 10 Jan 2007 Fixed 12.5.1 ESD#16 10 Jan 2007 Fixed Description ODBC Driver by Sybase: SQLColumns returns type name varchar for timestamp data type.

CR:416250

CR Number:   416250 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#6 10 Jan 2007 Fixed 12.5.1 ESD#16 10 Jan 2007 Fixed Description ODBC Driver by Sybase: SQLColumns returns type names varchar and char for nvarchar and nchar data types respectively.

CR:416262

CR Number:   416262 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#5 10 Jan 2007 Fixed Description ODBC Driver by Sybase: SQLProcedureColumns does not return correct information for stored procedure parameters of type bigint.

CR:416419

CR Number:   416419 Product Name:   Open Client Product Component:   blklib Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2006 Fixed 16 Jan 2006 Fixed Description BLKLIB:bcp through open server crashes the open server in blk_50_sendrow when copying in row data that has several trailing NULLs. Workaround Description  bcp directly to ASE and bypass the Open Server

CR:416448

CR Number:   416448 Product Name:   Organic OLE DB Provider Product Component:   Configuration UI Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#2 19 May 2014 Insufficient priority to fix 12.5.1 ESD#12 19 May 2014 Insufficient priority to fix 15.7 SP130 30 May 2014 Fixed Description OLE DB Provider by Sybase: ASE Data Source Administrator connection fails if the charset is capitalized

CR:416449

CR Number:   416449 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 07 24 Mar 2006 Fixed Description MFC Server Option for CICS returns incorrect error code for license key error

CR:416541

CR Number:   416541 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ODBC: Request for ODBC driver to implement SQLPutData to handle long data values in manageable chunks. Workaround Description  None known.

CR:416737

CR Number:   416737 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   HP-UNIX Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2006 Fixed 06 Apr 2006 Fixed 21 Feb 2006 Fixed Description DBLIB: A dblib application may fail on HP Itanium if the application has set the file descriptor limit to be more than 2048 with the following error: Operating-system error: Bad file number Workaround Description  Reset setrlimit(RLIMIT_NOFILE,) to FD_SETSIZE.

CR:416759

CR Number:   416759 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed 02 Feb 2006 Fixed 01 Feb 2006 Fixed Description jConnect: Request to support getDatabaseMajorVersion(), getDatabaseMinorVersion(), getJDBCMajorVersion() and getJDBCMinorVersion() functions on the DatabaseMetaData class.

CR:416869

CR Number:   416869 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   Red Hat Enterprise Linux Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description OLEDB Driver needs to return more specific error messages for kerberos to the client applications

CR:417005

CR Number:   417005 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2006 Presently Not Targeted For Any Future Release Of This Product Description IBMLISTNR message thats a catch all 35039,' TRAN START ERROR: TRANSACTION %s NOT DEFINED IN THE PCT OR IS DISABLED.' Needs to change.

CR:417041

CR Number:   417041 Product Name:   Open Client-Doc Product Component:   Release Bulletin Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Galaxy 19 Apr 2006 Fixed 12.5.1 26 Jan 2006 Fixed Description Require Solaris libsocket patch: #111328-04: SunOS 5.8_x86 to avoid Repserver memory leak. Workaround Description  Install Solaris patch: #111328-04: SunOS 5.8_x86: libsocket patch

CR:417233

CR Number:   417233 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 07 23 Mar 2006 Fixed Description An abnormal end occurs in MFC Server Option for CICS with CICS SIT parameter XUSER=YES and CICS surrogate user defined to RACF with insufficient authority

CR:417417

CR Number:   417417 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   Unknown Original Version:   6.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description jConnect should throw proper exception XAER_HEUR type return codes when transactions have been "prepared", dbcc complete_xact(commit | rollback) but not heuristically forgotten via dbcc forget_xact(). Workaround Description  Workaround is to be sure to run dbcc forget_xact() for any heuristic transactions.

CR:417539

CR Number:   417539 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   Unknown Original Version:   6.5 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Mar 2006 Fixed 20 Mar 2006 Fixed Description jConnect: For User-defined datatypes, the DatabaseMetadata.getColumns(TYPE_NAME) returns the underlying native datatype name and not the User-defined datatype name. Workaround Description  Get the column type info from getTypeInfo() vs. getColumns)

CR:417585

CR Number:   417585 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS - DOC Status:   Closed OS:   MVS Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Mar 2006 Not a Bug Description An ommission from the Install and Admin Guide for MainframeConnect Server/Client Options (see Appendix A) - when configuring OSC 12.6 to use IBM z/OS conversion utility and services (i.e. USEIBMUNICODE=Y), OSC specific non-ER conversion definition entries must be manually added before generating the IBM z/OS conversion image using CUNMIUTIL.

CR:417628

CR Number:   417628 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 07 27 Mar 2006 Fixed Description MFC Server Option for CICS, non-DB2 CSP sp_datatype_info returns an out-of-range precision value of 4GB for IMAGE data type and causes ODBC error message

CR:417711

CR Number:   417711 Product Name:   OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Fixed Description OLEDB: When sending the statement "WRITETEXT table_name.column_name, text_pointer, text_data" from the OLE DB application to ASE, and if the text_data contains the substring "exec" then the OLEDB provider considers the rest of the string following "exec" as a stored procedure name. Thus, ASE fires the error "Stored Procedure sproc_name not found. Specify owner.objectname or use sp_help to check that the object exists".

CR:417721

CR Number:   417721 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   Microsoft Windows NT Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2006 Fixed 19 Jan 2006 Fixed Description jConnect: Statement.getUpdateCount() does not return a valid update count after Statement.executeUpdate() is executed.

CR:417723

CR Number:   417723 Product Name:   ODBC Driver Kit Product Component:   ODBC Driver Kit Status:   Open OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ODBC: metadata is not availble after SQLPrepare...causing the odbc application to stop abnormally Workaround Description  Set the driver property "Dynamic Prepare" to "ON".

CR:417755

CR Number:   417755 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 03 26 May 2006 Fixed Description In MFC Server Option for CICS, introduce support for RPC names with the format of "dbname..rpcname"

CR:417760

CR Number:   417760 Product Name:   ODBC Driver Kit Product Component:   ODBC Driver Kit Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Fixed Description ODBC: With COMPUTE clause in a SQL query, the compute result set is not being retrieved by driver, but it is being sent in the response from the ASE.

CR:417914

CR Number:   417914 Product Name:   ADO.NET Data Provider Product Component:   TDS Library Status:   Open OS:   Microsoft Windows 2003 Original Version:   1.15 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ADO.NET: Connecting to OpenSwitch as an admin user fails

CR:418120

CR Number:   418120 Product Name:   Connectivity Utilities Product Component:   bcp Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2006 Fixed Description BCP: bcp stops when ASE encounters a duplicate key row in a batch (e.g. -b1) Workaround Description  Use bcp from version 12.5.1

CR:418124

CR Number:   418124 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2006 Fixed Description ODBC Driver by Sybase: When using SQLDriverConnect with SQL_DRIVER_PROMPT Option, changes made to the connect string in the prompt dialog are not reflected in the OutConnectString.

CR:418260

CR Number:   418260 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2006 Fixed Description jConnect: NullPointerException when updateTimestamp() method is called.

CR:418275

CR Number:   418275 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   2.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2008 Fixed Description Request for ASE ADO.NET 2.0 Provider.

CR:418335

CR Number:   418335 Product Name:   ESQL Product Component:   C Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2006 Fixed 23 Feb 2006 Fixed Description CPRE: cpre occasionally gives Access Violations precompiling some source files. Workaround Description  None known at this time.

CR:418449

CR Number:   418449 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2000 Original Version:   1.1 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.15 ESD#18 07 Apr 2009 Duplicate Description ADO.NET: New feature request for ASE ADO.NET Data Provider to trim blanks from a null "char" column.

CR:418530

CR Number:   418530 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   Unknown Original Version:   5.5 ESD#15 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SQLWarnings chained off Statements should be cleared on execute() of a statement. Not clearing the SQLWarnings can lead to memory leaks. Workaround Description  call <statement>.clearWarnings(); explicitly or process all SQLExceptions instead of some of them.

CR:418625

CR Number:   418625 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#9 08 Dec 2013 Fixed 12.5.1 ESD#19 08 Dec 2013 Fixed Description ODBC Driver by Sybase: Fetching numeric data with scale = 0, bound as SQL_C_CHAR returns a string with a trailing decimal point. So number zero is returned as "0."

CR:418664

CR Number:   418664 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.5 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jun 2008 Fixed 09 Jun 2008 Fixed 09 Jan 2008 Fixed 09 Jan 2008 Fixed 25 Oct 2010 Fixed 17 Dec 2010 Fixed Description jConnect: Implement support for ASE Cluster Edition features: Login redirection, Connection migration and extended failover.

CR:418913

CR Number:   418913 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#5 16 Jan 2007 Fixed 12.5.1 ESD#15 16 Jan 2007 Fixed Description ODBC Driver by Sybase: String columns with null characters embedded in the value are truncated after the first null character. Target Version  15.0 ESD#3

CR:419030

CR Number:   419030 Product Name:   Organic ODBC Driver Product Component:   TDS Library Status:   Closed OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 May 2006 Fixed 12.5.1 ESD#13 02 May 2006 Fixed Description ODBC Driver by Sybase: Binding a datetime column to SQL_C_TYPE_DATE returns invalid Indicator length.

CR:419306

CR Number:   419306 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2007 Fixed 10 Jan 2007 Fixed Description ODBC Driver by Sybase: SQLNumParams reports incorrect number of parameters if the query being executed contains "@" sign.

CR:419579

CR Number:   419579 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.5 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2006 Fixed 02 Mar 2006 Fixed 02 Mar 2006 Fixed Description jConnect: The column names used to describe ResultSet MetaData do not conform to the JDBC specifications.

CR:419583

CR Number:   419583 Product Name:   OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description OLEDB: When using the MS DataShape Service and Provider connection property SelectMethod=Cursor, executing a Stored procedure, with SHAPE, or SHAPE and APPEND, application would hang.

CR:419671

CR Number:   419671 Product Name:   Connectivity Utilities Product Component:   isql Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 May 2006 Duplicate Description When ISQL displays double-byte column data e.g. Simplified Chinese from a resultset, on reaching the end of a line as determined by the -w parameter setting, ISQL does not preserve the integrity of the double-byte data string i.e. it splits the string not at the correct double-byte character boundary but between the two bytes of a double-byte character.

CR:419684

CR Number:   419684 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#2 07 23 Mar 2006 Fixed Description MFC Server Option for CICS caused TDS errors in a gateway environment if the specified packet size was greater than 512 bytes

CR:419724

CR Number:   419724 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Apr 2006 Fixed 20 Mar 2006 Fixed 21 Mar 2006 Fixed Description Customer wants OpenSwitch to cancel query when RESPONSE_TIMEOUT expires Workaround Description  With JConnect/JDBC you can implement a setQueryTimeout() method, which is the logical equivalent of the OpenSwitch timing out. You can set this value to something smaller than RESPONSE_TIMEOUT so that when the setQueryTimeout limit is hit in JConnect, the row is not inserted and a SQLException is returned.

CR:419730

CR Number:   419730 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.5 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Feb 2006 Fixed Description jConnect: PreparedStatement.setObject(paramIndex, String, java.sql.Types.BIT) does not set underlying boolean column to true if string value provided is "1".

CR:419831

CR Number:   419831 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description jConn: Request for support invoking getTypeMap and setTypeMap (Connection)

CR:419856

CR Number:   419856 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Not reproducible with latest version of the product available as of Resolution Date Description ODBC Driver by Sybase: Selecting a smalldatetime column that does not allow NULL may cause an Internal Error 30016. Workaround Description  Use smalldatetime (allows null value) data type. But it may be unacceptable if your customer has too many smalldatetime (not null) columns.

CR:419921

CR Number:   419921 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   5.5 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Feb 2006 Fixed 01 Feb 2006 Fixed 01 Feb 2006 Duplicate Description jConnect: Installing jConnect meta-data stored procedures (sql_server*.sql or installmaster script) on an ASE setup with Japanese character set fails due to character set conversion issues.

CR:419959

CR Number:   419959 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.5 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2006 Fixed Description jConnect: Output parameters registered as JDBC type of FLOAT are returned as Float objects when getObject() is called. These should be returned as Double as per JDBC specification.

CR:420087

CR Number:   420087 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#3 19 May 2006 Fixed 02 Dec 2013 Fixed Description ODBC Driver by Sybase: SQLGetInfo SQL_MAX_PROCEDURE_NAME_LEN returns invalid value.