Replication ASA-ASE stops because ASE is full
I have a replication between a consolidated DB on ASE and 4 remote DB on ASA. During a replication, ssremote was unable to apply messages from the remotes because the segments of the consolidated DB where full. The message of ssremote was : E. 03/31 06:00:06. bourget: Error 1105: Can't allocate space for object 'depot' in database 'stp_qual' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment. I have increas...

tempdb full
Last week, for one of our production servers stopped responding. On logging in , found that tempdb is full and we were forced to shutdown the server. The error log read as follows: " 02:00000:00259:2001/03/16 14:10:24.63 server Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available. " We have a threshold in place, that threshold procedure will call another store procedure that will email and page us when ...

ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...

tempdb is full
Hi, I need to know how to capture the query that full up the tempdb database when is at 80%. Thanks Willy Hi, There are a few alternatives oyu can use for that purpose: 1-) add a threhold (calculate how many pages remains when the segment in tempdb is 80% per. full) for the segment you are interested in and insert data related to spid filling up the tempdb into a table located in a user database you got. 2-)(from master..syslogshold where dbid=2) when you find out the spid of the process filling up tempdb, use the following commands to retrieve sql text: dbcc traceon(3604) ...

tempdb full
Last week, for one of our production servers stopped responding. On logging in , found that tempdb is full and we were forced to shutdown the server. The error log read as follows: " 02:00000:00259:2001/03/16 14:10:24.63 server Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available. " We have a threshold in place, that threshold procedure will call another store procedure that will email and page us when ...

ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...

tempdb full
Hi Some query fills my tempdb (system segment), probably a huge 'order by' clause. I'm using 12.0 , so I can't use the 'resource governor' available in 12.5. This blocks my whole ASE !!! I can't even do sp_who How can I find out WHO is filling tempdb and subsequently killing the offending process? I'm thinking of a threshold procedure on the system segment of tempdb, unlike the logsegment, there's no system table to query from for the 'system segment'. (for the log-segment, there's the syslogshold table) Is there any way ...

ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...

Tempdb Full #5
Could anyone tell about the procedure , if the tempdb get full in production system? ( Apart from bouncing the server ) Bal, Kumar wrote: > Could anyone tell about the procedure , if the tempdb get > full in production system? ( Apart from bouncing the server > ) You can use ALTER DATABASE to increase the size of tempdb. Long term, if it is getting full because of regular objects getting created and then abandoned by code, you will need to figure out what code is creating those objects and whap the developers on the head, make them use #temp tables. What ...

tempdb full #3
I received this entry in the log: There is no space available in SYSLOGS to log a record for which space has been reserved. This process will retry at intervals of one minute. tempdb is full. So I did: dump tran tempdb with no_log go the execution of this command took a lot of time. So i interrupted it and did a restart. Is there a more efficient command to free the tempdb?? How to see which user/database filled up the tempdb?? thanks, > There is no space available in SYSLOGS to log a record for which space > has been reserved. This process will retry at inte...

tempdb log full.
Our system is ASE 11.5.1 and SWR8155 and it is running on HP-UX 11. When the logsegment of the tempdb is full, I cannot kill the process which fills the log. And I have to shutdown the SQL server with nowait option. Does anybody help me about why I cannot kill the process which fills up the tempdb log? And is there a way clearing the tempdb logs without shutting down the server (And also dump tran with nolog does not work in this situation) Thanks for your help, Deniz Ata wrote: > > Our system is ASE 11.5.1 and SWR8155 and it is running on HP-UX 11. > When the lo...

tempdb runs full
Does anybody know how i can avoid that tempdb runs full during several heavy SQL statements? I guess i have to increase the size of it, but i'm not sure how i do that the right way. Any suggestions? ASE: 11.0.3 OS: Linux Redhat 6.1 -- Regards Oystein Selbekk any questions: 1. What is the size of your tempdb. 2. What is the size of the tables and result sets of your SQL-statements? If you use 'order by - having' or 'sort by', than the result is buffered in the tempdb Torsten Zielinski "�ystein Selbekk" <oystein@reiselivdata.st.no&...

Tempdb Full #2
The tempdb on my server is fuill ? What are the options which I have now ? Whether I should just reboot the server ? Whether I can somehow create space in tempdb even if it is full now Thanks Amit You'll have to reboot! Try turning on "abort transaction on full log" on the tempdb database - this will at least allow your server to continue running You can alter tempdb, making it larger, even if it is currently full - you can do that with any database except master. -bret Amit wrote: > The tempdb on my server is fuill ? What are the options which I ha...

tempdb full #4
How to know what spid was responsible of filling the tempdb?? the error logs show nothing relevant about that and when tempdb is full, sybase hangs when I run all kinds of stored procedures. thx below information might help you tempdb - server-wide temporary database ASE 12.5.0.1 1. Is a temporary database and rebuilt from model template 2. By default tempdb resides on master device, extend on separate device 3. Heavy contention in tempdb due to server-wide temporary objects 4. Bind tempdb to named cache in case of heavy usage/contention 5. When tempdb is full and no spa...