RE: Question about data area

Josï¿½ Rï¿½mulo Elï¿½as Contreras Fri, 12 Mar 2004 17:24:02 -0800

hi:

this is the part of the knldiag when the error occur:

2004-03-12 11:35:20 0x71C WRN 6 Kernel_E 80 percent of data base occupied, 1280 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 90 percent of data base occupied, 640 pages free\par 2004-03-12 11:35:21 0x71C 7 Kernel_E DB usage fell below 90 percent, 640 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 90 percent of data base occupied, 640 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 95 percent of data base occupied, 320 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 96 percent of data base occupied, 256 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 97 percent of data base occupied, 192 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 98 percent of data base occupied, 128 pages free\par 2004-03-12 11:35:21 0x71C WRN 6 Kernel_E 99 percent of data base occupied, 64 pages free\par 2004-03-12 11:35:21 0x71C WRN 41 Converte Force Rollback due to DB-Full. Tasks 28 holds to many temp pages #all p.= 6399 #all temp. p.= 3255 #task temp p.= 1\par 2004-03-12 11:35:21 0x71C WRN 41 Converte 610\par 2004-03-12 11:35:21 0x71C 7 Kernel_E DB usage fell below 95 percent, 320 pages free\par 2004-03-12 11:35:21 0x71C 7 Kernel_E DB usage fell below 90 percent, 640 pages free\par 2004-03-12 11:35:21 0x71C 7 Kernel_E DB usage fell below 80 percent, 1280 pages free\par 2004-03-12 11:35:21 0x71C 19651 CONNECT Connection released, T28\par 2004-03-12 11:35:21 0x71C 19633 CONNECT Connect req. (T28, Node:'cora', PID:0)\par 2004-03-12 11:35:24 0x71C 19633 CONNECT Connect req. (T33, Node:'', PID:2568)\par 2004-03-12 11:35:25 0x71C 19651 CONNECT Connection released, T33\par 2004-03-12 11:35:30 0x71C 19633 CONNECT Connect req. (T33, Node:'web_server', PID:0)\par 2004-03-12 11:35:31 0x71C 19633 CONNECT Connect req. (T34, Node:'', PID:2568)\par 2004-03-12 11:35:31 0x71C 19651 CONNECT Connection released, T34\par 2004-03-12 11:35:45 0x71C 19633 CONNECT Connect req. (T34, Node:'', PID:2568)\par 2004-03-12 11:35:45 0x71C 19651 CONNECT Connection released, T34\par 2004-03-12 11:35:58 0x71C 19633 CONNECT Connect req. (T34, Node:'cora', PID:0)\par 2004-03-12 11:36:07 0x71C WRN 6 Kernel_E 80 percent of data base occupied, 1280 pages free\par 2004-03-12 11:36:07 0x71C 7 Kernel_E DB usage fell below 80 percent, 1280 pages free\par 2004-03-12 11:36:33 0x71C 19633 CONNECT Connect req. (T35, Node:'web_server', PID:0)\par 2004-03-12 11:36:53 0x71C 19633 CONNECT Connect req. (T36, Node:'cora', PID:0)\par 2004-03-12 11:37:15 0x71C 19633 CONNECT Connect req. (T37, Node:'cora', PID:0)\par 2004-03-12 11:37:23 0x71C 19633 CONNECT Connect req. (T38, Node:'', PID:2568)\par 2004-03-12 11:37:24 0x71C 19651 CONNECT Connection released, T38\par 2004-03-12 11:37:36 0x71C WRN 6 Kernel_E 80 percent of data base occupied, 1280 pages free\par 2004-03-12 11:37:36 0x71C 7 Kernel_E DB usage fell below 80 percent, 1280 pages free\par 2004-03-12 11:37:36 0x71C WRN 6 Kernel_E 80 percent of data base occupied, 1280 pages free\par 2004-03-12 11:37:36 0x71C 7 Kernel_E DB usage fell below 80 percent, 1280 pages free\par 2004-03-12 11:37:36 0x71C WRN 6 Kernel_E 80 percent of data base occupied, 1280 pages free\par 2004-03-12 11:37:36 0x71C 7 Kernel_E DB usage fell below 80 percent, 1280 pages free\par 2004-03-12 11:37:58 0x71C 19633 CONNECT Connect req. (T38, Node:'', PID:2568)\par 2004-03-12 11:37:58 0x71C 19651 CONNECT Connection released, T38\par 2004-03-12 11:37:59 0x71C 19633 CONNECT Connect req. (T38, Node:'web_server', PID:0)\par

The node='' is the host in who is installed DBM GUI.
The node='webserver' is the crystal reports servlet.
The node='cora' is the host where the tomcat is running.

The data cache information hit rate is:
DATA           100%
CATALOG    57%
SEQUENCE    0%

Some parameters are:
CACHE_SIZE       = 30000
MAXLOCKS         = 8920
MAXUSERTASKS = 200

The DATA AREA has a total space of 51200 KB
The LOG AREA has a total space of 10224 KB

What can I have to chage to resolve this error?

thanks
Josï¿½ Rï¿½mulo Elï¿½as Contreras
Ingeniero en Sistemas Computacionales
Guadalajara, Jalisco
Tel: (33) 3126-47-81 y 3126-48-13
Cel: (311) 910-50-59

From: "Schroeder, Alexander" <[EMAIL PROTECTED]> To: 'Josï¿½ Rï¿½mulo Elï¿½as Contreras' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: Question about data area Date: Fri, 12 Mar 2004 10:44:38 +0100

Hello Jose,

could it be that a timeout happens? The error simply indicates that the session is 'lost' at the TCP/IP level.

You may also look into knldiag/knldiag.err if you see something 'suspicios' there, and/or post the portion the knldiag to the list.

Regards

Alexander Schrï¿½der
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Josï¿½ Rï¿½mulo Elï¿½as Contreras [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 11, 2004 9:24 PM
> To: [EMAIL PROTECTED]
> Subject: Question about data area
>
>
> I have an application running in Apache Tomcat whith
> connection to SAPDB.
> When the used space of the SAPDB data area is around 82% my
> application
> display this error:
>
> com.sap.dbtech.jdbc.exceptions.ConnectionException: [-1]
> Communication Error
>        at
> com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:418)
>        at
> com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:325)
>        at
> com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.
> java:681)
>        at
> com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:720)
>        at
> com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:219)
>        at
> com.sap.dbtech.jdbc.StatementSapDB.executeQuery(StatementSapDB
> .java:350)....
>
> and I can't work more with the application, i have to restart
> it to work one
> more time.
>
> Why does my application display this error if the SAPDB data
> area is not in
> a full state?
>
> It is urgent.
> Thanks.
>
>
> Josï¿½ Rï¿½mulo Elï¿½as Contreras
> Ingeniero en Sistemas Computacionales
> Guadalajara, Jalisco
> Tel: (33) 3126-47-81 y 3126-48-13
> Cel: (311) 910-50-59
>
> _________________________________________________________________
> MSN. Mï¿½s ï¿½til Cada Dï¿½a  http://www.msn.es/intmap/
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]

_________________________________________________________________ ï¿½nete al mayor servicio mundial de correo electrï¿½nico: http://www.hotmail.com


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

RE: Question about data area

Reply via email to