Hi Jose, the size of your data area is not suitable for your application! Your data area is filled with about 3000 perm pages and 3255 temp pages! Each temp page consuming task will fail with error code -904, -907 etc., because not enough space is available.
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 I strongly recommand you to increase your data area size, i.e. you should add some data volumes. Probably the log area is also too small. BTW. I am very confused by the CACHE_SIZE. You set the cache size to 30.000 pages (230 MB), but your data area has only 50 MB. Why? Regards, Torsten SAP Labs Berlin -----Original Message----- From: Jos� R�mulo El�as Contreras [mailto:[EMAIL PROTECTED] Sent: Samstag, 13. M�rz 2004 02:24 To: Schroeder, Alexander; [EMAIL PROTECTED] Subject: RE: Question about data area 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
