Database Studio 7.9 News

• 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 SAP Community

Search for Database Studio in the Software Download Catalog (SAP MaxDB).

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, 1097311, Problems when Database Studio is launched, regarding the predecessor version see also  Database Studio 7.9.08 News.

Version Database Studio 7.9.10.04 contains the following Corrections and Features:

Corrections

• Closing Database Studio
  Fix for potential long wait time when closing Database Studio with many databases registered due to an unnecessary and time consuming loop (PTS1273891).
   
• Recreating bad indexes
  Fix for recreating a bad index with user SYSDBA failing against databases versions above 7.9.09.10 during internal wrong command usage (PTS1273901).

Feature

• Add Server/Database Filter
  Added a filter to the Add Server/Database dialog to display in the lower dialog field already used server names while typing (PTS1273893).
   
• Port numbers
  Port-numbers are now supported for local connections. In addition to it there is a new connection option in the preferences that informs the Database Studio that the port base local connection is used for tunneling like SSH-tunnels and all files must be accessed via IP-communication (PTS1273716).

Version Database Studio 7.9.10.03 contains the following Corrections and Features:

Feature

• Database Studio -ldf
  If Database Studio is called with the calling option -ldf <landscape file> then the user is not asked anymore whether the landscapes in the landscape file should overwrite the existing landscapes with the same name, but directly overwrites.
  (PTS1273680)

Version Database Studio 7.9.10.02 has the following Corrections and Features:

Corrections

• Database Studio -ldf option for loading a landscape definition
  Now the -ldf calling option not only adds but also deletes entries from the explorer landscape which do not exist in the landscape file (specified within the -ldf option) anymore.
  (PTS 1273613) 
  
  
• Upper/lower mode in Create user wizard
  In the create user wizard in landscape tree username/password entered with enclosing " signs in order to enter it in mixed upper/lower mode are now handled correctly.
  (PTS 1265221)
  
  

• Add Server and Database and synchronisation with landscape tree
  Misbehaviour in Add Server / Database wizard now corrected. 
  Now it the server name and database name are reflected correctly in the landscape tree.
  (PTS 1265198)

Features

• Create Database wizard without Parameter MaxSQLLocks
  In the create database wizard regarding MaxDB 7.9.10 and newer the parameter MaxSQLLocks is not shown anymore. 
  Due to the new parameter InitialSQLLocks there is no need to set the MaxSQLLocks parameter anymore.
  (PTS 1265147)
   
• Explicit properties in Create User wizard
  In the create user wizard, when specifying the properties "session timeout", "cost warning" and "cost limit" you can choose "Default values" or enter specific user defined values.
  (PTS 1265211)
  
  
• Manual log backup while Automatic Log Backup is enabled
  Database Studio supports now a log backup manually started while Automatic Log Backup is enabled.
  The respective prerequisites are met in the DBMServer see PTS 1263818 (7.9.10.00),  1263822 (7.9.08.41) and 1263823 (7.9.09.02).
  (PTS 1263925)

Version Database Studio 7.9.09.10 has the following Corrections and Features:

Corrections

• Data Area Tab: context menu function "Edit" & "Delete" eliminated 
  The context menu function "Edit"/"Delete" on a data volume is only meaningful and therefore now available only while creating a database.
  (PTS 1264935)
  
• Log Area Tab: context menu function "Delete"
  The context menu function "Delete" on a log volume is only meaningful and therefore now available only while creating a database.
  (PTS 1264935)

Features  

• Expand of volumes now possible via Database Studio
  Data volumes can be expanded in online state via Database Studio. This is the equivalent to dbmcli command db_expand.
  The Expand functionality is only offered on the data area tab if the maximum volume size is not reached yet.
  
  
• Improved guidance during recovery via media
  Better guidance during recovery via media when it is necessary to choose between replace and "No more media".
  In the past the technical term was "ignore", now it is "No more media".
  
  
• Improved cursor positioning in DB Analyzer files
  In Database Analyzer files from the actual date of today the cursor sits at end of file when opening.
  Otherwise the cursor is place on the first line of the file.
  
  
• Database Studio reflects in advance the parameter classification of MaxDB 7.9.10
  As of MaxDB 7.9.10 a new parameter class SECURITY is shown.
  In the case of MaxDB database instances of version < 7.9.10 this parameter class is empty.
  
  

Version Database Studio 7.9.09.09 has the following Corrections:

Corrections

• Context menu function on Index -> Check Structure → Check Index 
  (PTS 1264931)
  Now the check structure function works properly if tablename or indexname contains special characters like "/" (slash).
  
  
• Warnings on Log Area page
  (PTS 1264944)
  Now no warning is issued anymore on Log Area page if MaxLogVolumes is almost reached.
  
  
• Context menu functions like "Save To Diagnosis Local" and "Save to Diagnosis Shared"
  (PTS 1264957)
  Now these context menu functions are restricted to date folders with Database Analyzer data and the parent of those date folders.

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 properties 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)