I am unfamiliar with the query output you discuss... But a suggestion is to use dbmcli and do the "info state" command against your database instance. I have found this has a good summary of page usage (temp, perm, also in percentages).
Not sure if log pages are being included in the numbers you are viewing... If so, a backup will dump the used log pages... Stephen -----Original Message----- From: Gembus, John [mailto:[EMAIL PROTECTED] Sent: Thursday, November 27, 2003 4:44 AM To: '[EMAIL PROTECTED]' Subject: The number of data pages is increasing extraordinarily my database becomes bigger and bigger. Size 55.758 pages select * from tablestatistic and select * from indexstatistc shows for user Database-User and normal-user 5216 used pages. I don't know where to find 50.542 pages. My Applikation needs nearly constant 5100 pages. There is no other program which works with sapdb. After installation and loading everything is ok. Then the number of used pages becomes more and more. Any Ideas I user sapdb 7.4.3.10 an windows 2000 / Windows XP John -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
