Getting started

smartDBcheck Beta Test Program · Index · Part 1 · 2 · 3 · 4 · 5 · Expand · Web Feed

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.