From: Ines Liefeldt (ines.liefeldtmbjs.brandenburg.de)
Date: Wed Jul 02 2003 - 04:18:30 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

I've the following problem:

I will let run a procedure with a loop for every entry of table n_arbumfang taken in a cursor.
In the loop will be started two procedures:

The first (proc_verguet_buch) contains 3 Queries for the table t_dbv which supply the variable verguet_buch.

The second (proc_buch_n) starts an update statement like

       update dba.n_Stellen
       set vze_anspruch=vze_anspruch+:vze
       where deckring_sl in
        (select deckring_sl from DBA.n_deckring
        where verguet_sl=:c_verguet and not ueberlauf)
       and akt_datum>=:c_beg and akt_datum<=:c_end
       AND SCHULAMT_NR= SANR;

This is the only statement to change the database, but it concerns ca. 5000 to 10000 of 40000 entries of table n_stellen.

When I start the procedure database manager shows 13% of data dev space are used.
After booking(= updating of n_stellen) of 1000 from the 9000 entries of table n_arbumfang 60% of data dev space are used
and after booking of 1700 from the 9000 entries of table n_arbumfang the 100% of data are used, but there is no insert statement - only the above listed update statements of n_stellen.
It shows 'database is full', but it can't be!

Can anybody help me?

Thank you

Ines

Ines Liefeldt

Ministerium für Bildung, Jugend und Sport

Tel.: 0331/866-3743
e-Mail: ines.liefeldtmbjs.brandenburg.de

_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]