niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Sybase
New problems when doing hard boiled datatest
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Photubias
*nix forums beginner


Joined: 27 Apr 2006
Posts: 13

PostPosted: Mon May 29, 2006 5:04 pm    Post subject: Re: New problems when doing hard boiled datatest Reply with quote

"Michael Peppler" <mpeppler@peppler.org> schreef in bericht
news:pan.2006.05.28.14.48.35.584528@peppler.org...
Quote:
On Sat, 27 May 2006 14:20:56 +0000, Photubias wrote:

I inserted a big database 'benchdb' into de sybase server: When issueing
a
bunch of read statements i got this error: "Space available in the log
segment has fallen critically low in database 'BASE01_TMP1'. All future
modifications to this database will be suspended until the log is
successfully dumped and space becomes available." I kinda solved that one
by doing a
sp_dboption benchdb, "abort tran on log full",false go
use benchdb
go
checkpoint
go

But now I have this error:
Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname
or use sp_help to check whether the object exists (sp_help may produce
lots of output).
I can't seem to find how to solve this one... The clients are getting
error's asswell... Thx in advance,

You should either turn on the "trunc. log on checkpoint" option for this
database, or do regular transaction log dumps.

I strongly suggest that you read chapters 27 and 28 of the ASE System
Administration Guide which cover the backup and recovery of Sybase ASE
databases.

The manuals are on line at
http://sybooks.sybase.com/nav/detail.do?docset=812

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org -
http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html



TX, "truncate log on checkpoint" worked, and i also added room to the
tempdb, and split my log and data devices for each database...
Back to top
Michael Peppler
*nix forums Guru Wannabe


Joined: 15 May 2005
Posts: 112

PostPosted: Sun May 28, 2006 2:48 pm    Post subject: Re: New problems when doing hard boiled datatest Reply with quote

On Sat, 27 May 2006 14:20:56 +0000, Photubias wrote:

Quote:
I inserted a big database 'benchdb' into de sybase server: When issueing a
bunch of read statements i got this error: "Space available in the log
segment has fallen critically low in database 'BASE01_TMP1'. All future
modifications to this database will be suspended until the log is
successfully dumped and space becomes available." I kinda solved that one
by doing a
sp_dboption benchdb, "abort tran on log full",false go
use benchdb
go
checkpoint
go

But now I have this error:
Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname
or use sp_help to check whether the object exists (sp_help may produce
lots of output).
I can't seem to find how to solve this one... The clients are getting
error's asswell... Thx in advance,

You should either turn on the "trunc. log on checkpoint" option for this
database, or do regular transaction log dumps.

I strongly suggest that you read chapters 27 and 28 of the ASE System
Administration Guide which cover the backup and recovery of Sybase ASE
databases.

The manuals are on line at
http://sybooks.sybase.com/nav/detail.do?docset=812

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
Back to top
Photubias
*nix forums beginner


Joined: 27 Apr 2006
Posts: 13

PostPosted: Sat May 27, 2006 2:20 pm    Post subject: New problems when doing hard boiled datatest Reply with quote

I inserted a big database 'benchdb' into de sybase server:
When issueing a bunch of read statements i got this error:
"Space available in the log segment has fallen critically low in database
'BASE01_TMP1'. All future modifications to this database will be suspended
until the log is successfully dumped and space becomes available."
I kinda solved that one by doing a
sp_dboption benchdb, "abort tran on log full",false
go
use benchdb
go
checkpoint
go

But now I have this error:
Stored procedure 'sp_thresholdaction' not found. Specify owner.objectname or
use sp_help to check whether the object exists (sp_help may produce lots of
output).
I can't seem to find how to solve this one...
The clients are getting error's asswell...
Thx in advance,

Tijl Deneut
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Fri Jan 09, 2009 5:23 am | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Winbind problems for ADS authentication nlinley networking 1 Tue Sep 19, 2006 9:22 am
No new posts problems using oddmuse with mod_perl2 inside apache2.2 pe... Fergus McMenemie Perl 0 Fri Jul 21, 2006 9:48 am
No new posts Problems with make-kpkg and skas patch Todd A. Jacobs Debian 0 Fri Jul 21, 2006 12:30 am
No new posts Problems with relay control Félix Martos Trenado Postfix 3 Thu Jul 20, 2006 3:33 pm
No new posts again a newbie... :( compiler problems Thorsten Kaben C++ 18 Thu Jul 20, 2006 2:52 am

Bad Credit Loan | Babb Fest | Debt Consolidation | Remortgaging | Free Ringtones
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.1429s ][ Queries: 20 (0.0628s) ][ GZIP on - Debug on ]