|
|
|
|
|
|
| Author |
Message |
Photubias *nix forums beginner
Joined: 27 Apr 2006
Posts: 13
|
Posted: Mon May 29, 2006 5:04 pm Post subject:
Re: New problems when doing hard boiled datatest
|
|
|
"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
|
Posted: Sun May 28, 2006 2:48 pm Post subject:
Re: New problems when doing hard boiled datatest
|
|
|
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
|
Posted: Sat May 27, 2006 2:20 pm Post subject:
New problems when doing hard boiled datatest
|
|
|
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 |
|
 |
|
|
The time now is Fri Jan 09, 2009 5:23 am | All times are GMT
|
|
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
|
|