smartDBcheck is a tool to manage Progress® storage objects and to optimize performance on the physical implementation level. smartDBcheck currently is in the beta test phase, it should work with every Progress® V9 database on Win32 server machines. If you join the beta test program, you'll receive a nice discount when you purchase a full product afterwards.


Index

About smartDBcheck

Technical stuff like system requirements, architecture, installation. [Shrink]

smartDBcheck Beta Test License

The beta test software is fully functional and does not expire. [Shrink]

Getting started

Check out the basics first, then take a closer look at the details. Here is the roadmap for the first session. [Shrink]

Wish list

The current list of desired add-ons. [Shrink]

Known bugs

Please check in here if you've any troubles [Shrink]



About smartDBcheck

[Shrink]

System Requirements

· Progress databases version 9+ (not yet tested with OpenEdge), SQL enabled
· Progress client version 9.1D+ on a Win32 server machine



Architecture

smartDBcheck is written in pure Progress® 4GL. It does not need any external components like OCXs or DLLs. It makes use of the ADM2 framework as delivered by Progress®. Settings and object properties are stored locally and get updated from the virtual system tables (VST) and the file system on each database connect. smartDBcheck performs absolutely no updates in databases. It generates editable structure files and scripts. In the beta test version there is no way to execute a script from a running instance of smartDBcheck.



Installation

Download smartDBcheck.zip, unpack on the database server, change the current directory to .../smartDBcheck, right click start.p and choose run/start.



Release Notes

Current Version: 1.00Beta as of March/20/2005
State: Roughly tested (in house), delivered to two companies for extensive stress-testing.



Screen shots



smartDBcheck Beta Test License

[Shrink]

Functionality

The smartDBcheck beta test software comes with all features described on this web site and does not expire. However, it may contain errors and is delivered as is without any guarantees. During the beta test phase we'll improve the software, most probably the full product will contain even more functionality.



License

Please read the smartDBcheck beta test license here, in short:
Accept the NDA, then download and install the software. Use and test it in a real life environment, for example on a development server running many databases. In return for the free of charge software we kindly ask you to answer a few questions. Your answers and bug reports will help us to create a user friendly and stable product. When you purchase a full product afterwards, you'll receive a nice discount.



Join the smartDBcheck beta test program here.



Getting started

[Shrink]

Check out the basics first, then take a closer look at the details. Here is the roadmap for your first smartDBcheck session:

· Install smartDBcheck on your database server machine. Don’t run it on a network client. Check your PF file, you must not use the –q startup parameter.

· Run start.p in the program directory. Don’t open start.p with any database connected. Scan / read the help draft.

· Go to ‘Settings’ and edit the default values.

· Go to ‘DB’ and choose a database located on the current server machine. Enter the logical database name in ‘DB Name’ and additional connect parameters, if necessary. Press ‘Connect’. Edit the database settings.

· Go to ‘Areas’ to monitor storage areas and extents. Read the suggestions.

· Go to ‘Tables’ and press ‘Load Tables’ to view a list of your application tables. Press ‘Calculate Tables’ to get the details. Choose ‘Find targets for all movable tables’ in the browser’s popup menu. Press ‘View Script’ to edit the tablemove script.

· Go to ‘Preview’ to view a list of storage objects per storage area at present and after not yet processed moves. Go back to ‘Tables’ to adjust the suggested changes. Check the new area dimensions as well as volume limits etc. before you run the tablemove script.

· Go to ‘DB’, disconnect and exit.



Wish list

[Shrink]

This is the current wish list, containing all topics smartDBcheck users and beta testers have desired yet. Please add your wishes and ideas, just click the Contact link on the left.



A character based user interface for UNIX servers.



A list of current and not yet executed scripts with a run selected script button.



An option to truncate the BI file after each table/index move.



A batch mode to monitor the file size of extents. The script should allow an individual limit for each extent and email the DBA when the file size reaches the limit. It should find new extents and monitor the general file size limit, even when smartDBcheck did not run after the creation of new extents.



Generation of index rebuild scripts on demand.



Generation of a structure file adding a new extent to a selected storage area.



Updates of stand-by-systems.



Analyzing a delta.df shipped with application updates, smartDBcheck shall replace all target areas by the object's current location and place new storage objects in a separate area, which is subject of particular monitoring.





Known bugs

[Shrink]

Error messages 2(98) on start and/or 'Save and exit'


In some cases the configuration files shipped with the beta version can't get changed. If you get error messages like "Unable to open file: data/ttDB.d. Errno=2 (98)", just delete the (empty) *.d files in the data directory. Starting the program again, these files are created and populated without errors caused by the OS.



Author: Sebastian
Last Update: 03/29/2005   Web Feed

· Home

· smartDBcheck

· Beta Test

· Download

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy