Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Database Studio 7.9 on SWDC

Attention: 
Database Studio 7.9.09.05 comes for 64 bit platforms (Microsoft Windows or Linux) only.
In order to download it, make sure to enter in the filter one of those platforms.

    • WINDOWS ON X64 64 BIT
    • LINUX ON X86_64 64 BIT 

MAXDB GUI COMPONENTS/TOOLS

Database Studio 7.9 on SCN

Search for Database Studio in the SAP Store (http://store.sap.com) or click on this link: Database Studio in SAP Store

Find documentation for Database Studio 7.9.09 here: Database Studio, Working with Database Analyzer Charts

Working with database analyzer charts is also described in expert session on maxdb.sap.com/training

  • Session 2: Basic Administration with Database Studio -> News 2016
  • Session 22: SAP MaxDB Database Analyzer / Charts -> Charts

Further Information: SAP notes 2213168, 1097311Problems when Database Studio is launched, regarding the predecessor version see also  Database Studio 7.9.08 News.

 

 

Version Database Studio 7.9.09.08 is equivalent to 7.9.09.07

Version Database Studio 7.9.09.07 has the following corrections and features: 

 

Corrections  

 

  • Context menu function on Index -> Check Structure → Check Index 
    (PTS 1264724)
    Now this function works for the database user which is the owner of the index and is not the SYSDBA user.
     
  • Recreate Index context menu function under Show Indexes dialog
    (PTS 1250126)
    The recreate Index function drops and creates the index.
    Now the DROP INDEX step finalizes with a COMMIT to avoid blocking of parallel commands on the table.
    Therefore while the recreate index function is running it is possible to insert or delete data regarding the table the index is created for. 
                         
  • Correction of "Communication Error, code 8224"
    (PTS 1264836)
    This problem could occur for example in the case:
    backup check of full backup followed by backup check of an incremental backup. 
                
  • Database Studio "Recover a Medium" strategy
    (PTS 1252710)
    Database Studio "Recover a Medium" strategy did not display the list of backup items in a proper manner when the backup stems from another database using the external backup tool NetWorker. Now the items are displayed properly.
     
  • Check Backup on a backup template of type log
    (PTS 1264800)
    Before the correction check backup on a backup template of type LOG only signaled success without showing the detailed result. 
    Now the result line includes: 
    label, first log page, last log page, db stamp 1 date/time,  db stamp 2 date/time and Database ID.
               
  • Database Studio and Check backup via medium from a backup tool
    (PTS 1264798
    Using a backup stemming from another database with the same name but another server Database Studio is now working properly and finds the appropriate External Backup IDs.
Features    
  • Recovery from external backup tool, if source database differs from target database
    (PTS 1264783

    • Database Studio now only displays those backups found in the backup tool, which correspond to the backup type specified in the backup template selected. 
      The respective dbmcli commands towards DBMServer deliver all backups found in the backup tool which where produced during the recent past time frame (for Networker this time frame is set to the recent 38 days). 
      backup_ext_ids_get <backup template>
      backup_ext_ids_list
      backup_ext_ids_listnext

      (PTS 1264794)    
    • After recovery of a data backup in the next recovery step only those ExternalBackupIDs are provided from the backup tool, that have a creation date equal or greater than the data backup item which precedes the just recovered data backup item.

 

  • Constraint attribute in a database parameter definition  
    (PTS 1264860)
    In the Database Studio Administration view under Parameters tab you can display every parameter definition.
    Now the CONSTRAINT section of a parameter specification, if there exists any, is displayed as well.


Version Database Studio 7.9.09.06 has the following corrections:

 

  • Incomplete list of backups from external backup tool, "Continue" does not work
    (PTS 1264661)
    Database Studio recovery via medium with backups from external backup tool did not display the expected list of external backups.  
    Database Studio 7.9.09.06 provides the whole list of external backups as shown by the dbmcli commands "backup_ext_ids_get <backup template>", "backup_ext_ids_list" and      "backup_ext_ids_listnext".

 

  • Administration → DBA History display, "Continue" does not work
    (PTS 1264621 )
    Database Studio did not display correctly long DBAHistory files larger than 250 KB (about 3250 lines). (See file dbahist.prt in the folder  <database run directory>/dbahist) 
    Database Studio 7.9.09.06 displays up to 20000 recent records of the dbahist.prt file.  

     
  • Recovery via backup history and parallel backup template
    (PTS 1264476)
    Recovery based on the backup history erroneously  skipped the incremental backup if  the data backup was done on a parallel backup template.
    The backup history in this case could look like this:
    - Complete Data on a parallel backup template
    - Incremental Data
    - Log
    During the recovery Database Studio erroneously considered the incremental backup part as belonging to the "recover data" step.
    Database Studio 7.9.09.06 corrects this issue.

 

  • Recovery via backup history with incremental backup alternatively to log backups
    (PTS 1264563)
    Recovery from history if there is an incremental backup alternativly to log backups then Database Studio selected the data backup and the appropriate incremental backup and provided this as recovery strategy. If deselecting the incremental backup then the "Next" button was actived but did not work. 
    With Database Studio 7.9.09.06 the "Next" botton works again and it is also possible to stop recovery after the full database backup has been restored successfully.

 

  • Recovery of external filesystem snapshot via backup template device type "EXTERNAL" did not work
    (PTS 1251332)
    Starting with context menu function "Recovery..." on a backup template with device type "EXTERNAL" Database Studio did not send the right recover statement to the DBM Server.
    1. Database Studio 7.9.09.06 sends the correct statement:
        instead of:    recover_start  <template name> DATA
        it is now:  recover_start  <template name for external snapshot> DATA ExternalBackupID <freely chosen external backup ID>
    2. Database Studio 7.9.09.06 comes with an improved guiding message in the wizard: 
      • Instead of: 
        "You have completed the steps required to perform a recovery. Make the specified medium available and choose "Start""
      • It is improved to:  
        "You have chosen this backup template to recover an external filesystem snapshot. Restore the data volumes on file system level with the file system backup of your choice. If you have restored the data volumes on file system level choose "Start"."

 

 

Version Database Studio 7.9.09.05 has the following Corrections and Features:

Corrections
  • Backup history details corrected:
    in case backup was successful from kernel point of view but not successful on the backup tool side.
    (PTS 1263937, 1263938) 
               

  • Function Administration Tasks - Diagnosis Package - Generate:
    has been enhanced and corrected so that it's applicable also for liveCache instances of kernel version 7.9.09.05 and higher. 
    (PTS 1264336, PTS 1264230)      
               

  • Messages in Console window suppressed:

    • Could not create 'Local Folders' repository. Diagnosis Local Folder, See log for details.

    • Could not create 'Local Folders' repository. Diagnosis Shared Folder, See log for details.
      if the preferences "Diagnosis Local Folder" and "Diagnosis Shared Folder" have not been specified.

  • Error messages in Event Log Viewer suppressed:

    • Catalog cannot be displayed due to:Cannot connect to jdbc:sapdb://BERD31651376A/LVC1 [Restart required].  when the database is OFFLINE.
      Now this kind of information can only be seen as warning only in the log file <workspace>\.metadata\.plugins\com.sap.sdb.tools.core\dbstudio.log file.

    • Invalid entry in local folder property: Diagnosis Shared Folder

    • Invalid entry in local folder property: Diagnosis Local Folder

Features 
  • Improved context menue in table representation of CSV files:
    When displaying the CSV files under Diagnosis Files / DB Analyzer File as tables the context menue varies depending on the other opened CSV files.  
    The potential menue functions are f.e.:
    • Compare with <another opened CSV file of another date and same type>
    • Concatenate with <another opened CSV file of adjazent date and same type>
    • Merge with <another opened CSV file of another type and same date>
                   
  • Improved context menue in the explorer and navigator regarding the date folders under Diagnosis Files / DB Analyzer File:
    • Display via Metric Template
    • Compare via Metric Template
    • Concatenate via Metric Template

  • It is possible to specify threshold values Min/Max for one column per chart:
    • If there are values in the column which exceed the Max value or are less than the Min value specified the part with these values is being highlighted.
                 
  • Import of landscapes function now also provides a Cancel button
     
  • Improved handling of log files smaller than 20 MB:
    The default preference setting for Log File Viewer is now: "Use log file viewer for large files if the log file size exceeds 20 MB." Before it was 10 MB.
    This means that the logs <20 MB are handled with the simple editor which loads the whole content into the cache.
               
  • Improved handling of "Save to Diagnosis Local ..."/ "Save to Diagnosis Shared...": 
    When copying Database Analyzer data from any database to the local or shared folder sometimes it can happen that some files are not copied successfully.
    In this situation now the user is being informed which files were not copied successfully.

Version Database Studio 7.9.09.02 has the following new feature:

Features
  • Manual log backup is made possible although automatic log backup is enabled. 
    Prerequisite: database versions 7.9.08.41, 7.9.09.02 and newer. 
     

Version Database Studio 7.9.09.01 has the following corrections and features:

Corrections
  • Log backup sequence while recovery corrected: 
    While recovery now Database Studio takes care of the right log backup sequence in cases where the log backup entries in the backup history have been written before the entry of the data backup where they belong to.
    (PTS 1254917)
  • Installation on Linux x86/64, executable flag on bin directory of sapjvm binaries corrected (Database Studio on Linux x86/64 only):       
    During installation of Database Studio 7.9.09.01 which installs the sapjvm runtime library now the executable flag is set correctly in directory /sapdb/clients/DatabaseStudio/sapjvm/sapjvm_8_jre/bin.  Without the executable flag Database Studio 7.9.09.00 did not start.
    (PTS 1263437)
  • Percentage values between 95% and 100% corrected in some displays: 
    The percentage values are not shown properly in the area 95% to 100%.     
    (PTS 1263539)
  • "Merge via Metric Template" now with corrected chart titles:
    In the explorer tree if comparing two date folders by the context function "Merge via Metric Template" it could happen that the dates in the chart title are not correct.
    Now the dates in the chart title are corrected.
    (PTS 1254939)
               
  • Delete Database background/foreground switch corrected:
    Delete Database in background can be brought again to the foreground by clicking on the Delete Database line in Running state.
    (PTS 1254837)
  • Session specific vtrace now supported:
    Creating a session specific vtrace is now possible. 
    (PTS 1243207)
  • Installation of Database Studio:
    The following error message will not occur anymore.
    ERR:  Cannot open "C:\WINDOWS\SysWOW64\drivers\etc\services" to write: No such file or directory
    or 
    ERR:  Cannot open "<SystemDirectory>\drivers\etc\services" to write: No such file or directory
    (Note 1097311)
     
Features
  • Improved Hot Standby (with shared log area) support:
    Now Database Studio fully supports the Hot Standby (with shared log area) functionality of MaxDB.
    • configure / enable / disable a hotstandby system
    • add / delete hotstandby nodes.
      (PTS 1252989)

  • Functionality "Mark productive":
    It is possible to mark individual databases as "productive" to emphasize visually the productive role of the system. 
    In the explorer view select the database you want to be marked and choose the p
    roperties function.
    Select
    Database Environment and mark the check box Database is a productive database.
    As result the database icon in the explorer is presented in orange and all administration windows appear with a colored header. 
    To change the color of the header for productive databases select in the preferences window -> Database Studio -> Editors -> Push the button Color for productive Databases and select another color.
    (PTS 1243276)

  • "Restore connection state of database on startup" not set per default:
    In the preference window the option Restore connection state of databases on startup is not set per default anymore. As consequence in case some database are not reachable because of network problems Database Studio will not block anymore waiting for the network.
    (PTS 1254765)
     
  • Change of meaning of Yes/No on import landscape function:
    When importing the a landscape file into Database Studio, now the meaning of the answer Yes/No works like yes: "do the merge", no: "ignore the import".
    (PTS 1254930)

  • Enhanced database parameter wizard - activation of parameter evaluation of dependencies:
    The database parameter wizard offers now the possibility to reset a user modified parameter to its default value. Additionally the parameter is reactivated regarding the calculation of other depending parameter values, according to the formulas specified in the parameter configuration file.
    (PTS 1253629)
  • Clipboard restriction when copying knlMsg files is now set to 10 000 KB instead of 100 000 Bytes.
    (PTS 1263470)

 

 

  • No labels

2 Comments

  1. Hello,

     

    where can I find version  7.9.09.5? In the SWDC there is only version 7.9.09.4, in the store is 7.9.09.1 ....

     

    Thanks

    Jan

    1. Hello Jan,
      thanks for the feedback. Preset selection in the widget can cause the effect, that you don't find the newest Database Studio 7.9.09.05 download.
      Just adjust in the filter drop down widget the right selection:

      Attention:  Database Studio 7.9.09.05 comes for 64 bit platforms (Microsoft Windows or Linux) only. In order to download it, make sure to enter one of those platforms
        • WINDOWS ON X64 64 BIT
        • LINUX ON X86_64 64 BIT 

      Best regards,
      Barbara