Sybase数据库技术，数据库恢复专家

to be used with kerberos network based security feature

RepositoryInfoPanel:

-Removed the conditional inside the build method that controls whether or not we add the xml file as a resource.

-Removed all other references of the boolean.

as if the query exceeded the limit of 1024. The real limit is 300.

allocation for the target table, wherever possible. As a result, SELECT INTO may

choose the largest I/O size possible for the target table, based on the size

of the buffer pools available in the target database cache. ASE 12.5.0.3 will

have this option on by default. ASE 12.0.0.7 requires the use of -T5304 to activate

this enhancement.

maybe reported when executing a SELECT INTO statement using

views in the FROM clause together with a UNION and a GROUP BY clause.

errors. This occurs on the Regatta family of servers and is fixed by IBM APAR IY38226.

procedures with parameters where no parameters were defined in the extended stored procedure

declaration list.

and character set conversion is enabled.

CIS connections are used by Replication Agent, Proxy Tables, and

CIS RPC calls, therefore SSL can be enabled to work with Replication

Agent, Proxy Tables, and CIS RPC calls.

SP_ADDLOGIN, SP_DROLOGIN and SP_LOCKLOGIN stored procedures.

102 when a SQL query involving proxy tables is executed.

when a 'between' clause is used in conjuction with a correlated subquery

Status: Reviewed Sep 2002. Fix targeted (but not commited) to the 12.0.0.7 release.

Status: Reviewed Sep 2002. Feature targeted (but not commited) to the 12.6 release.

to read page 0 (object SYSALLOCPG); this error occurs when there is a corruption in

the SYSGAMS extent allocation.

space in the device fragments with no SYSGAMS extensions; this attempt

results in a 605/691 error accessing a page for object SYSGAMS.

query generates a sorted worktable on an object with an index generated

from presorted data. Functions 'mjoin_open','pll_sort_open', 'sam_gen_distmap',

'sortclean' will be found in the error log.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

Requires: AIX 4.3.3 Maintenance Level 7, HACMP/ES 4.4.1 (with its prerequisite RSCT)

and two patches - APAR IY26561 & APAR IY26492.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

when an access rule based on a non-existant Java user-defined function is bound to a table column and

this column is accessed via a subquery.

procedure that requires recompilation and the database is

in READONLY or STANDBY_ACCESS mode. Likewise, the view,

trigger or stored procedure is unnecessarily suspended temporarily

when a QUIESCE DATABASE command is active.

object '14' in database '<dbid>'" may be reported in the error log when the database size

exceeds 2016 GB.

using JDBC interface, it may result in error 103,

if the columns in a table are of length greater than 28 bytes

lists "NEW" as a T-SQL reserved word and is erroneous.

in 12.5.0.1 ESD#2 and later Coverletters.

but <value> data rows. Drop and recreate the index." may be reported

by DBCC CHECKTABLE on a Data-Only Locked table after having created

either a CLUSTERED or NONCLUSTERED index with the SORTED_DATA

option but ASE was first shutted down with the NOWAIT option.

language statements (e.g. "use @p0") required that the host variable

be supplied using a datatype of CHAR or VARCHAR. Henceforth, the

host variable may instead be supplied using a datatype of UNICHAR

or UNIVARCHAR (assuming the requirements for use of these datatypes

are met).

Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release.

Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release. While the implementation will not be unlimited, it will be relaxed to a very large extent.

query may hang or return wrong results.

datatypes when server's default sort order is different from binary.

As consequence some queries may be executed using suboptimal plans.

gives incorrect values when the page size is > 2K.

Permission related internal error was encountered.

Unable to continue execution." will be reported by

the stored procedure sp_helprotect if DBCC or

SELECT GET_APPCONTEXT|SET_APPCONTEXT|RM_APPCONTEXT|LIST_APPCONTEXT

have been granted to any user or role, and auditing

is enabled.

message with the reason is not sent to the client immediately. The message is now

sent immediately to the client.

apply to single partitioin.

if the resource property name is not specified in exact case, the update will not give any

error eventhough the supplied value for the resource property is invalid/wrong

(and hence the ASE resource might not work as expected).

The Asynchronous disk I/O subsystem changes are generic towards Sun
Solaris 8 and Linux RH7.2 and RH Advanced Server 2.1 and up where both
platforms by default follow a Kernel Asynchronous disk I/O strategy and
where not supported fall back on the (RT) Posix Asynchronous disk I/O
strategy. The use of (RT) Posix Asynchronous disk I/O can be forced by
booting the server with traceflag 1630.

has been granted to read from a table, but the table name is a

built-in function name.

(any 12.0 version) as expected. This can result in sp_sysmon encountering "Divide by zero occurred"

message or sp_sysmon hanging. The SIGALRM issue has been identified by Sun as an error in the

Solaris operating system, Sun Bug ID 4716436. Contact Sun Support for resolving this problem.

used by the spid.

"ORA-00932 inconsistent datatypes..dco12_5ss"

Reviewed Nov 2002. Fix is targeted for a future (as yet undetermined) 12.0.x release.

if that remote server is rebooted, then further connection request from ASE to that remote server

fails with 7210 error. ASE must be restarted before users can once again connect to that remote server.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

be <count1>. Instead <count2> was found" may be raised after an ALTER TABLE LOCK command

run for a user table marked for replication has been interrupted.

tables are only established in the master and model databases and not in any other

databases. The setting of the default permissions on all system tables in all

databases is now done once only, as an upgrade step.

17394 are raised.

a stored procedure that uses SET ISOLATION LEVEL statement

together with conditional statements and that also accesses

temporary tables (#<table_name>) which haven't been created

inside this stored procedure.

every attempt by RepAgent in ASE to connect to RepServer leaks one file descriptor.

This can eventually lead to "kernel nopen: accept, Too many open files" error followed

by 1605 error "server Failed to open virtual socket for new connections".

expected after either loading a transaction dump that was dumped with the

NO_TRUNCATE clause or loading a transaction dump using the UNTIL_TIME clause.

the Migration Tool throws a "NullPointerException" error if the "Back" button is clicked

from any of the windows.

ASE task is not removed from the ASE and it continues to run the query consuming resources.

can be reported when calling the method registerOutParam() for a datatype of java.lang.Types.JAVA_OBJECT.

Reviewed Dec 2002. Fix is targeted (but not committed) for the 12.5.1 release.

data and Adaptive Server is configured with a multi-byte character set.

in the module 'th__check' together with a stack trace which includes the

module 'th_log_lct_reserve' may be reported in the error log.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

The error that was thrown was

"The specified Default is a system generated one, whose DDL cannot be generated : <def>".

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

when being accessed within a subquery, generates an error 207.

If gh_chunks tuning is desired, the following guideline can be followed.

If gh_chunks is non-zero, shared memory page size is promoted from default 8KB to 4MB,

and those pages can ONLY be used by ASE and are wired down at boot time.

The value for gh_chunks (number of 4MB pages to be wired down) can be calculated as

"max memory"/4MB (for pre ASE 12.5 releases, "total memory"/4MB) rounded up.

For example, to allocate 2GB for ASE, set gh_chunks=(2048MB/4MB)=512.

which includes the modules 'senderror', 'd_upgradeobj' and 'exec_dbcc' if the command DBCC

UPGRADE_OBJECT is used to upgrade a compiled object containing a view on a table which does not

exist.

datatypes, that will neither truncate trailing spaces or null bytes (which might be

significant to their application) or pad the type with additional spaces or bytes.

Rather, the datatype should simply store what is inserted.

Space savings would still occur as only as much space as is needed would be used to

store the value.

The variable-length CHAR datatype would be able to distinguish between a null, a

zero-length string "", a single space, and any number of spaces. Likewise, the BINARY

type would be able to distinguish between a null, a zero-length binary string, a binary

string containing a single null byte 0x00, or any number of null bytes.

Reviewed Nov 2002. This feature is targeted (but not committed) to the ASE 15.0 release.

Reviewed Nov 2002. Feature is targeted (but not commited) for the ASE 15.0 release.

sp_dropsegment 'logsegment', or sp_extendsegment 'logsegment' have

been executed.

Alternativaly, DBCC TABLEALLOC(syslogs, full, nofix) may report a

12947 error "Syslogs free space is currently <X> pages but DBCC

counted <Y> pages. This descrepancy may be spurious if this count

was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs,

full, fix) to correct it."

single-byte Asian character sets, non-ASCII characters with ASCII equivalents

are recognized in keywords, numeric literals, and string delimiters. The

command line trace flag -T109 hereby disables this behavior, allowing only

ASCII characters to be recognized in keywords, numeric literals, and string

delimiters.

This is incorrect and should be updated to v12.5 Installation Guide documentation...

Chapter 8 Upgrading Sybase Servers ...

Draining the transaction logs for primary databases

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

with an assertion failure.

the query that immediately follows conversion error return such as message 2402.

error messages longer than 255 bytes, originating from remote servers (e.g.

backup server) are not relayed correctly to client applications.

return duplicate rows if the select list for the inner query includes a non-correlated column.

"disk mirror name = master, mirror = <mirror device path>" may fail with error 5137

"Dynamic mirroring failed for logical device 'master'. Check the SQL Server error log for more information".

ASE kernel reports "sddone: read error on virtual disk 0 block 0: not within virtual disk range, start bn = 2

Closing the secondary device for virtual device master" in errorlog.

error 2402 is raised if character data contains roman numerals.

columns is the inner member of an outerjoin.

Reviewed Nov 2002. Fix is targeted (but not committed) for the 12.5.1 or 15.0 release.

10106 270704 jConnect now kills the connection when the server's

default charset is unsupported in Java (and the client

has not made a specific request for a charset). When

the client does not request a specific charset,

jConnect will attempt to use the server's default

charset. However, there are cases where the server

charset does not map to Java (because there is no

corresponding converter in Java -- an example would be

the roman8 charset). Previously, jConnect would allow

the Connection to be made, but the connection would be

unusable, as all further communications with the server

would result in an exception. jConnect now throws at

JZ0IB exception and does not allow the connection to be

made.

This problem is not an ASE Replicator problem, but rather a jConnect/Java/roman8 problem.

the procedure to renormalize its object references. If a procedure refers to a

table_a, and table_a is renamed to table_b, the procedure will currently continue to

reference the contents of table_b even if a new table_a is created (if the

procedure is dropped and recreated, or the original table is dropped, then it will

start refering to the new table_a). If the RENORMALIZE option was used, the

procedure would start referencing the new table_a.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

in the reference manuals, usibg an example.

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

Reviewed Nov 2002. This feature is not targeted for a future release. The config files can be copied to resolve this problem.

followed by a stacktrace.

returns 0.0.0.0 instead of the IP address of the client.

Reviewed Nov 2002. The fix for this CR is targeted for the ASE 12.5.0.3 release. See also CR 298368.

statistics found in optdiag, such as cluster ratios, space utilization

and large io efficiency.

This is harmless and can be ignored. The suspected cause is that the first extent of an allocation unit is being deallocated at the same time checkstorage is being run, and catches a moment in the processing when the allocation map indicates all 8 pages of the extent are deallocated, although the first page of the extent, which is the allocation page itself, should actually never be marked deallocated.

Reviewed Nov 2002. Pending further research.

statement "select * from table where char_column like @p1" sent from

jConnect 5.5 client will fail to find a match.

-----[304 changed to 304]-----

< uninstall_feature_reverse_dependencies=The following features require the feature you are unselcting. If you select OK, these features will also be deselected.\n{0}

---

> uninstall_feature_reverse_dependencies=The following features require the feature you are unselecting. If you select OK, these features will also be deselected.\n{0}

Currently, if you issue a CREATE or ALTER database on a device that doesn't have as much free space

as was requested, ASE allocates all the available space and provides a simple message of how much space it allocates (but without drawing attention to the fact that it is less than was requested). Whether or not it should actually fail with an error instead has been debated for years.

This CR requests a new sp_configure parameter to control this behavior, such as

sp_configure "Cause create/alter database to fail if requested space not available" (default 0)

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

command line.

parameters as well as declared variables. (Parameters are current visible with the "where" command, but it seems intuitive that "show variables" would display parameters as well, as they look and act just like variables.)

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

declared variables. Currently it only works against variables.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

commits resulting in sub-optimal performance. Likewise, the data pages of

a table created in TEMPDB with SELECT INTO are unnecessarily flushed to disk.

This optimization may be disabled using the 2709 trace flag.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

select * from blurbs where copy is not null

java.io.InputStream is implicit. The conversion between

SQL type TEXT/IMAGE and Java type java.lang.String has to be

explicit.

after "load database" raises warning message 7961. Subsequent executions are

fine.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

Reviewed Nov 2002. Feature is currently not targeted for any release.

Reviewed Nov 2002. This feature will be addressed in the documentation released with the next release of ASE.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

creation through the 'CREATE DATABASE' command, then errors 913 and 834

may be hit with a stack trace reported in the error log showing modules

'dbt_removeall', 'bufdbclean' and 'cm_dbclean'. The same can happen if

instead the database is being dropped through the 'DBCC DBREPAIR(<dbname>,

DROPDB)' command.

must specify the column names. This fix can be disabled by traceflag 1702.

which includes the modules 'proc_setdb_tree', 's_renormalize' and 's_recompile' if a stored procedure containing a SELECT statement having 16 subqueries in the select list is executed and the table referenced by the SELECT is dropped and recreated in the meantime.

You can work around this problem by running syconfig from the command line.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

to the remote server fails. This enhancement works only when traceflag 11299 is turned on.

invoked helper process. This can easily confuse the DBA or SA when platform specific

commands are required to control the process. With this fix, 'showserver' command

only lists the main thread for ASE or its related components.

do not match" may be reported when executing a query that references the

same column in the select list and in the WHERE clause of a view which

itself defines that same column as a subquery.

Reviewed Nov 2002. A fix is planned but currently unscheduled.

trace in the errorlog when creating a large database on a raw device.

Failed to re-set the database context to original catalog of <xxx>.

Current catalog is <unknown>.

With this fix, ASE Replicator will still log this error but it will keep going. The side effect may be slower performance because connections to ASE will be closed and re-created instead of being released and held in a pool.

CR 301366 opened for DOC changes

various entries from interfaces file, especially entries of non-tli styles. Also there were few problems, when the entries in the interfaces had preceding/following white spaces/comment characters.

returns erroneous output for a stored procedure that has a multi-byte character

in the 255th byte position in its CREATE PROCEDURE statement.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.0.3 release.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

will return 0x12ab instead of null.

after 7940/7949 errors were corrected by the DBCC TABLEALLOC command run with the FIX

option.

sp_modifylogin to modify the attributes of a login.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

allow null values." will be reported, when a stored procedure

creates a table using SELECT INTO with the options IDENTITY_INSERT,

EXTERNAL FILE, EXTERNAL TABLE or COLUMN DELIMITER and

we try to insert into that table inside the same stored

procedure.

be false if minimally-logged operations or dump tran with truncate_only had been executed since the most recent dump database).

Reviewed Nov 2002. Pending further research in engineering.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

FROM clause and <table> has a referential constraint.

audit event number, returns the associated description of the event.

with the module memmove(),run__fix_collen(),do__groups() or run(), may be reported in the

errorlog when processing a query that contains many aggregate functions needing

multiple worktables.

parameter is enabled.

The syntax will be:
sp_chgattribute tab_name, "identity_burn_max", 0, new_identity_val

task termination could lead to phantom processes.

the '=' operator in prepared statements behaves as 'like' clause.

@variable1, the index on the <column> is sometimes not used.

These errors are greatly reduced, but in theory not totally eliminated, by the fix to this CR.

index (the index keys are not being updated), may be incorrectly executed in

deferred mode rather than direct mode, resulting in poor performance.

sp_configure "disallow non-sa logins before recovery complete" [default off]

that would prevent any users other than users with sa_role from logging in to the server before

recovery of user databases is complete (i.e. logins would be allowed starting either just before or just after all engines are brought online).

This description is under revision.

In 15.0 GA and 15.0 ESD#1, sp_modifylogin NULL, "enable logins during recovery", "0"/"1" needs to be used.

As of 15.0 ESD#2 onwards, the sp_configure "enable logins during recovery" option needs to be used.

2. The sp_sysmon "Task Management" section has been updated with a more detailed recommendation for the I/O Pacing section.

empty error message.

rusnocsnopref.srt.

This fix makes ASE recognize 'ASE_DIRS'.

dump or load if the product (allocated space * pagesize) exceeds

4gig.

to 585 on 32 bit platforms and 512 on 64 bit platforms.

Due to the current implementation of timestamp, this will lead to differences in the timestamp values between the primary side and the secondary.

replication if they lose the primary, replicate or DDB database. This would include

recommendations for backups.

Customer would also like complete instructions on how to recover replication

(including locater reset commands, dbcc's ect...) in the event that the customer had

to recover (restore) any of the involved databases from backups.

"noobhandler: recv of OOB byte returned -1 errno 22" or

"noobhandler: recv of OOB byte returned -1 errno 4" reported in the error log,

leaving the corresponding Adaptive Server sessions unable to be killed.

allocation for the target table, when possible. As a result, SELECT INTO may

choose the largest I/O size possible for the target table, based on the size

of the buffer pools available in the target database cache.

Java capabilities of ASE will become unavailable and attempts to use Java fails in unpredictable ways.

Running "sp_who" will show the process waiting for "remote i/o". The errorlog may have a stacktrace

containing U_get_previous_frame_x and ending with ExecuteJava__7VMFrameSFP6JNIEnvP8VMMethodP6VMword.

where the data file contains less columns than expected

causes dataserver to crash with a core dump.

may get error 924 saying that database is in use by other tasks.

as kill spids, truncate table, create/drop index, dump/load database/transaction.

Or add another type of role that would only have a subset of sa_role authorizations (between operator and sa role).

may be reported by DBCC CHECKSTORAGE on page 0 in a database which

has a proxy table to a partitioned remote table.

to Operating System for setting non-blocking mode or asynchronous mode for a client

connection fails.

are violated.

'CREATE DATABASE' command, to allow the database administrator

to specify database id when creating a new database.

instead of 'sql' as useful for getting temp table info of the debugged task.

a stack trace which includes the modules stu_findslot, st_hist_has_freqcells and

j_process_n_bld_distmap, may be reported in the error log for queries using sort-merge

join, and one of the columns used in the join has the value NULL for all rows in the

table.

a 16384-byte long string.

of a 12.5 ASE does not have the unique attribute set whereas it should.

audited, sp_displayaudit incorrectly displays that both actions

are being audited. In either case, only GRANT actions are actually

being audited.

deallocating a page (as a result of deletes), while another is trying to

scan the object for the rows it wants to delete. The stacks of tasks

will show functions apl_getnext and removepage respectively.

or in the module 'com__subquery' may be reported in the errrorlog when

executing SELECT that contains subqueries and assigns multiple local

variables that are used in the SELECT list and in the WHERE clause.

signal and fail. ASE treats EINTR as unrecoverable error leading to the connection being

aborted by the network handler. ASE may report "nopen: accept, Interupted system call" in

the errorlog leading to 1605 error.

This fix incorporates SSL Plus library v.3.1.3 into ASE.

ASE must be used with the corresponding OCS release using SSL Plus v.3.1.3.

to affinity to it" may be raised when an engine is offline and dbcc monitor is executed

multiple times (through sp_sysmon or historical server).

may make a large no. of exclusive row requests and impact performance

due to redundant garbage collection checks.

depending on the length of text constant in the SELECT clause.

that uses an aggregate function in a WHERE clause within subquery under a HAVING clause on a correlated column. The error is raised when such a statement is executed via a stored procedure which is recompiled.

modules 'cinsert' and 'ncupdate'.

in ASE 12.0.x and 12.5.x. with Msg 241:

Msg 241, Level 16, State 2:

Server 'local', Line 3:

Scale error during implicit conversion of NUMERIC value '11.6000004' to a

DECIMAL field.

"Can't open a connection to site '<remote server name>' because 'set up channel' message was not acknowledged"

if they are issued to the same remote server after the timeout period.

ASE reports "nconnect: connect, Connection refused" error followed by

"Cannot read, host process disconnected: <remote server name> spid: <n>" in the errorlog.

executes a procedure via a cursor then it's usage doesn't show up in the

stats.

A possible implementation of this would be to use an architecture similar to the way sp_thresholdaction is handled with last-chance thresholds.

sp_password could be modified to check for the existance of a user-provided procedure called (for example) sp_validate_password @varchar(30) password, and if it exists, pass the new password to it for checking, based on the results either abort or go ahead and change the password. Sybase would not provide sp_validate_password so that it does not get overwritten (losing the user-provided content) when installmaster was run.

parameterized language statement through jConnect fails with some multi-byte characters.

block will be missing.

view with DISTINCT clause may produce a stacktrace. This happens when the

view with UNION ALL is not materialized into a worktable.

when accessing a table, if a non clustered index is

created on this table in the same batch.

in the Connectivity libraries linked with ASE cause ASE to exit abruptly, with

the message "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED. SERVER MAY NOT BE ABLE

TO CONTINUE" in the errorlog.

a user-defined role.

system or user-defined temporary database. The stack trace of the hung process will

include the modules 'recover_tempdb', ..., 'pg__updateoam' and

'pg__updateoam_thru_allocpg'

is executed only when the procedure is compiled.

extended stored procedure with a parameter list, this having been created via the

"sp_addextendedproc" procedure. This fix is enabled only by starting Adaptive

Server using -T523 traceflag.

together with a stack trace which includes the modules 'smput', 'send_audit',

'form_and_send_audit', 'chk_and_send_audit' and 'ex_audit' may be reported in

the error log.

SybaseFeatureUninstallPanel: Added some code to figure out whether the repository is "disconnected"

Uninstallable*: Added special methods for selecting withough doing dependency checking.

This problem is fixed by providing an appropriate error message with a trace in

the sqldbgr code and continuing to run the sqldbgr

Users using a non default 'max memory' configuration should take note of the
increase in the memory requirements of the 'large i/o buffer' pool and update
their 'max memory' configuration appropriately.

Users using the default 'max memory' configuration and having the 'allocate max shared memory' config option set to '1' should also take note of this change and
make sure that adequate memory is available for ASE or specify an explicit value
for the 'max memory' configuration in the config file.

if there is free space in fragments without system segment.

the engines were less active and only a couple of engines were under high load.

row length and offset VALUE may be reported with error message 631

"The length of <value> passed to delete row routine for the row at

offset <value> is incorrect on the following page: <value>. The expected

row length is <VALUE>. The offset should be no greater than <VALUE>".

Alternatively when the configuration option 'print recovery information'

is active the error message 3410 "Roll back transaction '<value>' -- was aborted."

may not be correctly reported.

to execute a DROP TABLE command fails to report either a 3906 or a 3944 error;

"Attempt to BEGIN TRANSACTION in database '<value>' failed because...".

"nl__write_defer: write failed on socket 1: Insufficient quota to complete the requested service".

of this property represents seconds. However, the granularity of the timeout is determined

by the housekeeper, which wakes up roughly every minute to perform its housekeeping chores.

One of the new chores is to check for CIS connections that have been idle for a time equal

to or greater than the configured timeout value. If that is the case, these connections

are dropped, if no transaction is pending for the thread that owns the connection.

exclusive lock on the table.

is reported when a statement with multiple keywords is executed and the total size of all the double and triple keywords within the command exceeds 30 characters.

M_SYNTAX_PARSE error during precompilation.

at some point so that other databases can be recovered.

2. Automate the process of deleting old inactive sessions & views.

3. Have historical server put the data directly into a table instead of a text file

Error 2521 in TSG on how to handle this.

1. Solaris /etc/init.d/sybase script to start and stop all servers.

2. Script to do master database critical table BCPs, take snapshot of current configuration, and dump the master database.

3. System procedure to run "update statistics" on all user tables.

permission to SELECT a grantable built-in (SET_APPCONTEXT,

GET_APPCONTEXT, RM_APPCONTEXT or LIST_APPCONTEXT), tries

to SELECT them from within a stored procedure owned by

another user who has not been explicitely granted

to do so.

database <value>, the forwarded row (<value>, <value>) pointed to by (<value>, <value>) is invalid", may be reported.

is shutdown while that engine is still in the dormant state, the unix process corresponding to the dormant engine may still be present after shutdown.

in the given target table, then some data is mistakenly left

into it, although the target table's creation cannot be undone

at that stage.

is often used in conjunction with backup strategies.

statement using views in the FROM clause together with multiple UNION clauses and a GROUP BY clause.

monitor (perfmon.exe) is unable to list counters from any configured ASEs.

not been installed in $SYBASE/$SYBASE_OCS. Attempting to run xpserver fails in exec() reporting

"Cannot load program xpserver because of the following errors: " followed by the

message "Dependent module libsrv.so could not be loaded".

in terms of class loaders, to the point where behavior may differ from placing the implementation in the java/classes directory. Additionally, the documentation should include recommendations for when a JAR file should be in java/lib versus in the java/classes hierarchy.

contains an ORDER BY with a column that does not appear

in the result select list.

"Database '<value>': beginning upgrade step [ID 1307]: executing SQL

statement (if not exists (select 1 from syscol)" would be followed by 1505

error "Create unique index aborted on duplicate key. Primary key

is '<value>'".

Error 12323, state 51 may be raised when running REORG REBUILD on an index

of a DATA_ONLY LOCKED table. A stack trace will appear in the errorlog with

module bt__batchinsert_log_getendpos() and bt__rebldchk_failed().

column has a value of NULL. This will happen if the row previously contained a non-NULL text value,

but has since been updated to NULL.

a segmentation violation occurs on outbound CIS connections using SSL.

The solution is to ensure that the appropriate SSL filter with driver version

is in place in the OCS-12_5/lib directory.

Connectivity is fixing library behavior so that an appropriate error message

is encountered, instead of a segfault.

corruption detection due to hardware problem.

ASE kernel reports "Process <process ID of failed engine process> exited with status 0"

in the errorlog followed by the message "current process infected with 11" in the

module 'kediagexit' together with a stack trace.

do not report the amount of log space that is reserved for rollback log records.

This caused the ddl to fail when executed against a db, which was created using 'with override' option.

the SELECT INTO <target> FROM <source> ORDER BY command was not predictable.

We now retain this sequence by inserting rows in the order of rows received.

system database dump is initiated.

is being cached, due to the premature access of the cached information.

The likelihood of hitting this error increases when the 'number of open

databases' is configured too low.

Adaptive Server as a host variable to a Dynamic SQL statement. Truncation

occurs when BOTH the following hold true:

1) The dynamic parameter marker is used as the argument to a builtin

function or a string concatenation expression. For example (using

Embedded/SQL syntax, but not limited to Embedded/SQL):

PREPARE s FROM "SELECT 1 FROM t WHERE col1 = col2 + '?'"

where the host variable data is greater than 255 bytes.

2) The dynamic statement is executed more than once, and the second

execution uses data that exceeds in length the data used on the

first execution. For example:

EXECUTE s USING :one_thousand_byte_var;

. . .

EXECUTE s USING :two_thousand_byte_var;

if one of the remote columns has a default set to it. Only seems to happen in

conjunction with DC,

with many simultaneous connections, each of which is configured

for a multi-byte character set (e.g. SJIS/EUCJIS)

"Object '<table_name>' cannot be found." may be reported when executing a stored procedure that

does a CREATE TABLE under a IF statement and a SELECT from the same table.

simple sanity checks on 'sysgams' system table when

command DBCC CHECKTABLE('sysgams') is executed.

the message "Sysgams in database <value> has <value> extents, but

the database needs <value>. Please contact Technical Support for

assistance." may be incorrectly reported in the error log.

supply data for a column having a default when the default is added using ALTER TABLE immediately after the SELECT INTO that created the object.

including the modules 'attrib_insrow' and 'pg__allocate' when a SELECT-INTO

command is executed that has a local table as destination and a proxy table

as source corresponding to the execution of an external remote procedure.

has been created with ignore_dup_key or ignore_dup_row, @@error value

is set to 3601 to indicate the command has been aborted. This value

should be zero as the duplicate key or row has been specified, to be

ignored, through the create index options.

databases have been recovered. Messages similar to "os_process_exists: kill failed. pid 1 Not owner"

and "engine 6, os pid 1 exited" will appear in the log.

traces when creating over 16k nchar/unichar local variables.

"current process infected with 11" stacktrace on the following functions

ra_ct_sendpassthru(), ct_sendpassthru(), and ksctsuspend().

built-in function sometimes causes truncation of the resulting value.

'dsync' attribute of device 'emp_dev' turned 'off'. Restart Adaptive Server for the change to take effect.

gather metadata for a table that is being dropped.

when a stored procedure is invoked by a client application as a remote procedure

call and a cancel attention is also sent by that client application.

constraint name or sometimes no name at all.

for a given database by raising an unexpected 2222 error. This may happen if

ever the 'sp_configure' stored procedure was run subsequently to suspending

the update activity for this database using the 'QUIESCE DATABASE HOLD' command.

selection may be skipped on the dbcc_faults and dbcc_fault_params tables in the

dbccdb database.

It reads:

create procedure sa_check as

if (proc_role("sa_role") > 0)

begin

return(1)

end

print "You are a System Administrator."

The print statement is placed past the end of the proc definition.

The correct code example should be:

create procedure sa_check as

if (proc_role("sa_role") > 0)

begin

print "You are a System Administrator."

return(1)

end

may may be reported in the error log together with a stacktrace which includes the modules

'ubo_object_from_slot', 'uwforeachchild', 'wt_pss_family_owners', 'lock__set_sleepingowner_list'

and 'lock__check_deadlock'.

reserve words.

the upper limit of ASE's "max memory" parameter from roughly 2 gb to roughly 2.75 gb.

table using a small batch size by using -b option.

errors related to usability of this database." is reported in the error log when loading database

'master' (with Adaptive Server started in 'single user' mode). This message doesn't affect the

load and recovery of 'master' database.

If an Abstract Plan is forcing the query plan, check its correspondence to

the query. If not, please contact Sybase Technical Support." may be reported

when executing a query with nested subqueries which contain an aggregate

function like MAX() or MIN() on a table that is not correlated.

sp_audit "all", "mon_role"

wrong record number is captured.

Error message 18897 is reported when user switched to the master database
and running 'sp_modifylogin' there.

'-i' option in RUN_SERVER_BS file and the registry. This problem prevents us from starting up backupserver.

will be raised by the stored procedures sp_password and sp_addlogin

when trying to set a password that contains a single quote.

- Select 'Help'->'About ASEPlugin' menu item. A dialog shows up with the build information.

- Select 'Help'->'About Sybase Central' menu item. A dialog shows the version string with the build information.

when run against a Data Only Locked table followed by a segmentation

violation in module 'getpage_with_validation' with a stack trace in

the error log resulting in the session being killed.

with error mesage, "Could not load library examples.sl".

"### kipollsignal: resetting sigmask" continuously in the errorlog.

This problem is due to Sun Bug ID 4457358. To resolve the problem, install

Sun patch 105210-41 for Solaris 2.6, 108244-03 for Solaris 7, 109384-02 for Solaris 8.

results in promotion to an exclusive table level lock on that same object,

then other readers or writers accessing this object will not be blocked by

this exclusive lock. An 820 error may be reported by the concurrent sessions

that are trying to update the same pages.

there's a CS- / CT-Library issue.

create procedure xp_freedll @dllname varchar(25) as external name sybsyesp

monCachePool.Stalls

monDataCache.Stalls

monDataCache.CacheSearches

monDataCache.LogicalReads

monDataCache.PhysicalWrites

of less recently used plans. This unintended change in the replacement policy results in more

procedure reads and lead to a performance degradation. Applications that use EXECUTE <proc> WITH RECOMPILE,

will observe a heavier degradation due to a higher need for caching new plans; creating these

procedures using CREATE <proc> WITH RECOMPILE will improve the performance of ASE.

binding that it qualifies for. Further, it will not be possible to create an application binding for an application name of "" (i.e. the empty string).

a VARCHAR or VARBINARY datatype. This happens when the variable with CHAR / BINARY datatype is

asigned to the variable with the VARCHAR / VARBINARY datatype. A new version of the fix for

CR 196218 will be available later under CR 263837.

control characters like spaces are present between certain SQL keywords. For example

CREATE<space><space>TABLE could be stored as CCREATE<space>TABLE.

characterset to an ASE with a multi-byte default characterset

available users for the database. This is now fixed.

Previously these were restricted to the 'sa' only. This restriction has

been removed. Login bindings take priority over application bindings.

(Login, Application) pair bindings are still not supported.

be raised because of an empty BEGIN/END block in the SQL being used. This error is raised correctly but the procedure/trigger text is saved in syscomments anyway.

allowed if the table also participates in a regular join clause." can be raised when executing a

SELECT INTO. The message is correct but temporary tables created during that session are orphaned.

$SYBASE/$SYBASE_ASE/sample/esp/ on ibmaix64 platform.

1 indicates report only hard faults. 0 is the default and reports everything as currently.

together with a stack trace which includes the modules 'keipanic' and 'ueshutdown' may

be reported in the error log when 'shutdown" or 'shutdown with nowait' is executed

on an Adapative Server that has started XP server.

The device tab of segment properties is now showing the size of device that is used by segment, not total device size. The device size can be found in database device properties which can be interlink from the device tab of segment properties.

be reported in the error log when accessing a proxy table on another server.

convertion of a char(>15) column to text value.

in the syscomments.

character sets.

at meta data in internal JDBC driver.

With this fix, TEXT/IMAGE column datatype is showed as TEXT/IMAGE type at

meta data in internal JDBC driver.

With this fix, the string representation of the object will returned without error.

out file '<file name>' due to system error '<system error message>'"

could be unable to report correctly the file name of the configuration

file specifying the message "Invalid pointer param number 2, pointer

value 0x00000000" instead of the default configuration file name.

We can check the value in column "dpagecrcnt" from table "systabstats". This value is used to calculate the data page cluster ratio.

Solaris% isql -Usa -P -Drepro

1> select dpagecrcnt from systabstats where id = object_id("client_search_100_v2_t")

2> go

dpagecrcnt

----------------

311.000000

(1 row affected)

1>

Also we can see it in the "optdiag" output:

Table name: "client_search_100_v2_t"

Statistics for index: "idx" (clustered)

Index column list: "search_key"

Data page count: 444

Empty data page count: 0

Data row count: 10001.0000000000000000

Forwarded row count: 0.0000000000000000

Deleted row count: 0.0000000000000000

Data page CR count: 311.0000000000000000 <<<<< high value

OAM + allocation page count: 4

First extent leaf pages: 0

Data row size: 0.0000000000000000

Index height: 2

Derived statistics:

Data page cluster ratio: 0.3427835051546392 <<<< poor clustering

Space utilization: 0.0000000000000000

Large I/O efficiency: 1.0000000000000000

==================================================================================

To Reproduce this issue

// creates the table

isql -Usa -P -Drepro -itable.sql

// populates the table

bcp repro..client_search_100_v2_t in x.dat -fimport.fmt -Usa -P

// create the index with the sorted_data option

isql -Usa -P -Drepro -i idx_datasorted.sql -o idx_datasorted.out

// gather statistics

optdiag statistics repro..client_search_100_v2_t -o idx_datasorted.sts -Usa -P

overflowed or corrupted its stack -- aborting" message in its log

may be hit resulting in the session being terminated. The stack trace in the error

log will report modules 'th_fill_freespaceinfo', 'th__oam_extent_count' and

'pg_oam_extent_count'.

exceeding 'max memory', a descriptive error 10879 is printed instead of

the earlier error 5861.

on a proxy table if the proxy_table's column/s have been renamed using sp_rename.

"You cannot use the modulo operator on smallmoney, money, float,numeric or

real columns."

when trying to set up ha_role auditing.

may result in Error: 12324, Severity: 21, State 1.

in localized (non-English) error messages may be incorrect on 64-bit platforms.

missing." will occur when executing a stored procedure in CHAINED transaction mode that contains RETURN <value> statement.

Msg 7981, Level 16, State 1:
Procedure 'sp_procxmode', Line 93:
The new transaction mode must be unchained, chained or anymode.

issued via execute immediate or from within another user stored procedure.

packets when the SQL statements are executed using EXECUTE IMMEDIATE

inside a stored procedure.

stack traces and the connection is terminated.

from a recently loaded database.

later servers.

subsequent versions up to and excluding 12.5.1.

a) newid(), newid(0) will return GUID as VARCHAR with no dashes

b) newid(1) will return GUID as VARCHAR with dashes

c) newid(0x0) will return GUID as VARBINARY (any varbinary as argument will return

GUID as VARBINARY).

d) newid() builtin in select statement or used as default will generate new

values for every row that is selected or inserted (in case of defaults)in

the statement. TRACEFLAG 395 will disable this behavior.

The following example will explain this new behavior.

create table T1 (c1 varbinary(16) default newid(0x0), c2 varchar(30)

null, constraint pkey primary key (c1))

go

insert T1 (c2) select name from sysobjects

go

--- The above example there will new value generate for every row in sysobjects

statistics are used and Adaptive Server's configured page size

is greater than 2k.

the errorlog if the database being checked resides on raw devices/partitions.

Problem does not exists for filesystem devices.

"sql server clock tick length" is set to 10000. This is due to a bug in HP-UX

being investigated by HP-UX PM scheduler team; the bug id is JAGae81924.

hang because of corruption in an internal queue of i/o structures.

is indeed on the same box as ASE.

not null and where no defaults are defined, the sql server may receive a signal 11 and terminate the client process after issuing a 4997 error:"alter table <tabname> failed. Default clause is required in order to add non-NULL column <colname>." The stack trace in the errorlog may include modules scanstypes(), palt__ck_add(), palt__ck_subclauses() and pre_alttab()

trace which includes the modules xls_preflush, finishlog and xact__endxact may be reported in

the error log if in chained transaction mode a transaction is opened in a Java method and rolled

back, commited or used outsite this Java method.

clauses.

The SP_TEMPDB WHO, <DB_name> will also display application name through which Login

is associated with the mentioned <DB_name>.

may be incorrectly reported when a stored procedure executes a SELECT ... UNION on a table in

a different database."

1601 in the errorlog.

error (overflow, divide by zero, format error, etc.) OR subquery

error like 512 OR a deadlock is hit, then a subsequent cursor FETCH

may fail with error 803 resulting in the session being killed with a

stack trace reported in the error log showing modules 'curs_fetch'

and 'bufkeep'. With this fix, the default behaviour is to end the cursor scan.

However, if Adaptive Server is started with the 589 trace flag, then

the cursor is implicitly closed instead.

a predicate with a column from inner table and ISNULL builtin function that has NULL constant

or @variable as a 2nd argument of ISNULL builtin.

the "--" comment style in stored procedures does not work.

system when failover occurs with databases being recovered in

parallel.

Received Msg 5850. All subsequent exections of same command are OK.

Go to server properties -> Monitor Server tab. Choose the monitor server name and select Display monitor folder.

Chapter 2 Understanding Component Integration Services

Configuration and tuning

Using sp_configure

Dynamic reconfiguration

CIS dbcc commands

dbcc mempools should be dbcc mempool -- remove the (s)

With this fix, in addition to DELETE, INSERT, OPEN, FETCH, SELECT and UPDATE, LOCKTAB can now be used in chained transaction mode to start a new transaction.

script, installdbextend, provided as part of SYBASE release that provides generic threshold

procedures which perform automatic expansion at run-time.

cannot be greater than 2GB. The problem is fixed by providing

large file support in the compress module.

Currently, sqldbgr displays just the line of code the breakpoint is on. Request is to have configurable options to display the <x> lines before and <y> lines after the current line being traced. Another alternative would be to have a GUI interface that displayed the entire source for the procedure and indicated the current line via highlighting.

whereby the divisor is very large.

than the maximum allowed by the server.

temporary table '#<table>' was dropped in this transaction either explicitly or implicitly.

This transaction has been aborted to prevent database corruption" is reported when

a stored procedure that creates and drops a temporary table in a temporary database

that has the "ddl in tran" property, is executed within a user transaction.

option set, checkpoint process bypasses the database entirely instead of checkpointing

the database. If a database dump takes one hour, the target database will go one hour

without an automatic checkpoint, despite any activity during that time.

using a separate directory. The resulting ASE is then booted with the default configuration values.

module 'des__clean' or 'des__unlink' together with a stack trace that

includes the module 'sqt_free' may be reported in the error log

when ASE is cleaning the Light Weight Procedure objects of a session.

This error results in ASE shutting down.

With the introduction of wide columns in ASE 12.5, a new TDS packet "TDS_ROWFMT2" was introduced

to accomodate the increased length in the data rows. There are additional meta data in "TDS_ROWFMT2"

which lead to the increased network traffic. Performance improvements were made to cache the meta data, as

well as providing an option to disable the transfer of the new meta data in "TDS_ROWFMT2" via -T7705

traceflag.

commands with the FIX option may result in removing OAM entries that show 0 pages allocated

and 0 pages used. Similarly the OAM chain may be extended should there be a need for this.

which includes the modules 'res_find', 'resgotos' and 'sqlpars' if a CREATE PROCEDURE is executed

with a very large number of parameters, local variables and goto labels.

ASE does not support i386 glibc, install i686 libraries.

2501 "Table named all not found; check sysobjects".

Error 9923 for partitioned dol tables, if the previous page value stored

in the first page is not 0.

'-uid' when a database is created or upgraded.

inserted into sysattributes table, instead the rows for the definition of those attributes

are modified. That leads to the corruption of the sysattributes table.

protocol error. An invalid datatype was received." is raised when executing a SELECT on a view

containing a UNION clause with SELECT's having a NULL, like SELECT col=NULL, on each side of the

UNION.

following a crash or a SHUTDOWN WITH NOWAIT when the configuration option 'housekeeper free write percent' was non-zero.

result

may report 100004 errors after server startup on a user-created temporary database.

could result in failures while attempting disk i/o. A database should not be recovered

if it's devices are not available.

Fix is disabled by boot time trace flag 397. (396 on 12.0)

of using the actual length.

resulting in 2513 error from 'dbcc checkcatalog'.

are used in certain context.

The command "create table" (T-SQL Commands in the ASE ref manual) and the stored procedure "sp_dboption" relating to the "allow nulls by default" database option (System Procedures in the ASE ref manual, and Setting Database Options in the System Admin Guide) are to be updated with comments to reflect this information.

stored procedure, the 'sysstat' column is not restored back to its original value.

create index, update statistics, reorg running in parallel.

1. Should mention starting the FTS engine during the steps to setup FTS in Chapter 3 of the Full-Text Specialty Data Store User's Guide

2. Chapter 3, under the heading "Name the local server" -- Clarify that it should be ASE server and not FTS engine.

3. Chapter 6, under the heading "Starting the Full-Text Search Engine on Windows NT" --

it should be clarified that the "path to the sql.ini" file must include the filename 'sql.ini'. And if you are adding the errorlog info then it should also include the errorlog file name along with its complete path.

subsequent versions up to and excluding 12.5.1.

sp_serveroption remote_server, 'server login', true

Now do not setup the remote server to trust this server, then the connections to the remote server will fail on second attempt onwards.

any attempt to encrypt a stored procedure text using 'sp_hidetext' will fail with a

9941 error saying "The source text of object named '<Object Name>' with object id

'<Object ID>' is missing and it is not hidden."

be due to insufficient metadata descriptors for the number of tables and procedures

in use by Adaptive Server. Configure the serverwide 'number of open objects'

parameter to accommodate more objects." incorrectly omitted increasing the

'procedure cache size' configuration parameter as a possible solution to the error.

it is specified to be false in 'disk init' command. This happens when

a device with dsync=true property is dropped followed by addition of a

new device with dsync=false using "disk init".

expansion for segments and devices. These rows are inserted and used by sp_dbextend family of

procedures that are provided as part of installdbextend script to support automatic database

expansion.

But, Sybase Central tool displays wrong database segments size.

now only sso_role have permissions to play with the logins;

sa_role has no permission to sp_locklogin/sp_addlogin/sp_droplogin login.

under heavy i/o load on block device or file-system based device. This is followed by the message

in the errorlog similar to "timeslice -1501, current process infected" together with a stack trace

which includes the modules 'rt__daiostart', 'basis_daiostart' and 'basis_dstart'.

value greater than 32768.

From documentation (Performance and Tuning Guide):

Troubleshooting Datatype Mismatch Problems for Joins

If you suspect that an index is not being considered on one side of a join due to datatype mismatches, use dbcc traceon(302). In the output, look for the "Selecting best index for the JOIN CLAUSE".

If datatypes are compatible, you see two of these blocks for each join; for example:

Selecting best index for the JOIN CLAUSE: t1.int_col = t2.int_col

And later in the output for the other table in the join:

Selecting best index for the JOIN CLAUSE: t2.int_col = t1.int_col

For a query that compares incompatible datatypes, for example, comparing a decimal column to an int, column, there is only the single block:

Selecting best index for the JOIN CLAUSE: t1.decimal_col = t2.int_col

This means that the join costing for using an index with t2.int_col as the outer column is not performed

during startup. The improper padding will not cause any problems to the correct operation of ASE,

though it could degrade performance.

"max cis remote connections" output are not increasing and stay zero.

'<value>' in database.... Page belongs to object with id '<value>', not to

object '<value>'", a 69* error or an 806 error may be reported when a duplicate

index key is inserted into a table having both a non unique clustered index and

some overflow pages. This is a run-time error and the table is not corrupted

since DBCC CHECKTABLE does not report any error.

report "Max_Used" quanties that exceed their configured value.

report "Max_Used" quanties that exceed their configured value.

report "Max_Used" quanties that exceed their configured value.

report "Max_Used" quanties that exceed their configured value.

it leaves the VM in an inconsistent state

is set to a value greater than one UPDATE STATISTICS will generate intermediate

histogram with number of steps equal to

number_of_requested_steps * 'histogram tuning factor'. This intermediate

histogram will be later compressed before storing in sysstatsitics.

The size of compressed histogram will depend on the data layout : high

frequency cells will not be compressed. As a result the final histogram should

provide much better representation of the table values.

To activate the feature execute:

sp_configure 'histogram tuning factor', VALUE

whenere VALUE > 1

Good value to use is 20:

sp_configure 'histogram tuning factor', 20

To disable the feature use:

sp_configure 'histogram tuning factor', 1

a DNS entry is used in the interfaces file, ASE encounters "infected with 11"

stacktrace or "kernel ninit: cannot find host" error and fails to boot.

This is due to a bug in IBM AIX 4.3.3 ML11 patch. To fix this problem,

install IBM AIX 4.3.3 patches bos.adt.prof.4.3.3.89 and bos.rte.libc.4.3.3.90.

The problem als exists on AIX 5.1 (fixed by bos.rte.libc 5.1.0.50) and

AIX 5.2 (fixed by bos.rte.libc 5.2.0.10) also.

descriptors per process is set to a number greater than 1024.

releases may fail with error 11060: "This statement has exceeded the maximum

number of recompilations (4). This indicates an internal error. Please note

the error prior to this one and contact Sybase Technical Support".

o A view references a Java type that is either system

or cross database defined.

o The view is sourced in a SELECT INTO statement.

This incorrectly generate recompilations. In the case of

a batch, this will produce a 225 error.

For example, backup server may get "A call to srv__waitfor_read() was interrupted by an attention"

message and ASE does not indicate reasons for this condition.

str_replace(), square(), audit_event_name(), derived_stat(), getdllname(), get_xtypeid(),

get_xtypename(), identity_burn_max(), index_colorder(), internal_encrypt(), is_sec_service_on(),

lockscheme(), newid(), next_identity(), pagesize(), show_translation(), syscol_name() may cause

internal memory corruption, resulting in the message "current process infected with 11 in

different functions, incorrect results or errors like 2511. The diagserver will print an Assertion

message in the errorlog together with a stack trace which includes the modules get_eval_param_type()

and copy__eval()

also has an or in it, depending on the position of / or % you either get

'divide by zero occurred' or some sort of result when dividing or moduloing by 0.

2. in diagram, put the mouse on some selected objects. you have a tooltip, but it shows only object type and not name

containing the module dmp_send_logchain, when truncating a database log

from a recently created database, or at boot time when creating

tempdb, if the log in database model is segragated.

the query fails with error 257 (Implicit conversion from datatype 'INT' to 'CHAR' is not allowed ...)

SET ROWCOUNT statement may raise a 9522 error: "The parameter

that specifies the number of rows in a SET ROWCOUNT statement

must be an integer with a value greater than 0." although

the number of rows specified was a correct value.

BCP or other data migration tools and used as such. Traceflag 1650

will turn on the compatibility mode. This compatibility mode is available

only on Linux platform and only passwords from Solaris 32-bit/64-bit can

be migrated.

being killed when an UPDATE command is run in the 'deferred_varcol' update

mode as shown by SET SHOWPLAN and a data page split occurs. The modules

'xact_endupdate', 'def_insert' and 'linksplit' will also be reported

in the stack trace found in the error log.

only based on the costing of the query. As a result of this, potential cost differences

between direct versus deferred updates are not considered.

In certain siuations this leads to an overall bad plan.

So the request is, to factor in the potential extra costs of a deferred update

1- Creae an XML with XSD

2- Move the tool palette and docked it between the workspace and the diagram.

3- Save model and close the PD.

4- Reopen them, we will notice that the tool palette now is docked on the left of the

workspace but not between this one and the diagram

from a stored procedure or a view in a recently loaded database.

if a database is created or altered on the master device after the master device

has been mirrored with the DISK MIRROR command.

holding logical page '<value>' in sdes '<value>' kept buffer pool

for object '<value>'." together with a stack trace which includes

the modules 'update_statistics', 'sam__get_dol_pages' and 'bufunkeep'

may be reported in the error log when an UPDATE STATISTICS WITH SAMPLING

command is run on a Data Only Locked table that has forwarded rows.

1) If you bring an engine online

2) If you try to do a failover(dbcc takeover)

For example, executing xp_cmdshell "isql -Usa -Sase12503" will cause XP server to hang.

executing a query involving a MAX() or MIN() aggregate and join

operation between two or more tables because the optimizer chooses

the best index to resolve the aggregate function. New command line

traceflag provided to avoid aggregate optimization for queries

involving joins.

the target database is not in single user mode.

'trunctab' and 'cfg_notify_current_audit_table' may be reported when

trying to change the current audit table using sp_configure, if the

process gets into a deadlock or it receives an attention while trying

to truncate the target audit table.

'proc_output_params' added to turn OFF sending back a stored

procedure's return status and/or its output parameters back to the

front-end client. These options are ON by default.

using the bulk interface (e.g. BCP) on an EUCJIS server

configured with "enable unicode conversions" set to 0 and

trace flag -T2402 active, error message 7105 is generated

and the insertion fails. This occurs regarless of whether

the data actually contains any Hankaku Katakana characters

whose width expands from one byte to two bytes during

conversion from SJIS to EUCJIS; it should occur only

if the data contains such characters. Furthermore, extraction

of such data using the bulk interface (e.g. BCP out)

produces a TDS protocol error if the data contains

Hankaku Katakana characters. This should not occur.

followed by stack overflow, when trying to process an inconsistent log record.

all control characters (like space etc.) except for the last control character between these

keywords are not saved in syscomments.

that can output a result set from a table auto-formatting character data. sp_exec_SQL is

a wrapper procedure to execute a SQL statement via 'execute immediate' and handle errors

in a single place.

"current process infected with 11" reported in the errorlog together with a stack trace

which includes a number of instances of init_dummy() module during boot time.

This is due to a bug in Red Hat's glibc patch tracked under RedHat Bug#102995

(Specifically glibc-2.3.1-30 through glibc-2.3.2-30 contains this bug;

which has been fixed from glibc-2.3.2-31 onwards).

Installing glibc-2.3.2-31.i686.rpm or later from RedHat will solve this problem.

"infected with signal 11" messages with different stack traces.

so that the potential later renormalization of this stored procedure may

not give desired effect. In such cases the only way to obtain the functionality

was to drop recreate stored procedure. This issue is related to INSERT and UPDATE

statements only.

reconfigured, some times memory consumption was reported. This

configuration parameter does not consume memory.

when executed at 'transaction isolation level 3' may not obtain a 'Sh_intent'

lock but instead a 'Sh_table' lock although the primary key index is being used

by the query.

index which could be used to flatten the subquery.

in the module 'EngineExitDiagnostics' may be reported in the error log.

Optimizer uses default value of 10 pages and 100 rows to estimate the cost for temp tables when they are created and used in the same batch process.

on both primary and secondary does not resolve the issue.

of 'total logical memory' that was undetected.

UPDATE statement. This is possible if the NULL is a result of an expression

or local variable value.

with a stack trace which includes the modules 'send_proc_audit' and 'cast_const_to_varchar'

may be reported in the error log if auditing is enabled and a stored procedure using Java

parameters is executed.

the owner of this database can access it.", may be incorrectly raised

when trying to online a database that is setup for "dbo use only", if

the database owner in the dump has a different user id from the

database owner of the database being onlined.

no longer issues the aggregate count SQL and the SELECT with ORDER BY statement

to the remote ASE server for gathering statistics. Instead, the new default

behavior for this will be accomplished via a new strategy that imports the

relevant statistics from the remote ASE system catalogs. This enhancement is

restricted to remote server of ASE class and may be disabled via the trace flag

11229, in which CIS will revert to the previous (old) style for gathering

statistics.

ASE 12.5.0.3 ESD#2 or ESD#3, dbcc checkstorage results in 702 Error

"Memory request for 16896 bytes exceeds the size of single page of 16384 bytes".

Use traceflag 7825 to display negotiated cipher suite.

Ability to restrict to a particular algorithm or set of cipher

suites and the ability for a user to programmatically obtain

their negotiated cipher suite is being added under a separate CR.

See 231231, also scheduled for this release.

ArrayIndexOutOfBounds Exception.

when the ORDER BY clause contains a uni(var)char column and not all the columns in the

SELECT DISTINCT clause are in the ORDER BY clause.

wrong results. Also, when unique index and special-OR strategy is used for unichar

and univarcharf columns, the result set ends up containing duplicates, which are

not removed by using *distinct* in select statement.

error with susequent server crash. The stack trace will contain multiple instances of the

function, exectrig.

resulting in the error 403 "Invalid operator for datatype op: type: VARBINARY."

It may be confusing if the function is used within a stored procedure.

environment will become hard affinity to the engine.

on after some data segments are installed. This error results in the database being moved to

a suspect state.

'proc__reset_wktbl' together with a stack trace may be

reported in the error log when executing a stored procedure

that inserts or deletes data in a table that has more than one

self-referential integrity constraints and when Adaptive Server

is configured to use multiple user temporary databases.

Later executions of the same stored procedure may raise a

8210 error, "Keep count of descriptor...was expected to be 1...".

on a 32bit version of ASE, a signal 11 is encountered. The stack of the

terminating process indicates kisignal()->cfg__cache_mem_sizes()->

cfg__memory_check()->cfg_main()->...

If content of the interface entry is separated by tab, then the entry is not read.

Another one: If the end of line is a new line, then NullPointerException.

UNION ALL. In some cases the UPDATE may result in the message "current process infected with 11" in the module 'update()'. A DELETE using the same view in the FROM clause will result in the message

"current process infected with 11" in the module 'norm3_setop()'.

result in some of the clients failing to connect to ASE when there is a surge of incoming connection

requests to ASE. This fix enhances the backlog limit to 128 eliminating this bottleneck.

auditing the creation of temporary tables via SELECT INTO.

The user requests Table Name to be included in the confirm delete message. As of 276282, instead of showing just the confirm message, a Delete Dialog will come up instead. It contains the name of the objects that are going to be deleted, also "Yes" and "No" button for final delete decision.

As a conclusion, the name of the tables that user request to be dropped will be shown in the ASE Plug-in Confirm Delete Dialog, so this CR is closed.

like procedures, triggers, views, so that the output matches exactly what was submitted by the user

when creating the object. Output can be generated with line numbers, and also as a context

block of SQL text around a given line number. Output can be generated as a stand-alone DDL script

which can be then used to recreate the object in most cases. Use 'sp_showtext' without any arguments

to get usage syntax help.

other than the default value "binary", search conditions '=' and 'not ='

can result in null values being selected.

core dumps, or causes ASE to hang in a CIS environment.

The scenario only happens when using java internal JDBC driver, and on text/image column

with NULL value and the user defined function has wasNull() API called on text/image column.

From 燙olumn爌roperties,爏elect constraint爐ab.燙lick on "Add" button, Check constraint wizard starts. In the constraint expression screen, user can click the "columns" button which opens the "Paste columns for check constraint" screen and select columns to be included for the constraint.

database if Adaptive Server is re-started after this indicator has been set.

With this fix, when Adaptive Server is booted with the 3477 trace flag, it

ignores and clears the "bypass recovery" indicator in the master database.

The server DOES upgrade those databases. Customers should ignore the instruction to issue "online database".

Either the method does not exist, or it is being called with the incorrect argument

types." may be raised when trying to execute a new method added to a java class

in a database that has been just loaded.

start the service result in the message 'the service terminated unexpectedly'

Issuing a database checkpoint

A checkpoint is an automatic mechanism to guarantee that data pages changed

by completed transactions are regularly written from the cache in memory to

the database device. Each time it issues a checkpoint, Adaptive Server does the

following:

* Freezes all current data modification transactions

* Writes pages that have been modified in memory, but not on disk, since the last checkpoint, to the database device

* Writes a checkpoint to the transaction log

* Unfreezes the current transactions

2. Excessive traceon(8399) messages occur in errorlog. Add filter.

a remote site (such as backupserver) that uses a TLI network listener if ASE is not using a TLI

network listener.

load database command.

This blocking results in a poor performance for these connections. Optimizations were made to the JAVA VM to allow more concurrency.

because a server kernel thread was being sent a SEGV. Upgrading to

OS patch level ML4 on AIX causes the problem to not occur.

The database devices retrieval SQL is corrected to avoid the Arithmetic overflow exception.

to fine-tune OMNI optimizer to pass OR search conditions as many as possible.

trace which includes the modules 'exec_eop' and 'execute' may be reported in the error log

when executing an UPDATE SET col_name = (<subquery>) WHERE CURRENT OF cursor_name.

when using other then the defaults

table) has been imposed as the deadlock victim, the session fails to

acknowledge this error event and continues.

to 1, and the housekeeper queues have filled up to more than 80% of their maximum capacity

because of an old open transaction.

page 'value' in sdes 'value' kept buffer pool for object 'value'." may be hit

in module "bufunkeep_sdes" with a stack trace in the error log showing modules

"closetable" and "endscan" if earlier the session has been unable to delete

for some reason a row from a Data Only Locked table.

a login delete dialog will display with all the login related users and ask the user whether he/she wants to delete all the users that associated with the login. This is a requirement for dropping the login. After the confirmation, all the users and login will be deleted.

If the login does not has associated users, the dialog will not be shown and login delete as normal.

full version number with minor version included. In 12.5.2,

@@version_number returns 12520. This complements @@version_as_integer,

which returns the upgrade version number (12500 as of 12.5.2).

larger than the maximum size (<value>bytes) allowed for this table." maybe reported when executing

an INSERT statement based on a SELECT using a view and a UNION clause. The error is raised when the

target table has a column with a DEFAULT using a builtin function like suser_id().

and no failover occurs if thorough probe is used and ASE server fails to respond to probe before

monitor times out.

when recovery is attempting to reconfigure the cache memory pools

for optimum usage. Cache memory pools are no longer reconfigured

during HA failover.

together with a stacktrace containing the modules 'call_ns_exec', 'ns_execute' and 'ns__exec_stmt'

when using internal JDBC with the CallableStatement.setNull() methode passing in a

java.sql.Types.INTEGER datatype as second param.

when executing a query using "GROUP BY" clause on columns

defined with fixed char datatype and when the Adaptive Server

is configured with a non binary sort order.

then during ASE restart if the given user device is not accessible,

"sybsystemdb" is silently recovered without a warning message being

reported. This may later cause problems in this database.

sort orders to be selected.

usage for "'list', 'threshold'" command.

attempt to free memory at address 0x<value>..." may be raised resulting

in the session being killed. Alternatively an "infected by 11" error

may occur. A stack trace will be reported in the error log showing modules

'proc_read', 'proc__fetchphdr' and 'proc_read__backout'.

00:00000:00002:2003/11/11 15:04:29.48 kernel uasetalarm: ticks value 0, must be positive

table for the INSERT is different than the database for the base table of the view.

Help button is enable for properties page.

incorrect value when a field in this Java Object is from a subclass and is

assigned a value from a SELECT FROM <table> statement.

operating system level even when no users are active. Boot-time traceflag 4073 has been added to

reduce the likelyhood of these events.

'load' audit option is enabled for a database, instead of when

the global 'security' option is enabled.

in SYSCHARSETS, even when (or especially when) the character set corresponds

with the server's currently configured default character set. This will make it

possible to update character set definitions as support for them evolves - notably

from pre-12.5.1 definitions of UTF-8 (limited to character widths of 3 bytes)

to the 12.5.1 definition of UTF-8 (which includes support for 4-byte characters).

are not handled properly as delimiters to bracketed identifiers.

DISTINCT clause to the query.

when running the 'data_pgs' builtin while there are a lot of concurrent table drops.

not find a unique index which it could use to scan table <table> for cursor <cursor>" being raised

at procedure creation time instead of procedure execution time.

will cause segmentation fault in rg__time_limit_hdlr() routine.

stored procedure parameter name which consists of 30 bytes.

is configured, error message 1579 can occur in unexpected circumstances (e.g. have invalid

characters in the table).

trigger, or SQL batch. Retry later ..." may be reported while a sort

operation is undergoing followed by an "infected with 11" message

in module "dealloc_merge" with a stack trace in the error log showing

modules "sortclean", "startsort" and "sort".

correctly raised but mistakenly followed by a stack trace in the

error log in module 'closetable' during the execution of a stored

procedure that creates a table making usage of a user defined

datatype that has been dropped in the meantime. Module 'tmp_check_nulls'

will also be reported.

from utf-8 with one of the external sortorders (big5bin:194, cp932bin:192,

cyrdict:140, eucjisbn:192, euckscbn:161, gb2312bn:137, gbpinyinbn:163,

rusdict:165, sjisbin:179 and turdict:155).

In the stacktrace, the following functions may be found : s_normquery()-norm3_driver() and

n3_res_udf().

cache size" and "executable codesize + overhead".

erroneously high "large I/Os denied due to Pool < Prefetch Size" percentage

for the 'default data cache'.

built-in function may yield incorrect results if the length of

the expression1 does not equal the length of the matching string

within expression2.

select * from (select sum(advance) from titles) d1 will get 11073 error. Rewrite as: select * from (select sum(advance) from titles) d1(a1) or: select * from (select sum(advance) as a1 from titles) d1

corruption within the JS Task sequencer memory table resulting in Job Scheduler Task violations

such as Segmentation violations or Bus errors. When this happens the only way to restart the

Job Scheduler is by rebooting ASE.

executed with the 'check' option.

This command should be used in those cases where open count errors are reported

and no active session appears to be using the database. Executing this command

may not succeed in all cases, therefore care must be taken when running this DBCC.

This command has to be executed by the SA, its syntax is as follows:

dbcc traceon(3604)

go

dbcc dbcacheremove(<dbid>|<dbname>)

go

immediately after creating a database with the ASE Plugin will fail with

the error 'Cannot unmount database 'dbname' because you are not

currently in the master database.'

Successfully initialized the security mechanism 'csfkrb5'. The SQL Server will support use of this security mechanism.

Security Control Layer was not initialized. The SQL Server will not support use of any external security mechanisms.

The second message which indicates an error occurred was incorrectly displayed.

Kerberos had been successfully initialized and would work.

This fix avoids the incorrect second message.

to remote server has been broken. The connection to remote server is broken due to either remote

server being shut down or the remote connection being disconnected via 'kill spid' on the

remote server.

consistency checking. Errors found by this utility may be fixed using

the new DBCC CHECKCATALOG(<dbname>, fix) syntax.

or accent-insensitive sort order is chosen, variable and database object

names are not case or accent-insensitive, and must be specified exactly

as they were declared.

ASE relies on OS provided Kerberos libraries,utilties, and

Kerberos KDC, as well as the Sybase Connectivity provided

Kerberos driver.

See Kerberos Interoperability Matrix for more details on testing.

installTemplateProcs.bat, installTemplateXml.bat and installTemplateXml are missing.

the table is a temp table with identity column, the identity column

data is not inserted correctly.

of the view with union worktable (if the view can't be merged).

CHECKTABLE on sysdatabases" may be reported when executing a stored procedure

in a recently loaded database that uses a cursor and fetches values in local

variables using extended datatypes (i.e. java classes).

error log when cross-database queries reference a database that is in single user mode and another

session is using this database.

synchronous io is used.

IN() clause, this may lead to suboptimal plan selection for a query

with IN()or OR clauses which joins multiple tables.

To take benefit of the change server must be started with -T301 trace flag.

if the query is executed with the option SET ROWCOUNT.

use the index instead of table scanning which tends to causes a performance degrade.

which includes the module 'PDFreeDataChain' may be reported when

an error is found at SSL initialization or while adding a certificate.

cause trailing blanks to be trimmed from the parameter used.

Requirements : veritas Volume Manager 3.5 , Veritas Cluster Software ver.2.1

'mda_populate_monOpenObjectActivity' during the collection of monitoring

data when the configuration option 'enable monitoring' is set resulting

in the session being killed. The stack trace reported in the error log

will also mention modules 'execrpc', 'exec__native_rpc' and 'mdarpc_exec'.

when running the 'curunreservedpgs' builtin while a database's information is

cached for the first time or it is replaced due to the "number of open databases"

being less than the total number of databases on the server.

'invalid length' TDS protocol errors during login.

To reproduce:

1) Generate XML model from project.pdm (do not select 'generate mapping' option)

2) In the XML model, create a datasource with project.pdm selected as the model

3) On the mapping tab, associate this datasource to the 'employee' element

4) Add the employee table as an element source

5) Select the Attribute Mapping tab and click on the 'Generate Mapping' icon

Note: No changes are made

if a user tries to select from a view that reads a table in a different

database that is set up for DBO use only.

Increase the memory per worker thread.

This message gets displayed on the console but does not get printed in the ASE errorlog.

It is used only after "create database for load", when user must re-create the space allocations and segment usage of the database being loaded from a dump.

query:

select cast(int) = 1

the drop of temporary definition time and partitioned tables.

Furthermore this optimization is applied as far as the drop operation

is not done under the scope of a user's defined transaction context,

irrespectively to the setting of the DDL-IN-TRAN database option

in the tempdb database(s).

be raised using the 'old' name of the object.

any trailing null bytes (0x00) are trimmed. A subsequent conversion back to unichar/univarchar may fail if the original unichar/univarchar data, when

viewed as a byte-stream on the given platform, contains trailing null bytes.

This typically the case for ASCII data on a little-endian platform, since

Unicode characters U+0000..U+007F are seen as the byte-streams 0x00 00..

0x7F 00 on little-endian platforms.

connection pulling data from the consolidated database, the error "Incorrect syntax near the keyword 'TEMPORARY'" would have been reported, and the isolation level of the connection would never have been changed. This has now been fixed.

column that has a default, as the proxy table doesn't automatically import the default

definition. Workaround is to add a default to the proxy table.

Click on the customize column and filter tool

In this window, the attribute type is missing

stacktrace (signal 11) could occur if the view is not materialized. This has been fixed

by materializing all such views.

However, an XPath query with function operator gives

incorrect error message 'insufficient memory' instead of

'XPATH: Parenthesized expression not supported'.

this can lead to stack overflow which results in ASE shutdown.

may return incorrect result if subquery selecting from the view

returns empty set and the view definition includes UNION operator.

Worktable generation may not have as good performance as expected.

the remote server is not.

for a materialization.

The message "current process infected with 11" in the module 'ubffree' together with a stack trace

which includes GarbageCollection modules may be reported in the error log on Unix platforms.

volumes bound to rawdevice interface on Linux.

in Reference Manual

TABLE 8-1 is correct.

with declared defaults and another session dropping such a table.

The deadlock call stacks will show for the former session

the module 'crt_main' and for the latter session the modules

'dropo', 'delcol' and 'dropo' again.

a role after a connection is established.

error 421 " TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT".

This happens when the view returns TEXT or IMAGE fields and requires materialization.

The sp_monitorconfig column 'Reused' has been changed to 'Num_Reuse'

to provide the number of reuse requests as opposed to the earlier 'Yes/No'

indicator of reuse requests.

issued to a remote procedure which insert/update/delete the same table may result in blocking

at the select call. The is resolved by removing the changes introduced in CR 321261. The fix

creates a new traceflag 11228 for CR 321261. This traceflag has to be turned on to allow

create table command in the remote procedure.

CHAR datatype may fail and raise an unexpected 2812 error stating the stored

procedure was not found whereas it actually exists in the database.

trace which includes the modules 'xls_preflush' and 'write_prepare_rec' may be reported in

the error log if a transaction is opened in one database and a Java method modifies a table

in another database.

when running DBCC TEXTALLOC on an indexed table having the 'ignore_dup_key' attribute

and at least one text column.

The Sybase Central User would see a java stacktrace containing the following frames if the details button was clicked:

com.sybase.jdbc2.jdbc.SybSQLException: Invalid role string received.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)

at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)

at com.sybase.jdbc2.tds.TdsResultSet.nextResult(TdsResultSet.java:585)

at com.sybase.jdbc2.tds.TdsResultSet.next(TdsResultSet.java:323)

at com.sybase.jdbc2.jdbc.SybResultSet.next(SybResultSet.java:148)

at com.sybase.aseplugin.sql.ASResultSet.getNextRow(ASResultSet.java:215)

at com.sybase.aseplugin.so.ScheduledJobsCtrSO.checkRole(ScheduledJobsCtrSO.java:170)

together with a stack trace which includes the modules 'pr_do_database' and

'lock_objstats' may be reported in the error log when the execution of

the system stored procedure 'sp_object_stats' hits 1205 error

"Your server command ... encountered a deadlock situation.

Please re-run your command.".

particular cache used by the query has been configured with a size bigger

than 2 Gigabytes.

if ISM (solaris) is not available

- DBCC Wizard

- Backup/Restore Wizard

- Log SQL Statements

- DDL Generator

This behavior is corrected. By selecting the "Save" menu item or clicking the "Save" tool bar button, the file is saved immediately.

and the message will be suppress in later version.

the Java VM associated with that client. This will be followed by the message

'Java services are temporarily unavailable while the Java system is being recycled'.

Correct script to use is distributed as instsecu script.

the dump. No LOGCONN messages can be seen in the ASE log.

'/work2/test.dmp' with error number 2 (No such file or directory)" giving the name of the dump device. The problem is actually with a database device having been DISK INITed with a trailing space in the name or space with-in the name.

objects.

text column mapped to remote varchar column will result in NULL text column being

inserted. This is now resolved for backend running DCO 12.5.0.4 ESD#3 or above.

and cp949 (Korean). Undefined characters in EUCCNS

should be 2 bytes wide. Charindex built-in gives wrong results

with unichar datatype and prefixes consisting of only spaces.

Obscure problems with normalization and surrogate pairs.

User will also get additional information for certain error messages thrown by FOR XML.

FOR XML catches errors thrown from modules underneath it and throws out the error message text under a different message name/number. This fix makes FOR XML also throw out the error message number of the error it caught from the modules underneath it.

needed for the timeout to work correctly. Traceflag 11235 has been added to allow the

behaviour of ignoring connection failures during compile-time.

name' that it does not hold in the hold procedure linked list." may be raised when some processes

are running concurrently stored procedures that use the same SQLJ function.

number reported in the 1249 message text, if ever this error is raised.

granted to all roles and users when the role has no granted permissions on the database.

Library path is

'$SYBASE/ASE-12_5/lib/libcompress.sl'. shl_load()

returned:

Code=2, Message=No such file or directory

Msg 8009, Level 16, State 1:

Line 1:

Error encountered by Backup Server. Please refer to Backup Server messages

"For Open Client EBFs, please refer to SDK URL in MySybase site".

rows instead of updating specified row(s).

mechanism, will now include procedure cache in the default memory dump. The administrator can

override this by manually specifying their preference for dump file contents using the

sp_shmdumpconfig stored procedure for CSMD, and the memdump command for manual "sybmon" dumps.

applications to multiple tempdb with on command.

commands may hang in 'remote i/o'.

large amount of time is spent in filling in the free space information

for a database that has the 'read only' database option turned on.

if a stored procedure tries to access a column that has been dropped

using ALTER TABLE DROP <column>.