Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
  blank
 
 
 
 
 
 
 
 
 
 

 
 
 
Reset | Search Tips | Advanced Search
View results only Community Forums/Newsgroups
Browse Product Manuals
 
 
 



Search Results
Results 1-20 of 1185 for spid
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
Click links below
for results in
specific categories
 
Products : DBISQL 11.0.1 from ASE 15.7 ESD#1 Platform : ANY The Table and Procedure name lookup (F7 / F8) is slow when matching our typing (try this on a server with 1000's of objects to see it). By looking at the auditing output, we see that DBISQL is g
Category: Support and Trouble Shooting Date: 2012-07-09
Products : ASE 15.5 Platform : ANY PROBLEM: sp_sysmon cache wizard deadlocks create clustered index There is an sp_sysmon cache wizard which runs every minute. This causes 'create index' to deadlock on syspartitions. Issue can be reproduced at will. Mu
Category: Support and Trouble Shooting Date: 2011-12-22
Within a query calling dbcc sqltext( spid) with a smallint variable is reporting the text for the executing spid's query, not the variable spid's sqltext. This behavior is only on Linux and Solaris AMDx64, not on SPARC 64.
Category: Support and Trouble Shooting Date: 2010-12-10
A table has a column 'spid' defined with a DEFAULT using a global variable: create 0xA0 table 0xA0 t ( 0xA0 spid smallint DEFAULT spid NOT NULL). A stored procedure, compiled under deferred compilation, is using the global variable spid in a where clause to delet
Category: Support and Trouble Shooting Date: 2008-12-10
Category: Miscellaneous Date: 2008-09-29
We received a support ticket from our clients that users could not access the database. By running some commands, I could see that a user process was accessing one of our tables. This process had a lock type of sh_intent-Blk. How does an sh_intent lock g
Category: Support and Trouble Shooting Date: 2008-06-03
1. Is there a way to tell internally (other than running sp_who) how many SPIDs are used and what ones are free, and if any SPIDs are locked up? 2. Will rebooting server clear the SPIDs and free them all? (that should be true) 3. Can there be mult
Category: Support and Trouble Shooting Date: 2002-03-28
sp_who recently shows a large gap in unused spid's. What's going on?
Category: Support and Trouble Shooting Date: 2002-03-28
Query sysprocesses to determine the operating system process ID of a Sybase spid.
Category: Troubleshooting Date: 1999-08-19
Environment: Adaptive Server Enterprise 15.0.3 EBF 16375 Win, EnterpriseConnect Data Access 12.6.1 ESD#4 Win Problem: Using ASE Component Integration Services when mapping a proxy table to an MS SQL Server table with the 'default' specific
Category: Support and Trouble Shooting Date: 2009-08-05
ASE 12.5 and ASE 12.5.0.1 are no longer using SPID numbers over once somebody logs out. When a new SPID starts, it looks like it's always a higher number. In ASE 12.0 and before that, if you had for example SPIDs 77, 78, and 79 and SPID 77 logged out, the
Category: Support and Trouble Shooting Date: 2002-10-16
Sybase Replication Server
Category: Miscellaneous Date: 2008-02-26
Customer wants to know how to kill a spid where the spid is not a constant. Key Words: ASE Key Words: spid Key Words: kill
Category: Support and Trouble Shooting Date: 2002-06-02
ASE 12.5.3 ESD#5 on Solaris 2.8. Have spids on the server that apparently doing nothing: -- cmd is in 'AWAITING COMMAND' -- tran_name is '$chained_transaction' The transaction have been opened for sometime, got dbcc stacktrace, dbcc sqltext outut. 1
Category: Support and Trouble Shooting Date: 2011-04-06
We have a stored proc that is taking a long time to run. We would like to find out what line number in the stored proc is being run when this happens. How can I find out which statement in the proc the spid is currently executing at ?
Category: Support and Trouble Shooting Date: 2007-09-25
EBF 10688. Trying to get the return code from a dynamic xp_cmdshell statement. Executing the following commands: declare xp_rc int, dbname varchar(30), servername varchar(30), str varchar(200) select dbname='tammy' select servername='sasybqx
Category: Support and Trouble Shooting Date: 2003-04-28
How can we identify the space used in MB within the tempdb database by each process (SPID)?
Category: Support and Trouble Shooting Date: 2011-03-16
Products : ASE 12.5x & 15 Platform : ANY Problem: Help diagnosing issues with dynamic SQL LWPs (Light Weight Procedures) in ASE For example there is no way for a user to see which LWP procedure hangs on which spid.
Category: Support and Trouble Shooting Date: 2010-12-13
OpenSwitch log contains many messages like: Nov 3 04ᛔᛖ 2010: OPENTEST: ERROR: spid 1126: XML_BODY field value of length 2147483647 truncated to 10485760 Nov 3 04ᛔᛘ 2010: OPENTEST: ERROR: spid 1126: XML_BODY field value of length 2147483647 trunca
Category: Support and Trouble Shooting Date: 2010-12-02
Products : ASE 12.5.x & ASE 15 Platform : ANY Problem: How to display the type of authentication used by given users or a given spid.
Category: Support and Trouble Shooting Date: 2009-01-27


1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
 
There may be results in the Newsgroups/Community Forums area, or you can browse and search within the Product Manuals system
 
 
Product Info (1)

Troubleshooting (1134)

   





� Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics