Skip to Content

MaxDB Database Manager do not display State Info.

Hi,

After and update done ages ago MaxDB do not display any info on the State page on the DB Manager. Basically i can't see how much Data, log space or sessions are running (DB works fine though!) and I also get the following error when opening the DB in the DB Manager.

-24988 sql error [sql_execute SELECT DESCRIPTION, VALUE FROM SYSDBA.DBPARAMETERS WHERE DESCRIPTION = 'LOG_SEGMENT_SIZE' OR DESCRIPTION = 'MAXUSERTASKS'; 100,Row not found

The version of the DB is 7.4.03.32

version of DB Manager is 7.5.00.18 (I have tried with DB Manager version 7.4.3.30 and the above error do not happen but the info is not displayed either)

DB is running on Windows 2000 server, SP4.

Thanks in Advance!

Juan Reyes

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 01, 2006 at 10:22 AM

    Hi,

    it's probably due to a missing loading of the system tables. Please (re)load the system tables, either by using the Database Manager GUI or dbmcli:

    - Database Manager v7.6: Configuration -> Upgrade System Tables

    - dbmcli (from the commandline):

    dbmcli -d <SID> -u <dbm-user>,<pwd> load_systab -u <dba-user>,<pwd> -ud DOMAIN

    Regards,

    Roland

    Add comment
    10|10000 characters needed characters exceeded

    • Could you try the following:

      1. Rename the UPC-files

      a.) c:\sapdb\data\wrk\<SID>\dbm.upc (for example to dbm.upc.orig)

      b.) c:\sapdb\data\config\<SID>.upc (for example to <SID>.upc.orig) [apparantly not existing on your system)

      2. Create new UPC files

      Issue from the commandline:

      dbmcli -s -d <SID> -u control,<pwd>

      You should now find UPC file in the paths from step 1.

      3. Load the System Tables

      Start the Database Manager, goto the option 'Configuration' -> 'Upgrade System Tables'. You'll probably get the error 'wrong sysdba' again here.

      After that, I got a popup where I could fill in the dba-user and password and the domain-user and password (normally 'domain').

      I'm using Database Manager GUI version 7.6 (103224).

      Message was edited by: Roland Mallmann