click to expand ...

 

 


Download

Recent Version

    

Versions

VersionReleasedInstall Packages
4.0.525.05.2016All in oneGUIReporting
4.0.410.05.2016-GUIReporting
4.0.324.03.2016-GUIReporting
4.0.219.02.2016-GUIReporting
4.0.128.01.2016

-

GUIReporting

4.0.0

17.12.2015

-

GUIReporting

 

Table of content

Update to 4.0.4 or newer is highly recommended

Update v4.0.4 fixes a critical problem observed since v4.0.0, that leads to endless growing database capacity. Please upgrade as soon as possible to keep migration time short.

Larger performance tables will be reorganized. Based on the database size and underlying storage, this might run for a few hours. Please be patient.

Highlights

Treetable

Treetable massively enhances the usability of the BVQ GUI. It is a complete new face to the user, that justifies to give this release a new major number - 4.0.

It shows all attributes of all available objects ordered according the same path the Treemap uses. It is a replacement of the classic table view always visible below the Treemap with a synchronized selection.

Now the user has two perfect methods for configuration browsing: Treemap and Treetable.

Treemap stays to be the best tool for to get an overview about load or capacities of concurrent consumer type objects in a shared resource like a pool, storage class or node. It is perfect to show group relations across all objects in one picture. Selected objects show up in all of their groups, in some cases only as single pixel, but visible.

Treetable as an extension of Treemap adds capabilities with even more benefits:

  • Perfectly suited for text based identification of objects
  • Selectively shows all objects with all of their attributes grouped in categories
  • Allows sorting and filtering
  • Arranges the object hierarchy according to the same path as Treemap
  • Keeps the selection of objects in sync with Treemap
  • Can be exported via system clipboard or CSV file.

Here is a picture of the whole story:

How to work with it?

The Treetable will always open below the Treemap. A split bar between both allow you to resize both as needed or to enlarge one of both to fill the whole window.

 

Treetable arranges the object hierarchy according to the same path as Treemap. The last Object type configured in the path browser is shown with a selectable set of Attributes in the Treetable.

The selection of Objects is synchronized between Treemap and Treetable. All objects selected in Treemap will also be selected in the Treetable and vice versa. Collapsed folders in Treetable will automatically expand if one of their contained objects are selected in the Treemap. Treetable will try to show the most recent selected object in a visible area.

 

We invested months of work to reorganize and consolidate all the attributes and giving them appropriate short and long names and in many cases a helpful description. Hover your mouse pointer over a column header an wait for the tooltip. Long name and the optional description will be shown therein

 

With the Treetable menu you can select a singular attribute or a whole group of attributes to be shown as columns in the Treetable. To open this menu, you need to click on the button in the top rightmost corner of the Treetable or use the popup menu on one of the column headers.

 

The Treetable can be switched to a sort and filter mode. This can be initiated by selecting Sort and filter mode from the Treetable menu or with a double click on a column header.
In sort and filter mode you are able to set filters in the filterrow, or to sort the table rows according to the contents of columns. Simply click a single column header or hold the CTRL key pressed while clicking multiple to define a sort sequence.

 

The column containing the folder tree in normal mode is exchanged with a set of columns, one for each configured object type as configured in the current Path, representing the primary name of each object accordingly.
Such a table also fits perfectly to be exported to a CSV for further handling in a spreadsheet tool.

Treemap filtering

Ever analyzed very large clusters? Now you can concentrate the Treemap contents on one or more selected objects. Simply single click the object you want to isolate with the middle mouse button. You can also select Isolate from the object menu. If you selected more than one object in advance, Isolate will keep all selected objects in the upcoming focus. The filtering will also be effective in the Treetable.

A "*" character wil be displayed behind filtered objecttypes the path browser.

 

To get back to to an unfiltered Treemap, just single click the middle mouse button on filtered objects again or use the Clear filter entry in the path browsers objecttype menu.

Object centric navigation

You now can navigate directly and more easy from a selected object to related objects without the need to use the path browser for that. Simply select the objecttype you want to see grouped inside an object. For this selet the desired objecttype behind Isolate > Detail this in the object menu. The number behind each objecttype in the submenu is the count of related objects, that will be displayed inside. If there are no related objects for a specific type, it will not show up in the submenu.

Global analytic favorites

With the introduction of Analytic favorites in this release, favorites in general became more important than ever, so we also added some collaboration features to the favorite manager.

Collaboration features

New favorite management functions now allow to share them more easily between the users of inside a team and to define standard analysis processes with them.

The new main features of the favorite manager are:

  • Favorites are exportable and importable
  • Global favorites are stored in the BVQ DB and thus are available for all users. This allows collaboration between users and a continuous enhancement of the workflows supported and driven by BVQ.

A new favorite type called "Analytic Performance Favorite" adds major benefits:

Analytic Performance Favorites

The new Analytic Performance Favorites allow to store Performance view configuration settings more abstractly. With that property, they can be applied more flexibly to other objects or even other object types than initially defined. They allow to invoke a well defined performance view configuration on different objects in future situations.
This is most beneficial when multiple Analytic Performance Favorites are defined as part of a sequence of a comprehensive step-by-step analytic process.

In comparison, the classic BVQ performance favorites are more like an exact screenshot that can be recalled for exactly the same object set and timeframe showing a situation recorded in the past. Analytic Performance Favorites are decoupled from any time (duration) and object. Instead, it acts on the following currently active user selections:

  • Selected objects in the related topology view
  • Current timeframe, as most recently set in the performance view  (current adjustment of the performance time favorite)

They can be invoked in the following ways:

  • From the favorite manager
  • From the object menu embedded in a shortened stucture as defined in the favorite manager
    • Menu entry Favorites offers all Analytic Performance Favorites
    • Submenues of type specific performance view entries offer only Analytic Performance Favorites of the appropriate type.

Example of Analytic Performance Favorites in the favorite manager:

Example of Analytic Performance Favorites shown in the favorites:

Example of Analytic Performance Favorites shown behind type specific performance view menu entries:

Customize GUI startup window layout

You can save your current window layout to be reused automatically after each BVQ GUI start. Choose Main menu > BVQ > Save layout as default... entry to do this.

Consolidated DB installer

The two previously separate installers BVQ DB setup and BVQ DB schema migration are now consolidated to one tool. This will ease and accelerate upgrades and inital installations.

Pre-consolidated stats storage

Storing performance statistical data in the BVQ DB is now much more space efficient and data can be loaded much faster. Most counters are now aggregated across all cluster nodes and stored to DB after this pre-processing step. That will reduce the amount of data to be stored roughly by a factor equivalent to the number of nodes in the system. For example an 8 node cluster will only need 1/8 of the space for VDisk or MDisk data compared to previous versions of BVQ.

To overcome the need for a very long data conversion, the GUI and reporting modules have been enhanced to read both formats without any user intervention. Due to this capability, old data is kept until deleted by the BVQ schedulers space retention period (default: 100 days). Thus, the maximum space reduction is not expected to be seen at once. It can only be fully realized after the retention period.

Performance view enhancements

  • Less system memory usage and much faster drawing in case of a massive high count of objects
  • Manual rescale of every Y-axis
  • Store chart configuration options configured in the chart menu in favorites or as default configuration reused at every start of a performance view
  • Quick background color chooser menu integrated in the chart menu

Adaptive Treemap Sizing enhancements

Adaptive Treemap Sizing (ATS) is now used for all object attributes, that can be selected in the aspect selector of the topology view. That includes: Performance, cost and  price aspects.
An additional information in the text overlay of a Treemap object pad starting with the character ∑ shows the current object type used as aggregation source.

System deletion tool integrated in GUI

Discovered Systems (VMware, SVC, Storwize, ...) can now be deleted very easy. Just Open the main menu BVQ and select Delete discovered system... and follow the appearing wizard's instructions.

 

 


 

Special note for 4.0.x

Customers currently running BVQ version 4.0.0 (Family & Friends Release) need to take special attention to upgrade to 4.0.1 or later:

The DB schema manager will detect a gap in the schema migration sequence, because a schema change included in release 3.5.9 is not included in 4.0.0 (3.5.9 was released with a critical fix after 4.0.0).

 

After you get the error message you need to cancel the complete update procedure here.

Now, you have to run the schema migration scripts for schema levels 3.5.9.1, 3.5.9.2, 3.5.10.1 & 3.5.10.2 manually via db2cmd:

  1. Start a DB2 Command window - Administrator  (Befehlsfenster - Administrator for german installations) within the start menu folder IBM DB2 DB2COPY1.
  2. Run the command db2 connect to %DATABASE_NAME% user %USER% using %PASSWORD%
    1. (warning) %DATABASE_NAME% - Replace by name of the BVQ database (default: bvq)
    2. (warning) %USER% - Replace by name of the DB user for the database (default: bvq)
    3. (warning) %PASSWORD% - Replace by password for the specified %USER% (default: P@ssw0rd)
  3. You will get an information for the successfully established db connect:

    C:\Program Files\IBM\SQLLIB\BIN>db2 connect to bvq user bvq using P@ssw0rd
    
    	 Database Connection Information
    
     Database server        = DB2/NT64 10.5.6
     SQL authorization ID   = BVQ
     Local database alias   = BVQ
  4. Type the command db2 -tvf "c:\Program Files\SVA\BVQ\bvq-db-schema-manager\migrationscripts\3.5.9.1.raise_schema_level_for_migration.sql"
    1. (warning) Depending on your BVQ installation the path to the \migrationscripts folder may vary - please customize if needed.
  5. Check the output of the command for DB20000I  The SQL command completed successfully. messages which indicate a successfully executed sql command.
  6. If all commands were executed successfully run the next command db2 -tvf "c:\Program Files\SVA\BVQ\bvq-db-schema-manager\migrationscripts\3.5.9.2.repair_drive_cur_table.sql"
    1. (warning) Again depending on your BVQ installation the path to the \migrationscripts folder may vary - please customize if needed.
  7. Again check the output of the command for DB20000I  The SQL command completed successfully. messages.
  8. Repeat step 6 & 7 for migrationscripts 3.5.10.1.raise_schema_level_for_migration.sql & 3.5.10.2.clear_drive_cur_table_encore.sql
  9. If all commands were executed successfully run the repository installer again. The schema manager should run without any errors.
  10. Complete the update to version 4.0.1 (or newer) as usual.

(info) If you have any trouble with the procedure please contact the BVQ support.

 

Requirements and restrictions 

Requirements of the HW/SW environment

Please see Supported Environments

Minimum BVQ version required for an update

V2.7

DB2 Version

DB2 Advanced Workgroup Server Edition V10.5 FP5
Filename: v10.5fp5_ntx64_server_t.exe

Java Runtime version

1.8.0.66

 

Update step by step 

Important update notes

  1. BVQ license: A new license file may be necessary to use certain new features.
  2. GUI favorites:  During some of the GUI updates the predefined favorites are replaced. Possible user changes will be lost. However, changes in user favorites and all user favorites are kept.
  3. Update DB2 JRE: Before installing the BVQ update please upgrade DB2 and JRE to the recommended  versions.
  4. If you have problems: Please contact your BVQ support partner
  1. Preparations
    • Checking for correct function of the environmentin particular function of the scanner.
    • Manual stop of BVQ Scanner and Alerting-service, Scheduler-services and also of all GUIs and reporting-clients
    • Backup of BVQ installation directory and BVQ DB (e.g. DB offline backup with DB2 CMD, VMware snapshots) 
    • Starting again the BVQ Scanner
  2. Update BVQ Install Package Repository: bvq-package-repository-installer-x64-V4.0(.x).exe
    1. DB Schema update
    2. BVQ GUI update
    3. BVQ Reporting Engine update
    4. BVQ Report Module update
    5. BVQ SVC Scanner update 
    6. BVQ VMware Scanner update
    7. BVQ Scheduler update
    8. BVQ Alerting update
  3. Performing functional tests
  4. If necessary inform colleagues about the need to update locally installed BVQ GUI / report clients.  

 

Changelogs

 Version 4.0.5

Version 4.0.5


Bugfixes

 

Issue ID

Module

Description

CriticalBVQ-10932SVC scannerThe datetime zone id 'GMT+03:00', ID: 379 Name: Europe/Minsk or FET is not recognised
CriticalBVQ-10897Repository Installer

Sometimes does not inherit admin right elevation to subinstallers

CriticalBVQ-10907GUICPU Utilization performance indicator shows too high values
Recommended
BVQ-10821GUITreetable: Filter: Column "RDM": Entries != All deliver no lines
RecommendedBVQ-10824GUITreetable: Filter: Pressing space in filter expression opens detail pane
RecommendedBVQ-10535GUITreetable: Filter: Column "Mapping type": Filter dropdown does not offer "N/A or Undef"
 Version 4.0.4

Version 4.0.4

Improvements

Issue ID

Module

Description

BVQ-10454

GUI

Treetable: Optimize column width

BVQ-10656DB schema managerAdd domain user support

Bugfixes

 

Issue ID

Module

Description

CriticalBVQ-10702SVC scannerTopology persist: Ran into timeouts in larger installations.
CriticalBVQ-10724SVC scannerPerformance persist: DirectoryNotEmpty exception after restarts
CriticalBVQ-10613DB schema managerDB2 CLI RC=1 combined with no output is not detected as error
CriticalBVQ-10778DB Schema amangerDB schema migration fails to start due to DB connection problems
CriticalBVQ-10757DBPerformance tables: Some do not fill DIM_DATE
CriticalBVQ-10819GUIEditors: Validation checks in editors does not work
ImportantBVQ-10756GUIMulti Edit: Selection within treemap gets lost
Recommended
BVQ-10755GUIPerf-View: MDisk group lower cache partition: IllegalStateException when trying to open
RecommendedBVQ-10535GUI"Launch BVQ Reporting" fails
 Version 4.0.3

Version 4.0.3

Improvements

Issue ID

Module

Description

BVQ-10560

GUI

Fonts are blurry when high DPI settings are used

Bugfixes

 

Issue ID

Module

Description

CriticalBVQ-10647SVC scannerTopology Persist: Too many SQL statements executed
CriticalBVQ-10543GUIPerformance Loader: Interval is expanded with 20 minutes on the left and right 
CriticalBVQ-10690GUIStartup fails with corrupt views.xml
CriticalBVQ-10567GUILook & Feel: Old themes aren't set to the new default
ImportantBVQ-10492GUIAttribute names: Definition for long name & description of newly added foreign key & linked objects
ImportantBVQ-10649GUIScanner Status: Check interval to low for performance persist
Recommended
BVQ-10539GUIException while changing treemap path
RecommendedBVQ-10510GUITable Views: Window resize shows treemap
RecommendedBVQ-10507GUIDB selector: Last update column for systems is empty
RecommendedBVQ-10154GUIPerf-View: Node/Core: Tooltip of Measure-Point has incorrect Format
RecommendedBVQ-10574GUIPerformance Loader: 4w custom PI shows no values
RecommendedBVQ-10589GUIPerf-View: Duration switches to "Custom" after mouse shift in chart
RecommendedBVQ-10546GUITreetable: VDisk copies: Column "Copy role" shows ID instead of value
RecommendedBVQ-10534InstallerReporting GUI: Memory usage limit invalid
RecommendedBVQ-10537ReportingLogfiles are not written
RecommendedBVQ-10435WatchdogCannotAcquireResourceException
RecommendedBVQ-10633CommonDeletion tool: Exception when trying to start from \bin directory
 Version 4.0.2

Version 4.0.2

Improvements

Issue ID

Module

Description

BVQ-9924

SVC scanner

Installer: Increase maximum concurrent instances to 30

BVQ-10473DBDB: Improve database-connectivity
BVQ-10440GUIGUI: Analytic favorites should store visibility of aggregates and objects
BVQ-10496GUIGUI: DBSelector: "Start" Button should have focus by default
BVQ-10396GUIGUI: Fixing the Treemap/Treetable separation to a consistent state
BVQ-10451GUIGUI: Store topology filter within favorites
BVQ-10452GUIGUI: Treemap: Filtering: Enable OneClick behavior for isolate menu
BVQ-10355GUIGUI: Treetable: Complete keyboard navigation
BVQ-10459GUIGUI: Treetable: Reduce presentation delay
BVQ-10336GUIGUI: Treetable: Show names for foreign key linked objects
BVQ-9778InstallerInstaller: Löscht im /conf Ordner wenn man einen falschen Dienst-User angibt
BVQ-10442InstallerInstaller: Offsite Scanner: Proxy Configuration

Bugfixes

 

Issue ID

Module

Description

CriticalBVQ-9866 GUIGUI: Aggregation: Provider Capacities doesn't involve Child MDgs correctly
CriticalBVQ-10445 GUIGUI: PerfChart: NPE when switching all ChartObjects to invisible
ImportantBVQ-10209 GUIGUI: Language: Some menus using mixed languages
ImportantBVQ-10480 GUIGUI: DB Selector: DB Selector tries to access not existent tables
ImportantBVQ-10500 GUIGUI: Forms: Change of selection in 1-n table via arrow key does not update enable state of interaction buttons
ImportantBVQ-10430 GUIGUI: Perf: CSV Export: Export of NodeCPU Data exports different data than selected
RecommendedBVQ-10406 GUIGUI: FlatTable: Switching the navigationpath should keep for distinct values even if not visible in the dropdown menu
RecommendedBVQ-10424 GUIGUI: Startup time before database selection dialog is shown takes to long
RecommendedBVQ-10458 GUIGUI: Treetable: Fit column width with double-click
RecommendedBVQ-10249 ReportingReports: Standard schema doesn't consider ChildMDiskGrps
 Version 4.0.1

Version 4.0.1

Improvements

Issue ID

Module

Description

BVQ-10130

GUI

Disk type: Renaming of "Lowrange" to "Nearline"

BVQ-10335

GUI

Detail Pane: Cluster: Capacities: Display wasted capacity again

BVQ-10351

GUI

List-View: Replace the old implementation with the new treetable view

BVQ-10286

BVQ-10287

BVQ-10290

BVQ-10291

DB / SchemaDatabase und BVQ Schema cleanup

Bugfixes

x

Issue ID

Module

Description

CriticalBVQ-10366SVC ScannerFixed problem with space in nodename
Critical

BVQ-10364

Installer

Drive (partition) detection fault for existing DBs

CriticalBVQ-10407InstallerRepository Installer doesn't detect an existing 3.5.8 installation correctly
CriticalBVQ-10414InstallerRepository installer: Error during installation to other than default path
Important

BVQ-10090

VM Scanner

Authentication error if password contains a exclamation mark

ImportantBVQ-10295GUIPerf-View: Export: Default filename isn't Windows compliant (":")
ImportantBVQ-10344GUITreetable: Collapse doesn't work for selections with VDisk copies
ImportantBVQ-10387GUIDP: Percent allocated capacity wrong calculation
ImportantBVQ-10394ReportingUpdate all reporting views for previous schema changes
RecommendedBVQ-10395GUIWindows users with # in the username can't start the GUI
RecommendedBVQ-10333GUITreemap: Removed duplicated Virutal Capacity
RecommendedBVQ-10386GUIPerf-View: Node port: Options: Export: Aggregated object values is exported twice as high as it really is, when exported with multiple other objects
RecommendedBVQ-10388GUIPerf-View: Node port: Options: Export: Wrong default file name
RecommendedBVQ-10290GUIPerf-View: Adding a new metric after a scaling change for this metric type leads to NPE
RecommendedBVQ-10408GUIDPs: Storage consumer objects show real capacity instead of virtual capacity in the detail pane header
RecommendedBVQ- 10384SchedulerReadme insturctions updated

 

 

 Version 4.0.0

Version 4.0.0

New features

Issue ID

Module

Description

BVQ-8241

Common

IBM FlashSystem 840 / 900 support

BVQ-10021

Common

SVC/Storwize v7.6 toleration support

BVQ-9737

Common

iSCSI: Add active and failover ports to topology

BVQ-892

SVC Scanner

Performance persist: Use config nodes timestamp as normalized reference timestamp

BVQ-9373

SVC Scanner

Performance persist: Consolidate stats from all online nodes and store counter differences in DB

BVQ-9777

CLI

Use .bdp file for DB access

BVQ-8508

Installer

DB Setup & Schema migration: Consolidate to a single installer package

BVQ-9674

GUI

Main menu: Add cluster deletion feature to BVQ GUI

BVQ-9973

GUI

Object VDisk: Add Flash copy mapping counters

BVQ-10066

GUI

Object Node: Show if config node

BVQ-9226

GUI

Object Drive: Show class as color analogue to MDisk tier

BVQ-10197

GUI

Object Host: Show status as color

BVQ-2204

GUI

Topology view: Filtering (Treemap & Treetable)

BVQ-6112

GUI

Topology view: Treetable

BVQ-7352

GUI

Topology view: Object Centric Navigation

BVQ-9863

GUI

Topology view: Aspect "cost": Split into "cost_allocated" & "cost_allocatable"

BVQ-4058

GUI

Favorites: Separate into System, All users, User (My favorites)

BVQ-8272

GUI

Favorites: Performance view: Enable Analytic performance favorites

BVQ-9691

GUI

Favorites: Export / Import feature

BVQ-9505

GUI

Favorites: Open all favorites of a selected folder as new tab

BVQ-10119

GUI

Docking: Save current window and dock arrangement as start configuration

BVQ-8208

GUI

Performance view: Chart menu: Add feature to be able to configure all visible Y-axes

BVQ-8209

GUI

Performance view: Chart menu: Add feature to store common configuration options as default

BVQ-8210

GUI

Performance view: Chart menu: Add feature to store specific configuration options in Favorites

BVQ-10069

GUI

Performance view: Add quick chooser for background color to chart menu

BVQ-9852

GUI

Performance view: Node2Node: Object-list: Add object menu for "From node"

Improvements

Issue ID

Module

Description

BVQ-9924

SVC scanner

Installer: Increase maximum concurrent instances to 30

BVQ-9630

DB schema migration

Increase table space INCREASESIZE to 1G

BVQ-5917

CLI

Object Disk array: Automatically calculate a default estimated IO density

BVQ-9736

CLI Scheduler

Make PI Date configurable via attribute

BVQ-3670

GUI

Startup: Delayed load of PIs in background after GUI start

BVQ-9669

GUI

Common: Format currency values according to OS configuration

BVQ-8912

GUI

Common: Format date, time and number values according to OS configuration

BVQ-9948

GUI

Common: Reduce number of selectable Look&Feels

BVQ-9873

GUI

Common: Spilt allocatable & unallocated capacities according to MDisk and Child MDisk group

BVQ-9135

GUI

Detail pane: Add compliance task bar for remote copy objects

BVQ-9645

GUI

Scanner status: Topology scan & persist: Dynamically adjust WARN timeout according to scanner configuration

BVQ-9718

GUI

Cluster selection dialog: Show latest performance file timestamp as last scan timestamp

BVQ-9990

GUI

Performance view: Enlarge radius of dot-context-menu

BVQ-10095

GUI

Performance view: Accelerate drawing of massive number of objects and metrics

BVQ-10155

GUI

Performance view: Accelerate JFreeChart with multithreading

BVQ-10134

GUI

Performance view: Enhance draw sequence of upper / lower cache (partition)

BVQ-10190

GUI

Performance view: Dot-detail-pane: Show all metric tabs (current in front)

BVQ-9935

GUI

Editors: Do not show "ID: null"

BVQ-10244

GUI

Topology view: Path Browser: Hide Extents

Bugfixes

 

Issue ID

Module

Description

Critical

BVQ-9764

DB

DISK_TYPE: Correct wrong Design IO rate of 15k drives

Critical

BVQ-9380

GUI

Treemap: ATS: Path "BVQ/MDisk group/VDisk", Aspect: Alloacatable does not always show VDisks

Critical

BVQ-8761

VMware scanner

Topology persist: Unique key violation while storing VM Virtual disks

Critical

BVQ-9367

VMware scanner

Stops with BVQScanException

Critical

BVQ-10215

GUI

Favorites: Performance: Some deaktivated after migration from 3.3.2 to 3.5.7

Important

BVQ-9903

SVC Scanner

Hot spare drives are not recognized

Important

BVQ-9998

SVC Scanner

Topology persist: BVQ drives do not use a sequence, instead they use MAX(ID) query

Important

BVQ-9658

Common installer

SVC scanner: Missing softlinks are not recognized

Important

BVQ-9985

GUI

Object Disk type: Name in TT, TO und DP no longer include the type attribute

Important

BVQ-10195

GUI

Performance view: Initial Scaling for Buffer Credit Wait < 0.100%

Important

BVQ-10283

GUI

Editors: VDisk & MDisk group shuttle list exception / no popup / updates are not shown correctly

 

 

 


 

Page viewed 2562 times by 9 users since Feb 12, 2016

For the usage of BVQ, the provided environment has to meet certain requirements. Please ensure that the following requirements are met for the server, client and network!

Hardware requirements

  • The stated minimum requirements allow operation in an environment depending on the number of volumes.
    Please ask back for sites larger than 8000 volumes.

SVC/V7000 supported software versions

Please take a look at this page:  Supported SVC software environments

Server

  • Most installations are carried out on a VMware guest system.
    During production the following setups should be planned for different sizes.

Number of volumes

CPU

RAM

HDD

LAN

< 1000

3GHz, 4 cores

4GB

120GB free

100MBit/s

1000 - 4000

3GHz, 4 cores

6GB

250GB free

100MBit/s

4000 - 8000

3GHz, 6 cores

8GB

500GB free

100MBit/s

Supported operating systems

The following table lists which operating systems are supported for servers and clients.

Operating system (English/German)

BVQ server

BVQ client workstation (GUI)

Windows Server 2012, 2012 R2,
64 Bit, (English / German+ current patches)

(tick)

(tick)

Windows Server 2008 (>=SP1), 2008 R2,
64 Bit, (English / German+ current patches)

(tick)

(tick)

Windows Server 2003 R2 SP2, 64 Bit

(tick)

(tick)

Windows 8, 8.1 (+current patches) (tick)

Windows 7 SP1, 64 Bit (+current patches)

 

(tick)

Windows Vista SP 1, 64 Bit (+current patches)

 

(tick)


In addition, the following conditions have to be met:

  • (warning) The name of the host / the server (s) (especially BVQ DB server or their combinations) MAY NOT BE BVQ! (otherwise the required BVQ user on the system can not be created!)

  • The time and time zone of the BVQ server must be equal to the time of the monitored SVC cluster. Here NTP is recommended for automated configuration time.
  • The BVQ server (BVQ DB server / server BVQ / BVQ GUI), needs the LAN side of the split port 50000 for communication between server / GUI and DB to be unlocked and accessible.
  • For communication between the server and BVQ to monitor SVC clusters, the port 22 has to be open for SSH or SCP or accessible.

 

Software pre-requisites

DB2 Advanced Workgroup Server Edition

IBM DB2 AWSE version 10.5 fix pack 5 is required on the database server.

The OEM license needed for installation is included in BVQ and therefore does not need to be purchased separately.

An overview of the latest version can be obtained at: http://www.ibm.com/support/docview.wss?rs=71&uid=swg27007053
In the section # DB2 installation, a detailed step by step manual for installing DB2 can be found.

Java Runtime Environment (JRE)

An Oracle Java Runtime Environment version 1.8.x with most current patches should to be installed on the BVQ server, database server and the clients.
(warning) The Java Runtime Environment 32/64 bit version must match the bit version of the operating system!

The installed version of Java and the Java file association can be checked by using the following commands:

C:\>java -version
java version "1.8.0_xx"
Java(TM) SE Runtime Environment (build 1.8.0_xx)
Java HotSpot(TM) 64-Bit Server VM (build xx, mixed mode)

C:\>C:\WINDOWS\SYSTEM32\java.exe -version
java version "1.8.0_xx"
Java(TM) SE Runtime Environment (build 1.8.0_xx)
Java HotSpot(TM) 64-Bit Server VM (build xx, mixed mode)

C:\>assoc .jar
.jar=jarfile

C:\>ftype jarfile
jarfile="C:\Program Files\Java\jre6\bin\javaw.exe" -jar "%1" %*

PuTTY

PuTTY is a free Secure Shell (SSH) client. It allows to send direct commands via a terminal session to the SVC CLI. PuTTY is required during installation of BVQ to check the following SVC parameters and to adapt them if necessary:

Create a SSH-key

For mutual authentication between SVC and PuTTY, an SSH-key is needed. The creation of an SSH-key is described in the following section:


Download PuTTY (puttygen.exe) from the following website: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
Then execute puttygen.exe:

  1. Accept the parameters SSH-2 RSA and number of bits in a generated key: 1024.
  2. Select 'Generate'. Then move the cursor over the popup window to the button 'Key is fully created'.
  3. The 'Key passphrase' and 'Confirm passphrase' have only to be entered, if the private key has to be additionally protected by passphrase.
  4. Select 'Save public key'. Enter a file name with the extension .pub (for example: SVCClusterName_Username.pub) and then save the file in a separate directory: eg * \ SSH_Key_SVC.
  5. Select 'Save private key'.



  6. Click 'Yes'. This confirms that you want to save the key without a passphrase.
    Then enter the file name with the extension of .ppk (eg: SVCClusterName_Username.ppk). Save the file in the same folder as the public key.
  7. Close the PuTTY key generator.


Upload public key in SVC

The key can be assigned to the SVC GUI to an existing user. Alternatively, a new SVC user for BVQ can be created.

1. Call the SVC GUI and authenticate as Security Admin or Superuser.
2. Select 'User Management' -> User.
3. Add the SSH public key to a new or existing users.
(warning) The SSH key user must be in the user group 'Security admin' or 'Admin'.

[BVQ> prerequisites> svc_sshkey.PNG]

 

Adobe Acrobat compatible reader

The included BVQ reports are created as PDF files by default. To view them a PDF reader is required.
The Adobe Acrobat Reader software can be downloaded from the Internet at the following link: http://get.adobe.com/de/reader/

TeamViewer or Cisco WEBEX for support purposes

The BVQ team prefers the software 'TeamViewer' for world wide remote support. TeamViewer can be installed on the BVQ server (or as workaround on security issues on any work station with RDP access to the BVQ server).
The TeamViewer software can be downloaded at the following link: http://www.teamviewer.com/de/download/index.aspx

TeamViewer is our preferred tool but remote access can also be instantiated with many other methods.

SVC Storwize settings

SSH access

  • SSH and SCP access to SVC/V7000 cluster using SSH key

  • 2 unused SSH login sessions per SVC cluster and server BVQ

 

SVC time synchronization

 

Before starting the scanning services on the affected SVC clusters, the following actions have to be performed:

  • Ensure the correct SVC cluster time and time zone (eg: Europe / Berlin, UTC ...)
    This should be automated via NTP.

  • (warning) Important! The scanner scans at 1.4 attempts performance matched to the time of delivery of SVC data.
    This requires that the clocks on the BVQ servers and SVC nodes are synchronized!

  • The best way to ensure this is achieved by using NTP:
    • BVQ scanner system: Time Synchronization with NTP Server option
    • SVC / Storwize cluster: Time synchronization with NTP Server option.

CLI procedure:

### Set Timezone and NTP ###
svctask settimezone -timezone 360             ### Timezone 360: Europe/Berlin !!!
svctask chcluster -ntpip <IP adress of NTP Server> ### Example: svctask chcluster -ntpip 9.20.165.16)

 


SVC performance statistics interval

The SVC performance data is copied at regular intervals by BVQ scanner into the BVQ database. To achieve this BVQ requires a solid SVC performance statistics interval of 5 minutes.

  • Check whether old remnants of 'iostat' files on the SVC clusters exist and delete them if necessary (SVC GUI - \> list dumps ...)
  • SVC perf statistics enable tracing in 5min intervals (BVQ version 3 will also be able to support 1 min intervals)

CLI procedure:

### Sweep and start Perfstats ###
svctask stopstats
svcinfo lsnode  -nohdr | while read id rest ; do svctask cleardumps -prefix /dumps/iostats $id ; done
svctask startstats -interval 5

Other conditions

Active directory - Domain registration


(warning) If a domain registration is used, the database and the BVQ users have to be created in advance as described in active directory domains registration.

The following table provides an overview of the required users and their user groups in active directory.

 

UAC - User Access Control Windows 2008 R2 / Vista / Windows 7

Starting with Windows Vista Microsoft introduced the User Access Control (UAC) on the Windows platform. The intention was to avoid that all actions are performed with administrator privileges.

For the duration of the BVQ SW-installation, it may be necessary to set the UAC to 'Never notify' (reboot needed!).

When the installation is finished UAC can be resetted to the previous level.

UAC manager:

  • Start -> execute ... -> uac
  • To install set control to "Never notify".

  • Reset after a successful installation to the original value.

SSH connection

For communication between SVC and BVQ a Secure Shell (SSH) connection is required. For this purpose the BVQ SSH / telnet client PuTTY is used in addition.

The following parameters must be defined in PuTTY for connecting to a SVC cluster:

  • Category: session
    Hostname (or IP address) = IP address or DNS entry of the appropriate SVC cluster
    Port = 22
    Connection type = SSH
    Saved sessions = enter name of the corresponding SVC cluster

  • Category: connection -> data
    Auto-login username = bvq

  • Category: connection -> SSH -> auth
    Private key file for authentication = off # SSH key created select 'Create. Ppk file'

  • Back to category: session
    Save button to save settings permanently

 

(info) On first connection attempt an error message may appear that the SSH fingerprint is not saved in the registry. Confirm this warning once.

BVQ GUI remote desktop with Microsoft RDP

The redirection of the BVQ GUI-operation from a server to a workstation by using Microsoft Remote Desktop Protocol (RDP) is supported. But losses in rendering quality and speed must be expected.
Therefore, it is recommended to use GUI to BVQ screen directly without detours.
In Windows 2008 Terminal Services environments certain settings need to be considered before installing (in user mode enable installation).
Please follow this link for more information: http://www.techotopia.com/index.php/Installing_Applications_for_Windows_Server_2008_Terminal_Services

Adjustment of virus scanner on the BVQ server

The following directories should not be scanned!

C:\DB2
D:\DB2
%ProgramFiles%\SVA\BVQ\bvq-scanner
%ProgramFiles%\SVA\BVQ\bvq-scheduler

Problematic behavior has been observed in connection with the virus scanner from Sopohs. This can potentially be also relevant for other virus scanners.

Pre installation checklist