Discussion:
-24988,ERR_SQL: sql error 1,database not running
(too old to reply)
Koller Sébastien
2002-11-26 16:32:32 UTC
Permalink
Hello,

I have the following problem with my database, the database use to work, but
now I get this message:
----------------------------------
***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n atchoum.cpln.ch
-d DW03_P -u dba,dba db_offline
OK
***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n atchoum.cpln.ch
-d DW03_P -u dba,dba db_start
OK
***@atchoum:/usr/local/sapdb/indep_prog/bin> ./dbmcli -n atchoum.cpln.ch
-d DW03_P -u dba,dba db_warm
ERR
-24988,ERR_SQL: sql error
1,database not running
----------------------------------
I check the permission about the file 'Registry.dcom' and 'Registry1.dcom',
everything is alright.

Thanks for any idea,
Sébastien Koller
Vorsprach, Bernd
2002-11-27 07:45:53 UTC
Permalink
Post by Koller Sébastien
----------------------------------
atchoum.cpln.ch
-d DW03_P -u dba,dba db_offline
OK
atchoum.cpln.ch
-d DW03_P -u dba,dba db_start
OK
atchoum.cpln.ch
-d DW03_P -u dba,dba db_warm
ERR
-24988,ERR_SQL: sql error
1,database not running
----------------------------------
There is a problem during the so called "RESTART" (transition
from state cold to warm). Check the files knldiag and knldiag.err
in the rundirectory of the database for more information.

Bernd
--
SAP Labs Berlin
Koller Sébastien
2002-11-27 09:35:19 UTC
Permalink
Post by Koller Sébastien
----------------------------------
atchoum.cpln.ch
-d DW03_P -u dba,dba db_offline
OK
atchoum.cpln.ch
-d DW03_P -u dba,dba db_start
OK
atchoum.cpln.ch
-d DW03_P -u dba,dba db_warm
ERR
-24988,ERR_SQL: sql error
1,database not running
----------------------------------
There is a problem during the so called "RESTART" (transition
from state cold to warm). Check the files knldiag and knldiag.err
in the rundirectory of the database for more information.

Bernd
--
SAP Labs Berlin


I found this in my knldiag.err:

2002-11-27 12:29:54 --- Starting GMT 2002-11-27
11:29:54 7.3.0 Build 024-000-085-555

2002-11-27 12:30:21 2563 ERR 53000 FBM No Free Block available: 38
2002-11-27 12:30:21 2563 ERR 52050 SHUTDOWN savepoint/no_more_space

I have a lot of place on my disks, so what does it mean?
Thanks,

Sébastien Koller
Vorsprach, Bernd
2002-11-27 12:43:19 UTC
Permalink
Post by Koller Sébastien
2002-11-27 12:29:54 --- Starting GMT 2002-11-27
11:29:54 7.3.0 Build 024-000-085-555
2002-11-27 12:30:21 2563 ERR 53000 FBM No Free Block
available: 38
2002-11-27 12:30:21 2563 ERR 52050 SHUTDOWN savepoint/no_more_space
I have a lot of place on my disks, so what does it mean?
Thanks,
SAP DB does not grow automaticly. You have to add a new volume (devspace).

Start the database in cold mode with db_start and than add a new volume
with

db_adddevice DATA <devicename> <type> <size>
e.g. db_adddevice DATA dat002 F 20000

Now you can start your db in warm mode.

Bernd
--
SAP Labs Berlin
Koller Sébastien
2002-11-28 07:58:20 UTC
Permalink
SAP DB does not grow automaticly. You have to add a new volume (devspace).

Start the database in cold mode with db_start and than add a new volume
with

db_adddevice DATA <devicename> <type> <size>
e.g. db_adddevice DATA dat002 F 20000

Now you can start your db in warm mode.

Bernd
--
SAP Labs Berlin
----------------------------------
I have already used the Database Manager to add devspaces (MAXDATADEVSPACES
20, MAXDATAPAGES 5000000). I have more than 10 Data Volume (DATA0001
-DATA0010 of 204'800KB) and I know it is more than I need..

Is there any else I should do in order to use these new files?
Thanks,
Vorsprach, Bernd
2002-11-29 07:57:43 UTC
Permalink
Post by Koller Sébastien
I have already used the Database Manager to add devspaces
(MAXDATADEVSPACES
20, MAXDATAPAGES 5000000). I have more than 10 Data Volume (DATA0001
-DATA0010 of 204'800KB) and I know it is more than I need..
Is there any else I should do in order to use these new files?
Thanks,
The error message in the knldiag says there is no more space in
the database.

Maybe there is disproportion between size of log volumes and size
of data volumes.

SAP DB needs for a restart after a crash the so called "reserved
redo size" on the data volumes. As default the half of the log is
reserved on the data volumes as reserved redo size. Normally this
area is unused but even not available for your data.

You may set the configuration parameter RESERVED_REDO_SIZE (in
mode offline) other than 0 to deviate from the default.

Bernd

Loading...